Table: flight_accidents
Columns: date
flight
aircraft
registration
location
fatalities

Question: Which flight had an aircraft of vickers viscount type 794?
SQL: SELECT "flight" FROM flight_accidents WHERE "aircraft" = 'vickers viscount type 794'

Question: Which flight had the aircraft avro rj-100?
SQL: SELECT "flight" FROM flight_accidents WHERE "aircraft" = 'avro rj-100'

Question: When was the registration of tc-jes?
SQL: SELECT "date" FROM flight_accidents WHERE "registration" = 'tc-jes'

Question: Which fatality was at ankara for the aircraft douglas c-47?
SQL: SELECT "fatalities" FROM flight_accidents WHERE "location" = 'ankara' AND "aircraft" = 'douglas c-47'