Table: aircraft_incidents
Columns: date_dd_mm_yyyy
tail_number
location
fatalities
brief_description

Question: What's the tail number of the airplane involved in the accident described as crashed?
SQL: SELECT "tail_number" FROM aircraft_incidents WHERE "brief_description" = 'Crashed'

Question: How many different brief descriptions are there for crashes with 0/161 fatalities?
SQL: SELECT COUNT("brief_description") FROM aircraft_incidents WHERE "fatalities" = '0/161'

Question: When did the airplane with tail number RA-85282 crash?
SQL: SELECT "date_dd_mm_yyyy" FROM aircraft_incidents WHERE "tail_number" = 'RA-85282'

Question: How many fatalities were there in the crash described as ditched 300 m short of runway?
SQL: SELECT "fatalities" FROM aircraft_incidents WHERE "brief_description" = 'Ditched 300 m short of runway'

Question: How many fatalities were there in the crash described as crashed at take-off due to engine failure?
SQL: SELECT "fatalities" FROM aircraft_incidents WHERE "brief_description" = 'Crashed at take-off due to engine failure'