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 UNK64X4019Accident · No injuriesClosedLuscombe 8E · Cohoes, NYSep 17, 1964 · N1774K · Substantial damage NTSB UNK64X4010Accident · No injuriesClosedPiper J-3 · Anchorage, AKSep 16, 1964 · N98787 · Substantial damage NTSB UNK64X3975Accident · No injuriesClosedAeronca 7AC · West Newfield, MESep 13, 1964 · N84837 · Substantial damage NTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNSep 13, 1964 · N72393 · Substantial damage NTSB UNK64X3970Accident · No injuriesClosedCessna 140 · Amarillo, TXSep 13, 1964 · N72807 · Destroyed NTSB UNK64X3934Accident · No injuriesClosedAeronca 7BCM · Rochester, NHSep 12, 1964 · N83457 · Destroyed NTSB UNK64X3883Accident · Minor injuriesClosedErcoupe 415C · Easton, PASep 9, 1964 · N94396 · Substantial damage NTSB UNK64X3880Accident · No injuriesClosedCulver V · Pacoima, CASep 9, 1964 · N3104K · Substantial damage NTSB UNK64X3862Accident · No injuriesClosedCessna 120 · South Bend, INSep 7, 1964 · N1791N · Substantial damage NTSB UNK64X3784Accident · No injuriesClosedCessna 120 · Vancouver, WASep 5, 1964 · N1782N · Substantial damage NTSB UNK64X3741Accident · No injuriesClosedErcoupe 415C · Bennington, VTSep 2, 1964 · N2415H · Substantial damage NTSB UNK64X3727Accident · No injuriesClosedCessna 140 · Northbrook, ILSep 1, 1964 · N89918 · Substantial damage NTSB UNK64X3698Accident · No injuriesClosedPiper J3 · Chattanooga, TNAug 31, 1964 · N30798 · Substantial damage NTSB UNK64X3691Accident · No injuriesClosedCessna 120 · Pride, LAAug 30, 1964 · N77008 · Substantial damage NTSB UNK64X3664Accident · No injuriesClosedCessna 140 · Gualala, CAAug 29, 1964 · N76587 · Substantial damage NTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MIAug 29, 1964 · N2981N · Substantial damage NTSB UNK64X3631Accident · No injuriesClosedPiper J3 · Copperscove, TXAug 27, 1964 · N6711H · Substantial damage NTSB UNK64X3606Accident · No injuriesClosedAeronca 7BCM · Denton, TXAug 26, 1964 · N81779 · Substantial damage NTSB UNK64X3589Accident · No injuriesClosedCessna 120 · West Salem, ILAug 25, 1964 · N76542 · Substantial damage NTSB UNK64X3584Accident · No injuriesClosedPiper J3C · Anchorage, AKAug 25, 1964 · N42128 · Substantial damage NTSB UNK64X3583Accident · Minor injuriesClosedAeronca 7AC · Chiloquin, ORAug 25, 1964 · N2266E · Destroyed NTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WAAug 24, 1964 · N3624V · Substantial damage NTSB UNK64X3559Accident · Minor injuriesClosedLuscombe 8E · Orlando, FLAug 23, 1964 · N2480K · Substantial damage NTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VAAug 22, 1964 · N72134 · Substantial damage NTSB UNK64X3481Accident · Minor injuriesClosedPiper J3 · Talladega, ALAug 19, 1964 · N98023 · Destroyed NTSB UNK64X3476Accident · No injuriesClosedCessna 140 · Nacogdoches, TXAug 19, 1964 · N4131N · Substantial damage NTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NMAug 16, 1964 · N2787N · Destroyed NTSB UNK64X3411Accident · No injuriesClosedLuscombe 8A · Gravois Mills, MOAug 16, 1964 · N2312K · Substantial damage NTSB UNK64X3409Accident · No injuriesClosedPiper PA11 · Funny River, AKAug 16, 1964 · N4624M · Substantial damage NTSB UNK64X3380Accident · No injuriesClosedAeronca 7DC · Sand Springs, MTAug 14, 1964 · N2836E · Substantial damage NTSB UNK64X3379Accident · Minor injuriesClosedErcoupe 415C · Lansing, ILAug 14, 1964 · N87101 · Substantial damage NTSB UNK64X3363AccidentClosedCessna 140 · Sterling, COAug 13, 1964 · N72394 · Substantial damage NTSB UNK64X3348AccidentClosedChampion 7FC · Coloma, WIAug 12, 1964 · N9870B · Substantial damage NTSB UNK64X3301Accident · No injuriesClosedLuscombe 8E · Colo Springs, COAug 9, 1964 · N2944K · Substantial damage NTSB UNK64X3279Accident · No injuriesClosedCessna 120 · Portland, TNAug 8, 1964 · N76008 · Substantial damage NTSB UNK64X3278Accident · No injuriesClosedLuscombe 8E · Camdenton, MOAug 8, 1964 · N2057K · Substantial damage NTSB UNK64X3248Accident · No injuriesClosedPiper PA18A · Douglas, AZAug 6, 1964 · N3599A · 2 aircraft · Substantial damage NTSB UNK64X3235Accident · No injuriesClosedLuscombe 8E · Carrolton, OHAug 6, 1964 · N2011B · Substantial damage NTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WIAug 3, 1964 · N2084V · Substantial damage NTSB UNK64X3103Accident · No injuriesClosedCessna 120 · Laporte City, IAJul 29, 1964 · N2081V · Substantial damage NTSB UNK64X3100Accident · No injuriesClosedLuscombe 8E · Amory, MSJul 29, 1964 · N1941K · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X3048Accident · No injuriesClosedErcoupe 415C · Bartlesville, OKJul 26, 1964 · N94027 · Destroyed NTSB UNK64X3033Accident · No injuriesClosedCessna 140 · Barre, VTJul 25, 1964 · N89746 · Substantial damage NTSB UNK64X2997Accident · No injuriesClosedErcoupe 415E · Middletown, DEJul 23, 1964 · N94866 · Substantial damage NTSB UNK64X2926Accident · No injuriesClosedErcoure 415C · Hanover, NJJul 19, 1964 · N99288 · Substantial damage NTSB UNK64X2924Accident · Minor injuriesClosedLuscombe 8A · Lainsburg, MIJul 19, 1964 · N2586K · Substantial damage NTSB UNK64X2920Accident · No injuriesClosedCessna 140 · Selma, CAJul 19, 1964 · N77265 · Substantial damage NTSB UNK64X2878Accident · No injuriesClosedPiper J5 · Cody, WYJul 17, 1964 · N54677 · Substantial damage NTSB UNK64X2823Accident · No injuriesClosedCessna 140 · Lagrange, TXJul 14, 1964 · N89257 · Destroyed