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 CHI75DEM18Accident · No injuriesClosedCessna 120 · Burlington, MIOct 31, 1974 · N2339N · Substantial damage NTSB LAX75DUQ16Accident · No injuriesClosedLuscombe 8E · Simi Valley, CAOct 27, 1974 · N77965 · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 120 · Stockbridge, GAOct 6, 1974 · N2481N · Substantial damage NTSB LAX75DUG16Accident · No injuriesClosedCessna 140 · Chino, CAOct 6, 1974 · N76098 · Substantial damage NTSB MIA75FKG33Accident · Minor injuriesClosedCessna 120 · Dawson, GASep 23, 1974 · N1875N · Substantial damage NTSB NYC75FNC09Accident · No injuriesClosedCessna 140 · Nashua, NHSep 22, 1974 · N4006N · Substantial damage NTSB DEN75AD012Accident · 1 fatalClosedCessna 140 · Virginia Dle, COSep 12, 1974 · N72537 · Destroyed NTSB CHI75FEV03Accident · Minor injuriesClosedLuscombe 8E · Gillespie, ILSep 4, 1974 · N1829K · Substantial damage NTSB SEA75DYI08Accident · Minor injuriesClosedPiper J5A · Bend, ORSep 2, 1974 · N38862 · Substantial damage NTSB NYC75DNC07Accident · No injuriesClosedSmith Mini · Post Mills, VTSep 2, 1974 · N417A · Substantial damage NTSB IAD75FLJ09Accident · Minor injuriesClosedCessna 140 · Angier, NCAug 23, 1974 · N2685N · Substantial damage NTSB MIA75DLA12Accident · No injuriesClosedCessna 140 · Panama City, FLAug 22, 1974 · N81063 · Substantial damage NTSB ANC75DAG22Accident · No injuriesClosedPiper PA-11 · King Salmon, AKAug 20, 1974 · N4688M · Substantial damage NTSB CHI75FEI12Accident · No injuriesClosedTaylorcraft BC12-D · Wharton, OHAug 18, 1974 · N43969 · Substantial damage NTSB MKC75DCQ11Accident · No injuriesClosedCessna 140 · Argonia, KSAug 16, 1974 · N76520 · Substantial damage NTSB ANC75DAG16Accident · No injuriesClosedTaylorcraft BC12-D · Skwentna, AKAug 13, 1974 · N94964 · Substantial damage NTSB SEA75DYE08Accident · Minor injuriesClosedErco 415-C · Port Townsnd, WAAug 6, 1974 · N3013H · Destroyed NTSB CHI75DEP14Accident · No injuriesClosedCessna 140 · Shawano, WIAug 2, 1974 · N77253 · Substantial damage NTSB FTW75FPD01Accident · No injuriesClosedCessna 120 · N.Richlnd Hls, TXJul 27, 1974 · N72384 · Substantial damage NTSB MIA75DLD06Accident · No injuriesClosedAeronca 7AC · Clearwater, FLJul 25, 1974 · N81588 · Substantial damage NTSB MKC75DER03Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNJul 15, 1974 · N2314V · Substantial damage NTSB DEN75FQA08Accident · No injuriesClosedPiper PA-11 · Los Lunas, NMJul 3, 1974 · N4516M · Substantial damage NTSB MKC74DCG45Accident · Minor injuriesClosedCessna 140 · Paola, KSJun 29, 1974 · N72597 · Substantial damage NTSB NYC74DNC49Accident · No injuriesClosedAeronca 7DC · Winterport, MEJun 23, 1974 · N84775 · Destroyed NTSB SEA74DYE49Accident · No injuriesClosedLuscombe 8E · Arlington, WAJun 20, 1974 · N2029K · Substantial damage NTSB MKC74DCJ47Accident · No injuriesClosedCessna 140 · Papillion, NEJun 17, 1974 · N76601 · Substantial damage NTSB MKC74FCD39Accident · No injuriesClosedCessna 120 · Hampton, IAJun 14, 1974 · N1883N · Substantial damage NTSB SEA74DTI27Accident · No injuriesClosedCessna 140 · Townsend, MTJun 9, 1974 · N76001 · Substantial damage NTSB MKC74DCG40Accident · No injuriesClosedCessna 120 · Monett, MOJun 4, 1974 · N2702N · Substantial damage NTSB CHI74FEI42Accident · No injuriesClosedCessna 120 · N Bass Islnd, OHJun 2, 1974 · N90004 · Substantial damage NTSB FTW74DQG56Accident · No injuriesClosedCessna 140 · Amarillo, TXMay 22, 1974 · N2020N · Substantial damage NTSB CHI74FEV50Accident · No injuriesClosedCessna 120 · Macomb, ILMay 19, 1974 · N3157N · Substantial damage NTSB ANC74DAH02Accident · No injuriesClosedAeronca 11BC · Soldotna, AKMay 2, 1974 · N4002E · Substantial damage NTSB LAX74FUA07Accident · No injuriesClosedErco 415-D · Long Beach, CAApr 28, 1974 · N2493H · Substantial damage NTSB CHI74DEE70Accident · Minor injuriesClosedErco 415-CD · Dekalb, ILApr 27, 1974 · N99214 · Substantial damage NTSB DEN74FQA39Accident · Minor injuriesClosedAeronca 7BCM · Albuquerque, NMApr 15, 1974 · N6478C · Substantial damage NTSB NYC74FHJ24Accident · No injuriesClosedCessna 140 · White Plains, NYApr 11, 1974 · N89352 · Substantial damage NTSB LAX74DUG47Accident · No injuriesClosedCessna 120 · Apple Vly, CAApr 10, 1974 · N76385 · Substantial damage NTSB OAK74DXQ29Accident · Minor injuriesClosedCessna 140 · Susanville, CAMar 31, 1974 · N2018N · Substantial damage NTSB LAX74FUA20Accident · Serious injuriesClosedCessna 140 · Hntngtn Bch, CAMar 30, 1974 · N89425 · Destroyed NTSB CHI74FEG20Accident · No injuriesClosedCessna 140 · Dayton, OHMar 28, 1974 · N72331 · Substantial damage NTSB ANC74FAA32Accident · Serious injuriesClosedCessna 140 · Delta Jnctn, AKMar 24, 1974 · N2934N · Substantial damage NTSB FTW74FRG70Accident · Minor injuriesClosedErco 415-C · Alice, TXMar 18, 1974 · N99749 · Substantial damage NTSB ANC74FAA74Accident · No injuriesClosedCessna 120 · White Mntn, AKMar 11, 1974 · N2928N · Substantial damage NTSB IAD74DHD30Accident · No injuriesClosedCessna 140 · Dover, DEMar 7, 1974 · N72757 · Substantial damage NTSB SEA74DYA24Accident · No injuriesClosedAeronca 7DC · Ontario, ORFeb 16, 1974 · N3085E · Substantial damage NTSB NYC74DNC38Accident · No injuriesClosedCessna 140 · Wolfeboro, NHFeb 13, 1974 · N3648V · Substantial damage NTSB SEA74DYA20Accident · Minor injuriesClosedTaylorcraft BC12-D · Montpelier, MTFeb 3, 1974 · N39916 · Substantial damage NTSB CHI74FEK14Accident · No injuriesClosedPiper J3C-65 · London, OHJan 30, 1974 · N92224 · Substantial damage NTSB FTW74ORJ31Accident · No injuriesClosedCessna 140 · Vera Cruz, MexicoJan 18, 1974 · N9607A · Substantial damage