NTSB investigations: Continental TSIO-550-K, CA
9 cases on aircraft whose registry engine model is Continental TSIO-550-K. 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
| 2017 | 1 |
|---|---|
| 2018 | 1 |
| 2024 | 2 |
| 2025 | 4 |
| 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 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 ('17410'))
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 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 ('17410'))
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 WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.NTSB WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.NTSB ANC25LA040Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · San Luis Obispo, CAThe pilot's failure to maintain directional control during takeoff.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB WPR25LA085Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Santa Barbara, CAOn January 29, 2025, about 1417 Pacific standard time, a Cirrus Design Corp SR22T, N124LZ, was destroyed when it was involved in an accident near Santa Barbara, California. The two pilots were seriously injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA041Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Palm Springs, CAThe pilot’s failure to maintain clearance from a commercial airliner which resulted in an encounter with wake turbulence and subsequent loss of control resulting in impact with terrain.NTSB ANC24LA026Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Paso Robles, CAThe flight instructor’s failure to maintain adequate airspeed during landing which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot receiving instructions failure to maintain runway alignment.NTSB WPR18FA093Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · San Diego, CAThe pilot's exceedance of the airplane's critical angle of attack during an attempted return to the runway following a total loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the excessive amount of…NTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…