NTSB investigations: Continental O-470 series, 2014, CA
6 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 | 27 |
|---|---|
| 1965 | 33 |
| 1966 | 27 |
| 1967 | 37 |
| 1968 | 17 |
| 1969 | 23 |
| 1970 | 24 |
| 1971 | 23 |
| 1972 | 16 |
| 1973 | 18 |
| 1974 | 16 |
| 1975 | 22 |
| 1976 | 12 |
| 1977 | 15 |
| 1978 | 21 |
| 1979 | 21 |
| 1980 | 15 |
| 1981 | 10 |
| 1982 | 8 |
| 1983 | 14 |
| 1984 | 14 |
| 1985 | 4 |
| 1986 | 10 |
| 1987 | 9 |
| 1988 | 7 |
| 1989 | 6 |
| 1990 | 14 |
| 1991 | 14 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 10 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 10 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 7 |
| 2008 | 2 |
| 2009 | 4 |
| 2010 | 7 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 9 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2025 | 8 |
| 2026 | 1 |
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\") = 2014
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2014
AND c."eventStateOrRegion" = 'CA' 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 WPR15CA047Accident · No injuriesData collectionFinal reportCessna 182Q · San Luis Obispo, CAThe pilot's failure to maintain airplane control during the landing flare with a crosswind.NTSB WPR14CA268Accident · Minor injuriesData collectionFinal reportCessna L19 - A · Firebaugh, CAThe pilot's inadequate compensation for the wind conditions in the landing area, which resulted in a loss of directional control and encounter with soft terrain and vegetation.NTSB WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.NTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.NTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.