Fatal NTSB investigations: Continental O-470 series, 2005
7 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\") = 2005
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") = 2005
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 ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.NTSB NYC05FA109Accident · 4 fatalField investigationFinal reportCessna 182Q · Groton, CTThe pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.NTSB NYC05FA100Accident · 1 fatalField investigationFinal reportCessna 182Q · Stockholm, NJThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the ground. Factors in this accident were clouds, and the pilot's spatial disorientation.NTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.NTSB IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.NTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.NTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.