NTSB investigations: Continental TSIO-520 series, 2006
56 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, newest first
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\") = 2006
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") = 2006
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 ATL06CA042Accident · No injuriesData collectionFinal reportCessna T210N · Rome, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB CHI06FA076Accident · 4 fatalField investigationFinal reportCessna 421B · Wheeling, ILThe pilot's failure to maintain airspeed during the landing approach which led to an inadvertent stall and subsequent uncontrolled descent and impact with the ground.NTSB ATL06LA039Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Murfreesboro, TNThe pilot's failure to maintain airplane control during a precautionary landing following a reported failure (undetermined) of the elevator trim control system.NTSB LAX06LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Mariposa, CAThe failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.NTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB ATL06CA032Accident · Minor injuriesData collectionFinal reportCessna T210L · Auburn, ALThe pilot's failure to attain the proper touchdown point during landing which resulted in an overrun and subsequent on ground collision with a fence.