NTSB investigations: Cessna 152, 2000, FL

8 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, 2000, 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\") = 2000
    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 MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…Aug 15, 2000 · N93589 · Substantial damageNTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.May 4, 2000 · N92995 · Substantial damageNTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.Mar 26, 2000 · N757JE · Substantial damageNTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.Mar 15, 2000 · N569JH · Substantial damageNTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…Mar 9, 2000 · N79960 · 2 aircraft · DestroyedNTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.Feb 19, 2000 · N68197 · Substantial damageNTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.Feb 12, 2000 · N757XF · 2 aircraft · Substantial damageNTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.Jan 29, 2000 · N94999 · Substantial damage