NTSB investigations: Continental O-470 series, 2009, TX
4 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 | 24 |
|---|---|
| 1965 | 16 |
| 1966 | 27 |
| 1967 | 20 |
| 1968 | 14 |
| 1969 | 10 |
| 1970 | 16 |
| 1971 | 7 |
| 1972 | 7 |
| 1973 | 7 |
| 1974 | 7 |
| 1975 | 12 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 13 |
| 1979 | 6 |
| 1980 | 13 |
| 1981 | 5 |
| 1982 | 8 |
| 1983 | 11 |
| 1984 | 4 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 6 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 7 |
| 2009 | 4 |
| 2010 | 11 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 6 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 10 |
| 2023 | 2 |
| 2024 | 2 |
| 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\") = 2009
AND c.\"eventStateOrRegion\" = 'TX' 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 ('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") = 2009
AND c."eventStateOrRegion" = 'TX' 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 ('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 CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.NTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB CEN09CA419Accident · No injuriesData collectionFinal reportCessna 182Q · Ballinger, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning.