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 MIA95LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe student pilots failure to follow the checklist and assure the door was closed prior to takeoff. Contributing to the accident was the student's diverted attention during the takeoff roll.NTSB FTW95LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKThe pilot's improper recovery from a bounced landing. Factors were the improper flare and the resultant loss of directional control.NTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.NTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.NTSB FTW95LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COThe pilot's loss of directional control.NTSB BFO95LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bucyrus, OHThe pilot's faliure to maintain directional control during the takeoff roll.NTSB ATL95FA013Accident · 2 fatalField investigationFinal reportCessna 152 · Dresden, TNThe pilot in command's (CFI) impairment of judgment and performance due to alcohol and drugs, which led to his failure to maintain separation from terrain.NTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.NTSB LAX95LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · La Verne, CAthe student pilot's poor recovery from a bounced landing and improper use of the elevator control. The lack of total experience is a factor in this accident.NTSB LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.NTSB CHI95LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's failure to maintain aircraft control while landing. Factors associated with the accident were the improper landing flare and the pilot's lack of total experience.NTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…NTSB FTW94LA318Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control.NTSB CHI94LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainwell, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of total experience.NTSB ATL94LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Linden, TNThe pilot's improper use of the rudder which resulted in a loss of directional control.NTSB MIA94LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe failure of the pilot-in-command to calculate fuel consumption correctly resulting in loss of engine power due to fuel exhaustion.NTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.NTSB MIA94LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLThe pilot-in-command's decision to land with excessive airspeed, and failure to obtain the proper touchdown point during a precautionary landing. The electrical short was a factor in the accident.NTSB NYC94LA171Accident · Serious injuriesLimited investigationFinal reportCessna 152-II · Enfield, NYThe pilot-in-command's attempt to take off under conditions beyond the performance capabilities of the airplane.NTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.NTSB FTW94LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · Arkadelphia, ARLoss of engine power due to fuel exhaustion and the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.NTSB MIA94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLEngine power loss due to blockage of the carburetor fuel discharge nozzle pickup by an insect that inadvertently entered the carburetor during overhaul resulting in fuel starvation.NTSB MIA94LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aguadilla, PRThe failure of the pilot-in-command to divert and refuel resulting in loss of engine power due to fuel exhaustion.NTSB MIA94LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLThe pilot's inadequate compensation for wind conditions. The gusty, crosswind was a factor.NTSB MIA94LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe inadvertent encounter with a water puddle on the runway during takeoff roll which resulted in the pilot losing directional control and running off the side of the runway.NTSB MIA94LA190Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot-in-command's decision to intentionally exit the airplane with the engine running, and failure to maintain a clearance from the propeller. The improper aircraft preflight was a factor.NTSB MIA94LA185Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe pilot-in-command's improper use of carburetor heat. The carburetor icing conditions were a factor.NTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.NTSB LAX94LA316Accident · No injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe pilot's failure to maintain proper runway alignment by failing to properly compensate for the surface wind conditions. The crosswind and the loose dirt were factors in this accident.NTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.NTSB ATL94LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAThe student pilot's improper use of the rudder, and his failure to maintain directional control during takeoff.NTSB MIA94LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe pilot's improper handling of the aircraft during the landing. Contributing to the accident was the lack of total experience by the pilot-in-command.NTSB BFO94FA108Accident · 1 fatalField investigationFinal reportCessna 152 · Mohawk, NYThe pilot's failure to maintain adequate airspeed. A factor is the pilot's overconfidence in his ability.NTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.NTSB MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .NTSB MIA94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lauderdale, FLThe pilot's improper flare and failure to maintain directional control during the aborted landing.NTSB LAX94LA237Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Upper Lake, CAThe pilot's failure to maintain adequate airspeed during a go- around. Contributing factors were the pilot's delayed remedial action in initiating the go-around and his improper use of the carburetor heat during the attempted initial climb.NTSB NYC94LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Spring City, PAThe pilot's improper inflight planning and inaccurate fuel consumption calculations, resulting in fuel supply exhaustion, loss of engine power, and the subsequent collision with trees during a forced landing.NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB LAX94LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Los Banos, CAthe student pilot's inadequate compensation for the existing crosswind conditions and his resultant loss of directional control. A factor in the accident was the student's lack of total flight experience.NTSB ANC94LA057Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kenai, AKFuel exhaustion as a result of the student pilot-in-command's failure to refuel. The lack of suitable terrain for a forced landing was a factor.NTSB ATL94LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, SCThe failure of the pilot to maintain directional control of the aircraft.NTSB LAX94LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe student pilot's failure to maintain directional control of the aircraft.NTSB NYC94LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTThe student pilot's improper recovery from a bounced landing which resulted in a loss of directional control. A factor was the student pilot's imroper landing flare, which resulted in a hard landing.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.NTSB MIA94LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Pompano Beach, FLThe student pilot's improper recovery from a bounced landing, resulting in a porpoise of the aircraft and nose gear collapse.NTSB LAX94LA182Accident · 1 fatalLimited investigationFinal reportCessna 152 · Avalon, CAthe failure of the pilot to apply carburetor heat as appropriate while conducting flight in conditions conducive for carburetor icing. A factor in the accident was the unsuitable steep mountainous terrain for a forced landing.NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.
Back to Cessna 152