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 BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.NTSB CHI94DET01Accident · Minor injuriesFinal reportArthur Alan Blind FOX III Speedster · Watervliet, MIa total loss of engine power due to carburetor icing.NTSB BFO94LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, NYThe pilot's inadequate compensation for the wind conditions and failure to maintain alignment with the runway which resulted in an inflight collision with a tree. A factor is crosswinds.NTSB BFO94FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Bloomingburg, OHThe failure of the pilot-in-command to maintain adequate airspeed. This led to a stall during the initial takeoff and climb at an altitude that did not permit a recovery. A factor related to the accident was the presence of sunglare during the takeoff, which…NTSB MIA94LA151Accident · No injuriesLimited investigationFinal reportCessna 150H · Sugarloaf Key, FLThe improper flare and improper recovery from a bounced landing by the pilot-in-command.NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB LAX94LA240Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAthe flight instructor's failure to maintain an adequate airspeed margin while maneuvering at minimum controllable airspeed. A factor in the accident was the instructor's selection of an inadequate above ground altitude to begin the maneuver.NTSB FTW94LA160Accident · No injuriesLimited investigationFinal reportCessna 150M · Spring, TXThe pilot's failure to maintain directional control during the attempted takeoff from the touch and go landing. Factors were the inadvertent porpoise and the soft terrain.NTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.NTSB ATL94LA089Accident · No injuriesLimited investigationFinal reportHesterlee Rutan Vari EZE · Statesville, NCThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation during the initial climb after takeoff. A factor was a ditch adjacent to the runway.NTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB BFO94LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westminster, MDThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and the inflight loss of control. A factor is the pilot's failure to do a go around.NTSB BFO94LA075Accident · No injuriesLimited investigationFinal reportCessna 150M · Washington Cros, NJthe pilot-in-command's inadequate in-flight planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CHI94LA136Accident · No injuriesLimited investigationFinal reportCessna 150A · Angola, INthe on ground collision of the airplane with a deer. A factor was the dark night.NTSB CHI94LA135Accident · No injuriesLimited investigationFinal reportCessna 150J · Fredricktown, MOthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB BFO94LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Mount Vernon, OHThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground. Factors were transmission wires and the pilot's inadequate inflight decision.NTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.NTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.NTSB ATL94LA069Accident · Minor injuriesLimited investigationFinal reportCessna 150L · N. Myrtle Beach, SCThe improper procedures used by ground personnel during banner tow operations.NTSB CHI94LA114Accident · No injuriesLimited investigationFinal reportCessna 150M · Independence, MOwere the premature lift-off, and the failure of the pilot to maintain control of the airplane.NTSB MIA94LA088Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the student pilot to properly recover from a bounced landing.NTSB MIA94FA085Accident · 1 fatalField investigationFinal reportDaffron, Harold C. Varieze · Oxford, MSPoor planning/decision by the pilot-in-command for failure to perform high and low speed taxi tests before the flight after repairs and modification of the airplane. Additionally, failure or malfunction of the flight control system for undetermined reasons,…NTSB LAX94LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Sacramento, CAthe child's disregard for prescribed safety procedures which was compounded by the diminishing lighting conditions existing at the time, and her lack of familiarity with an aviation environment.NTSB SEA94LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarkston, WAThe pilot in command's inadequate use of carburetor heat. Factor(s) were: carburetor icing weather conditions and rough terrain.NTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.NTSB MIA94LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Tampa, FLThe student pilot's improper use of the flight controls and failure to maintain sufficient airspeed on final approach for landing resulting in an inadvertant stall and subsequent collision with terrain.NTSB FTW94LA084Accident · Minor injuriesLimited investigationFinal reportNoble Quickie Q-200 · N. Little Rock, ARThe pilot/owner's inaccurate calculation of the airplane's center of gravity. A factor was the pilot's failure to follow the correct calculation procedure.NTSB CHI94LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · La Crosse, WIThe failure of the exhaust valve in the number one cylinder. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB BFO94LA041Accident · 1 fatalLimited investigationFinal reportCessna 150 · Lima, OHThe failure of the passenger to maintain clerance from the propeller.NTSB SEA94LA053Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ORFuel exhaustion, and the pilot's poor inflight decision. Factors include the pilot's poor pre-flight planning, and a sign in the path of the landing roll.NTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.NTSB ANC94LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKLoss of engine power due to improper procedures used by the PIC. A factor contributing to the accident was the snow covered terrain.NTSB MIA94LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Raymond, MSThe pilot-in-command's delay in identifying carburetor ice and improper use of carburetor heat.NTSB SEA94LA041Accident · No injuriesLimited investigationFinal reportCessna 150J · Tonasket, WAThe pilot's failure to attain a proper touchdown point. Factors include an inadequate preflight, fuel exhaustion, and an icy landing area.NTSB MIA94FA034Accident · 1 fatalField investigationFinal reportCessna 150J · Delray Beach, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented, and subsequent in-flight collision with the ocean. Contributing to the accident was the dark night with no visible horizon.NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.NTSB ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.NTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.NTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.NTSB LAX94LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVthe student pilot's failure to execute a go-around, premature flare, and improper use of the flight controls. Factors related to this accident are the student pilot's lack of total experience and diverted attention.NTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.NTSB BFO94LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150M · West Milford, NJThe loss of engine power due to an undetermined reason. A factor in this accident was the lack of suitable terrain to complete a forced landing.NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…NTSB LAX94LA024Accident · No injuriesLimited investigationFinal reportCessna 150K · California City, CAFailure of maintenance personnel to assure that the nose wheel axle was properly secured during previous maintenance.NTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.NTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.