NTSB investigations: Continental IO-550-N, 2010
11 cases on aircraft whose registry engine model is Continental IO-550-N. 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
| 1984 | 1 |
|---|---|
| 2005 | 1 |
| 2006 | 4 |
| 2007 | 8 |
| 2008 | 13 |
| 2009 | 8 |
| 2010 | 11 |
| 2011 | 9 |
| 2012 | 12 |
| 2013 | 5 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 7 |
| 2019 | 14 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 6 |
| 2025 | 14 |
| 2026 | 7 |
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 year(c.\"eventDate\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17215'))
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 year(c."eventDate") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17215'))
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 CEN11LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Nacogdoches, TXThe total loss of engine power during cruise flight for undetermined reasons.NTSB ERA11WA060Accident · No injuriesForeign investigationCirrus Design SR22 · Luzzara, ItalyOn November 12, 2010, at 1000 universal coordinated time, a Cirrus Design Corp SR22, N918SR, experienced a total loss of engine power while in cruise flight, and was substantially damaged during a forced landing to field in Luzzara, Italy. The pilot was not…NTSB ERA11LA043Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hilton Head Island, SCThe Pitts pilot's inadequate visual lookout and failure to maintain clearance from the Cirrus airplane.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB WPR10FA383Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot‘s failure to maintain airspeed and airplane control during a turn from the base leg to final approach due to his diverted attention.NTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.NTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB CEN10WA206Accident · No injuriesForeign investigationCirrus Design SR22 · Berkshire, United KingdomNTSB CEN10CA167Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Sugar Land, TXThe pilot's failure to maintain a proper glidepath and rate of descent during approach, resulting in a hard landing.NTSB ERA10LA135Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Indiantown, FLThe pilot's improper landing flare, which resulted in damage to the nose landing gear and the airplane nosing over.NTSB CEN10CA104Accident · No injuriesData collectionFinal reportCirrus SR22 · Fredericksburg, TXThe pilot's failure to maintain directional control during landing, and his failure to properly execute a go-around.