NTSB investigations: Cessna 152, MA

7 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, MA per year, 1982–2026: 7 cases
19821
19871
19932
19961
19971
20001

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\" = 'MA' 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 NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.Jul 3, 2000 · N48858 · Substantial damageNTSB IAD97LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAInadequate compensation for wind conditions by the pilot. A related factor was the crosswind.Aug 2, 1997 · N89242 · Substantial damageNTSB NYC96LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Worcester, MAthe pilot's improper recovery from a bounced landing, and his failure to maintain control of the airplane, which resulted in a nose over. His improper flare was a related factor.Aug 10, 1996 · N5431Q · Substantial damageNTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.Jun 8, 1993 · N64932 · Substantial damageNTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.May 1, 1993 · N49394 · Substantial damageNTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…Nov 1, 1987 · N757PY · Substantial damageNTSB 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…Sep 18, 1982 · N46872 · Destroyed