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 NYC02LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Matawan, NJThe pilot's inadequate weather evaluation, and excessive airspeed while landing. A factor was a tailwind.NTSB CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.NTSB LAX02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.NTSB LAX02LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder City, NVa loss of engine power due to an undetermined malfunction of the carburetor.NTSB ATL02LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe students pilot's failure to perform a go-around after a bounced landing condition that resulted in the on-ground collision with a ditch.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB SEA02LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Longmont, COThe pilot's failure to maintain directional control of the aircraft during landing. Factors were a contaminated runway, which was icy and covered with snow, and a snow bank.NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB FTW02LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKthe instructor pilot's delayed go-around which resulted in an in-flight collision with trees. A contributing factor to the accident was the instructor pilot's fatigued condition due to lack of sleep.NTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.NTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB FTW02LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAthe Helldiver pilot's failure to maintain visual separation with the Cessna while taxiing. Contributing factors were the Cessna pilot's failure to comply with the local controller's instructions to continue taxiing and the failure of the local and ground…NTSB FTW02LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW02LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · New Braunfels, TXthe loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB CHI02LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedalia, MOThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.NTSB MIA02FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Poplarville, MSThe pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…NTSB IAD02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, NYThe CFI's delayed remedial action, which resulted in a loss of control during landing rollout and impact with a parked airplane.NTSB ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.NTSB FTW02LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bethany, OKthe mechanic's failure to properly lock the exhaust valve's clearance adjusting screw locknut, which resulted in a loose nut, disabling of the exhaust valve pushrod, and a partial loss of engine power while in cruise flight. A contributing factor was the…NTSB LAX02LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Henderson, NVFuel exhaustion during cruise flight due to the pilot's improper in-flight decision. A contributing factor was his improper preflight planning.NTSB NYC02FA009Accident · 1 fatalField investigationFinal reportCessna 152 · Middlefield, CTThe pilot's failure to maintain sufficient altitude while maneuvering, which resulted in a collision with terrain. Factors in the accident were the dark night, rising terrain, and clouds.NTSB MIA02LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe improper flare by the pilot-in-command resulting in a hard landing and subsequent collapse of the nose landing gear due to overload.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB MIA01LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe failure of the pilot of N89803 to insure his brakes were set and that the airplane was not rolling prior to diverting his attention to duties inside the cockpit, resulting in N89803 rolling forward and colliding with N8660Q which was parked in front of…NTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB FTW01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Springdale, ARthe instructor's failure to refuel the airplane, which resulted in fuel exhaustion.NTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.NTSB ANC01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Haines, AKThe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the pilot's selection of unsuitable terrain for takeoff, and a rough/uneven takeoff area.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB CHI01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Patriot, INthe inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.NTSB CHI01LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Roscommon, MIThe failure of the pilot to maintain clearance from the tree line. Factors to the accident were the tailwind, the aircraft being near gross weight, the high density altitude, the rough runway condition, and the tree line. An additional factor to the accident…NTSB IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.NTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.NTSB DEN01LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Junction, COthe student pilot's failure to recover from a bounced landing, which resulted in porpoising and subsequently a nose over.NTSB DEN01LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control of the airplane during landing.
Back to Cessna 152