NTSB investigations: Continental O-470 series, 2003, CO
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 | 7 |
|---|---|
| 1965 | 1 |
| 1966 | 5 |
| 1967 | 8 |
| 1968 | 5 |
| 1969 | 8 |
| 1970 | 1 |
| 1971 | 9 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 7 |
| 1977 | 4 |
| 1978 | 2 |
| 1979 | 8 |
| 1980 | 4 |
| 1981 | 3 |
| 1982 | 3 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 5 |
| 2008 | 5 |
| 2009 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2026 | 2 |
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\") = 2003
AND c.\"eventStateOrRegion\" = 'CO' 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") = 2003
AND c."eventStateOrRegion" = 'CO' 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 DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.NTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.NTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.NTSB DEN03TA082Accident · No injuriesFinal reportCessna 182R · Boulder, COthe pilot's failure to maintain aircraft control during landing flare/touchdown which resulted in a hard landing. A contributing factor was the pilot's improper flair.