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 UNK64X2794Accident · No injuriesClosedErcoupe 415CD · Watertown, WIJul 12, 1964 · N94712 · Substantial damage NTSB UNK64X2775Accident · No injuriesClosedLuscombe 8A · Phoenix, AZJul 12, 1964 · N1186B · Substantial damage NTSB UNK64X2770Accident · No injuriesClosedMooney MK18 · Medicine Lodge Ka, KSJul 11, 1964 · N4160 · Substantial damage NTSB UNK64X2736Accident · No injuriesClosedAeronca 7BM · Augusta, GAJul 9, 1964 · N81545 · Substantial damage NTSB UNK64X2708Accident · No injuriesClosedErcoupe 415C · Concord, CAJul 8, 1964 · N93333 · Substantial damage NTSB UNK64X2698Accident · No injuriesClosedAeronca L16 · Meriden, CTJul 7, 1964 · N1316V · Substantial damage NTSB UNK64X2691Accident · 1 fatalClosedPiper J3 · Tekamah, NEJul 6, 1964 · N98775 · Destroyed NTSB UNK64X2655Accident · No injuriesClosedPiper J3C · Yolo, CAJul 5, 1964 · N6515H · Substantial damage NTSB UNK64X2622Accident · No injuriesClosedCessna 140 · Uhrichsville, OHJul 3, 1964 · N77002 · Substantial damage NTSB UNK64X2580Accident · No injuriesClosedCessna 140 · Akron, OHJun 30, 1964 · N76919 · Substantial damage NTSB UNK64X2495Accident · No injuriesClosedErcoupe 415C · Sunray, TXJun 26, 1964 · N3121H · Substantial damage NTSB UNK64X2408Accident · No injuriesClosedLuscombe 8E · National City, CAJun 21, 1964 · N1574K · Substantial damage NTSB UNK64X2357Accident · No injuriesClosedLuscombe 8A · Monroe, LAJun 18, 1964 · N1378K · Substantial damage NTSB UNK64X2304Accident · No injuriesClosedCessna 120 · Lexington, NEJun 15, 1964 · N76948 · Substantial damage NTSB UNK64X2290Accident · No injuriesClosedPiper J3C · Hebron, ILJun 14, 1964 · N98527 · Substantial damage NTSB UNK64X2259Accident · No injuriesClosedCmnwealth 185 · Kellam Field, VAJun 13, 1964 · N92830 · Substantial damage NTSB UNK64X2258Accident · No injuriesClosedPiper J3C · Hartline, WAJun 13, 1964 · N6849H · Substantial damage NTSB UNK64X2225Accident · Minor injuriesClosedTribby 1 · San Antonio, TXJun 11, 1964 · N8083E · Substantial damage NTSB UNK64X2166Accident · No injuriesClosedPiper J3C · Winnebago, ILJun 7, 1964 · N6820H · Substantial damage NTSB UNK64X2146Accident · No injuriesClosedSmith DSA1 · Madison, MSJun 6, 1964 · N1711 · Minor damage NTSB UNK64X2128Accident · No injuriesClosedCessna 140 · Boise, IDJun 5, 1964 · N76680 · Substantial damage NTSB UNK64X2117Accident · Serious injuriesClosedAeronca 7DC · Hollister, CAJun 4, 1964 · N83050 · Substantial damage NTSB UNK64X2088Accident · No injuriesClosedCessna 140 · Decatur, INJun 3, 1964 · N76537 · Substantial damage NTSB UNK64X1955Accident · No injuriesClosedCessna 140 · Clare, MIMay 25, 1964 · N72856 · Substantial damage NTSB UNK64X1934Accident · Minor injuriesClosedLuscombe 8E · Gardner, KSMay 24, 1964 · N2306K · Substantial damage NTSB UNK64X1933Accident · No injuriesClosedCessna 140 · W Milford, NJMay 24, 1964 · N1931N · Substantial damage NTSB UNK64X1915Accident · No injuriesClosedErcoupe 415C · Cream Ridge, NJMay 23, 1964 · N94180 · Substantial damage NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage NTSB UNK64X1904Accident · No injuriesClosedPiper PA15 · Solon, OHMay 23, 1964 · N4185H · Substantial damage NTSB UNK64X1903Accident · No injuriesClosedAeronca 7BCM · Idaho City, IDMay 23, 1964 · N6057C · Substantial damage NTSB UNK64X1899Accident · No injuriesClosedFunk B85C · Corry, PAMay 23, 1964 · N81190 · Substantial damage NTSB UNK64X1880Accident · No injuriesClosedAeronca 7AC · Syracuse, KSMay 22, 1964 · N84795 · Substantial damage NTSB UNK64X1877Accident · No injuriesClosedPiper PA11 · Franklin, NCMay 22, 1964 · N4902M · Substantial damage NTSB UNK64X1827Accident · Minor injuriesClosedPiper J3 · Clinton, NCMay 18, 1964 · N70729 · Substantial damage NTSB UNK64X1824Accident · No injuriesClosedAeronca 7AC · Glasgow, MTMay 18, 1964 · N81712 · Substantial damage NTSB UNK64X1813Accident · 1 fatalClosedFunk B85C · Fort Calhoun, NEMay 17, 1964 · N81192 · Destroyed NTSB UNK64X1806Accident · No injuriesClosedAeronca 11CC · Mt Vernon, GAMay 17, 1964 · N4297E · Substantial damage NTSB UNK64X1787Accident · No injuriesClosedCessna 140 · Belgrade, MTMay 16, 1964 · N76850 · Substantial damage NTSB UNK64X1762Accident · No injuriesClosedLuscombe 8E · Brinkley, ARMay 14, 1964 · N2124K · Substantial damage NTSB UNK64X1749Accident · No injuriesClosedErcoupe 415CD · Weaubleau, MOMay 13, 1964 · N3972H · Substantial damage NTSB UNK64X1709Accident · No injuriesClosedCessna 140 · Atwood, ILMay 10, 1964 · N76501 · Substantial damage NTSB UNK64X1686Accident · No injuriesClosedCessna 140 · Pensacola, FLMay 9, 1964 · N89175 · Substantial damage NTSB UNK64X1667Accident · No injuriesClosedMiniplane · Yucca Valley, CAMay 8, 1964 · N74P · Substantial damage NTSB UNK64X1660Accident · 1 fatalClosedAeronca 7BCM · Truro Beach, MAMay 7, 1964 · N1145V · Destroyed NTSB UNK64X1625Accident · 2 fatalClosedCessna 140 · Winslow, AZMay 5, 1964 · N72621 · Destroyed NTSB UNK64X1616Accident · No injuriesClosedCessna 140 · Boulder, COMay 4, 1964 · N72542 · Substantial damage NTSB UNK64X1597Accident · No injuriesClosedCessna 140 · Fullerton, CAMay 3, 1964 · N72202 · Substantial damage NTSB UNK64X1582Accident · No injuriesClosedCessna 120 · Phoenix, AZMay 3, 1964 · N2507N · Destroyed NTSB UNK64X1571Accident · No injuriesClosedCessna 120 · Okla City, OKMay 2, 1964 · N2391N · Substantial damage NTSB UNK64X1557Accident · No injuriesClosedCessna 120 · Nenana, AKMay 2, 1964 · N77377 · Substantial damage