NTSB investigations: Continental 0-200 series, 2014
19 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 | 96 |
|---|---|
| 1965 | 172 |
| 1966 | 317 |
| 1967 | 365 |
| 1968 | 305 |
| 1969 | 299 |
| 1970 | 273 |
| 1971 | 265 |
| 1972 | 216 |
| 1973 | 191 |
| 1974 | 222 |
| 1975 | 212 |
| 1976 | 214 |
| 1977 | 232 |
| 1978 | 209 |
| 1979 | 171 |
| 1980 | 123 |
| 1981 | 118 |
| 1982 | 104 |
| 1983 | 100 |
| 1984 | 101 |
| 1985 | 84 |
| 1986 | 76 |
| 1987 | 94 |
| 1988 | 79 |
| 1989 | 71 |
| 1990 | 98 |
| 1991 | 67 |
| 1992 | 75 |
| 1993 | 82 |
| 1994 | 71 |
| 1995 | 56 |
| 1996 | 62 |
| 1997 | 70 |
| 1998 | 52 |
| 1999 | 76 |
| 2000 | 63 |
| 2001 | 68 |
| 2002 | 47 |
| 2003 | 55 |
| 2004 | 50 |
| 2005 | 53 |
| 2006 | 44 |
| 2007 | 56 |
| 2008 | 35 |
| 2009 | 38 |
| 2010 | 38 |
| 2011 | 38 |
| 2012 | 38 |
| 2013 | 23 |
| 2014 | 19 |
| 2015 | 36 |
| 2016 | 31 |
| 2017 | 23 |
| 2018 | 29 |
| 2019 | 25 |
| 2020 | 21 |
| 2021 | 34 |
| 2022 | 29 |
| 2023 | 30 |
| 2024 | 29 |
| 2025 | 27 |
| 2026 | 19 |
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\") = 2014
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") = 2014
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 ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB CEN14CA515Accident · Minor injuriesData collectionFinal reportCessna 150J · Brookfield, WIThe pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.NTSB ERA14LA411Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Creedmoor, NCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s impairment due to alcohol ingestion.NTSB ERA14LA401Accident · No injuriesLimited investigationFinal reportCessna 150G · Pittstown, NJA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14FA387Accident · 2 fatalField investigationFinal reportCessna 150 · Mount Pleasant, SCThe commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…NTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…NTSB CEN14CA381Accident · No injuriesData collectionFinal reportCessna 150D · Greenfield, INThe student pilot failed to maintain directional control while landing with a crosswind.NTSB ERA14FA328Accident · 2 fatalField investigationFinal reportCessna 150J · Topping, VAThe pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.NTSB WPR14LA232Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ronan, MTA loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.NTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.NTSB ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.NTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…NTSB CEN14LA144Accident · No injuriesLimited investigationFinal reportCessna 150 - G · Galion, OHA total loss of engine power on climbout for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.