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 CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.NTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.NTSB MIA02WA103Accident · No injuriesForeign investigationCessna 150L · Pinar Del Rio, CubaNTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.NTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.NTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.NTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.NTSB NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty windsNTSB ATL02LA084Accident · No injuriesLimited investigationFinal reportCessna 150D · Chatsworth, GAThe pilot's failure to apply carburetor heat that resulted in the loss of engine power. Factors were conditions favorable for the formation of carburetor icing and the selection of unsuitable terrain for a forced landing.NTSB MIA02LA077Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Lawrenceville, GAThe pilot's failure to maintain directional control while landing and during his subsequent attempt at a go around, resulting in collision with a tree and impact with the terrain.NTSB NYC02LA078Accident · No injuriesLimited investigationFinal reportCessna 150M · Salisbury Ctr, NYThe pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.NTSB FTW02LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Melbourne, ARthe pilot's failure to maintain directional control as a result of becoming incapacitated due to a stroke while taxiing for takeoff.NTSB ATL02LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's improper flare and failure to recover from a bounced landing resulting in the subsequent collapse of the nose gear during the landing flare touchdown. A factor contributing to the accident was the student pilot's lack of total experience.NTSB ATL02LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Panama City Bch, FLThe pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ANC02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…NTSB SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.NTSB LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.NTSB MIA02LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Stuart, FLThe pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.NTSB CHI02FA025Accident · 2 fatalField investigationFinal reportCessna 150M · Dyer, INThe failure of the flight crew to maintain adequate airspeed, resulting in an inadvertent stall/spin and the flight instructor's inadequate supervision of the flight, his impairment due to the use of over-the-counter medication is a contributing factor.NTSB LAX02LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Nogales, AZThe pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.NTSB CHI02LA023Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Backus, MNThe pilot's improper preflight planning/preparation, and his continued flight into known adverse weather conditions. Factors relating to the accident were the pilot becoming lost/disoriented in the weather, visual lookout by the pilot during the descent not…NTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB MIA02LA007Accident · No injuriesLimited investigationFinal reportCessna A150L · Buena Vista, GAThe pilot's failure to use proper bounced landing technique, resulting in a hard touchdown, propeller strike, and noseover.NTSB FTW02FA005Accident · 1 fatalField investigationFinal reportCessna 150G · Sargent, TXthe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall. Contributing factors were the pilot's flight into known adverse weather, his self-induced pressure to complete the flight and the thunderstorm.NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB CHI01LA311Accident · No injuriesLimited investigationFinal reportCessna 150M · South St. Paul, MNThe student pilot failed to maintain directional control. A factor was his lack of total flight experience.NTSB LAX01LA289Accident · No injuriesLimited investigationFinal reportCessna 150J · Sonoma, CAFuel exhaustion due to the pilot's inadequate preflight fuel consumption calculations and failure to ensure that adequate fuel was onboard the airplane prior to departure. A factor in the accident was the pilot's continued use of the airplane with known…NTSB CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.NTSB FTW01LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Miami, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB LAX01LA280Accident · Serious injuriesLimited investigationFinal reportHumphreys Stitts SA6B · Elko, NVThe failure of the pilot-in-command to reverse course in a timely manner after flying into a box canyon. Factors in the accident were the pilot's lack of familiarity with the aircraft and the local terrain.NTSB IAD01LA098Accident · No injuriesLimited investigationFinal reportCessna 150M · Cincinnati, OHThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.NTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB ANC01LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's failure to maintain directional control during the landing roll. A factor associated with the accident is rough and uneven terrain at the off-airport landing site.NTSB NYC01LA190Accident · 1 fatalLimited investigationFinal reportHolsclaw Barnett J4B · Titusville, PAThe pilot's failure to maintain control while maneuvering. A factor was the pilot's lack of experience in type of gyroplane.NTSB CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.NTSB IAD01LA083Accident · No injuriesLimited investigationFinal reportCessna 150L · Lusby, MDThe student pilot's improper use of carburetor heat.NTSB SEA01LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Blackfoot, IDPilot's failure to maintain directional control of the airplane while landing.NTSB LAX01FA253Accident · 2 fatalField investigationFinal reportMcDougall Veri EZE · Palm Springs, CAthe failure of the builder to balance the elevators per the kit manufacturer's instructions resulting in flutter and in-flight separation of the right elevator.NTSB ATL01LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lake City, FLThe pilots failure to maintain clearance during an approach to land, that resulted in an in-flight collision with trees.NTSB CHI01LA212Accident · 1 fatalLimited investigationFinal reportReitz Mohawk 1 · Camdenton, MOThe pilot not performing an aborted takeoff and the inadvertent stall he encountered on his inadvertent initial climb. Factors were his inadvertent lift-off, the reported inadequate rudder control, his inadvertent flight with known deficiencies, and the…NTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..NTSB LAX01LA229Accident · Serious injuriesLimited investigationFinal reportSmith FW-190 · Reedley, CAThe pilot's failure to maintain airspeed during takeoff, which resulted in an inadvertent stall.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.NTSB SEA01LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Port Townsend, WAAn improper decision by the pilot to initiate an evasive maneuver toward the ground at low altitude, resulting in a hard landing. A factor was the aircraft's low altitude.