Skip to content

NTSB investigations: Continental E185 series, NM

22 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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 CEN16LA234Accident · No injuriesLimited investigationFinal reportNorth American Navion · Alamogordo, NMThe failure of the No. 5 exhaust valve key spring, which resulted in a total loss of engine power.Jun 24, 2016 · N91137 · Substantial damage NTSB CEN15LA436Accident · No injuriesLimited investigationFinal reportBeech C35 · Belen, NMThe total loss of engine power due to contamination in the fuel system.Sep 26, 2015 · N1990D · Substantial damage NTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.Dec 25, 2009 · N8828A · Substantial damage NTSB CEN09LA170Accident · No injuriesLimited investigationFinal reportBeech B35 · La Luz, NMA loss of engine power due to fuel starvation as a result of a blockage in the right fuel tank vent.Feb 21, 2009 · N8799A · Substantial damage NTSB DEN08LA015Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Santa Fe, NMA leak in the fuel selector valve and gascolator that resulted in fuel starvation during takeoff. Contributing to the accident was a lack of suitable terrain for a forced landing.Oct 20, 2007 · N5104K · Substantial damage NTSB DEN03FA157Accident · 1 fatalField investigationFinal reportBeech 35 · Belen, NMThe pilot's failure to maintain aircraft control immediately after takeoff due to spatial disorientation. A factor was the dark night light conditions.Sep 29, 2003 · N3853N · Destroyed NTSB DEN87LA079Accident · No injuriesLimited investigationFinal reportNorth American Navion · Los Alamos, NMThe instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…Apr 3, 1987 · N91735 · Substantial damage NTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…Mar 30, 1982 · N5237C · Destroyed NTSB FTW81DQD10Accident · No injuriesClosedBeech C35 · Carlsbad, NMDec 4, 1980 · N2033D · Substantial damage NTSB DEN80FQA25Accident · No injuriesClosedBeech 35 · Albuquerque, NMApr 20, 1980 · N2798V · Substantial damage NTSB DEN77DQA48Accident · No injuriesClosedBeech C35 · Albuquerque, NMAug 18, 1977 · N5959C · Destroyed NTSB DEN74FQG03Accident · Serious injuriesClosedNavion A · Jal, NMApr 26, 1974 · N5119K · Substantial damage NTSB DEN71DQA59Accident · No injuriesClosedBeech 35 · Eagle West, NMJun 20, 1971 · N1166 · Substantial damage NTSB DEN68F0095Accident · No injuriesClosedBeech C35 · Albuquerque, NMSep 3, 1967 · N811Y · Substantial damage NTSB DEN67A0076Accident · No injuriesClosedBeech C35 · Santa Fe, NMJun 4, 1967 · N623Z · Substantial damage NTSB DEN67F0284Accident · No injuriesClosedBeech C35 · Albuquerque, NMMay 25, 1967 · N668D · Substantial damage NTSB DEN67D0113Accident · Serious injuriesClosedBeech 35 · Columbus, NMJul 13, 1966 · N3253 · Destroyed NTSB DEN66F0292Accident · No injuriesClosedBeech 35 · Texico, NMApr 10, 1966 · N440B · Substantial damage NTSB FTW66F0336Accident · No injuriesClosedNavion A · Clovis, NMOct 3, 1965 · N91165 · Substantial damage NTSB DEN66D0028Accident · No injuriesClosedBeechcraft 35 · Cuba, NMJun 29, 1965 · N3008V · Destroyed NTSB UNK64X4194Accident · No injuriesClosedBeechcraft A35 · Albuquerque, NMSep 28, 1964 · N8639A · Substantial damage NTSB UNK64X2496Accident · No injuriesClosedBeechcraft D35 · Las Cruces, NMJun 26, 1964 · N2710V · Substantial damage