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 SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.NTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.NTSB CHI98LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rush City, MNthe pilot inadvertently stalled the airplane during the initial takeoff climb. Factors associated with the accident were the pilot's inattentiveness at lowering excessive flaps for takeoff.NTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.NTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…NTSB IAD98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEInadequate compensation for wind conditions by the pilot, and his failure to maintain control of the airplane. High, gusting winds were contributing factors.NTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.NTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.NTSB FTW98LA255Accident · No injuriesLimited investigationFinal reportCessna 150L · Pearland, TXThe pilot's selection of the wrong runway/landing area. A factor was the lack of visual runway cues available to the pilot.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB NYC98LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Blakeslee, PAThe pilot's inadequate preflight resulting in fuel exhaustion. A factor was the pilot's failure to refuel the aircraft prior to departing.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB IAD98LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe pilot's failure to maintain adequate airspeed during an aborted landing which resulted in an inadvertent stall/spin.NTSB CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.NTSB LAX98LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Oroville, CAThe pilot's failure to maintain the proper glide path, and his inadequate compensation for wind conditions, which resulted in an undershoot.NTSB FTW98FA190Accident · 2 fatalField investigationFinal reportCessna 150H · Parowan, UTThe pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.NTSB SEA98IA060Incident · Minor injuriesIncident investigationFinal reportCessna 150L · Seattle, WAThe pilot's failure to reposition the flaps to the 20 degree position during a go-around, as called for in the Pilot's Operating Handbook. Factors include the pilot's decision to land long behind a departing aircraft, an encounter with wake turbulence during…NTSB MIA98FA110Accident · Serious injuriesField investigationFinal reportCessna 150H · West Palm Beach, FLThe poor in-flight planning by the pilot-in-command for his failure to ask for assistance after becoming lost momentarily, and his failure to monitor the total time airborne after the fuel tanks were filled. Contributing to the accident was the binding of the…NTSB SEA98LA053Accident · No injuriesLimited investigationFinal reportCessna 150G · Hailey, IDA fractured nosewheel steering linkage bolt, which permitted the nosewheel steering linkage to become disconnected, and the student pilot's subsequent failure to restore directional control by use of differential wheel braking.NTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB CHI98LA090Accident · No injuriesLimited investigationFinal reportCessna 150M · Troy, MIthe student pilot's failure to maintain direction control of the airplane. Factors relating to this accident were: the crosswind, and wet/soft terrain (mud) beside the runway.NTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.NTSB FTW98LA102Accident · Serious injuriesLimited investigationFinal reportMartin Varieze · Artesia, NMThe pilot's inadequate compensation for the crosswind. Factors were the prevailing crosswind and the pilot's lack of total experience in type of aircraft.NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.NTSB LAX98LA080Accident · No injuriesLimited investigationFinal reportCessna 150F · San Carlos, CAThe pilot's excessive airspeed, which resulted in a bounced landing, and, his failure to ensure that his seat locking pin was engaged, which caused his seat to move backwards during the touchdown and resulted in his loss of directional control.NTSB CHI98LA078Accident · No injuriesLimited investigationFinal reportCessna 150J · Gaylord, MIthe pilot's misjudging the flare leading to a hard landing, and the kit manufacturer's (Supplemental Type Certificate holder's) inadequate design leading to a corrosion stress fracture of the landing gear attachment. A factor was the landing gear attachment…NTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…NTSB CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.NTSB CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.NTSB SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.NTSB SEA98LA011Accident · No injuriesLimited investigationFinal reportCessna 150H · Missoula, MTThe student pilot's failure to maintain directional control.NTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB FTW98LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · San Antonio, TXinadequate service provided by the ground controller, by clearing the Boeing 727 to taxi after the Cessna 150 was cleared to taxi behind the 727, which led to a wake turbulence (jet exhaust) encounter and damage to the Cessna 150.NTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.NTSB FTW98LA022Accident · No injuriesLimited investigationFinal reportCessna 150G · Tyler, TXThe failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.NTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.NTSB NYC97LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Easton, NYmechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…NTSB MIA97LA245Accident · No injuriesLimited investigationFinal reportLouttit Celebrity · Ridgeland, SCthe in-flight failure of the upper wing spar wood resulting in a forced landing in swampy terrain.NTSB ANC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gulkana, AKThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.NTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB ANC97LA141Accident · No injuriesLimited investigationFinal reportCessna 150H · Yakutat, AKA partial blockage of the main fuel supply line to the engine, caused by improper manufacture of the fuel line by unknown maintenance personnel.NTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.NTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.NTSB ANC97LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC-19 · Anchorage, AKThe pilot's excessive descent rate during a touch-and-go landing, which resulted in damage to the landing gear and inability to control the airplane during a subsequent landing. A factor was his lack of total experience in tailwheel-equipped airplanes.NTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.