NTSB investigations: Continental TSIO-520 series, 2002, CA
6 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 7 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 9 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 9 |
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 9 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 4 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 7 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2002
AND c."eventStateOrRegion" = 'CA' 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 LAX03TA048Accident · No injuriesFinal reportCessna T210L · Agua Caliente, CAThe failure of the right main landing gear actuator during the landing roll, which resulted in a collapse of the right main land gear, and loss of directional control.NTSB LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…NTSB LAX03FA031Accident · Minor injuriesField investigationFinal reportCessna T210L · Pacoima, CAa loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.NTSB LAX02FA163Accident · 2 fatalField investigationFinal reportCessna T210M · Groveland, CAa catastrophic engine failure due to the fatigue fracture and failure of the crankshaft. A factor contributing to the accident was the unsuitable nature of the mountainous terrain for a successful forced landing. The precipitating cause of the fatigue…NTSB LAX02LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, CAThe collapse of the right main landing gear as a result of a malfunctioning microswitch.NTSB LAX02LA221Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAthe pilot's failure to remain above the landing Boeing 757's glide path resulting in an encounter with wing tip vortices, a loss of directional control after touchdown, and collision with taxiway signs.