NTSB investigations: Continental 0-200 series, 2008
35 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\") = 2008
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") = 2008
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 CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.NTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB MIA08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Falmouth, KYA 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 CHI08CA280Accident · Minor injuriesData collectionFinal reportCessna 150G · Urbana, OHA loss of engine power due to carburetor ice. Contributing to the accident were environmental conditions conducive to carburetor icing.NTSB LAX08CA291Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Harper, ORThe pilot's failure to maintain clearance from a tree during the takeoff initial climb.NTSB CHI08CA277Accident · No injuriesData collectionFinal reportCessna 150L · Wadsworth, OHThe lack of radio communication with the airplane and the inadequate visual lookout by the driver of the vehicle.NTSB CHI08CA276Accident · Minor injuriesData collectionFinal reportCessna 150J · Spring Grove, ILThe pilot's inadequate preflight planning and his failure to maintain clearance from the trees. Contributing factors were the trees and the high density altitude.NTSB CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB CHI08CA221Accident · Minor injuriesData collectionFinal reportCessna 150G · Grand Rapids, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the crosswind and wind gusts.NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.NTSB CHI08CA194Accident · Minor injuriesData collectionFinal reportCessna 150F · Johannesburg, MIThe pilot's failure to recognize the onset of carburetor icing resulting in a loss of engine power and the unsuitable terrain encountered during the forced landing. Contributing to the accident were the carburetor icing conditions, and the rough terrain.NTSB MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.NTSB CHI08LA162Accident · No injuriesLimited investigationFinal reportCessna 150L · Summerville, SCA total loss of engine power for undetermined reasons.NTSB DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB SEA08CA143Accident · Minor injuriesData collectionFinal reportCessna 150M · Cove, ORThe pilot's failure to maintain clearance with terrain during a go-around.NTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.NTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.NTSB CHI08LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Palestine, ILThe loss of engine power due to carburetor icing. Contributing to the accident were the pilot's decision to conduct a low-power spiraling descent operation during conditions conducive to carburetor icing, and the weather that was conducive to carburetor icing.NTSB LAX08FA115Accident · 2 fatalField investigationFinal reportCessna 150J · Sonora, CAThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident were rising mountainous terrain and a high density altitude.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB LAX08LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mesa, AZA partial loss of engine power for undetermined reasons.NTSB DFW08CA083Accident · No injuriesData collectionFinal reportCessna 150 · Idabell, OKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident are high and gusting winds.NTSB NYC08LA137Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Middlesboro, KYThe mechanic's improper maintenance installation of the No. 1 cylinder rocker arms which led to oil starvation and a loss of engine power.NTSB CHI08CA084Accident · No injuriesData collectionFinal reportCessna 150G · Viroqua, WIThe pilot not maintaining directional control during the landing and the ground loop the pilot encountered. A factor was the crosswind.NTSB MIA08CA047Accident · No injuriesData collectionFinal reportCessna 150J · Dawson, GAThe pilot's failure to maintain directional control during landing roll out.NTSB LAX08FA049Accident · 5 fatalField investigationFinal reportCessna 172N · Corona, CAThe failure of both pilots to see and avoid the other airplane.NTSB NYC08CA079Accident · No injuriesData collectionFinal reportCessna 150G · Sarasota, FLThe pilot's improper preflight and in-flight planning which resulted in a loss of engine power due to fuel exhaustion.