NTSB investigations: Cessna 152
2,738 cases on aircraft the registry lists as Cessna 152. 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.aircraft_model_code IN ('2071835'))
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.aircraft_model_code IN ('2071835'))
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 NYC90LA203Accident · 2 fatalLimited investigationFinal reportCessna 152 · Provincetown, MAThe failure of the pilot to maintain adequate airspeed, which resulted an inadvertent stall/spin. Probable factors related to the accident were: failure of the pilot to follow procedures/directives, and his lack of proper certification (qualification) for…NTSB LAX90LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAThe improper technique used by the student pilot to recover from a bounced landing attempt.NTSB ANC90LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Goose Bay, AKThe pilot-in-command's improper flare on touchdown.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB CHI90LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILImproper flare and improper recovery from a bounced landing.NTSB FTW90LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roades, LAUnknown mechanical malfunction resulting in engine oil starvation. A contributing factor was rough terrain in which the forced landing was made.NTSB LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.NTSB FTW90LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Lytle, TXThe pilot's failure to adequately manage the onboard fuel supply.NTSB CHI90LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe instructor's inability to control the airplane during its landing roll.NTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.NTSB MIA90LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeland, FLThe improper use of the carburetor heat control resulting in the loss of engine power due to carburetor ice.NTSB CHI90LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, SDThe pilot in command's improper in flight planning which resulted in fuel exhaustion and a forced landing in a field at which time the aircraft nosed over.NTSB CHI90LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Grand Marais, MNUndetermined partial loss of engine power during the initial climbout. A factor was the lack of suitable terrain for a forced landing.NTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.NTSB LAX90LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Fullerton, CAThe warped condition of the engine valves and valve seats due to excessive and repeated thermal shock cycles.NTSB SEA90LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Reno, NVThe pilot's use of an inappropriate runway. The gusty tailwind and the pilot's lack of experience were factors related to the accident.NTSB LAX90LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAThe inadvertent engagement of the starter during flight for undetermined reasons. >NTSB DEN90LA144Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Golden, COThe pilot's disregard for airplane performance data. Contributing to the accident were high density altitude and the fact that airplane climb performance capability was exceeded.NTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.NTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.NTSB MKC90LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, IAFuel exhaustion due to misjudged fuel consumption calculations by the pilot in command, and a forced landing to a field with a hidden obstruction.NTSB MKC90LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSPoor pre-flight and in-flight planning and refueling not performed by the pilot in command.NTSB MIA90LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe improper landing flare by the pilot in command.NTSB LAX90LA205Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Rialto, CAPilot's inadequate visual outlook which resulted in an inflight encounter with wake turbulence produced by a hovering helicopter.NTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.NTSB DEN90FA119Accident · 1 fatalField investigationFinal reportCessna 152 · Longmont, COThe pilot continued into hazardous weather conditions.NTSB CHI90LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Bad Axe, MIFailure of the pilot to abort the takeoff with sufficient runway to stop the aircraft. Contributing to the accident is a lack of total flying experience.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB DEN90LA114Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Erie, COCfi's failure to ensure that the student pilot maintained sufficient airspeed, resulting in the inadvertent stall/mush. A factor was the downdraft experienced at low altitude after takeoff.NTSB DEN90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Delta, UTThe pilot's loss of directional control during landing. Factors were gusting tailwinds and the pilot selected the wrong runway.NTSB LAX90FA179Accident · 1 fatalField investigationFinal reportCessna 152 · San Diego, CAThe failure of the pilot to maintain adequate airspeed on final approach resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed use of flaps.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.NTSB NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.NTSB FTW90LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Albany, TXThe pilot's failure to maintain flying speed which resulted in an uncontrol touchdown and collision with objects.NTSB LAX90LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Banning, CAFailure of the student pilot to ascertain the wind direction resulting in a downwind landing.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB LAX90LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAFailure of the student pilot to maintain adequate control of the airplane during the takeoff roll.NTSB CHI90FA105Accident · 1 fatalField investigationFinal reportCessna 152 · Oberlin, OHImproper use of carburetor heat by the dual student, carburetor ice, inadequate supervision to correct the situation by the instructor pilot (CFI), and failure of the CFI to maintain adequate airspeed, which resulted in a stall. Carburetor icing condition was…NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.NTSB NYC90LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Glens Falls, NYPilot factor in that he lost directional control during takeoff and subsequently collided with a snowbank.NTSB MIA90FA085Accident · 3 fatalField investigationFinal reportCessna 152 · Miramar, FLThe failure of the local controller to provide adequate traffic advisories to N7510H, the local controller's improper clearance to N7510H to descend through the traffic pattern, and the failure of the pilots of both aircraft to see and avoid each other.…NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.NTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.NTSB LAX90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot's failure to maintain visual lookout.NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.