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 UNK64X1508Accident · No injuriesClosedPiper PA12 · Sioux Falls, SDApr 29, 1964 · N3356N · Substantial damage NTSB UNK64X1468Accident · No injuriesClosedCessna 140 · San Diego, CAApr 26, 1964 · N2790N · Substantial damage NTSB UNK64X1359Accident · No injuriesClosedCessna 120 · Macon, MSApr 18, 1964 · N89901 · Substantial damage NTSB UNK64X1264Accident · No injuriesClosedCessna 140 · Bakersfield, CAApr 11, 1964 · N73026 · Substantial damage NTSB UNK64X1258Accident · No injuriesClosedCessna 140A · Marlboro, MAApr 11, 1964 · N89489 · Substantial damage NTSB UNK64X1244Accident · No injuriesClosedCessna 120 · Detroit, MIApr 10, 1964 · N1913N · Substantial damage NTSB UNK64X1242Accident · No injuriesClosedLuscombe 8F · Middletown, NYApr 10, 1964 · N1862K · Substantial damage NTSB UNK64X1158Accident · No injuriesClosedLuscombe 8E · Hopewell, VAApr 4, 1964 · N1879K · Substantial damage NTSB UNK64X1156Accident · No injuriesClosedCessna 120 · Robbinsdale, MNApr 4, 1964 · N2888N · Substantial damage NTSB UNK64X1143Accident · No injuriesClosedChampion 7FC · Muldrow, OKApr 3, 1964 · N84576 · Substantial damage NTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NEApr 3, 1964 · N76748 · Substantial damage NTSB UNK64X1095Accident · No injuriesClosedCessna 140 · Bethel, AKMar 29, 1964 · N72770 · Substantial damage NTSB UNK64X1028Accident · No injuriesClosedCessna 140 · Lake Tomahawk, WIMar 24, 1964 · N2907N · Substantial damage NTSB UNK64X1026Accident · 1 fatalClosedCessna 140 · Westboro, MAMar 23, 1964 · N76660 · Destroyed NTSB UNK64X0944Accident · Minor injuriesClosedCessna 140 · Lincoln, ILMar 15, 1964 · N5310C · Substantial damage NTSB UNK64X0937Accident · No injuriesClosedCessna 120 · Lane, KSMar 15, 1964 · N1795N · Substantial damage NTSB UNK64X0936Accident · No injuriesClosedAeronca 11CC · Fullerton, NEMar 15, 1964 · N4206E · Substantial damage NTSB UNK64X0706Accident · No injuriesClosedErcoupe 415C · Thermal, CAFeb 27, 1964 · N93511 · Substantial damage NTSB UNK64X0677Accident · No injuriesClosedPiper J3 · Belgrade, MTFeb 23, 1964 · N92394 · Substantial damage NTSB UNK64X0649Accident · No injuriesClosedCessna 120 · Frederick, MDFeb 22, 1964 · N90004 · Substantial damage NTSB UNK64X0637Accident · No injuriesClosedCessna 140 · Palo Alto, CAFeb 21, 1964 · N72458 · Substantial damage NTSB UNK64X0564Accident · No injuriesClosedCessna 140 · Hopkins, MNFeb 14, 1964 · N76111 · Substantial damage NTSB UNK64X0539Accident · Minor injuriesClosedCessna 120 · Cuthbert, GAFeb 11, 1964 · N1771N · Destroyed NTSB UNK64X0523Accident · No injuriesClosedCessna 120 · Big Bear Cy, CAFeb 9, 1964 · N1700V · Substantial damage NTSB UNK64X0514Accident · No injuriesClosedErcoupe 415C · Bristol, PAFeb 9, 1964 · N99158 · Substantial damage NTSB UNK64X0511Accident · No injuriesClosedCessna 140 · Castroville, TXFeb 9, 1964 · N76290 · Substantial damage NTSB UNK64X0479Accident · No injuriesClosedCessna 120 · Metamora, ILFeb 6, 1964 · N3570V · Substantial damage NTSB UNK64X0457Accident · No injuriesClosedCessna 140 · Van Nuys, CAFeb 4, 1964 · N2234V · Substantial damage NTSB UNK64X0443Accident · No injuriesClosedLuscombe 8E · Pontiac, SCFeb 2, 1964 · N1815K · Substantial damage NTSB UNK64X0427Accident · No injuriesClosedCessna 120 · Wabash, INFeb 1, 1964 · N76782 · Substantial damage NTSB UNK64X0395Accident · No injuriesClosedCessna 140 · Hillsdale, MIJan 29, 1964 · N72846 · Substantial damage NTSB UNK64X0386Accident · No injuriesClosedCessna 140 · Tyler, TXJan 28, 1964 · N73049 · Substantial damage NTSB UNK64X0376Accident · No injuriesClosedCessna 120 · Harrisonville, MOJan 26, 1964 · N73050 · Substantial damage NTSB UNK64X0357Accident · Serious injuriesClosedAeronca 7BCM · Hasty, MNJan 26, 1964 · N85758 · Destroyed NTSB UNK64X0312Accident · No injuriesClosedCessna 140 · Huey, ILJan 21, 1964 · N76421 · Substantial damage NTSB UNK64X0299Accident · No injuriesClosedPiper J3 · Lancaster, MNJan 19, 1964 · N40821 · Substantial damage NTSB UNK64X0289Accident · No injuriesClosedCessna 140 · Pittstown, NJJan 19, 1964 · N72195 · Substantial damage NTSB UNK64X0235Accident · No injuriesClosedCessna 120 · Lowell, MIJan 12, 1964 · N2946N · Substantial damage NTSB UNK64X0186Accident · No injuriesClosedCessna 120 · Seagoville, TXJan 8, 1964 · N1867N · Substantial damage NTSB UNK64X0178Accident · No injuriesClosedLuscombe 8E · Ft Benton, MTJan 6, 1964 · N1118B · Substantial damage NTSB UNK64X0150Accident · No injuriesClosedCessna 120 · Van Nuys, CAJan 4, 1964 · N2374N · Substantial damage NTSB UNK64X0143Accident · Serious injuriesClosedLuscombe 8A · Palo Alto, CAJan 4, 1964 · N2663K · 2 aircraft · Destroyed