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 SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.NTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…NTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.NTSB BFO93LA187Accident · No injuriesLimited investigationFinal reportCessna 150B · Woodford, VAThe pilot misjudging his altitude and airspeed and not attaining the proper touchdown point resulting in the airplane exiting the runway and colliding with pine trees. Factors in this accident were: 1) the wet runway, 2) rain which resulted in poor braking…NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB LAX93LA346Accident · No injuriesLimited investigationFinal reportCessna 150L · Chemehuevi Valy, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB FTW93LA253Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Weatherford, TXFuel exhaustion. Factors were: the pilot's failure to have the airplane serviced to capacity prior to departure, and his erroneous fuel consumption calculations.NTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.NTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.NTSB CHI93LA335Accident · No injuriesLimited investigationFinal reportCessna 150J · Rochester, INthe commercial pilot's inadequate preflight planning/preparation.NTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.NTSB NYC93LA155Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Lyndonville, VTAn inadvertent stall of the airplane as a result of the pilot's failure to maintain adequate airspeed and improper use of the carburetor heat and flaps during takeoff which degraded aircraft performance.NTSB CHI93LA313Accident · No injuriesLimited investigationFinal reportCessna 150M · Blue Rapids, KSthe loss of engine power for an undetermined reason.NTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB DEN93LA092Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Galveston, TXThe disconnection of the throttle linkage and the resultant power loss. A factor was the lack of suitable terrain for the forced landing.NTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.NTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.NTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.NTSB LAX93LA294Accident · No injuriesLimited investigationFinal reportCessna 150L · Hanford, CAThe student pilot's failure to maintain aircraft control. Factors related to this accident were the pilot's poorly planned approach, failure to maintain the proper glide path, delay in raising the flaps, and the improper use of the carburetor heat.NTSB ANC93LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC19 · Resurrect'N Bay, AKThe pilot-in-command's failure to maintain directional control upon landing.NTSB BFO93LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150J · East Corinth, METhe pilot's misjudgement of airspeed while making a precautionary landing without airspeed indication, and the block pitot tube.NTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB ANC93LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Dillingham, AKThe pilot in command's attempt to takeoff with insufficient airspeed. A factor in the accident was the pilot in command's selection of unsuitable terrain on which to land and takeoff.NTSB DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.NTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.NTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.NTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.NTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.NTSB ATL93LA104Accident · Minor injuriesLimited investigationFinal reportHatz CB-1 · Stedman, NCThe improper positioning of the main fuel tank drain, which resulted in fuel starvation and engine stoppage. A factor were trees in the forced landing area.NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB MIA93LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Myers, FLFailure of the pilot-in-command to perform in-flight fuel consumption calculations. The lack of suitable terrain for a forced landing was a factor.NTSB CHI93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Jeffersonville, INThe flight instructor's delayed remedial action and failure to assure recovery from a bounced landing. A factor related to the accident was: improper flare by the student pilot.NTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.NTSB SEA93LA118Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WAThe inadequate compensation for wind conditions by the student pilot. Factors relating to the accident were the gusty wind conditions and the student's lack of total experience.NTSB LAX93LA221Accident · No injuriesLimited investigationFinal reportCessna 150E · Hollister, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.NTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.NTSB BFO93LA084Accident · No injuriesLimited investigationFinal reportCessna A150M · Tarentum, PAFailure of the pilot to maintain directional control and proper runway alignment. The adverse weather condition and proximity of the parked aircraft were related factors.NTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.NTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.NTSB BFO93LA066Accident · No injuriesLimited investigationFinal reportQuickie 200 · N. Kingstown, RIImproper flare by the pilot.NTSB DEN93LA048Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Newark, TXAn inadvertent stall. A factor was: the pilot's diverted attention.NTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.NTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.NTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.NTSB LAX93LA178Accident · Serious injuriesLimited investigationFinal reportMcreynolds Cassutt III · Napa, CAThe loss of engine power for undetermined reasons.NTSB FTW93LA134Accident · No injuriesLimited investigationFinal reportCessna 150F · Garrison, TXThe student pilot's failure to refuel the airplane. A factor was his becoming lostNTSB LAX93LA175Accident · No injuriesLimited investigationFinal reportCessna 150K · Boulder City, NVThe instructor's inadequate bounced landing recovery and airspeed management during the attempted go around, which led to an inadvertent stall and the instructor's inadequate supervision of the flight. A factor in the accident was the instructor's low total…NTSB FTW93LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Houston, TXFuel exhaustion induced power loss and the pilot's failure to refuel. A factor was the existing night conditionsNTSB NYC93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dowingtown, PAThe loss of engine power for undetermined reasons.