NTSB investigations: Continental E185 series, 1991
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 | 67 |
|---|---|
| 1965 | 63 |
| 1966 | 76 |
| 1967 | 72 |
| 1968 | 34 |
| 1969 | 29 |
| 1970 | 22 |
| 1971 | 27 |
| 1972 | 18 |
| 1973 | 15 |
| 1974 | 20 |
| 1975 | 20 |
| 1976 | 16 |
| 1977 | 14 |
| 1978 | 22 |
| 1979 | 10 |
| 1980 | 13 |
| 1981 | 13 |
| 1982 | 9 |
| 1983 | 10 |
| 1984 | 5 |
| 1985 | 9 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 9 |
| 2000 | 8 |
| 2001 | 6 |
| 2002 | 14 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 7 |
| 2008 | 2 |
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 4 |
| 2014 | 3 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 1991
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") = 1991
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 SEA91LA226Accident · No injuriesLimited investigationFinal reportRyan Navion · Chelan, WAPoor in flight planning/decision by the pilot in command. Factors to the accident were: down drafts, proper alignment was not maintained and inadequate remedial action.NTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.NTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.NTSB MIA91LA077Accident · No injuriesLimited investigationFinal reportRyan Navion · Lake City, FLIn-flight encounter with wind shear while on short final resulting in a hard landing.NTSB SEA91FA261Accident · No injuriesField investigationFinal reportBeech 35 · Walla Walla, WAImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter. Improper installation of the trim tabs and an encounter with turbulence were related factors.