Fatal NTSB investigations: Continental O-470 series, 2015
12 cases on aircraft whose registry engine model is Continental O-470 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 | 9 |
|---|---|
| 1965 | 5 |
| 1966 | 2 |
| 1967 | 10 |
| 1968 | 2 |
| 1969 | 6 |
| 1970 | 7 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 6 |
| 1977 | 10 |
| 1978 | 25 |
| 1979 | 15 |
| 1980 | 12 |
| 1981 | 12 |
| 1982 | 15 |
| 1983 | 19 |
| 1984 | 16 |
| 1985 | 12 |
| 1986 | 13 |
| 1987 | 12 |
| 1988 | 6 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 10 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 7 |
| 1995 | 9 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 3 |
| 2001 | 8 |
| 2002 | 11 |
| 2003 | 19 |
| 2004 | 15 |
| 2005 | 7 |
| 2006 | 16 |
| 2007 | 19 |
| 2008 | 5 |
| 2009 | 11 |
| 2010 | 5 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 6 |
| 2015 | 12 |
| 2016 | 8 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 2 |
| 2026 | 4 |
Where
Latest 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\") = 2015
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 ('17026'))
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") = 2015
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 ('17026'))
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 CEN16FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Pattonsburg, MOThe pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.NTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN16FA037Accident · 1 fatalField investigationFinal reportCessna 182Q · Richmond, MOThe airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…NTSB WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.NTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB ANC15FA066Accident · 2 fatalField investigationFinal reportCessna 180 · Kasilof, AKThe total loss of engine power for reasons that could not be determined based on postaccident examination and testing.NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaNTSB ERA15FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Mulberry, TNThe pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.NTSB ANC15FA021Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe pilot's decision to continue flight into known icing conditions, contrary to the airplane’s limitations, which resulted in a total loss of engine power due to icing.NTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.NTSB CEN15FA119Accident · 1 fatalField investigationFinal reportCessna 182L · Owen, WIThe flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…