NTSB investigations: Continental IO-550-N, 2020
9 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\") = 2020
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") = 2020
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 WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.NTSB CEN21LA057Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tishomingo, OKThe pilot’s improper adjustment of the engine mixture control, which resulted in a total loss of engine power. Contributing to the accident was a disconnected oil temperature connector, which was likely damaged during maintenance before the accident flight…NTSB CEN20WA426Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Le Chevillotte, FranceNTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.NTSB CEN20CA335Accident · Serious injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Lafayette, INThe pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.NTSB ANC20CA012Accident · Minor injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Kapolei, HIThe student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.NTSB ERA20LA064Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Kenansville, NCA fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.