Skip to content

NTSB investigations: Continental C85 series

2,292 cases on aircraft whose registry engine model is Continental C85 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 ('17008')) 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 ('17008'))
  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 ('17008'))
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 DIA67D0056Accident · No injuriesClosedCommonwlth 185 · Boone, NCMar 12, 1967 · N34130 · Substantial damage NTSB LAX67D0325Accident · No injuriesClosedCessna 120 · Torrance, CAMar 9, 1967 · N77294 · Substantial damage NTSB MIA68D0106Accident · No injuriesClosedCessna 140 · Ormond Beach, FLMar 5, 1967 · N72962 · Substantial damage NTSB NYC67D0538Accident · No injuriesClosedCessna 140 · Nashua, NHMar 2, 1967 · N73096 · Substantial damage NTSB NYC67D0553Accident · No injuriesClosedCessna 140 · West Chester, PAFeb 26, 1967 · N72995 · Substantial damage NTSB MKC67D0483Accident · No injuriesClosedCessna 140 · Cohasset, MNFeb 25, 1967 · N3709V · Substantial damage NTSB NYC67F0530Accident · No injuriesClosedLuscombe 8E · Deer Park, NYFeb 22, 1967 · N2930K · Substantial damage NTSB MKC67D0536Accident · No injuriesClosedChampion 7DC · Roosevelt, MNFeb 21, 1967 · N4516E · Substantial damage NTSB SEA67F0267Accident · No injuriesClosedErcoupe 415-C · Eugene, ORFeb 12, 1967 · N3555H · Substantial damage NTSB ANC67F0086Accident · No injuriesClosedPiper J3C · Talkeetna, AKFeb 11, 1967 · N32708 · Substantial damage NTSB SEA67D0241Accident · No injuriesClosedCessna 140 · Starbuck, WAFeb 8, 1967 · N77018 · Substantial damage NTSB DIA67F0061Accident · No injuriesClosedCessna 140 · Wilmington, DEFeb 8, 1967 · N89328 · Substantial damage NTSB NYC67F0487Accident · No injuriesClosedErco 4I5-CD · West Mifflin, PAFeb 4, 1967 · N3913H · Substantial damage NTSB SEA67D0284Accident · No injuriesClosedCessna 140 · Bothell, WAJan 30, 1967 · N2199N · Substantial damage NTSB SEA67D0283Accident · No injuriesClosedCessna 140 · Redmond, WAJan 30, 1967 · N89528 · Substantial damage NTSB FTW67D0425Accident · No injuriesClosedCessna 140 · Baton Rouge, LAJan 30, 1967 · N72844 · Substantial damage NTSB LAX67D0284Accident · No injuriesClosedCessna 140A · Essex, CAJan 28, 1967 · N9436A · Substantial damage NTSB NYC67F0483Accident · No injuriesClosedCessna 120 · Ballston Spa, NYJan 15, 1967 · N2254N · Substantial damage NTSB OAK67D0217Accident · No injuriesClosedCessna 140 · Newman, CAJan 13, 1967 · N72777 · Substantial damage NTSB LAX67F0274Accident · No injuriesClosedLuscombe 8A · Piru, CAJan 13, 1967 · N1357B · Substantial damage NTSB MIA67F0404Accident · No injuriesClosedErcoupe 415-C · Lithonia, GAJan 6, 1967 · N99318 · Substantial damage NTSB NYC67F0683Accident · No injuriesClosedCessna 120 · Tarentum, PAJan 5, 1967 · N77474 · Substantial damage NTSB NYC67D0485Accident · No injuriesClosedCessna 140 · Red Bank, NJJan 2, 1967 · N72427 · Substantial damage NTSB MKC67D0395Accident · No injuriesClosedCessna 120 · Marion, IADec 31, 1966 · N2672N · Substantial damage NTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NEDec 29, 1966 · N6637H · Substantial damage NTSB MKC67D0384Accident · No injuriesClosedCessna 120 · Buyek, MNDec 26, 1966 · N72775 · Substantial damage NTSB NYC67D0435Accident · No injuriesClosedCessna 120 · Jobstown, NJDec 21, 1966 · N4221N · Substantial damage NTSB MIA67D0341Accident · No injuriesClosedErco 415-D · Logansville, GADec 19, 1966 · N99143 · Substantial damage NTSB DEN67D0186Accident · Minor injuriesClosedAeronca 7AC · Layton, UTDec 16, 1966 · N81973 · Substantial damage NTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damage NTSB FTW67F0345Accident · Minor injuriesClosedPiper J3C-65 · Tulsa, OKDec 10, 1966 · N56274 · Substantial damage NTSB OAK67D0173Accident · No injuriesClosedLuscombe 8E · Novato, CANov 23, 1966 · N1350B · Substantial damage NTSB NYC67F0396Accident · No injuriesClosedRearwin 185 · Yorktown Hts, NYNov 21, 1966 · N93245 · Substantial damage NTSB MIA67F0298Accident · No injuriesClosedLuscombe 8E · Iami, FLNov 9, 1966 · N1526B · Substantial damage NTSB FTW67D0310Accident · No injuriesClosedErcoupe 415-C · Crosbyton, TXNov 6, 1966 · N94399 · Substantial damage NTSB NYC67D0346Accident · No injuriesClosedCessna 120 · Waynesboro, VANov 5, 1966 · N1805N · Substantial damage NTSB FTW67F0285Accident · No injuriesClosedCessna 140 · Arlington, TXNov 5, 1966 · N1710V · Substantial damage NTSB OAK67D0256Accident · Serious injuriesClosedCessna 120 · Hayward, CAOct 30, 1966 · N2507N · No damage NTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PAOct 30, 1966 · N1992V · Substantial damage NTSB SEA67D0164Accident · Minor injuriesClosedAeronca 7AC · Twin Falls, IDOct 29, 1966 · N3085E · Substantial damage NTSB MKC67F0303Accident · No injuriesClosedAeronca 11CC · Savage, MNOct 28, 1966 · N4132E · Substantial damage NTSB LAX67D0196Accident · No injuriesClosedCessna 140 · Chino, CAOct 25, 1966 · N2133N · Substantial damage NTSB CHI67D0362Accident · No injuriesClosedCessna 120 · Wheeling, ILOct 16, 1966 · N1772V · Substantial damage NTSB NYC67D0327Accident · No injuriesClosedLuscombe 8E · Middletown, NJOct 15, 1966 · N2419K · Substantial damage NTSB NYC67D0325Accident · No injuriesClosedCessna 140A · Sutton, WVOct 12, 1966 · N5619C · Substantial damage NTSB MIA67F0199Accident · No injuriesClosedCessna 120 · Morganton, NCOct 8, 1966 · N4003N · Substantial damage NTSB MKC67F0281Accident · No injuriesClosedGlobe GC-1A · St.Louis, MOOct 2, 1966 · N90321 · Substantial damage NTSB LAX67D0206Accident · No injuriesClosedCessna 140 · Blythe, CAOct 2, 1966 · N89923 · Substantial damage NTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYSep 28, 1966 · N89262 · Substantial damage NTSB LAX67D0174Accident · No injuriesClosedLuscombe 8E · Phoenix, AZSep 24, 1966 · N1676K · Substantial damage