Cessna 152
NTSB investigations · 2,749
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 CHI93LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe student pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB BFO93LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Cuddy, PAThe student pilot's failure to maintain directional control during flare/touchdown. The proximity of the ravine and trees to the runway was a related factor.NTSB LAX93LA269Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAA failure of the pilot to maintain directional control of the airplane during a go-around maneuver, subsequent improper remedial actions and an inadvertent stall. A factor in this accident was the pilot's lack of total aeronautical experience.NTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.NTSB NYC93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wyantskill, NYInadequate supervision and delayed remedial action by the flight instructor. The student pilot's failure to maintain directional control and his inexperience is a contributing factor.NTSB LAX93LA253Accident · No injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe failure of dual student to maintain an adequate airspeed during the go around initiation, and, the inadequate supervision of the flight by the instructor.NTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.NTSB NYC93LA100Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Cincinnati, OHThe pilot's improper inflight planning and decision resulting in fuel exhaustion, and the subsequent forced landing and collision with power lines.NTSB MIA93LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLPilot in command's failure to ensure the aircraft contained enough fuel to complete the flight resulting in the engine failing due to fuel exhaustion.NTSB LAX93FA241Accident · 3 fatalField investigationFinal reportCessna 152 · Chino, CAInadequate visual lookout by the pilot of the Lancair 320, N69WD, that precluded him from recognizing a collision hazard and taking action to avoid a midair collision with the Cessna 152, N80203. In addition, the local controller failed to advise the pilot of…NTSB NYC93LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAImproper recovery from a bounced landing which resulted in the airplane departing the side of the runway and striking trees.NTSB MIA93FA137Accident · 2 fatalField investigationFinal reportCessna 152 · Miami, FLThe pilot-in-command's failure to maintain airspeed while maneuvering at low altitude. A factor which contributed to the accident was the pilot's failure to maintain an adequate altitude from which a recovery would have been possible.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB MIA93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot-in-command's failure to initiate a climb.NTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.NTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.NTSB BFO93LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Norfolk, VAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was the unsuitable terrain.NTSB LAX93LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Elko, NVThe pilot's failure in not determining the surface winds prior to landing which resulted in a landing in conditions beyond the demonstrated capability of the airplane.NTSB FTW93LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Waco, TXThe students pilot's failure to maintain clearance from an object and inadequate supervision by the instructor pilotNTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX93LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeport, CAthe student pilot's misjudging the landing flare altitude. A factor relating to this accident was the student pilot's lack of total experience.NTSB MIA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Orlando, FLVisual lookout not maintained by the pilot-in-command while taxiing the airplane. Contributing to the accident was the failure of the driver of the vehicle to advise the ground controller that he had stopped the vehicle on the taxiway.NTSB FTW93LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind.NTSB LAX93LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight and delaying the remedial action. The dual student's improper use of the brakes is a factor in this accident.NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.NTSB LAX93FA165Accident · 1 fatalField investigationFinal reportCessna 152 · Dunsmuir, CAAn inadvertent encounter with rain and icing conditions. Factors in this accident included environmental conditions consisting of rain, icing, and darkness, and the pilot's overconfidence in his abilities to deal with the encountered weather conditions.NTSB ATL93LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe failure of the student pilot to maintain control of the aircraft.NTSB MIA93LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLImproper in-flight planning/decision by the student pilot, and inadequate supervision of the flight by the instructor pilot (CFI). Factors related to the accident were: the tailwind, and the student pilot's improper flare and transition to an aborted landing,…NTSB BFO93LA053Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJThe flight instructor's failure to successfully take remedial action to maintain control of the airplane during takeoff. A factor related to the accident was the student pilot's improper control of the airplane during liftoff, while practicing a soft field…NTSB LAX93LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe student pilot's failure to maintain directional control of the aircraft and his improper remedial action to correct the situation. A factor in the accident was the student's lack of total experience.NTSB LAX93FA144Accident · 1 fatalField investigationFinal reportCessna 152 · Apple Valley, CAThe pilot inadvertently stalled the airplane near the ground. The intentional buzzing, over confidence in his personal ability, and poor inflight planning/decision were factors.NTSB CHI93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIThe student pilot's failure to maintain directional control during the takeoff roll.NTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.NTSB BFO93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Petersburg, OHLoss of engine power due to undetermined reasons. A factor related to the accident was the short, soft, hilly terrain condition in the emergency landing area.NTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.NTSB ATL93FA061Accident · 4 fatalField investigationFinal reportCessna 152 · Atlanta, GAThe failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…NTSB SEA93T#A02Accident · No injuriesClass 3Final reportCessna 152 · Amalga, UTNTSB LAX93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Galt, CAThe pilot's inadequate compensation for the existing crosswind conditions and his failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited total flight experience.NTSB MIA93LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Mccoy, FLThe in-flight collision with a large bird.NTSB ATL93LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe student pilot's failure to judge a proper touchdown point, and his failure to maintain directional control after landing. A factor was the pilot's lack of total experience.NTSB MIA93LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Ruskin, FLThe failure of the pilot-in-command to monitor fuel quantity resulting in an engine failure due to fuel exhaustion.NTSB ATL93LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe poor preflight planning by the pilot.NTSB DEN93LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COPower loss due to water contaminated fuel. A factor was: unsuitable terrain for a forced landing.NTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.NTSB BFO93LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotia, NYThe student pilot's failure to maintain directional control during landing. The snow covered runway was a related factor.NTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.NTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landingNTSB FTW93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe pilot's failure to maintain directional control.
Back to Cessna 152