NTSB investigations: Continental 0-200 series, 2013
23 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\") = 2013
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") = 2013
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 CEN14LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gladewater, TXThe loss of engine power due to carburetor icing.NTSB WPR14CA069Accident · Minor injuriesData collectionFinal reportCessna 150F · Henderson, NVThe flight crew's improper in-flight fuel planning lead to fuel exhaustion, which resulted in a complete loss of engine power.NTSB ERA14CA065Accident · No injuriesData collectionFinal reportCessna 150D · Portland, METhe failure of the pilot to maintain directional control during landing.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.NTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…NTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.NTSB WPR13CA421Accident · No injuriesData collectionFinal reportCessna E162 · Eugene, ORThe pilot's improper flare that resulted in a bounced landing.NTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.NTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…NTSB CEN13CA485Accident · No injuriesData collectionFinal reportCessna 150D · Hermleigh, TXThe pilot's improper positional awareness, which resulted in an off airport landing and impact with terrain.NTSB CEN13LA339Accident · Serious injuriesLimited investigationFinal reportYoungs William D T211 · Festus, MOFuel exhaustion due to the pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power.NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13CA343Accident · No injuriesData collectionFinal reportCessna 150G · Franklin, OHThe pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC13CA050Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Napakiak, AKThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.NTSB WPR13CA173Accident · No injuriesData collectionFinal reportCessna 150 · Brush Praire, WAThe pilot's failure to maintain directional control during the landing flare.NTSB WPR13CA170Accident · No injuriesData collectionFinal reportDiamond DA 20-C1 · Provo, UTThe student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.NTSB WPR13CA165Accident · No injuriesData collectionFinal reportCessna 150 · Bellingham, WAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN13CA197Accident · Minor injuriesData collectionFinal reportCessna 150G · Baytown, TXThe pilot’s poor in-flight decision-making and improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.NTSB CEN13LA179Accident · 1 fatalLimited investigationFinal reportCessna 150M · Deming, NMThe pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.