NTSB investigations: Continental IO-520 series, 2003, CO
4 cases on aircraft whose registry engine model is Continental IO-520 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 3 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 5 |
| 1975 | 4 |
| 1976 | 4 |
| 1977 | 5 |
| 1978 | 4 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 6 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 2 |
| 2025 | 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\") = 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 ('17032'))
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 ('17032'))
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 DEN04LA013Accident · No injuriesLimited investigationFinal reportCessna 210G · Meeker, COthe pilot's failure to extend the landing gear. Contributing to the accident was the pilots failure to recognize the gear warning horn during the landing flare.NTSB DEN03LA118Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Durango, COthe pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the high altitude on base turn and final approach, the low airspeed, the pilot's improper use of flaps, the inadvertent…NTSB DEN03LA107Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe pilot's inadequate in-flight planning/decision in which he mismanaged his fuel supply by failing to switch tanks resulting in fuel starvation and the loss of engine power. A contributing factor was the pilot's diverted attention.NTSB DEN03FA059Accident · 4 fatalField investigationFinal reportCessna A185F · Grand Junction, COthe pilot's poor judgment and his failure to maintain aircraft control. Contributing factors were the high winds and downdrafts, and the pilot's self-induced pressure to go home.