Fatal NTSB investigations: Continental TSIO-520 series, 2011
8 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\") = 2011
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") = 2011
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 WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.NTSB CEN11FA425Accident · 1 fatalField investigationFinal reportCessna T210L · Romeoville, ILA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…NTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB WPR11FA170Accident · 1 fatalField investigationFinal reportCessna T310R · Butte, MTThe pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…