NTSB investigations: Continental 0-200 series
6,416 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, newest first
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 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 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 CEN16LA004Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dexter, MOThe pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.NTSB WPR15FA268Accident · Serious injuriesField investigationFinal reportCessna 150F · Port Townsend, WAThe loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…NTSB CEN15LA433Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fort Wayne, INThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.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 ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.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 ANC15CA072Accident · No injuriesData collectionFinal reportCessna 150D · Delta Junction, AKThe pilots decision to land on an unfamiliar, unimproved airstrip which resulted in a loss of control and runway excursion.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 ERA15LA323Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dorado, PRA short circuit of unknown origin, which resulted in electrical arcing in the engine compartment and smoke in the cockpit, which necessitated a precautionary landing to a field.NTSB CEN15LA361Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookfield, MOThe pilot's failure to visually check the quantity of fuel in the fuel tanks in accordance with the Preflight checklist, which resulted in a loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.NTSB ANC15CA058Accident · No injuriesData collectionFinal reportCessna 150G · Mekoryuk, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.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.NTSB GAA15CA175Accident · Minor injuriesData collectionFinal reportCessna 150J · Renton, WAThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.NTSB CEN15LA451Accident · No injuriesLimited investigationFinal reportCessna 150L · Carthage, INThe partial loss of engine power due to carburetor icing.NTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB CEN15CA236Accident · No injuriesData collectionFinal reportCessna 150C · Durango, COThe total loss of engine power due to carburetor icing.NTSB ERA15CA209Accident · No injuriesData collectionFinal reportCessna 150D · Balsam Grove, NCThe pilot's decision to attempt an off airport takeoff, and failure to maintain adequate clearance during the initial climb in crosswind conditions, which resulted in a collision with trees.NTSB CEN15LA217Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Neillsville, WIA partial loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA154Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Van Nuys, CABoth pilots’ failure to see and avoid each other, which resulted in an on ground collision while taxiing. Contributing to the accident was the ground controller’s failure to notify either pilot about the presence of the other airplane on the taxiway.NTSB GAA15CA044Accident · No injuriesData collectionFinal reportCessna 150M · Slate Hill, NYThe pilot's failure to maintain an adequate descent rate, resulting in a hard landing.NTSB ERA15LA184Accident · Serious injuriesLimited investigationFinal reportCessna 162 · Shelter Island, NYThe pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.NTSB GAA15CA020Accident · Minor injuriesData collectionFinal reportCessna 150 · Flushing, MILoss of engine power due to fuel contamination. A factor contributing to the accident was the pilot's inadequate preflight.NTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…NTSB WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.NTSB WPR15LA090Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Silver Springs, NVThe loss of engine power for reasons that could not be determined during a postaccident examination of the airplane.NTSB ERA15LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fernandina Beach, FLThe pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.NTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.NTSB CEN15LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pontiac, ILThe flight instructor’s loss of directional control during an attempted go-around with a crosswind. Contributing to the accident was the loss of engine power for reasons that could not be determined during examination of the engine.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.