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 MIA66A0011Accident · 2 fatalClosedCessna 120 · Brooksville, FLJul 17, 1965 · N22412 · Substantial damage NTSB FTW66D0149Accident · Minor injuriesClosedCessna 140 · Cashion, OKJul 15, 1965 · N72688 · Substantial damage NTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damage NTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARJul 7, 1965 · N88371 · Substantial damage NTSB NYC66F0056Accident · Minor injuriesClosedMiniplane DSA-1 · New Haven, CTJul 3, 1965 · N9155R · Substantial damage NTSB SEA66F0058Accident · No injuriesClosedCessna 120 · Kalispell, MTJun 29, 1965 · N77423 · Destroyed NTSB OAK66F0021Accident · Minor injuriesClosedCessna 140 · Dos Palos, CAJun 27, 1965 · N2244N · Substantial damage NTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDJun 27, 1965 · N72455 · Destroyed NTSB DEN66D0043Accident · No injuriesClosedCessna 140 · Hereford, AZJun 27, 1965 · N1634V · Substantial damage NTSB LAX66F0003Accident · Serious injuriesClosedCessna 140 · Lathrop Wells, NVJun 21, 1965 · N72467 · Substantial damage NTSB MIA66D0043Accident · Minor injuriesClosedCessna 140 · Chattanooga, TNJun 20, 1965 · N72386 · Substantial damage NTSB SEA66F0021Accident · No injuriesClosedCessna 120 · Brewster, WAJun 19, 1965 · N2792N · Substantial damage NTSB LAX66D0030Accident · No injuriesClosedCessna 120 · Fullerton, CAJun 18, 1965 · N77470 · Substantial damage NTSB NYC66F0129Accident · No injuriesClosedForney 415-C · Spring Valley, NYJun 17, 1965 · N99463 · Substantial damage NTSB NYC66F0106Accident · No injuriesClosedCessna 120 · Beaver Falls, PAJun 15, 1965 · N2729N · Substantial damage NTSB MKC66F0067Accident · No injuriesClosedCessna 140 · Columbia, SDJun 10, 1965 · N2341N · Substantial damage NTSB CHI66F0206Accident · No injuriesClosedCessna 140 · Joliet, ILJun 9, 1965 · N2353V · Substantial damage NTSB LAX66D0065Accident · No injuriesClosedLuscombe 8E · Las Vegas, NVJun 5, 1965 · N1687K · Substantial damage NTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MAJun 3, 1965 · N186CM · Minor damage NTSB MKC66F0019Accident · No injuriesClosedErcoupe 415C · Wellington, KSJun 3, 1965 · N87131 · Substantial damage NTSB MIA65F0123Accident · No injuriesClosedPiper J3L · Chattanooga, TNJun 1, 1965 · N30798 · Substantial damage NTSB MIA66D0054Accident · No injuriesClosedCessna 140 · Franklin, NCMay 31, 1965 · N90170 · Substantial damage NTSB CHI66F0041Accident · No injuriesClosedCessna 120 · Dixon, ILMay 31, 1965 · N3692V · Substantial damage NTSB NYC66D0028Accident · No injuriesClosedTaylorcraft BC-12D · Rumford, MEMay 30, 1965 · N43292 · Substantial damage NTSB NYC66F0019Accident · No injuriesClosedCessna 140 · Zelienople, PAMay 26, 1965 · N508D · Substantial damage NTSB OAK66F0012Accident · Minor injuriesClosedCessna 140 · Montague, CAMay 25, 1965 · N77S · Substantial damage NTSB SEA66F0014Accident · Minor injuriesClosedTaylorcraft BC-12D · Madras, ORMay 15, 1965 · N43669 · Substantial damage NTSB DEN65D0086Accident · No injuriesClosedLuscombe 8E · Lovell, WYMay 12, 1965 · N2422K · Substantial damage NTSB MKC66D0020Accident · No injuriesClosedCessna 120 · Big Bow, KSMay 8, 1965 · N2391N · Substantial damage NTSB CHI65F0177Accident · No injuriesClosedCessna 140 · Pontiac, MIMay 1, 1965 · N76943 · Substantial damage NTSB OAK65F0037Accident · No injuriesClosedLuscombe 8E · Fresno, CAApr 26, 1965 · N2368K · Substantial damage NTSB LAX65D0073Accident · No injuriesClosedCessna 140 · Ely, NVApr 26, 1965 · N76367 · Substantial damage NTSB MKC65F0122Accident · No injuriesClosedCessna 140 · Maryville, MOApr 20, 1965 · N89826 · Substantial damage NTSB FTW65F0049Accident · No injuriesClosedFunk B85C · Austin, TXApr 16, 1965 · N81105 · Substantial damage NTSB MKC65F0062Accident · Minor injuriesClosedForney 415E · Papillion, NEApr 12, 1965 · N94852 · Substantial damage NTSB CHI65F0140Accident · No injuriesClosedPiper PA-15 · Adrian, MIApr 7, 1965 · N4301H · Destroyed NTSB CHI65D0061Accident · No injuriesClosedCessna 140 · Newark, OHApr 6, 1965 · N72782 · Substantial damage NTSB OAK65F0038Accident · No injuriesClosedLuscombe 8E · Concord, CAMar 30, 1965 · N2368K · Substantial damage NTSB CHI65F0115Accident · No injuriesClosedCessna 140 · Hastings, MIMar 28, 1965 · N89480 · Substantial damage NTSB SEA65F0025Accident · No injuriesClosedCessna 140 · Lebanon, ORMar 27, 1965 · N2593N · Substantial damage NTSB LAX65F0052Accident · Serious injuriesClosedCessna 140 · Hawthorne, CAMar 25, 1965 · N4029N · Destroyed NTSB SEA65F0057Accident · No injuriesClosedCessna 140 · Great Falls, MTMar 21, 1965 · N2585N · Substantial damage NTSB FTW65F0002Accident · No injuriesClosedCessna 140 · Fort Hood, TXMar 15, 1965 · N72949 · Substantial damage NTSB NYC65D0127Accident · No injuriesClosedCessna 140 · Pitman, NJMar 14, 1965 · N76391 · Substantial damage NTSB MKC65D0138Accident · No injuriesClosedLuscombe 8A · Creston, IAMar 12, 1965 · N1990B · Substantial damage NTSB SEA65F0020Accident · No injuriesClosedCessna 140 · Pullman, WAMar 9, 1965 · N72232 · Substantial damage NTSB MIA65F0006Accident · No injuriesClosedCessna 140 · Batesville, MSMar 8, 1965 · N72717 · Substantial damage NTSB UNK65X1468Accident · No injuriesClosedCessna 140 · Jamison, ALMar 7, 1965 · N72207 · Substantial damage NTSB MKC65D0046Accident · No injuriesClosedCessna 140 · Davenport, IAMar 6, 1965 · N2733N · Substantial damage NTSB FTW66F0003Accident · No injuriesClosedLuscombe 8E · Stowell, TXMar 5, 1965 · N22004 · Substantial damage