NTSB investigations: Continental TSIO-520 series, 2012, FL
3 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
| 1974 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 2 |
| 1980 | 1 |
| 1981 | 7 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 5 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 2 |
| 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\") = 2012
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2012
AND c."eventStateOrRegion" = 'FL' 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 ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.NTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…NTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.