NTSB investigations: Continental IO-550-N, 2018
7 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\") = 2018
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") = 2018
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 ERA19LA057Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Kennesaw, GAThe total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB GAA18CA578Accident · No injuriesData collectionFinal reportCirrus SR22 · Frederick, MDThe pilot's improper landing flare, which resulted in the airplane porpoising.NTSB ERA18LA253Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Montauk, NYThe pilot's failure to properly secure his seat before initiating the takeoff, which resulted in the seat sliding back as the airplane accelerated during takeoff, his inability to reach the pedals, and the subsequent loss of directional control and impact…NTSB GAA18CA420Accident · No injuriesData collectionFinal reportCirrus SR22 · Hudson, NYCollision with a deer during landing.NTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.NTSB CEN18FA204Accident · 2 fatalField investigationFinal reportCirrus SR22 · Midland, TXAn inadvertent stall, resulting in an uncontrollable descent and impact with terrain. Contributing to the accident was the high density altitude.NTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.