NTSB investigations: Continental TSIO-520 series, 2003, CA
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
| 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\") = 2003
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") = 2003
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 LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.NTSB LAX04LA047Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Visalia, CAa loss of engine power for undetermined reasons.NTSB LAX03LA283Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Monterey, CAThe pilot’s inadequate in-flight planning/decision, which resulted in a loss of engine power during an instrument approach to land, and an in-flight collision with a tree and terrain.NTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.NTSB LAX03FA182Accident · 5 fatalField investigationFinal reportBeech A36TC · Los Angeles, CAthe pilot's in-flight loss of control due to spatial disorientation, and failure to maintain airspeed, which resulted in a stall/spin. Also causal was the pilot's disregard of the weather information provided and his attempt to continue VFR flight into IMC. A…NTSB LAX03LA089Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Stockton, CAfuel starvation due to the pilot's mismanagement of the fuel supply and failure to verify the fuel quantity on board at departure.NTSB LAX03LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · El Monte, CAthe alternator switch contact failure, which resulted in a complete electrical failure.NTSB LAX03FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Mather, CAloss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…NTSB LAX03FA067Accident · Serious injuriesField investigationFinal reportCessna 414 · Palm Springs, CAThe flight instructor's improper selection of the high boost position for the operating right engine while on base leg to land, which resulted in a loss of engine power of the right engine. Factors associated with the accident are the left engine's loss of…