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 CHI83LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNWhile performing a touch-and-go landing, the pilot used a higher than normal speed. After touching down, the aircraft became airborne again, then began to porpoise. After about the 3rd or 4th bounce, the nose gear failed.NTSB FTW83LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXWhile practicing touch & go landings the student plt lost directional control, ran off the side of the rwy into a ditch collapsing the nose gear & turning over.NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB MKC83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSThe pilot estimated there was about 10 gallons of fuel on board before he took off. After making three takeoffs and landings, he picked up a passenger and flew in the local area. After flying about one hour and 17 minutes, the engine lost power. While landing…NTSB MIA83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe student pilot was practicing touch-and-go landings. After touching down on his first landing, he configured the aircraft for takeoff. Immediately after applying power, he observed another plane (unknown make & model) landing from the opposite direction.…NTSB FTW82DA400Accident · No injuriesFinal reportCessna 152 · Dumas, TXDuring the student's first solo takeoff & landing, she was not lined up with the runway & elected to go around. Power was applied & the flaps were fully retracted. The acft immediately dropped to the ground left of the runway.NTSB CHI82IA364Incident · No injuriesIncident investigationFinal reportCessna 152 · Pontiac, MIThe pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was…NTSB FTW82DA392Accident · No injuriesFinal reportCessna 152 · Parks, LAThe pilot stated that the aircraft ran out of fuel. The fuel gauges were still registering 1/4 full on both tanks when the engine quit. In addition the pilot stated, "if I had dipped the tanks on preflight I would have known exactly how much fuel was in the…NTSB MIA82FLD20Accident · Serious injuriesFinal reportCessna 152 · Ft. Myers, FLThe aircraft crashed after the engine lost power. The pilot stated he did not visually check the fuel on the day of the flight. The aircraft was checked after the accident and it contained a negligible amount of fuel. The wings and fuel tanks were not damaged…NTSB NYC82DA228Accident · No injuriesFinal reportCessna 152 · Hyannis, MAAfter returning from a cross-country, the pilot landed on runway 23. The wind was reported to be from 240 deg at 10, gusting to 20 KTS. The pilot reported that during the landing, the plane touched down on the main gear, and nosed over onto the propeller. He…NTSB DEN82FA198Accident · 1 fatalField investigationFinal reportCessna 152 · Divide, MTThe acft stalled & crashed on the side of a ridge. The plt was described as an avid outdoorsman, sportsman & hunter. According to local residents near the crash site, the area is well populated with large & small game. Density altitude was computed to be…NTSB SEA82DA160Accident · No injuriesFinal reportCessna 152 · Bonners Ferry, IDAfter refueling, the pilot attempted to takeoff from a field. The first takeoff attempt was aborted. During the second takeoff roll the aircraft nose gear struck a ditch, causing the aircraft to nose over.NTSB FTW82DA357Accident · No injuriesFinal reportCessna 152 · College Station, TXAfter the CFI cut power for a simulated forced landing, the student set up an approach to a road. When power was added at the bottom of the approach the engine accelerated to about 75% power & then decelerated back to idle. On touchdown on the road the left…NTSB LAX82DA323Accident · No injuriesFinal reportCessna 152 · Chandler, AZStudent pilot during solo flight applied right brake to correct veer and aircraft veered right off runway. Aircraft collided with bushes and nosed over alongside runway. The right brake was locked after accident.NTSB MIA82FKT11Accident · Serious injuriesFinal reportCessna 152 · Lantana, FLWitnesses observed the acft flying 35-40 ft over the ocean making banks, climbs & dives. Just prior to crashing the acft was seen to be in a very steep climb.NTSB SEA82DA144Accident · No injuriesFinal reportCessna 152-II · Grants Pass, ORThe instructor pilot stated that the student was having difficulty aligning the aircraft with the runway during the landing approach. As they approached the runway he instructed the student to "get the nose up." At an altitude of approximately three feet, the…NTSB LAX82DA301Accident · No injuriesFinal reportCessna 152 · Santa Rosa, CAThe student pilot was on his first supervised solo flight. He had completed his first landing and was following through on a touch and go when he lost directional control. The aircraft veered left, ran off the side of the runway, hit a ditch and came to rest…NTSB LAX82FA297Accident · 2 fatalField investigationFinal reportCessna 172 · Lompoc, CAA student plt in a Cessna 152, N4603L, was departing from rwy 25 while Cessna 172, N733HV, was arriving from the north. After taking off, the student made a right climbing turn toward the north, then began another turn to the east in accordance with published…NTSB LAX82DA298Accident · No injuriesFinal reportCessna 152 · Livermore, CAThe student pilot was departing on a solo cross-country flight. He lost control of the aircraft on the takeoff roll, hit a ditch and nosed over. The aircraft owner, who was also his instructor, stated that a moderate crosswind existed during the takeoff roll.…NTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…NTSB MIA82DA169Accident · No injuriesFinal reportCessna 172 · Moore Haven, FLThe student pilot was on the return portion of a cross-country flight when she deviated to avoid weather. She tried to circumnavigate around lake okeechobee, but in her opinion, the weather began to close in with the visibility decreasing in heavy rain. She…NTSB FTW82DA321Accident · No injuriesFinal reportCessna 152 · Iredell, TXThe student pilot originally took off at temple, TX and proceeded to mcgregor, TX to practice touch-and-go landings. After departing mcgregor to return to temple, he became lost. After about two hours, he landed in a pasture and received directions to temple.…NTSB DEN82DA158Accident · No injuriesFinal reportCessna 152 · Avondale, COThe student pilot was on a private pilot check flight with a designated flight examiner. While demonstrating balked landings, the go-around procedure was improper. Therefore, the examiner asked the student to repeat the procedure on the next approach (a short…NTSB LAX82DA289Accident · No injuriesFinal reportCessna 152 · Phoenix, AZDuring a dual instructional flight, the instructor pilot (ip) initiated a forced landing for a student by pulling the mixture control out. The forced landing was taken to an altitude of about 400 ft AGL, then the ip pushed the mixture control in and told the…NTSB FTW82DA316Accident · Minor injuriesFinal reportCessna 152 · Rockwall, TXThe pilot stated that he encountered wind shear, dust devil or other instantaneous failure, while flying at about 100 ft AGL. He stated the aircraft dropped, fell out of control, impacted and tumbled to a stop. Reportedly, a witness observed the aircraft…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB CHI82DA313Accident · No injuriesFinal reportCessna 152 · Chatfield, MNThe pilot reported that he was landing on runway 36 at a private airport with a crosswind from 300 deg at 17, gusting 26 KTS. The wind was blowing over tall trees along the left side of the runway, near the approach end. The pilot stated that this resulted in…NTSB ATL82IA218Incident · No injuriesIncident investigationFinal reportCessna 152 · Hampton, GADuring taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…NTSB LAX82FA279Accident · 2 fatalField investigationFinal reportCessna 152 · Morgan Hill, CAA Cessna 152, N5090Q and a Cessna 172, N20100 collided in flight while the aircrews of both aircraft were on local dual instructional flights. The student in the Cessna 152 was practicing a recovery from an unusual attitude after the instructor (ip) put the…NTSB MKC82DA131Accident · No injuriesFinal reportCessna 152II · Near Wright Cit, MOThe student pilot was on a solo cross country and landed at an intermediate stop and refueled with 6 gallons of fuel. During the return flight the aircraft's engine quit. During the forced landing the aircraft collided with trees. Post accident examination of…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB MKC82FCQ13Accident · 1 fatalFinal reportCessna 152 · Rose Hill, KSThe student pilot was on a solo flight while he was in a training phase to practice flight maneuvers. During the flight, the aircraft crashed and burned. An investigation revealed that the plane did not move after impact and both wings were crushed…NTSB FTW82DA288Accident · No injuriesFinal reportCessna 152 · Huntsville, TXThe student stated that on her fourth landing of the day, she felt she was too FAR down the runway and to high to make a good landing, so she "put in flaps and power and was going to make a go-around." Reportedly, the aircraft landed, she lost directional…NTSB CHI82DA264Accident · No injuriesFinal reportCessna 152II · Zanesville, OHAircraft swerved off runway into tire casings used as a ditch barrier and flipped inverted during landing roll.NTSB ATL82FA184Accident · 1 fatalField investigationFinal reportCessna 152 · Charleston, SCPlt made steep turn after takeoff & stalled. Acft came to rest on the arpt about 1500 ft from the point where the takeoff run was initiated & about 200 ft north of rwy 9. It was necessary for the plt to be airborne by 0700 in order for him to make his first…NTSB LAX82DA249Accident · No injuriesFinal reportCessna 152 · Prescott, AZThe student pilot was on his second supervised solo flight. During his first landing on this flight, the aircraft touched down on the nosewheel first. It then began to porpoise. As the aircraft continued to bounce, the nose gear collapsed. According to the…NTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…NTSB CHI82DA232Accident · No injuriesFinal reportCessna 152 · Harlan, INReportedly, the pilot was demonstrating a forced landing to the passenger by moving the mixture to cut-off. He stated that another aircraft interferred with his approach and he was unable to restart the engine to go around. Subsequently, the aircraft nosed…NTSB LAX82DA228Accident · No injuriesFinal reportCessna 152 · Scottsdale, AZDuring a dual instructional flight, the student pilot and instructor pilot (ip) were practicing touch and go landings. After practicing a soft field approach and landing, the student initiated a short field takeoff with full power and 10 degrees of flaps.…NTSB DEN82DA109Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDThe student pilot was practicing takeoffs and landings on his third supervised solo flight with a left quartering wind at 10 KTS. Upon landing, the student began his takeoff roll. Subsequently, the aircraft veered off the runway, traveled about 600 ft, and…NTSB FTW82DA228Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKThe aircraft lost power during climb at 1300 feet. The engine would not restart. The pilot made a forced landing in the Arkansas river. No preimpact malfunction or failure of the aircraft's engine could be found.NTSB MKC82DA104Accident · No injuriesFinal reportCessna 152 · 10 Sw Falls Cit, NEThe pilot stated that he took off to take photographs in nemaha county, KS. While enroute, he shot 6 rolls of film and then continued toward falls city, NE. He reported that about 7 miles from the airport, he ran out of fuel and landed in a wheat field. After…NTSB FTW82DA220Accident · No injuriesFinal reportCessna 152 · Cushing, OKWhile landing, the student pilot lost control and the aircraft swerved off the runway, collided with a ditch and nosed down. The student stated that she flared for landing and added too much power and right rudder which resulted in the loss of control.NTSB FTW82DPA13Accident · No injuriesFinal reportCessna 152 · Mckinney, TXThe student pilot practicing touch and go landings lost control of the aircraft and swerved off the runway. The aircraft then contacted a fence and nosed over.NTSB LAX82DA214Accident · No injuriesFinal reportCessna 152 · San Andreas, CAThe student pilot was a foreign national that was scheduled for a solo cross-country flight. He departed with a passenger that was a private pilot with a ground instructor rating. According to the passenger, the student had not flown for 8 days and was afraid…NTSB NYC82FA116Accident · 1 fatalField investigationFinal reportCessna 152 · Elma, NYThe pilot was performing a flight exam for a private pilot certificate. An approach was made to a field bordered by high tension lines. During the approach the aircraft collided with wires and descended nose first to the ground.NTSB FTW82DA207Accident · No injuriesFinal reportCessna 152 · Clarksville, ARThe pilot reported that after landing at ozark, AR, no fuel was available. Therefore, he proceeded to obtain fuel at Clarksville, AR, a distance of about 15 miles. After takeoff, he encountered moderate turbulence, leveled at about 600 ft, and reduced power…NTSB LAX82DVM14Accident · Serious injuriesFinal reportCessna 152 · San Carlos, CAThe student pilot was practicing short field landings. On final the pilot lowered the nose of the aircraft and leveled the wings, the nose wheel struck the runway callapsing the nose gear.NTSB NYC82DA108Accident · No injuriesFinal reportCessna 152 · Burlington, CTThe student pilot was on her second supervised solo flight. While landing, she flared high and subsequently landed hard, collapsing the nose gear. The pilot reported that she did not have a good mental attitude since her children had been involved in a car…