NTSB investigations: Cessna 152, PA

12 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of control - on ground/water”. 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 per year

19832026
NTSB investigations: Cessna 152, PA per year, 1983–2026: 12 cases
19832
19852
19861
19911
19932
19951
19971
20001
20011

Latest cases

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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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.

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.Nov 21, 2001 · N58ND · Substantial damageNTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.Mar 1, 2000 · N67639 · Substantial damageNTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.Oct 3, 1997 · N94999 · Substantial damageNTSB NYC95LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Beaver Falls, PAthe failure of the student pilot to maintain directional control after touchdown.Jul 13, 1995 · N46911 · Substantial damageNTSB NYC93LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAImproper recovery from a bounced landing which resulted in the airplane departing the side of the runway and striking trees.Jun 4, 1993 · N94999 · Substantial damageNTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.Mar 3, 1993 · N4705Q · Substantial damageNTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…Jan 22, 1991 · N67315 · Substantial damageNTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…Aug 4, 1986 · N93454 · Substantial damageNTSB NYC85LA161Accident · No injuriesLimited investigationFinal reportCessna 152II · Ebensburg, PAThe student plt was practicing takeoffs and landings when the acft traveled off the left side of the rwy during the fourth landing. Once off the rwy, the acft traveled into a construction area where it nosed over.Jul 5, 1985 · N45946 · Substantial damageNTSB NYC85LA127Accident · No injuriesLimited investigationFinal reportCessna C152 · Newry, PAThe student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the…May 19, 1985 · N94221 · Substantial damageNTSB NYC83LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Factoryville, PAAfter touchdown on a full stop landing, the student plt was instucted to apply brakes. When he failed to respond, the instructor (CFI) applied the brakes to stop the acft. As the brakes were engaged, the acft veered to the left. The CFI corrected with full…Jul 3, 1983 · N49653 · Substantial damageNTSB NYC83LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe turf rwy was wet from melting snow with snowbanks on both sides. The plt decided to take off from the left side staying clear of mud. Acceleration was slower than normal due to the wet grass & as the plt tried to rotate a loud bang was heard. The plt…Feb 21, 1983 · N757ER · Substantial damage