NTSB investigations: Cessna 152, PA

8 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Hard landing”. 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

19822026
NTSB investigations: Cessna 152, PA per year, 1982–2026: 8 cases
19821
19841
19851
19871
19891
19901
20051
20061

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\" = 200))
  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 NYC07CA013Accident · No injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's inadequate flare, which resulted in a nosegear collapse during landing.Oct 27, 2006 · N68727 · Substantial damageNTSB NYC05CA112Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, PAThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a nose gear collapse while landing.Jun 23, 2005 · N46541 · Substantial damageNTSB NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.Apr 18, 1990 · N48259 · Substantial damageNTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.Apr 27, 1989 · N757JS · Substantial damageNTSB NYC87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Du Bois, PAThe student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then…Mar 21, 1987 · N67911 · Substantial damageNTSB NYC85LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Allentown, PAThe acft touched down hard and bounced while landing at Allentown, PA. The plt stated that upon making the landing, the controls felt like the acft's nose wheel had gone flat. As he attempted to pull the nose up, the acft ballooned and came down to the side…Aug 6, 1985 · N757PX · Substantial damageNTSB NYC84LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its…Apr 21, 1984 · N89880 · Substantial damageNTSB 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…May 19, 1982 · N45946 · Substantial damage