NTSB investigations: Cessna 152, 2001, FL

5 cases on aircraft the registry lists as Cessna 152. 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

19772026
NTSB investigations: Cessna 152, 2001, FL per year, 1977–2026: 329 cases
19774
19789
19799
198013
19819
198212
19839
198412
198510
19866
198715
19888
198915
199010
199115
19926
199311
199417
19957
19967
19979
19988
199910
20008
20015
20026
20034
20042
20055
20065
20078
20085
20095
20106
20112
20124
20131
20154
20166
20175
20186
20194
20203
20211
20241
20251
20261

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.\"eventStateOrRegion\" = 'FL' 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'))
  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 MIA01LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe failure of the pilot of N89803 to insure his brakes were set and that the airplane was not rolling prior to diverting his attention to duties inside the cockpit, resulting in N89803 rolling forward and colliding with N8660Q which was parked in front of…Jul 29, 2001 · N89803 · 2 aircraft · Substantial damageNTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.Jul 29, 2001 · N944AC · DestroyedNTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)Jun 25, 2001 · N152LE · 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 damage