NTSB investigations: Cessna 152, MN

13 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

19842026
NTSB investigations: Cessna 152, MN per year, 1984–2026: 13 cases
19841
19861
19871
19881
19892
19911
19921
19931
19941
19992
20011

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\" = 'MN' 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 CHI01LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNThe student pilot's failure to maintain directional control during the landing. Factors relating to the accident were the student pilot's lack of total experience, the icy runway, the strong crosswind, the wind gusts, and the snowbank.Feb 28, 2001 · N5236H · Substantial damageNTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.Mar 10, 1999 · N89084 · Substantial damageNTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.Jan 25, 1999 · N752AA · Substantial damageNTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.Dec 9, 1994 · N6445P · Substantial damageNTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.Jan 17, 1993 · N48863 · Substantial damageNTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.Nov 7, 1992 · N24975 · Substantial damageNTSB CHI91LA065Accident · No injuriesLimited investigationFinal reportCessna 152 II · St. Cloud, MNThe student pilot's failure to maintain directional control during acceleration for takeoff.Jan 11, 1991 · N4872B · Substantial damageNTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.May 2, 1989 · N6436P · Substantial damageNTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.Mar 1, 1989 · N5329B · Substantial damageNTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.Dec 4, 1988 · N6132H · Substantial damageNTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.Feb 6, 1987 · N757SX · Substantial damageNTSB CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.Jan 14, 1986 · N95636 · Substantial damageNTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…Jul 25, 1984 · N64985 · Substantial damage