Fatal NTSB investigations: Continental 0-200 series, 2015
5 cases on aircraft whose registry engine model is Continental 0-200 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 3 |
| 1968 | 11 |
| 1969 | 8 |
| 1970 | 7 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 6 |
| 1974 | 3 |
| 1975 | 6 |
| 1976 | 4 |
| 1977 | 13 |
| 1978 | 24 |
| 1979 | 10 |
| 1980 | 14 |
| 1981 | 12 |
| 1982 | 10 |
| 1983 | 15 |
| 1984 | 10 |
| 1985 | 9 |
| 1986 | 4 |
| 1987 | 14 |
| 1988 | 14 |
| 1989 | 7 |
| 1990 | 11 |
| 1991 | 6 |
| 1992 | 10 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 13 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 7 |
| 2007 | 10 |
| 2008 | 4 |
| 2009 | 6 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 8 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 1 |
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\") = 2015
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 ('17020'))
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") = 2015
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 ('17020'))
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 ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.NTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.NTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.