Skip to content

NTSB investigations: Continental E185 series, OH

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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…Jul 20, 2011 · N1883D · Substantial damage NTSB IAD97LA099Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Wadsworth, OHThe pilot's failure to retard the engine throttle to idle during the landing roll. A related factor was the diverted attention.Jul 12, 1997 · N2738V · Substantial damage NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.Feb 24, 1995 · N3344V · Substantial damage NTSB CHI84LA023Accident · No injuriesLimited investigationFinal reportBeech B35 · Northfield, OHDuring takeoff, the acft collided with trees. According to the arpt manager, the acft was rotated prematurely during the takeoff & the plt flew the acft on the back side of the power curve until tree impact. Reportedly, there was no preimpact part failure or…Oct 16, 1983 · N8719A · Substantial damage NTSB CHI81FEK24Accident · No injuriesClosedBeech B35 · Columbus, OHJul 17, 1981 · N5138C · Substantial damage NTSB CHI80FEG09Accident · No injuriesClosedRyan Navion · Troy, OHFeb 6, 1980 · N4341K · Substantial damage NTSB CHI78FA038Accident · 4 fatalClosedBeech 35 · Middletown, OHMay 3, 1978 · N3290V · Destroyed NTSB CHI76FEG08Accident · No injuriesClosedBeech 35 · Dayton, OHMar 11, 1976 · N2818V · Substantial damage NTSB CHI72FEK04Accident · Serious injuriesClosedNavion A · Coshocton, OHSep 8, 1971 · N4483K · Destroyed NTSB CHI71FEK37Accident · No injuriesClosedBeech B35 · Circleville, OHMay 9, 1971 · N8776A · Substantial damage NTSB CHI71FGG17Accident · No injuriesClosedNavion NAV4 · Findlay, OHOct 18, 1970 · N8569H · Substantial damage NTSB CHI69D0416Accident · No injuriesClosedBeech 35 · Stillwell, OHNov 3, 1968 · N312VL · Substantial damage NTSB CHI68D0771Accident · No injuriesClosedBeech A35 · Piqua, OHMay 28, 1968 · N710H · Substantial damage NTSB CHI68F0433Accident · No injuriesClosedBeech D35 · London, OHNov 20, 1967 · N2987B · Substantial damage NTSB CHI68D0486Accident · No injuriesClosedNavion A · Toledo, OHOct 29, 1967 · N4457K · Substantial damage NTSB CHI68F0151Accident · No injuriesClosedBeech 35 · Cleveland, OHJul 31, 1967 · N456B · Substantial damage NTSB CHI68D0045Accident · No injuriesClosedBeech B35 · Cincinnati, OHJun 2, 1967 · N8724R · Substantial damage NTSB CHI67D0027Accident · Minor injuriesClosedNavion A · Waterville, OHApr 23, 1967 · N91173 · Substantial damage NTSB CHI67D0384Accident · Minor injuriesClosedBeech A35 · Concord, OHDec 24, 1966 · N717B · Substantial damage NTSB CHI67F0319Accident · No injuriesClosedBeech C35 · Vienna, OHAug 26, 1966 · N1945D · Substantial damage NTSB CHI66F0178Accident · No injuriesClosedPiper PA-23 · Sandusky, OHJun 12, 1966 · N4092P · 2 aircraft · Substantial damage NTSB CHI66F0723Accident · Minor injuriesClosedBeech 35 · Cincinnati, OHMay 18, 1966 · N275H · Substantial damage NTSB UNK65X0707Accident · No injuriesClosedNavion A · Jefferson, OHNov 14, 1964 · N4505K · Substantial damage NTSB UNK65X0156Accident · No injuriesClosedBeechcraft B35 · Akron, OHOct 5, 1964 · N8906A · Substantial damage NTSB UNK64X0711Accident · No injuriesClosedBeechcraft 35 · Blue Ash, OHFeb 27, 1964 · N2779V · Substantial damage NTSB UNK64X0709Accident · No injuriesClosedBeechcraft A35 · Wadsworth, OHFeb 27, 1964 · N8666A · Substantial damage