NTSB investigations: Continental 0-200 series, 2023
30 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\") = 2023
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") = 2023
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 ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.NTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.NTSB WPR24LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Woodland, WAThe flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.NTSB ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…NTSB CEN23LA416Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Montrose, COThe pilot’s failure to maintain directional control during the landing roll with a gusting quartering headwind.NTSB CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.NTSB ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.NTSB CEN23FA401Accident · 2 fatalClass 3 · FieldFinal reportCessna 150K · Huntsville, TXA partial loss of engine power due to fuel starvation caused by a fuel system blockage, and the flight instructor’s subsequent failure to maintain adequate airspeed after the loss of engine power, which resulted in the airplane exceeding its critical angle of…NTSB WPR23LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Marble Canyon, AZThe pilot’s loss of airplane control after an encounter with windshear during takeoff which resulted in collision with terrain.NTSB WPR23FA323Accident · 1 fatalClass 3 · FieldFinal reportHensler Howard Cassutt · West Jordan, UTA loss of control during the initial climb for reasons that could not be determined.NTSB ERA23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Pink Hill, NCThe pilot’s inadequate compensation for prevailing wind conditions during the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB CEN23FA352Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Caddo Mills, TXThe pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.NTSB CEN23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Sherman, TXThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.NTSB WPR23LA276Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chelan, WAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and subsequent nose over.NTSB ERA23LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Elberton, GAThe pilot’s decision to take off with a known engine issue, which resulted in a partial loss of power on the initial climb due to the No. 1 cylinder’s exhaust valve becoming stuck. Contributing to the outcome, was the pilot’s delay in aborting the takeoff.NTSB CEN23LA281Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Jeffersonville, INThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR23LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Wishram, WAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN23FA204Accident · 2 fatalClass 3 · FieldFinal reportLuce Buttercup · Lyndonville, NYAn in-flight breakup due to structural overload of the airplane for undetermined reasons.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB ERA23LA222Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150M · Hernando, FLThe pilot’s failure to maintain adequate clearance from obstacles during takeoff at night.NTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…NTSB ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.NTSB CEN23LA136AccidentClass 4 · LimitedFinal reportCessna 150F · Hillsboro, TXSubstantial damage for reasons undetermined based on the available evidence.NTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.NTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.