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 ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.NTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.NTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.NTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…NTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.NTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB WPR21LA167Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Petaluma, CAThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground loop.NTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB WPR21LA121Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Lodi, CAA total loss of engine power during cruise flight due to a fatigue crack in the No. 3 cylinder connecting rod shaft resulting from either preignition or detonation, which resulted in a forced landing and impact with terrain.NTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA132Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Indian Head, MDThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a total loss of engine power. Contributing was the flight instructor’s mismanagement of the precautionary landing approach.NTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.NTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.NTSB WPR21LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chandler, AZThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Bishop, CAA loss of engine power due to the pilot’s inadvertent closure of the mixture control which starved the engine of fuel and resulted in a hard landing and collision with terrain.NTSB WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB WPR20LA279Accident · FatalClass 4 · LimitedFinal reportCessna 150 · Quillayute, WAThe airplane’s descent into trees and subsequent impact with terrain for undetermined reasons.NTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.NTSB WPR20LA259Accident · Serious injuriesClass 3 · LimitedFinal reportRutan Vari EZE · Kelso Valley, CAThe pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB WPR20LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Port Orchard, WAThe pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.NTSB CEN20LA260Accident · No injuriesClass 3 · LimitedFinal reportChampion 7EC · Port O'Conner, TXThe loss of engine power due to a stuck intake valve.NTSB ERA20CA226Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Shelby, NCThe pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.NTSB CEN20LA239Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Millersport, OHThe loss of engine power for reasons that could not be determined based on the available information.NTSB WPR20CA160Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7ECA · Vine Grove, KYAircraft control was not maintained during initial climb with gusting wind that resulted in a collision with power lines and the terrain.NTSB ERA20CA156Accident · No injuriesData collectionFinal reportCessna 150 · Hamburg, NYThe pilot's improper decision to land on unsuitable terrain, which resulted in a nose-over.NTSB CEN20LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · McKinney, TXThe pilot's inadequate preflight fuel planning and inflight fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN20FA108Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Port Isabel, TXThe pilot’s loss of control during the initial takeoff climb for reasons that could not be determined based on available evidence.NTSB CEN20LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Wadsworth, OHThe pilot’s inadequate preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC20CA016Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Big Lake, AKThe pilot's failure to apply full carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power, a forced landing, and impact with a tree.NTSB WPR20CA084Accident · No injuriesData collectionFinal reportCessna 150 · Prescott, AZThe pilot's improper approach and landing flare, which resulted in a stall and a subsequent hard, bounced landing.NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…NTSB CEN20LA036Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7ECA · Starkville, MSThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision not to visually confirm the remaining fuel onboard during the intermediate stop.NTSB CEN20LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Shreveport, LAThe loss of engine power for undetermined reasons.NTSB WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.NTSB ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.NTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.NTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…NTSB GAA20CA010Accident · No injuriesData collectionFinal reportCessna 150 · Fallon, NVThe pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.NTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB CEN19LA308Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Whitehall, MIThe pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation.NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.