Final NTSB investigations: Continental IO-550-C
9 cases on aircraft whose registry engine model is Continental IO-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
| 1980 | 1 |
|---|---|
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17209'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17209'))
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 ERA25LA045Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G58 · Fairfield Township, NJThe pilot’s failure to properly configure the landing gear for landing.NTSB ERA23FA047Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G58 · Alpharetta, GAThe pilot’s loss of aircraft control for unknown reasons.NTSB CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…NTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17CA047Accident · No injuriesData collectionFinal reportHawker Beechcraft G58 · Atlanta, GAThe pilot’s failure to maintain the proper airspeed during final approach and his subsequent loss of directional control during landing, which resulted in a runway excursion.NTSB CEN15LA280Accident · No injuriesLimited investigationFinal reportBeech G58 · Taylorville, ILThe flight instructor’s failure to verify that the left engine was operational, which resulted in insufficient engine power being available during an attempted go-around and his subsequent loss of airplane control. Contributing to the accident was the…NTSB WPR12LA324Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G58 · Medford, ORA loss of directional control on landing for reasons that could not be determined based on the available evidence.NTSB FTW80DRA16Accident · No injuriesClosedBeech 58 · Eagle Lake, TX