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 LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB LAX00LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe pilot's failure to compensate for a crosswind and to maintain directional control during landing.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB FTW00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Decatur, TXThe instructor pilot's failure to maintain the minimum controllable airspeed during a simulated emergency approach, which resulted in a stall.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB DEN00FA067Accident · 1 fatalField investigationFinal reportCessna 152 · Roswell, NMThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin. A factor was the pilot's diverted attention to over flying her residence.NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB ANC00LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 152 · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB FTW00LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.NTSB FTW00FA063Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, ARthe pilot's failure to maintain aircraft control.NTSB NYC00FA057Accident · 1 fatalField investigationFinal reportCessna 152 · N. Stonington, CTThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the pilot's lack of recent flight experience.NTSB MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…NTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.NTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.NTSB MIA00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.NTSB LAX00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Surprise, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff from a short and unimproved dirt road, which resulted in an inadvertent stall/mush condition and impact with the ground.NTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.NTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.NTSB MIA00FA019Accident · 1 fatalField investigationFinal reportCessna 152 · Tamarac, FLthe pilot's failure to maintain airspeed resulting in the airplane stalling and entering a spin to the left at an inadequate altitude and his failure to apply spin recovery emergency procedures prior to the airplane impacting the swamp.NTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.NTSB MIA00LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Cornelia, GAthe pilot misjudged the flare, causing the airplane to porpoise, and subsequently impact with the runwayNTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX00FA017Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAthe pilot's continued VFR flight into IMC. Contributing factors were the pilot's self induced pressure to depart the airport before the weather worsened and the airport closed, and the mountain obscurement and foggy weather conditions, and the night light…NTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB FTW99LA264Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXThe pilot's hard landing as result of his improper landing flare and his improper recovery from a bounced landing. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.NTSB ATL99LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Baker, FLThe flight instructor misjudged his altitude and airspeed. A factor was trees.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB SEA99LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Kennewick, WAThe student pilot's inadequate compensation for gusty wind conditions. A contributing factor was gusty winds.NTSB MIA99LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Ocala, FLA misjudged flare and the failure of the student pilot to use the proper recovery technique for a bounced landing, allowing the airplane to commence a porpoise, and the eventual collapse of the nose landing gear.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB MIA99LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAThe failure of the pilot to maintain directional control during takeoff from a touch and go landing resulting in the aircraft traveling off the runway, colliding with taxiway lights and a taxiway sign, collapsing the nose landing gear, and nosing down.NTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.NTSB CHI99LA286Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Evansville, INfuel exhaustion due to the flight instructor's improper in-flight decision. A factor was the ditch.
Back to Cessna 152