Final NTSB investigations: Cessna 172L, FL

22 cases on aircraft the registry lists as Cessna 172L. 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

19712026
Final NTSB investigations: Cessna 172L, FL per year, 1971–2026: 22 cases
19711
19723
19733
19741
19754
19762
19772
19821
19921
19981
20011
20081
20241

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\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
  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 ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.Sep 17, 2024 · N19703 · Substantial damageNTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.Jan 12, 2008 · N7100Q · Substantial damageNTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…Mar 3, 2001 · N3802Q · Substantial damageNTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…Jun 23, 1998 · N3853Q · DestroyedNTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.Nov 14, 1992 · N9854G · Substantial damageNTSB MIA82DA061Accident · No injuriesFinal reportCessna 172L · Lake City, FLWhile enroute, the pilot encountered an area with restricted visibility and with an estimated ceiling of 300 ft. after reversing course, he saw a forest road and elected to land. He reported that during the landing roll, a gust of wind was encountered causing…Feb 28, 1982 · N1026M · Substantial damageNTSB MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLDec 4, 1977 · N3966Q · DestroyedNTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLSep 16, 1977 · N7645G · DestroyedNTSB MIA76DKT80Accident · No injuriesClosedCessna 172 · Deerfld Beach, FLMay 31, 1976 · N7941G · Substantial damageNTSB MIA76DLD57Accident · Serious injuriesClosedCessna 172 · Plymouth, FLMay 22, 1976 · N7682G · Substantial damageNTSB MIA76AM041Accident · 1 fatalClosedCessna 172L · Key West, FLNov 8, 1975 · N3913Q · DestroyedNTSB MIA76FLD09Accident · Minor injuriesClosedCessna 172 · Nw Prt Richey, FLAug 9, 1975 · N4303Q · Substantial damageNTSB MIA75DKT82Accident · No injuriesClosedCessna 172L · Sanibel Island, FLMay 24, 1975 · N7002Q · Substantial damageNTSB MIA75AM079Accident · 1 fatalClosedCessna 172L · Marathon, FLMay 10, 1975 · N7059Q · DestroyedNTSB MIA75DKT35Accident · No injuriesClosedCessna 172L · Hollywood, FLDec 22, 1974 · N4393Q · Substantial damageNTSB MIA74DLD22Accident · No injuriesClosedCessna 172 · Arcadia, FLAug 24, 1973 · N3911Q · Substantial damageNTSB MIA73AM111Accident · 1 fatalClosedCessna 172L · Newberry, FLJun 17, 1973 · N9842G · DestroyedNTSB MIA73FLA37Accident · Serious injuriesClosedCessna 172L · St Augustine, FLMay 13, 1973 · N9879G · DestroyedNTSB MIA73DKT42Accident · No injuriesClosedCessna 172 · Evergldes Cty, FLDec 26, 1972 · N7900G · Substantial damageNTSB MIA73DLA18Accident · No injuriesClosedCessna 172 · Jacksonville, FLOct 10, 1972 · N4348Q · Substantial damageNTSB MIA73AM039Accident · 1 fatalClosedCessna 172L · Deerfield Bch, FLOct 5, 1972 · N9890G · DestroyedNTSB MIA72FLD14Accident · Serious injuriesClosedCessna 172L · Orlando, FLOct 3, 1971 · N7766G · Substantial damage