NTSB investigations: Cessna 152, 2002

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

19822026
NTSB investigations: Cessna 152, 2002 per year, 1982–2026: 264 cases
198218
198325
198426
198516
19864
198721
198817
198912
19907
199110
19927
19939
19949
19955
199612
19976
19986
19997
20008
20017
20026
20038
20042
20059
20065
20072

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 year(c.\"eventDate\") = 2002
    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 FTW03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.Oct 10, 2002 · N520SU · Substantial damageNTSB LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.Sep 17, 2002 · N5100B · Substantial damageNTSB FTW02LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKthe pilot's improper recovery from a bounced landing, which resulted in a hard landing.Sep 6, 2002 · N94112 · Substantial damageNTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.Jun 14, 2002 · N757FY · Substantial damageNTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.May 9, 2002 · N48819 · Substantial damageNTSB CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.Apr 16, 2002 · N752AA · Substantial damage