NTSB investigations: Continental TSIO-520 series, 2006, TX
7 cases on aircraft whose registry engine model is Continental TSIO-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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 7 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 6 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 8 |
| 1986 | 4 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 7 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 3 |
| 2016 | 4 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 5 |
| 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\") = 2006
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 ('17040'))
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") = 2006
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 ('17040'))
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 DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB DFW06CA168Accident · No injuriesData collectionFinal reportCessna TU206G · Eldorado, TXThe pilot's failure to maintain airspeed during an emergency simulation resulting in a hard landing. A contributing factor was the flight instructor's delayed remedial action.NTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,NTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.