Fatal NTSB investigations: Continental TSIO-520 series, 2016
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
| 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\") = 2016
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") = 2016
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 CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…NTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.NTSB CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…NTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…NTSB ERA16FA185Accident · 4 fatalField investigationFinal reportBeech A36TC · Tupelo, MSA preexisting stress rupture that initiated at a spot weld in the turbocharger v-band exhaust clamp, which resulted in the failure of the clamp and separation of the exhaust tailpipe, an in-flight fire, and subsequent impact with terrain.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.