Fatal NTSB investigations: Continental IO-550 series, 2013
6 cases on aircraft whose registry engine model is Continental IO-550 series. 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
| 1991 | 1 |
|---|---|
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 7 |
| 2005 | 7 |
| 2006 | 11 |
| 2007 | 2 |
| 2008 | 6 |
| 2009 | 9 |
| 2010 | 7 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 6 |
| 2014 | 5 |
| 2015 | 6 |
| 2016 | 2 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 10 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 6 |
Where
Latest 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\") = 2013
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042'))
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") = 2013
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042'))
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 ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.NTSB WPR13FA244Accident · 2 fatalField investigationFinal reportRaytheon A36 · Mountainaire, AZThe pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…NTSB ERA13FA184Accident · 2 fatalField investigationFinal reportLancair LC42 - 550FG · Winston-Salem, NCThe pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.NTSB CEN13FA130Accident · 4 fatalField investigationFinal reportRaytheon 58 · Maxwell, NEThe pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.