NTSB investigations: Cessna 152, 2001

10 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

19822026
NTSB investigations: Cessna 152, 2001 per year, 1982–2026: 376 cases
198231
198325
198426
198527
198623
198727
198821
198917
199020
199115
199211
199316
199422
199513
199614
19977
19989
199912
20007
200110
20026
20034
20044
20054
20063
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\") = 2001
    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 IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.Nov 21, 2001 · N58ND · Substantial damageNTSB IAD02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, NYThe CFI's delayed remedial action, which resulted in a loss of control during landing rollout and impact with a parked airplane.Nov 10, 2001 · N5195B · Substantial damageNTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.Jul 19, 2001 · N4662Q · Substantial damageNTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.Jul 2, 2001 · N5286P · Substantial damageNTSB DEN01LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Junction, COthe student pilot's failure to recover from a bounced landing, which resulted in porpoising and subsequently a nose over.Mar 3, 2001 · N24950 · Substantial damageNTSB DEN01LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control of the airplane during landing.Mar 3, 2001 · N152RC · Substantial damageNTSB 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 MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.Feb 25, 2001 · N942AC · Substantial damageNTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.Jan 29, 2001 · N152DF · Substantial damageNTSB CHI01LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Mattoon, ILthe pilot's failure to maintain directional control. Factors were the crosswind, the pilots lack of total experience, and the snow covered terrain adjacent to the runway.Jan 10, 2001 · N5394Q · Substantial damage