Fatal NTSB investigations: Continental GTSIO-520-C

69 cases on aircraft whose registry engine model is Continental GTSIO-520-C. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…Sep 25, 1982 · N8019Q · Destroyed NTSB FTW82FA155Accident · 1 fatalField investigationFinal reportCessna 411A · Houston, TXThe acft was the second acft of a flight of two. The lead acft had received radio clearance for takeoff. The lead acft was to proceed to a visual checkpoint northwest of the arpt & wait for this acft to join up. Witnesses observed the acft depart rwy 17 &…Apr 28, 1982 · N411HN · Destroyed NTSB DEN82FA056Accident · 3 fatalField investigationFinal reportCessna 320F · Missoula, MTDuring arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and…Apr 7, 1982 · N999LS · Destroyed NTSB MKC81FA053Accident · 4 fatalClosedAero Comdr 685 · Kansas City, KSSep 4, 1981 · N777MM · Destroyed NTSB ATL81FA093Accident · 1 fatalClosedCessna 411 · Columbus, GAJul 9, 1981 · N7007R · Destroyed NTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYMay 7, 1981 · N6842R · Destroyed NTSB FTW81FA079Accident · 1 fatalClosedCessna TU206B · Beaumont, TXApr 25, 1981 · N3414L · Destroyed NTSB MIA81FA042Accident · 6 fatalClosedCessna 172 · Ft Lauderdale, FLFeb 3, 1981 · N739DV · 2 aircraft · Destroyed NTSB NYC80FA040Accident · 4 fatalClosedCessna 411 · Vineland, NJMay 9, 1980 · N4973T · Destroyed NTSB LAX80FA064Accident · 2 fatalClosedCessna 421B · Tucson, AZMar 14, 1980 · N59RZ · Destroyed NTSB IAD80FA009Accident · 2 fatalClosedCessna T210 · Highlands, NCJul 8, 1979 · N6916R · Destroyed NTSB MIA79FA026Accident · 2 fatalClosedBeagle 206 · Miami, FLDec 2, 1978 · N568MA · Destroyed NTSB OAK78FA020Accident · 4 fatalClosedCessna 411 · Chilcoot, CAMar 3, 1978 · N3212R · Destroyed NTSB DEN77FA047Accident · 1 fatalClosedCessna TU206C · Vaughn, NMJul 13, 1977 · N29101 · Destroyed NTSB MIA75AM083Accident · 1 fatalClosedCessna 421A · Atlanta, GAMay 28, 1975 · N4006L · Destroyed NTSB NYC73AN111Accident · 2 fatalClosedCessna 210 · Missing AircraftJan 28, 1973 · N6710R · Destroyed NTSB NYC73AN084Accident · 3 fatalClosedCessna 421 · Cheektowaga, NYDec 16, 1972 · N121X · Destroyed NTSB MIA73AM014Accident · 5 fatalClosedCessna 421 · Cleveland, TNAug 7, 1972 · N123QF · Destroyed NTSB DEN72AD030Accident · 5 fatalClosedCessna 411 · Stockton, UTDec 26, 1971 · N411Q · Destroyed