NTSB investigations: Continental TSIO-520 series, 2000, ID
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
| 1975 | 1 |
|---|---|
| 1980 | 2 |
| 1982 | 5 |
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1999 | 1 |
| 2000 | 3 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 4 |
| 2015 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 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\") = 2000
AND c.\"eventStateOrRegion\" = 'ID' 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") = 2000
AND c."eventStateOrRegion" = 'ID' 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 SEA00LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Council, IDthe fatigue failure of the crankshaft due to improper overhaul procedures. Factors include a soft area in the field where the forced landing took place.NTSB SEA00FA142Accident · 1 fatalField investigationFinal reportCessna TU-206G · Pistol Creek, IDA loss of engine power due to the fracture of the #2 cylinder intake valve stem and the puncturing of the #2 piston dome by the intake valve head. Factors include no suitable landing site within the maneuvering abilities of the aircraft, and coniferous trees…NTSB SEA00LA090Accident · No injuriesLimited investigationFinal reportCessna T210M · Boise, IDThe deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.