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 MIA67D0228Accident · No injuriesClosedErcoupe 415-C · Zephyrhills, FLSep 23, 1966 · N2531H · Substantial damage NTSB CHI67D0313Accident · No injuriesClosedAeronca 11BC · Kaukauna, WISep 23, 1966 · N3948E · Substantial damage NTSB OAK67D0128Accident · No injuriesClosedCessna 140 · Columbia, CASep 17, 1966 · N77083 · Substantial damage NTSB NYC67D0264Accident · No injuriesClosedAeronca 7BCM · Charlton City, MASep 17, 1966 · N1143V · Substantial damage NTSB FTW67D0270Accident · No injuriesClosedCessna 140 · Grapevine, TXSep 13, 1966 · N1710V · Substantial damage NTSB LAX67F0100Accident · Minor injuriesClosedAeronca 7DC · Laguna Beach, CASep 10, 1966 · N85033 · Substantial damage NTSB MKC67D0203Accident · No injuriesClosedErcoupe 415-C · Langdon, NDSep 8, 1966 · N93364 · Substantial damage NTSB LAX67D0144Accident · No injuriesClosedCessna 140 · Santa Susana, CASep 7, 1966 · N72677 · Substantial damage NTSB OAK67D0121Accident · No injuriesClosedCessna 140 · Las Vegas, NVSep 3, 1966 · N72685 · Substantial damage NTSB MIA67A0031Accident · 2 fatalClosedLuscombe 8C · Zephrhills, FLSep 2, 1966 · N25208 · Destroyed NTSB LAX67F0087Accident · No injuriesClosedFunk B85C · Sunset Beach, CAAug 30, 1966 · N24154 · Substantial damage NTSB CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYAug 28, 1966 · N4022N · Substantial damage NTSB LAX67F0070Accident · No injuriesClosedCessna 140 · Chino, CAAug 25, 1966 · N2723N · Substantial damage NTSB FTW67F0185Accident · No injuriesClosedCessna 140A · Sikes, LAAug 25, 1966 · N5330C · Substantial damage NTSB CHI67D0589Accident · No injuriesClosedCessna 140 · Spring Bay, ILAug 24, 1966 · N1965N · Substantial damage NTSB LAX67D0086Accident · No injuriesClosedPiper J-3 · Santa Paula, CAAug 21, 1966 · N70238 · Substantial damage NTSB LAX67F0101Accident · No injuriesClosedErco 415-CD · Pacoima, CAAug 20, 1966 · N3540H · Substantial damage NTSB NYC67F0188Accident · Minor injuriesClosedCessna 140 · Princess Anne, MDAug 15, 1966 · N76942 · Substantial damage NTSB NYC67F0168Accident · No injuriesClosedWhitman T-WIND · Sussex, NJAug 14, 1966 · N370Y · Destroyed NTSB LAX67F0096Accident · No injuriesClosedTaylorcraft BC12-D · Santa Susana, CAAug 14, 1966 · N43698 · Substantial damage NTSB LAX67D0131Accident · No injuriesClosedCessna 120 · Guaymas, MexicoAug 8, 1966 · N76231 · Substantial damage NTSB OAK67D0062Accident · No injuriesClosedAeronca 11CC · Fort Bragg, CAAug 6, 1966 · N4412E · Substantial damage NTSB NYC67D0171Accident · No injuriesClosedPiper PA-17 · Burlington, CTAug 6, 1966 · N4664H · Substantial damage NTSB ANC67D0017Accident · No injuriesClosedPiper J-3 · Nome, AKAug 6, 1966 · N92211 · Substantial damage NTSB CHI67D0114Accident · No injuriesClosedErco 415D · Wapakoneta, OHAug 5, 1966 · N2988H · Substantial damage NTSB OAK67D0047Accident · Minor injuriesClosedLuscombe 8E · Vacaville, CAJul 31, 1966 · N2293K · Substantial damage NTSB CHI67F0129Accident · Minor injuriesClosedPiper J-5 · Charlotte, MIJul 30, 1966 · N2966C · Substantial damage NTSB ANC67D0037Accident · No injuriesClosedCessna 140 · Elmendorf Ab, AKJul 29, 1966 · N76619 · Substantial damage NTSB MKC67D0187Accident · No injuriesClosedErcoupe 415C · Knoxville, IAJul 23, 1966 · N87331 · Substantial damage NTSB MIA67D0064Accident · No injuriesClosedLuscombe 8F · Picayune, MSJul 23, 1966 · N2925K · Substantial damage NTSB CHI67F0093Accident · 1 fatalClosedCessna 140 · Freaser, MIJul 22, 1966 · N2378N · Destroyed NTSB NYC67F0142Accident · No injuriesClosedErco 415-D · Manchester, VTJul 20, 1966 · N99246 · Substantial damage NTSB MKC67D0084Accident · No injuriesClosedErcoupe 415C · Rockwell Cty, IAJul 16, 1966 · N3469H · Substantial damage NTSB NYC67F0113Accident · No injuriesClosedCessna 140 · Ilion, NYJul 15, 1966 · N1931N · Substantial damage NTSB NYC67F0054Accident · No injuriesClosedLuscombe 8E · Newport, RIJul 12, 1966 · N1689K · Substantial damage NTSB SEA67D0070Accident · No injuriesClosedLuscombe 8E · Puyallup, WAJul 10, 1966 · N2282K · Substantial damage NTSB NYC67D0180Accident · No injuriesClosedErco 415-C · Sanford, MEJul 10, 1966 · N99158 · Substantial damage NTSB FTW67D0066Accident · No injuriesClosedCessna 120 · Duncan, OKJul 7, 1966 · N2072V · Substantial damage NTSB ANC67D0006Accident · No injuriesClosedLuscombe 8E · Beaver, AKJul 6, 1966 · N2252B · Substantial damage NTSB SEA67D0126Accident · No injuriesClosedCessna 120 · Alderwood, WAJul 4, 1966 · N77299 · Destroyed NTSB MIA67F0190Accident · No injuriesClosedCessna 172 · Jay, FLJun 30, 1966 · N3712L · Substantial damage NTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damage NTSB SEA67D0079Accident · No injuriesClosedErcoupe 415-CD · Madras, ORJun 26, 1966 · N3555H · Substantial damage NTSB OAK67F0017Accident · Minor injuriesClosedLuscombe 8E · Fresno, CAJun 16, 1966 · N2011K · Substantial damage NTSB MKC67F0038Accident · Minor injuriesClosedPiper J3C · Parkston, SDJun 14, 1966 · N6318H · Destroyed NTSB CHI66F0784Accident · No injuriesClosedCessna 120 · Delaware, OHJun 12, 1966 · N2985N · Substantial damage NTSB CHI67D0029Accident · No injuriesClosedCessna 140 · Madison, WIJun 10, 1966 · N72919 · Substantial damage NTSB MIA66D0617Accident · No injuriesClosedCessna 120 · Milledgeville, GAJun 5, 1966 · N3678V · Substantial damage NTSB ANC67F0010Accident · No injuriesClosedAeronca 11BC · Dillingham, AKJun 5, 1966 · N3946E · Substantial damage