Fatal NTSB investigations: Continental E185 series

6 cases on aircraft whose registry engine model is Continental E185 series, where the first occurrence was “In flight encounter with weather”. 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

19852026

Fatal NTSB investigations: Continental E185 series per year, 1985–2026: 6 cases
1985	2
1988	2
2002	1
2007	1

Where

Open the map

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."highestInjuryLevel" = 'Fatal' 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') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"highestInjuryLevel\" = 'Fatal'
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."highestInjuryLevel" = 'Fatal'
  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')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 MIA07FA154Accident · 1 fatalField investigationFinal reportNorth American Navion · Clayton, NCThe pilot's intentional abrupt maneuver during low altitude cruise flight to avoid obstructions ahead, resulting in an in-flight collision with terrain and a building. Contributing to the accident were the failure of the pilot to obtain a preflight weather…Sep 21, 2007 · N8844H · Destroyed NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.Apr 8, 2002 · N3292C · Destroyed NTSB LAX88FA192Accident · 2 fatalField investigationFinal reportBeech 35 · Santa Paula, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and above the stall speed.May 7, 1988 · N3322V · Destroyed NTSB BFO88FA031Accident · 2 fatalField investigationFinal reportRyan Navion NA-4 · Fancy Gap, VAThe pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.Mar 25, 1988 · N1598V · Destroyed NTSB LAX86FA037Accident · 1 fatalField investigationFinal reportBeech 35 · Avenal, CAThe plt received a weather briefing (twice) and was advised each time that VFR flt along his route was not recommended. A witness observed the acft flying at a low alt below a cloud layer, when it made an abrupt left descending turn and crashed in a field.…Nov 11, 1985 · N50CN · Destroyed NTSB MIA85FA159Accident · 4 fatalField investigationFinal reportBeech C35 · Tampa, FLWitnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred…Apr 27, 1985 · N1967D · Destroyed