Fatal NTSB investigations: Continental IO-520 series, 2014
14 cases on aircraft whose registry engine model is Continental IO-520 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
| 1964 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 4 |
| 1970 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 9 |
| 1977 | 6 |
| 1978 | 17 |
| 1979 | 30 |
| 1980 | 15 |
| 1981 | 15 |
| 1982 | 22 |
| 1983 | 21 |
| 1984 | 13 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 5 |
| 1988 | 18 |
| 1989 | 9 |
| 1990 | 9 |
| 1991 | 11 |
| 1992 | 9 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 12 |
| 1999 | 13 |
| 2000 | 8 |
| 2001 | 19 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 21 |
| 2005 | 26 |
| 2006 | 16 |
| 2007 | 18 |
| 2008 | 15 |
| 2009 | 10 |
| 2010 | 14 |
| 2011 | 22 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 14 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 16 |
| 2020 | 13 |
| 2021 | 10 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 8 |
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\") = 2014
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 ('17032'))
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") = 2014
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 ('17032'))
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 CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.NTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…NTSB ERA15WA026Accident · 1 fatalForeign investigationCessna 310R · Governors Harbor, BahamasNTSB CEN14WA478Accident · 1 fatalForeign investigationCessna A185F · Baie-Comeau, CanadaNTSB ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.NTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.NTSB WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.NTSB CEN14FA219Accident · 1 fatalField investigationFinal reportBellanca 17 30A · Sweetwater, TXThe pilot’s inadequate inflight fuel management, which led to a loss of engine power due to fuel exhaustion or starvation.NTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.NTSB ERA14FA138Accident · 1 fatalField investigationFinal reportBeech F33 · Lumberport, WVA stroke or cardiovascular event, which resulted in the pilot’s acute impairment or incapacitation and his subsequent flight into terrain.NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.NTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…NTSB ERA14LA084Accident · 1 fatalLimited investigationFinal reportBeech A36 · Fryeburg, METhe pilot’s incapacitation due to a cardiac event during taxi.