Fatal NTSB investigations: Continental E185 series, 2002
5 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 5 |
| 1970 | 3 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1977 | 2 |
| 1978 | 6 |
| 1980 | 3 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 3 |
| 2016 | 4 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 2002
AND 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'))
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 year(c."eventDate") = 2002
AND 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.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.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.