NTSB investigations: Cessna 152, NJ

6 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

19832026
NTSB investigations: Cessna 152, NJ per year, 1983–2026: 6 cases
19831
19871
19911
19931
19971
19991

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\" = 'NJ' 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 IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.Apr 18, 1999 · N24707 · Substantial damageNTSB NYC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the pilot's failure to perform a go-around.Jan 12, 1997 · N48693 · Substantial damageNTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.May 17, 1993 · N5215Q · Substantial damageNTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.Mar 12, 1991 · N69095 · Substantial damageNTSB NYC87LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJWhen the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said…Mar 6, 1987 · N94902 · Substantial damageNTSB NYC83LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe student plt reported that she had made a go-around & two landings in calm wind conditions. She reported her 3rd approach was lower & slower, under 60 KTS. When she realized that she did not have the flaps full down, she added the last increment of flaps…Jun 17, 1983 · N6385M · Substantial damage