NTSB investigations: Continental TSIO-550-E
7 cases on aircraft whose registry engine model is Continental TSIO-550-E. 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
| 2006 | 1 |
|---|---|
| 2008 | 2 |
| 2012 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17247'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17247'))
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 CEN20LA266Accident · Serious injuriesClass 3 · LimitedFinal reportLancair ES-P · Pauls Valley, OKThe reason for this accident could not be determined based on the available information.NTSB WPR19LA088Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Laramie, WYAn environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.NTSB WPR16FA091Accident · 1 fatalField investigationFinal reportNokes Matthew Lancair IV P · Fallbrook, CAA loss of engine power during cruise for reasons that could not be determined because examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA611Accident · 1 fatalField investigationFinal reportFairley Gooch Lancair IV · Winnsboro, LAThe pilot’s failure to maintain control of the airplane after a loss of engine power during a go-around. Contributing to the accident was the difficult-to-operate fuel selector valve and the pilot’s continued operation of the airplane with a known mechanical…NTSB NYC08FA292Accident · No injuriesField investigationFinal reportSteven A. Jones Lancair IV P · Stafford, VAThe pilot's decision to install voltage regulators in the engine compartment where they were susceptible to water intrusion, which resulted in a malfunction of the standby electrical system's voltage regulator and a subsequent in-flight fire.NTSB LAX08LA066Accident · Serious injuriesLimited investigationFinal reportBartle Lancair IV-P · Murrieta/Temecu, CAA total loss of engine power while on approach due to the electrical overload of a fuse caused by the builder's inadequate design and installation of the electrical ignition system.NTSB NYC06LA112Accident · 2 fatalLimited investigationFinal reportBulmer Lancair IV-P · Somerset, PAThe pilot's failure to maintain sufficient airspeed after takeoff to preclude a stall, which resulted in a loss of control and an inadvertent stall. Factors associated with the accident are the inadvertent stall, the loss of engine power due to the pilot's…