NTSB investigations: Cessna 152, AR

6 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of control - on ground/water”. 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, AR per year, 1983–2026: 6 cases
19831
19842
19851
19871
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\" = 'AR' 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\" = 260))
  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 FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.Oct 15, 1999 · N66930 · Substantial damageNTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.Jan 8, 1987 · N68792 · Substantial damageNTSB MKC85LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrison, ARAfter an en route stop, on a x-country flt, the student plt was taxiing to takeoff again. While proceeding northbound with a left x-wind, the plt applied braking action to slow the acft for a turn. At about that time, the acft veered to the right, went down…Jul 15, 1985 · N68777 · Substantial damageNTSB MKC84LA139Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Little Rock, ARThe acft collided with a rwy light and nosed over during landing in a x-wind. The wind was reported to the student as from 040 degrees at 9 KTS at takeoff and 070 degrees at 11 KTS when she returned to land. These winds converted to a 90 degree x-wind of 6.5…May 15, 1984 · N757KD · Substantial damageNTSB MKC84LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · N.Carlisle, ARThe acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than…Apr 28, 1984 · N4823L · Substantial damageNTSB FTW83LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Bentonville, ARThe pilot reported that after the acft went off the right side of the runway during landing it went through a drainage ditch and once again became airborne. After the acft landed the second time in a muddy field the nose gear collapsed resulting in damage to…May 4, 1983 · N89557 · Substantial damage