Fatal NTSB investigations: Continental TSIO-520 series, 2001
11 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
| 1968 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 10 |
| 1979 | 10 |
| 1980 | 11 |
| 1981 | 11 |
| 1982 | 13 |
| 1983 | 10 |
| 1984 | 9 |
| 1985 | 10 |
| 1986 | 11 |
| 1987 | 9 |
| 1988 | 10 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 8 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 11 |
| 2002 | 12 |
| 2003 | 20 |
| 2004 | 13 |
| 2005 | 10 |
| 2006 | 16 |
| 2007 | 11 |
| 2008 | 8 |
| 2009 | 3 |
| 2010 | 13 |
| 2011 | 8 |
| 2012 | 9 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 9 |
| 2018 | 7 |
| 2019 | 4 |
| 2020 | 8 |
| 2021 | 7 |
| 2022 | 3 |
| 2023 | 6 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 1 |
Where
Open the mapLatest 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\") = 2001
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2001
AND c."highestInjuryLevel" = 'Fatal'
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 LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.NTSB FTW02FA054Accident · 2 fatalField investigationFinal reportCessna T210-M · Monticello, ARThe separation of the #2 connecting rod and subsequent catastrophic failure of the engine. A factor was the in-flight collision with a vehicle while maneuvering to a emergency landing area.NTSB LAX02FA028Accident · 2 fatalField investigationFinal reportCessna 340A · Santa Monica, CAThe pilot's failure to remove the control gust lock prior to takeoff and his failure to abort the takeoff with sufficient runway remaining to stop the airplane on the runway.NTSB LAX02FA018Accident · 1 fatalField investigationFinal reportCessna P210N · Mt. Charleston, NVthe pilot's failure to maintain an adequate airspeed after continuing flight into forecast adverse meteorological conditions consisting of turbulence, icing, and downdrafts, which resulted in a stall/spin.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB IAD01WA081Accident · 2 fatalForeign investigationCessna T210M · Innsbruck, AustriaNTSB LAX01FA270Accident · 1 fatalField investigationFinal reportBeech B36TC · Weaverville, CAthe pilot's selection of the wrong runway, which resulted in an attempted takeoff uphill in a prevailing tailwind toward rising terrain and high obstacles. Also causal was the pilot's loading of the airplane above maximum gross weight and his failure to…NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.NTSB CHI01WA123Accident · 2 fatalForeign investigationCessna T310R · Madinah, Saudi Arabia