Skip to content

NTSB investigations: Continental E185 series, MI

26 cases on aircraft whose registry engine model is Continental E185 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 per year

19642026

Where

Latest cases

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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014')) 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.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014'))
  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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014'))
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 CHI04LA099Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Big Rapids, MIThe total loss of engine power due to the pilot's improper fuel management which led to fuel starvation.Apr 4, 2004 · N1922D · Substantial damage NTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.Dec 17, 1999 · N5BB · Substantial damage NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.Jun 5, 1989 · N5011C · Destroyed NTSB CHI87DEM06Accident · Serious injuriesFinal reportNavion A · Baldwin, MIAfter beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the…Apr 19, 1987 · N4961C · Substantial damage NTSB CHI80FEM46Accident · No injuriesClosedBeech A35 · Lincoln, MISep 13, 1980 · N2744V · Destroyed NTSB CHI79FEC48Accident · No injuriesClosedBeech 35 · Detroit, MISep 3, 1979 · N3712N · Substantial damage NTSB CHI78FEC52Accident · No injuriesClosedBeech BE35 · Pontiac, MISep 8, 1978 · N2834V · Substantial damage NTSB CHI76FEM11Accident · No injuriesClosedBeech 35 · Manistee, MISep 14, 1975 · N62X · Substantial damage NTSB CHI76DEM09Accident · Minor injuriesClosedBeech C35 · Rockford, MIAug 29, 1975 · N1863D · Substantial damage NTSB CHI74DEM52Accident · No injuriesClosedBeech A35 · Cheboygan, MIMar 27, 1974 · N8758A · Substantial damage NTSB CHI73FEM38Accident · No injuriesClosedBeech B35 · Grand Rapids, MIJan 20, 1973 · N5240C · Substantial damage NTSB CHI71FDW30Accident · No injuriesClosedBeech 35 · Morrice, MIJan 8, 1971 · N4577V · Substantial damage NTSB CHI69F0535Accident · No injuriesClosedNavion A · Owosso, MIMar 8, 1969 · N8666H · Substantial damage NTSB CHI69F0445Accident · No injuriesClosedBeech D35 · Kalamazoo, MIJan 27, 1969 · N7300U · Substantial damage NTSB CHI69F0136Accident · No injuriesClosedBeech 35 · Byron, MIJul 25, 1968 · N89W · Substantial damage NTSB CHI68D0703Accident · No injuriesClosedNavion A · Port Huron, MIApr 11, 1968 · N4567K · Substantial damage NTSB CHI68F0291Accident · No injuriesClosedNavion B · Tecumseh, MISep 10, 1967 · N8569H · Substantial damage NTSB CHI67F0577Accident · No injuriesClosedBeech D35 · Cadillac, MIMar 6, 1967 · N5968C · Substantial damage NTSB CHI67F0413Accident · No injuriesClosedBeech 35 · Grand Rapids, MIDec 22, 1966 · N2820V · Substantial damage NTSB CHI67F0094Accident · No injuriesClosedBeech C35 · Detroit, MIJul 23, 1966 · N1863D · Substantial damage NTSB CHI67F0083Accident · No injuriesClosedNavion A · Plymouth, MIJun 25, 1966 · N4567K · Substantial damage NTSB CHI66F0695Accident · No injuriesClosedBeech 35 · Eaton, MIApr 21, 1966 · N2820V · Substantial damage NTSB CHI66D0395Accident · No injuriesClosedBeechcraft D-35 · Lake Angelus, MIOct 29, 1965 · N3446B · Substantial damage NTSB CHI66F0344Accident · No injuriesClosedNavion A · Freeland, MIOct 6, 1965 · N8574H · Substantial damage NTSB CHI66F0114Accident · No injuriesClosedBeechcraft 35 · West Branch, MIJul 29, 1965 · N2822V · Substantial damage NTSB UNK65X1155Accident · Minor injuriesClosedBeechraft 35 · Waterford, MIDec 27, 1964 · N2741V · Destroyed