NTSB investigations: Continental TSIO-550 series, CA
4 cases on aircraft whose registry engine model is Continental TSIO-550 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
| 2005 | 1 |
|---|---|
| 2007 | 1 |
| 2016 | 1 |
| 2017 | 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 ('17043'))
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 ('17043'))
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 WPR17FA150Accident · 2 fatalField investigationFinal reportCirrus Design SR22T · Schellville, CAThe pilot's failure to maintain adequate airspeed after a loss of engine power, which resulted in an aerodynamic stall at a low altitude from which the pilot was unable to recover. The loss of engine power resulted from the pilot's improper selection for the…NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB SEA07FA247Accident · 6 fatalField investigationFinal reportLancair LC41-550FG · Kernville, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. Contributing to the accident was the pilot's failure to maintain an adequate airspeed.NTSB LAX06FA014Accident · 3 fatalField investigationFinal reportLancair LC-41-550FG · Warner Springs, CAThe flight crew's failure to maintain adequate terrain clearance and their decision to continue flight into known adverse weather conditions. Contributing to the accident was overcast conditions, and terrain obscuration. A finding of the investigation is that…