Skip to content

NTSB investigations: Continental C90 series

1,117 cases on aircraft whose registry engine model is Continental C90 series. 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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 CHI68D0114Accident · No injuriesClosedAlon A2 · Grantsburg, WIJun 20, 1967 · N6363V · Substantial damage NTSB MKC68D0246Accident · No injuriesClosedSmith PSA-1 · Pennock, MNJun 17, 1967 · N14H · Substantial damage NTSB CHI68F0126Accident · Minor injuriesClosedCessna 140 · Roselle, ILJun 6, 1967 · N241V · Destroyed NTSB LAX68F0003Accident · Minor injuriesClosedLuscombe 8F · Chino, CAJun 5, 1967 · N2137B · Destroyed NTSB MKC68D0005Accident · No injuriesClosedAlon A-2 · Shenandoah, IAJun 4, 1967 · N6588Q · Substantial damage NTSB OAK67D0335Accident · No injuriesClosedChampion 7FC · San Carlos, CAMay 30, 1967 · N9021B · Substantial damage NTSB FTW67F0642Accident · Minor injuriesClosedAlon A-2 · Littlefield, TXMay 24, 1967 · N6558Q · Substantial damage NTSB MKC67D0601Accident · No injuriesClosedAeronca 7EC · Ranier, MNMay 7, 1967 · N4370C · Substantial damage NTSB MKC67D0610Accident · No injuriesClosedCessna 140 · Norfolk, NEMay 6, 1967 · N2267V · Substantial damage NTSB MKC67D0512Accident · No injuriesClosedAeronca 7AC · Bowman, NDMay 2, 1967 · N81782 · Substantial damage NTSB FTW67D0601Accident · No injuriesClosedCessna 140A · Dalhart, TXApr 26, 1967 · N5630C · Substantial damage NTSB OAK67D0304Accident · Minor injuriesClosedLuscombe 8F · Las Vegas, NVApr 23, 1967 · N1845K · Substantial damage NTSB LAX67A0099Accident · 2 fatalClosedHelton Lark 95 · Willcox, AZApr 20, 1967 · N86653 · Destroyed NTSB MKC67F0509Accident · Minor injuriesClosedPiper PA-18 · Watertown, SDApr 15, 1967 · N9097D · Substantial damage NTSB DEN67D0250Accident · No injuriesClosedCessna 140 · Burns, WYApr 15, 1967 · N5388C · Substantial damage NTSB LAX67F0408Accident · No injuriesClosedCessna 140A · Santa Ana, CAApr 14, 1967 · N1148D · Substantial damage NTSB MIA67D0503Accident · Minor injuriesClosedCessna 140A · Huntsville, ALApr 2, 1967 · N9688A · Substantial damage NTSB FTW67F0550Accident · Minor injuriesClosedChampion 7JC · Manila, ARApr 1, 1967 · N8967R · Substantial damage NTSB MKC67D0578Accident · No injuriesClosedCessna 140 · Thief R Flls, MNMar 27, 1967 · N3612V · Substantial damage NTSB FTW67F0510Accident · No injuriesClosedChampion 7EC · La Grange, TXMar 27, 1967 · N9063B · Substantial damage NTSB MKC67D0535Accident · No injuriesClosedAeronca 7EC · Washburn, IAMar 24, 1967 · N4660E · Substantial damage NTSB DEN67D0228Accident · No injuriesClosedCessna 140 · Glenwood Spg, COFeb 23, 1967 · N2167V · Substantial damage NTSB MKC67F0608Accident · Serious injuriesClosedPiper J-3C · Virginia, MNFeb 19, 1967 · N70955 · Destroyed NTSB DIA67F0036Accident · Minor injuriesClosedAlon A-2 · Chesapeake, VAFeb 8, 1967 · N6581Q · Substantial damage NTSB CHI67F0467Accident · No injuriesClosedCessna 140 · Elkhart, INFeb 5, 1967 · N2264V · Substantial damage NTSB NYC67D0513Accident · No injuriesClosedChampion 7FC · Philadelphia, PAJan 29, 1967 · N7566E · Substantial damage NTSB FTW67D0421Accident · Minor injuriesClosedCessna 140A · Midland, TXJan 20, 1967 · N81H · Substantial damage NTSB CHI67F0480Accident · Minor injuriesClosedAeronca 7FC · Walbridge, OHJan 13, 1967 · N7504B · Destroyed NTSB MKC67F0383Accident · Minor injuriesClosedAeronca 7CCM · Phelphs, MNDec 31, 1966 · N4642E · Substantial damage NTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NEDec 30, 1966 · N2397V · Substantial damage NTSB FTW67D0395Accident · Minor injuriesClosedAeronca 7FC · Houston, TXDec 24, 1966 · N9817Y · Substantial damage NTSB OAK67D0193Accident · No injuriesClosedAeronca 7CCM · Fallon, NVDec 11, 1966 · N82265 · Substantial damage NTSB MKC67D0340Accident · Minor injuriesClosedChampion 7FC · Riceville, IADec 4, 1966 · N9852Y · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB FTW67F0352Accident · No injuriesClosedAlon A-2 · El Paso, TXNov 24, 1966 · N6596Q · Substantial damage NTSB OAK67D0251Accident · No injuriesClosedChampion 7EC · Las Vegas, NVNov 19, 1966 · N4318C · Substantial damage NTSB NYC67F0352Accident · No injuriesClosedAlon A-2 · Deale, MDNov 13, 1966 · N5616F · Substantial damage NTSB MIA67F0294Accident · No injuriesClosedChampion 7EC · Picayune, MSNov 10, 1966 · N7506B · Substantial damage NTSB NYC67D0360Accident · No injuriesClosedPiper PA-18 · Artford, CTNov 5, 1966 · N7585D · Substantial damage NTSB ANC67D0061Accident · No injuriesClosedPiper PA-18 · Clear, AKNov 4, 1966 · N7670D · Substantial damage NTSB FTW67D0279Accident · No injuriesClosedAlon A-2 · Corning, AROct 22, 1966 · N5655F · Substantial damage NTSB FTW67D0238Accident · No injuriesClosedCessna 140A · Mc Gehee, ARSep 25, 1966 · N5605C · Substantial damage NTSB MKC67D0249Accident · No injuriesClosedAeronca 7FC · Sikeston, MOSep 24, 1966 · N4870E · Substantial damage NTSB FTW67F0235Accident · No injuriesClosedErcoupe 415-C · Shreveport, LASep 21, 1966 · N99649 · Substantial damage NTSB DEN67F0098Accident · No injuriesClosedLark 95 · Deming, NMSep 21, 1966 · N9726C · Substantial damage NTSB MKC67F0238Accident · Minor injuriesClosedCessna 140 · Franklin, MNSep 17, 1966 · N2237V · Substantial damage NTSB MIA67F0230Accident · 1 fatalClosedPiper PA-18 · Aurora, NCSep 13, 1966 · N9375D · Destroyed NTSB LAX67D0141Accident · No injuriesClosedCessna 140 · San Diego, CASep 12, 1966 · N2351V · Substantial damage NTSB FTW67D0201Accident · No injuriesClosedCessna 140A · Springhill, LASep 11, 1966 · N5317C · Substantial damage NTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORSep 4, 1966 · N7547E · Substantial damage