NTSB investigations: Continental O-470 series, 2005, CA
9 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\") = 2005
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") = 2005
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 LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.NTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.NTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.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 LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.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 LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.NTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.