NTSB investigations: Cessna 152, UT

5 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of control - in flight”. 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

19882026
NTSB investigations: Cessna 152, UT per year, 1988–2026: 5 cases
19882
19963

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\" = 'UT' 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\" = 250))
  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 SEA97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper in-flight planning/decision, which allowed his aircraft to encounter wake turbulence from a Lear Jet, and/or the student allowed the aircraft to stall. The crosswind component from the quartering headwind was a possible factor.Nov 20, 1996 · N4713Q · Substantial damageNTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.Jul 10, 1996 · N4897P · Substantial damageNTSB SEA96LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Erda, UTfailure of the pilot to maintain directional control of the airplane during the landing. Darkness was a related factor.Apr 27, 1996 · N24316 · Substantial damageNTSB DEN89FA001Accident · 2 fatalField investigationFinal reportCessna 152 · Eden, UTBefore takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft…Oct 1, 1988 · N48926 · DestroyedNTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…May 20, 1988 · N25934 · Destroyed