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 SEA99LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WACompensation for wind conditions was inadequate. Gusting wind conditions was a factor.NTSB LAX99LA211Accident · 1 fatalLimited investigationFinal reportCessna 150G · Rimrock, AZThe pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…NTSB LAX99LA198Accident · No injuriesLimited investigationFinal reportCessna 150L · Paso Robles, CAthe pilot's failure to maintain aircraft control and the resulting intentional off-airport landing. Inadequate recurrent training and recent flight experience were factors in this accident.NTSB ATL99LA096Accident · No injuriesLimited investigationFinal reportRutan VERI-EZE · Enterprise, ALThe pilot's failure to remove covers from the fuel tank vent which resulted in fuel starvation.NTSB ANC99LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Anchorage, AKThe pilot misjudging the taxi clearance between the airplane's wingtip and the parked vehicle.NTSB LAX99LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lucerne Valley, CAthe pilot's failure to refuel the airplane and improper fuel consumption calculations.NTSB DEN99LA076Accident · No injuriesLimited investigationFinal reportCessna 150M · Maybell, COThe pilot's inadvertent stall while maneuvering. Factors were the wind gusts weather conditions, and the high density altitude weather conditions.NTSB SEA99LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Detroit, ORThe pilot's inadvertent visual flight rules flight into instrument meteorological conditions, eventually resulting in a non-mechanical loss of engine power. Factors were: the pilot's inadequate preflight planning and preparation; a snowstorm with icing…NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.NTSB LAX99LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Yuba City, CAA total loss of engine power resulting from the fatigue failure of a cylinder's exhaust valve. A contributing factor was the uneven terrain at the forced landing site. The reason for the fatigue could not be determined.NTSB LAX99LA154Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Lake Mary, AZThe pilot's intentional buzzing and misjudged altitude/clearance with the nearby rising terrain. Contributing factors were the high density, the airplane's high gross weight, and the pilot's improper in-flight decisions.NTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…NTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.NTSB SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB CHI99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Paxton, ILthe inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.NTSB LAX99LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Madera, CAThe pilot's failure to maintain an adequate visual lookout and to see the stationary airplane on the taxiway ahead.NTSB FTW99LA069Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Nemo, TXA partial loss of engine power due to the obstructed fuel vent line and fuel cap vent.NTSB CHI99LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Hillsdale, MIthe pilot's disregarding preparation for the flight. Factors were a frozen landing gear wheel, and the snowbank.NTSB ATL99LA043Accident · Minor injuriesLimited investigationFinal reportTrohoski VARI-EZE · Tupelo, MSThe pilot's improper flare and compensation for wind conditions upon landing. Factors in the accident were the pilot's inadequate recurrent training and lack of experience with the airplane.NTSB FTW99LA066Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway, ARThe loss of engine power due to carburetor ice during the approach to land. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Madisonville, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB LAX99LA069Accident · No injuriesLimited investigationFinal reportCessna 182G · San Andreas, CAThe other pilot's failure to maintain an adequate visual lookout while taxiing in a confined area between rows of parked aircraft.NTSB MIA99LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Pembroke Pines, FLThe pilot's decision to abort the takeoff with insufficient runway remaining.NTSB FTW99FA049Accident · 2 fatalField investigationFinal reportCessna 150H · Marksville, LAThe pilot's failure to visually identify the hazardous condition of the runway. Factors were the dusk light condition and the pilot's failure to obtain NOTAMs.NTSB CHI99LA049Accident · No injuriesLimited investigationFinal reportCessna 150 · East Troy, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, and the ditch.NTSB ATL99LA029Accident · No injuriesLimited investigationFinal reportCessna 150B · Adjuntas, PRThe loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.NTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.NTSB CHI99LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tower, MNthe student pilot's failure to maintain directional control of the airplane after landing. Factors contributing to this accident were the icy runway and the snowbank.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB SEA98LA190Accident · No injuriesLimited investigationFinal reportCessna 150L · Bonners Ferry, IDImproper maintenance by an outsourcing facility which resulted in a lack of identification of scoring of the interior of the #3 cylinder rocker shaft bosses. The scoring resulted in a fatigue fracture and subsequent permanent closure of both intake and…NTSB SEA98LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · Freeland, WAFailure of the number two intake valve rocker arm in fatigue, and overload of the nose landing gear assembly. Factors include a ditch encountered during the forced landing.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB LAX98LA315Accident · No injuriesLimited investigationFinal reportCessna 150L · Oroville, CAFailure of the pilot to maintain proper clearance and subsequently striking a hangar door while taxiing to parking.NTSB CHI98LA336Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eaton Rapids, MIthe pilot's improper decision to abort the takeoff while in the air and beyond the point where the pilot could execute a landing on the remaining airstrip runway area. A factor which contributed to this accident was the soybean crop.NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB FTW98LA379Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lamar, COThe pilot's failure to maintain climb airspeed, and inadvertently allowing the airplane to stall/mush. A factor was the embankment.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.NTSB CHI98LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Litchfield, ILLoss of engine power due to an open exhaust valve and low cylinder compression. A related factor was the tailwind.NTSB CHI98LA263Accident · No injuriesLimited investigationFinal reportCessna 150H · Frankfort, INthe improper maintenance installation by other maintenance personnel. Factors were a missing lubricating oil drain plug, the safety wire for the plug and the roadway.NTSB MIA98LA199Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's failure to maintain directional control.NTSB LAX98FA219Accident · Minor injuriesField investigationFinal reportCessna 150 · Apple Valley, CAThe improper installation of unvented fuel caps that resulted in fuel starvation and loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB ATL98LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the pilot to obtain flying speed, and the delayed decision to abort the take-off, leading to a loss of control in flight, and the subsequent collision with a ditch.