NTSB investigations: Continental E185 series, AL

8 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

19662026

NTSB investigations: Continental E185 series, AL per year, 1966–2026: 8 cases
1966	1
1967	2
1969	1
1970	1
1972	1
2005	1
2018	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."eventStateOrRegion" = 'AL' 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\" = 'AL' 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" = 'AL' 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 WPR18LA144Accident · No injuriesLimited investigationFinal reportRyan Navion · Jasper, ALThe other pilot's failure to maintain clearance from another airplane in the formation flight due to sun glare.May 21, 2018 · N4356K · 2 aircraft · Substantial damage NTSB ATL05FA139Accident · 1 fatalField investigationFinal reportBeech BE-D35 · Decatur, ALThe pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.Aug 6, 2005 · N3468B · Substantial damage NTSB MIA72DKJ61Accident · No injuriesClosedBeech B35 · Talladega, ALJun 13, 1972 · N5015C · Substantial damage NTSB MIA70DKJ02Accident · No injuriesClosedBeech A35 · Meridianville, ALJan 4, 1970 · N8416A · Substantial damage NTSB MIA69D0407Accident · No injuriesClosedBeech C35 · Hartselle, ALMar 20, 1969 · N5918C · Substantial damage NTSB MIA68F0093Accident · No injuriesClosedBeech B35 · Bessemer, ALJul 1, 1967 · N8721A · Substantial damage NTSB MIA67F0515Accident · No injuriesClosedNavion A · Alexander Cty, ALApr 6, 1967 · N4321K · Substantial damage NTSB MIA66F0397Accident · No injuriesClosedNavion A · Montgomery, ALJan 12, 1966 · N91616 · Substantial damage