Fatal NTSB investigations: Continental TSIO-550-C
9 cases on aircraft whose registry engine model is Continental TSIO-550-C. 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
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2025 | 1 |
| 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17246'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17246'))
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 WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB WPR25LA212Accident · 1 fatalClass 4 · LimitedFinal reportCessna T240 · San Diego, CAImpact with the ocean for reasons that could not be determined because the pilot and airplane were not located.NTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.NTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.