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 DEN82DA097Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDDuring landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.NTSB NYC82DA101Accident · No injuriesFinal reportCessna 152 · Monongahela, PADuring a practice landing the aircraft landed hard and bounced back into the air. The student pilot applied excessive forward pressure on the yoke causing the aircraft to land hard a second time in a nose low condition. The instructor pilot tried to salvage…NTSB MKC82DA084Accident · No injuriesFinal reportCessna 152 · Ainsworth, NEThe pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots.NTSB CHI82DA161Accident · No injuriesFinal reportCessna 152 · Romeo, MIThe student pilot was practicing touch and go landings. On the third takeoff the aircraft veered to the left and the student was unable to correct. The aircraft continued into a soft field and nosed over. The wind was calm and the weather clear.NTSB LAX82DA169Accident · No injuriesFinal reportCessna 152 · San Fernando, CAThe student pilot lost directional control during landing and veered into a parked van. This was his second supervised solo flight.NTSB FTW82DA170Accident · No injuriesFinal reportCessna 152 · Coahama, TXThe pilot was on a cross country flight for his commercial pilot's license. He became lost, landed in a plowed open field and the aircraft nosed over. There was no evidence of propeller rotation or fuel at the scene of the accident.NTSB FTW82FPD11Accident · 1 fatalFinal reportCessna 152 · Carswell, TXAn instructor pilot and a passenger (a student pilot) departed north richland hills, TX at about 1700 hrs. The instructor flew to a recreational area and landed in an open nearby field. He gave airplane rides to various persons for about 1 1/2 hrs then parked…NTSB ATL82DA117Accident · Minor injuriesFinal reportCessna 152 · White Sulphur S, WVThe pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the…NTSB CHI82FA141Accident · 2 fatalField investigationFinal reportCessna 152 · Kenosha, WIThe aircraft crashed in a steep nosed down attitude while the pilot and one passenger were on a local flight. Prior to the accident, witnesses observed the pilot practicing stalls below 1000 ft. no precrash failures were found. The last entry in the pilot's…NTSB CHI82DA138Accident · No injuriesFinal reportCessna 152 · New London, WIThe pilot elected to land on a private strip he was not familiar with. He was not aware of the 3-4 inches of standing water on the sod surface when he touched down. The aircraft nosed over during landing roll.NTSB MKC82DA061Accident · No injuriesFinal reportCessna 152 · Grain Valley, MODuring landing roll the aircraft went off the runway and ended up in a ditch.NTSB MIA82DA107Accident · No injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot reported that she landed with 30 degrees of flaps on runway 23. She reported that the wind was gusting from 15 to 20 knots and the wind sock seemed to fluctuate from westerly to northwesterly. The pilot related that the aircraftbounced twice upon…NTSB MKC82IA047Incident · No injuriesIncident investigationFinal reportCessna 152 · Cottonwood Fall, KSAfter executing two landings on runway 36, the pilot noticed a wind shift from 360 degrees to 260 degrees and he taxied back up the runway and started a takeoff on runway 18. The pilot stated that about 1300 from the departure end of the runway, he…NTSB LAX82FUA13Accident · No injuriesFinal reportCessna 152 · Long Beach, CADuring the landing roll, the nose gear collapsed and the plane veered off the runway. The student pilot and a witness stated that the gear collasped after a normal landing. The nosewheel tire had uneven wear characerics. There was substantial damage to the…NTSB FTW82DA124Accident · No injuriesFinal reportCessna 152 · Lafayette, LAEn route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over.NTSB CHI82DA116Accident · No injuriesFinal reportCessna 152 · Pontiac, MIWhile the student pilot was on his fifth touch and go pattern, the plane veered to the left after touchdown. The left main gear then encountered snow and pulled the aircraft further left into a snowbank. The student claimed that the owners had advised him to…NTSB NYC82DA064Accident · No injuriesFinal reportCessna 152 · Ronkonkoma, NYWhile the student was on a local flight, the wind shifted from 240 degrees (down the runway) to 180 degrees. After returning, the student entered the traffic pattern for landing on runway 24. The downwind leg was extended to accommodate departing traffic.…NTSB NYC82DA063Accident · No injuriesFinal reportCessna 152 · East Aurora, NYDuring a local flight in marginal weather conditions with light snow, there was a gradual loss of power. At first, the instructor thought the student had throttled back and told him to increase the power. When the instructor realized the problem, he took the…NTSB FTW82DA102Accident · No injuriesFinal reportCessna 152 · New Orleans, LAThe student pilot was doing touch and go landings on runway 36. The wind was 290 degrees at 10 KTS. During a landing roll the student lost control and departed the left side of the runway. The aircraft sank into the mud and nosed over.NTSB LAX82DA115Accident · No injuriesFinal reportCessna 152 · Winslow, AZThe pilot stated that he did a touch and go on runway 29, then pulled the power off at approximately 300 ft AGL over the intersection of runways 29 and 22. He reported that from there, he attempted to land on runway 22 with no power, failed to maintain…NTSB ATL82DA077Accident · No injuriesFinal reportCessna 152 · Allendale, SCDuring a solo three hundred mile cross country flight the student pilot stated that he strayed to the south of his intended course. He subsequently became disoriented and after circling an area for about 30 minutes began to panic and elected to land. The…NTSB MIA82DA076Accident · No injuriesFinal reportCessna 152 · Brooksville, FLThe student pilot was on a solo cross-country flight. While landing at an en route airport, he encountered a gusty, right quartering, headwind. During touchdown, the plane bounced and the pilot applied power. However, he was unable to prevent the plane from…NTSB ATL82DA070Accident · Minor injuriesFinal reportCessna 152 · Lusby, MDThe student was on a cross-country flight from leonardtown, MD to cumberland, MD to lancaster, pa and then return to leonardtown. Before takeoff, the student was instructed to refuel at cumberland or lancaster before continuing. The student stated that he had…NTSB LAX82FVD11Accident · No injuriesFinal reportCessna 152 · Navato, CAAfter returning to the airport, the student pilot made one touch and go landing and noticed gusty crosswind conditions. He elected to make the next landing to a full stop. He reported that during the landing flare, he lost control and the aircraft was blown…NTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.NTSB MIA82DA081Accident · No injuriesFinal reportCessna 152 · Brooksville, FLWhile taxiing for takeoff on a road used for aircraft and vehicles the aircraft collided with a parked garbage truck.NTSB FTW82DA077Accident · No injuriesFinal reportCessna 152 · Arkadelphia, ARThe pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of…NTSB MIA82DA058Accident · No injuriesFinal reportCessna 152 · Miami Beach, FLThe pilot stated that while flying approximately 10 miles southeast of the airport over the ocean the engine started to vibrate. The pilot elected to return to the airport however. A few minutes later the engine oil pressure dropped to zero and the aircraft…NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…NTSB MKC82DA040Accident · No injuriesFinal reportCessna 152 · Mcpherson, KSAfter returning from a local flight, the student pilot landed on runway 36 with a wind from 070 degrees at 13 knots. He reported that he lost control on the landing roll and departed the left side of the runway. The aircraft ran into muddy terrain and nosed…NTSB CHI82DA070Accident · No injuriesFinal reportCessna 152II · Oxford, OHAfter a normal landing the pilot retracted the flaps and opened the throttle. As the aircraft gained speed it started drifting off the runway. The pilot attempted to correct with rudder but the aircraft veered off the runway. Power was reduced before the nose…NTSB MKC82DA035Accident · No injuriesFinal reportCessna 152 · Tipton, IAThe student pilot said that he was on the takeoff roll when the aircraft veered left and collided with a snowbank beside the runway. He reported that the runway was clear and dry, and the wind was not a factor.NTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…NTSB MIA82DA054Accident · No injuriesFinal reportCessna 152 · St. Petersburg, FLThe student pilot was on her first supervised solo flight. During the second landing the aircraft bounced and while attempting to recover the pilot first added power then cut it. The aircraft dropped down on its nose and the nose gear collapsed.NTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…NTSB MKC82DA032Accident · No injuriesFinal reportCessna 152 · Chesterfield, MOThe student pilot was making a touch and go landing. He failed to keep the aircraft on the runway during the takeoff. The plane departed the runway to the left and ran up onto a snowbank. The right side of the aircraft tipped down. The propeller and right…NTSB FTW82DA058Accident · No injuriesFinal reportCessna 152 · Cleveland, TXOn the second landing of a supervised solo flight, the aircraft veered and the student pilot lost control. The aircraft collided with the wind sock pole and was substantially damaged.NTSB CHI82DA054Accident · Minor injuriesFinal reportCessna 152 · Elyria, OHThe student was practicing takeoffs & landings. While taxiing after the first landing he detected a noticably bad shimmy. He continued his takeoffs & landings, and during the last landing he was unable to maintain directional control and collided with a…NTSB MKC82DA030Accident · No injuriesFinal reportCessna 152 · Chesterfield, MODuring takeoff from a touch and go landing, the engine lost power at about 300 ft AGL. The student pilot was unable to restart the engine. The aircraft was damaged during a forced landing off of the runway. No pre-impact engine malfunctions or failures were…NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.NTSB MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB LAX82DA064Accident · No injuriesFinal reportCessna 152 · Corona, CAFollowing a preflight inspection of the aircraft by the student pilot, the aircraft departed the Corona municipal airport on a dual training flight. Upon reaching an altitude of approximately 300 feet, the engine quit. The instructor landed the aircraft…NTSB MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…NTSB FTW82DA051Accident · No injuriesFinal reportCessna 152 · Mckinney, TXDuring local solo flight the aircraft veered off the left side of the runway resulting in substantial damage to the Cessna. The winds were gusting from 8 to 13 knots 35 degrees to the left of the runway heading.NTSB LAX82DA053Accident · No injuriesFinal reportCessna 152 · Lodi, CAThe pilot stated that during the landing roll he felt a vibration in the nose gear. Subsequently the aircraft veered offthe runway into soft ground and collapsed the nose gear.NTSB NYC82DA027Accident · No injuriesFinal reportCessna 152 · Ansonia, CTAfter departure from bridgeport on a local instructional flight, it was decided that a landing would be made at the Ansonia airport. The instructor reported that there was no NOTAM concerning hazardous runway conditions at Ansonia. During landing, the…NTSB MKC82DA021Accident · No injuriesFinal reportCessna 152 · Essex, MOThe student departed on a solo, cross-country flight. A comfort stop was made at an enroute airport during the first leg of the flight. The flight was then continued to the first pre-planned destination. After taking off on the second leg, the student became…NTSB FTW82DA044Accident · No injuriesFinal reportCessna 152 · Midland, TXDuring the student's first supervised solo flight he landed normally but lost control prior to adding power for a touch and go landing. The aircraft ran off the runway and collided with a pile of gravel coming to rest inverted.