NTSB investigations: Continental IO-550 series, 2012
12 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
| 1968 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 4 |
| 1998 | 3 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 16 |
| 2002 | 12 |
| 2003 | 15 |
| 2004 | 27 |
| 2005 | 21 |
| 2006 | 24 |
| 2007 | 13 |
| 2008 | 15 |
| 2009 | 20 |
| 2010 | 17 |
| 2011 | 22 |
| 2012 | 12 |
| 2013 | 17 |
| 2014 | 19 |
| 2015 | 18 |
| 2016 | 13 |
| 2017 | 13 |
| 2018 | 17 |
| 2019 | 20 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 16 |
| 2023 | 12 |
| 2024 | 16 |
| 2025 | 13 |
| 2026 | 11 |
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\") = 2012
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") = 2012
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 ERA13CA100Accident · No injuriesData collectionFinal reportRaytheon A36 · Rutland, VTThe pilot's failure to maintain control of the airplane while maneuvering on a snow-packed surface after landing, which resulted in a collision with a fuel truck.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB ERA13LA048Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pahokee, FLA main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.NTSB ERA12CA564Accident · Minor injuriesData collectionFinal reportLancair LC42-550FG · Okeechobee, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.NTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.NTSB CEN12FA617Accident · 1 fatalField investigationFinal reportBeech A36 · Kansasville, WIIn-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.NTSB CEN12LA558Accident · No injuriesLimited investigationFinal reportBeech A36 · Ruleton, KSThe improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.NTSB WPR12FA305Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Salina, UTThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…NTSB ERA12LA295Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Yorktown, NYThe pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.NTSB ERA12WA142Accident · No injuriesForeign investigationCirrus Design SR22 · Andros Island, BahamasOn January 7, 2012, about 1324 eastern standard time, a Cirrus Design Corp. SR22, N723EA, registered to and operated by M&W Aviation LLC, descended into water near Andros Island, Bahamas, following deployment of the Cirrus Airframe Parachute System (CAPS).…