NTSB investigations: Cessna 152, 2016, FL

6 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, 2016, 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\") = 2016
    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 ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.Nov 13, 2016 · N94292 · Substantial damageNTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.Oct 17, 2016 · N46953 · Substantial damageNTSB GAA16CA448Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilot's improper pitch control during landing, which resulted in a bounced landing, and a nose landing gear collapse.Aug 21, 2016 · N94939 · Substantial damageNTSB GAA16CA504Accident · No injuriesData collectionFinal reportCessna 152 · Immokalee, FLThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.Jun 16, 2016 · N4918H · Substantial damageNTSB ERA16LA193Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melrose, FLA total loss of engine power due to fuel exhaustion.May 23, 2016 · N952SA · Substantial damageNTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.Feb 24, 2016 · N6449P · Substantial damage