Fatal NTSB investigations: Continental TSIO-520 series, 2013
9 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
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\") = 2013
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") = 2013
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 ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB WPR14FA094Accident · 5 fatalField investigationFinal reportBeech B36TC · Yellow Pine, IDThe pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.NTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…NTSB CEN14FA051Accident · 2 fatalField investigationFinal reportCessna T310R · Junction, TXThe noninstrument-rated private pilot's decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in the loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a weather…NTSB CEN14FA047Accident · 3 fatalField investigationFinal reportBeechcraft B36TC · Amarillo, TXThe noninstrument-rated pilot’s improper decision to fly a night instrument approach in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane during an attempted missed approach.NTSB ERA14LA006Accident · 4 fatalLimited investigationFinal reportCessna 340A · Hampton Roads, VAThe pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.NTSB WPR14LA005Accident · 4 fatalLimited investigationFinal reportCessna 340A · Paulden, AZThe pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.NTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…