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 NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.NTSB BFO92LA001Accident · No injuriesLimited investigationFinal reportCessna 150H · Saluda, VAThe pilot's decision to abort the takeoff with inadequate runway to stop. A factor in the accident was the failure of the exhaust muffler baffle.NTSB ATL92LA009Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Whitesburg, GAA sudden wind shift during initial climb which resulted in an uncontrolled descent.NTSB SEA92LA006Accident · Minor injuriesLimited investigationFinal reportCessna C-150M · Woodburn, ORA seized engine exhaust valve. Factors include rough terrain and a collapsed nose gear.NTSB CHI92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Taylor, MOThe pilot-in-command's failure to attain proper compensation for the crosswind. A factor contributing to the accident was the crosswind.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB SEA91FA229Accident · 2 fatalField investigationFinal reportCessna 150L · Yamhill, ORInadequate inflight planning/decisions. Factors to the accident were: an uncontrolled stall, a tail wind, remedial action was not performed, and poor compensation for wind conditions.NTSB SEA91LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dixie, IDThe pilot's failure to maintain adequate clearance with tree(s) during the initial climb. Factors contributing to the accident were the high density altitude and downdraft conditions.NTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.NTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.NTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.NTSB NYC91LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashland, METhe pilot's premature liftoff. Factors were the rough airstrip and the soft terrain encountered during landing.NTSB FTW91LA153Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haskell, OKImproper installation of avionics equipment resulting in interference with flight control.NTSB CHI91LA268Accident · No injuriesLimited investigationFinal reportCessna 150 · St. Clair, MODirectional control was not maintained by the pilot.NTSB NYC91LA211Accident · No injuriesLimited investigationFinal reportCessna 150 · Sharon, OHThe improper use of carburetor heat by the pilot, which resulted in a loss of engine power and subsequent forced landing on rough terrain. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB CHI91LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Old Monroe, MOThe separation of the throttle control cable. Contributing to the accident was the rough terrain on which a forced landing was made.NTSB NYC91LA203Accident · No injuriesLimited investigationFinal reportCessna 150L · Moraine, OHThe failure of the pilot to maintain airspeed during a go-around, resulting in an inadvertent stall and in flight collision with terrain.NTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.NTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.NTSB CHI91LA221Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrillville, INImproper pre-flight planning and preparation by the pilot-in-command. Factors related to this accident were the pilot-in-commands's inattentiveness concerning the refueling of his airplane, and inadequate fuel supply, inattentive ground personnel, and…NTSB MIA91LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Tunica, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The quartering crosswind and soft terrain were related factors.NTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.NTSB ANC91LA095Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairbanks, AKThe partial loss of engine power resulting in a forced landing on unsuitable terrain and subsequent nose over during the landing roll. Contributing to the accident was the improperly performed 100 hour inspection by company maintenance personnel.NTSB CHI91LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Big Rapids, MIThe stall/mush which occurred during the go-around. A factor related to the accident was the pilot's abrupt pull-up maneuver.NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.NTSB LAX91LA276Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dana Point, CAThe seizure of the no. 1 cylinder's exhaust valve in its guide and the related fracturing of the rocker arm; and the pilot's operation of the aircraft with known deficiencies.NTSB FTW91LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · San Angelo, TXThe pilot's failure to refuel the airplane which resulted in engine failure due to fuel exhaustion.NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.NTSB LAX91FA242Accident · 1 fatalField investigationFinal reportCessna C-A150L · Cottonwood, CAThe pilot's intentional low pass during which he performed an aerobatic maneuver with inadequate airspeed. Contributing factors were the pilot's low altitude and the tailwind condition which created the visual perception to the pilot of having an airspeed…NTSB LAX91LA216Accident · No injuriesLimited investigationFinal reportCessna C-150L · Groveland, CAThe pilots neglect to calculate the aircrafts fuel consumption and his failure to service the aircraft with fuel prior to the last takeoff. The wire across the aircrafts flight path during the forced landing was a factor in the accident.NTSB MIA91LA142Accident · No injuriesLimited investigationFinal reportCessna 150J · Lantana, FLFailure of the pilot to perform fuel consumption calculations which resulted in fuel exhaustion due to an inadequate fuel supply. Also, inadvertent stall/mush by the pilot during the forced landing. Contributing to the accident was an incorrect fuel gauge.NTSB ATL91LA092Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Statesboro, GAFailure of both pilots to perform a visual lookout sufficiently adequate to avoid a collision at an uncontrolled airport. Factors related to the accident were: failure of the pilot of N95170 to communicate on the common traffic advisory frequency (CTAF) and…NTSB FTW91LA073Accident · No injuriesLimited investigationFinal reportCessna 150J · Cypress, TXFailure of the PIC to maintain proper airspeed and the inadvertent stall experienced by the pilot rated passenger. A factor was the pic's failure to attain runway alignment.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL91LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Bern, NCThe aircraft engine loss of power for an undetermined reason. Factors related to the accident were the dark night, and the inadvertent stall of the aircraft.NTSB NYC91LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Montgomery, NYThe pilot's inadvertent exit (falling) from the airplane, while attempting to recover an object from outside the airplane without setting the parking brake and/or shutting down the engine.NTSB MIA91LA119Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Bay, FLLoss of control during the landing roll due to failure of the pilot to apply aileron control to prevent the airplane from drifting off the runway due to a crosswind and failure to maintain directional control. Contributing to the accident was the pilot's lack…NTSB NYC91LA109Accident · No injuriesLimited investigationFinal reportCessna 150E · Walkill, NYAn inflight collision with terrain during an uncontrolled descent after the pilot parachuted from the airplane. Contributing to the accident were fuel exhaustion and the pilot's disregard for emergency procedures.NTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.NTSB MIA91LA116Accident · No injuriesLimited investigationFinal reportCessna 150H · Orlando, FLTotal loss of engine power due to fuel exhaustion and failure of the pilot to refuel the fuel tanks before departure.NTSB ATL91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pollocksville, NCFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin.NTSB DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB NYC91LA093Accident · No injuriesLimited investigationFinal reportCessna 150L · Chambersburg, PACarburetor ice and the pilot's improper use of carburetor heat. A factor related to the accident was: carburetor icing (weather conditions).