Skip to content

NTSB investigations: Continental E185 series, NY

21 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA15FA313Accident · 1 fatalField investigationFinal reportBeech C35 · Hicksville, NYThe pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…Aug 16, 2015 · N5946C · Destroyed NTSB ERA10LA014Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Mount Morris, NYThe pilot’s improper decision to take off from unsuitable terrain with a quartering tailwind.Oct 10, 2009 · N3515B · Substantial damage NTSB NYC08LA271Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Lockport, NYA partial loss of engine power, as reported by the pilot, for undetermined reasons. Contributing to the accident was the pilot's inadequate preflight planning and the overweight condition of the airplane.Aug 5, 2008 · N5208C · Substantial damage NTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.Jun 6, 1999 · N3191V · Destroyed NTSB IAD99LA011Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · East Moriches, NYThe student pilot's failure to maintain adequate airspeed and the certified flight instructor's inadequate supervision.Oct 20, 1998 · N4529K · Substantial damage NTSB NYC89FA033Accident · 3 fatalField investigationFinal reportBeech A35 · Shirley, NYLoss of control during takeoff, due to the failure (separation) of the right rudder control cable. Contributing to the accident was improper inspection and maintenance of the cable.Nov 18, 1988 · N8697A · Destroyed NTSB NYC82FFA05Accident · Serious injuriesFinal reportNavion A · Hancock, NYThe pilot reported that during takeoff, he climbed to about 20 to 30 ft and raised the gear. At about that time, the aircraft began to sink. He stated that he pulled the power off just before the aircraft hit the ground a few miles from the airport. An…May 16, 1982 · N91662 · Substantial damage NTSB NYC80FA053Accident · 1 fatalClosedBeech C35 · Spring Valley, NYJul 9, 1980 · N16W · Destroyed NTSB NYC72DFJ47Accident · No injuriesClosedBeech D35 · Skaneateles, NYJun 27, 1972 · N3888N · Substantial damage NTSB NYC72FFJ27Accident · Minor injuriesClosedBeech A35 · Centerville, NYFeb 2, 1972 · N8573A · Substantial damage NTSB NYC71FFJ35Accident · No injuriesClosedBeech 35 · Fulton, NYMay 14, 1971 · N80462 · Destroyed NTSB NYC67A0182Accident · 3 fatalClosedBeech A35 · Summitville, NYJun 17, 1967 · N8644A · Destroyed NTSB NYC67D0560Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYMar 26, 1967 · N8120S · Substantial damage NTSB NYC67F0388Accident · No injuriesClosedBeech A35 · Mcdonough, NYNov 27, 1966 · N449B · Substantial damage NTSB NYC67F0270Accident · Minor injuriesClosedNavion A · Phillipstown, NYSep 8, 1966 · N8650H · Substantial damage NTSB NYC67D0013Accident · No injuriesClosedNavion Navion · Malone, NYMay 30, 1966 · N4137K · Substantial damage NTSB NYC66D0540Accident · No injuriesClosedCessna 150 · Islip, NYMar 13, 1966 · N8120S · Substantial damage NTSB NYC66F0257Accident · No injuriesClosedNavion A · Montgomery, NYOct 3, 1965 · N5594A · Substantial damage NTSB NYC66F0093Accident · No injuriesClosedBeechcraft 35 · Frankfort, NYJul 11, 1965 · N3085V · Substantial damage NTSB UNK64X3688Accident · No injuriesClosedNavion A · Cooperstown, NYAug 30, 1964 · N5126K · Substantial damage NTSB UNK64X2855Accident · No injuriesClosedBeechcraft 35 · Niagra Falls, NYJul 16, 1964 · N3290V · Substantial damage