Skip to content

NTSB investigations: Cessna 172H, FL

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
  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.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.Aug 29, 2025 · N1607F · Substantial damage NTSB ERA25LA261Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172H · Century, FLOn July 9, 2025, about 1820 central daylight time, a Cessna 172, N3254C, was involved in an accident near Century, Florida. The pilot and the passenger were not injured. The flight was conducted as a 14 Code of Federal Regulations Part 91 personal flight. The…Jul 9, 2025 · N3254C · Substantial damage NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.May 14, 2022 · N8845Z · Substantial damage NTSB ERA21FA029Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dunnellon, FLA total loss of engine power due to fuel exhaustion. Contributing was the pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and loss of control.Oct 25, 2020 · N724BC · Substantial damage NTSB ERA10LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Dania Beach, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jun 1, 2010 · N1435F · Substantial damage NTSB ERA10LA233Accident · 1 fatalLimited investigationFinal reportCessna 172H · Archer, FLThe pilot's failure to maintain adequate airspeed for undetermined reasons while maneuvering in the vicinity of an airport, which resulted in an aerodynamic stall and hard landing.Apr 16, 2010 · N8112L · Substantial damage NTSB MIA05CA067Accident · No injuriesData collectionFinal reportCessna 172 · Jacksonville, FLThe pilot's improper landing flare which resulted in a hard landing.Mar 3, 2005 · N4980R · Substantial damage NTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.Jun 6, 2002 · N260WB · Destroyed NTSB MIA98LA080Accident · No injuriesLimited investigationFinal reportCessna 172H · St. Petersburg, FLa sudden encounter with wind gusts associated with a quickly passing rain shower which resulted in a nose-over, and subsequent collision with the runway.Feb 19, 1998 · N1430F · Substantial damage NTSB ATL96FA119Accident · 1 fatalField investigationFinal reportCessna 172H · St. Petersburg, FLAn engine malfunction for undetermined reasons. A factor was the pilot's selection of an unsuitable landing site.Aug 17, 1996 · N8016L · Substantial damage NTSB MIA92FA127Accident · 1 fatalField investigationFinal reportCessna 172-H · Clewiston, FLThe failure of the pilot-in-command (student pilot) to maintain an airspeed above stall, and his inadvertent stall and spin.May 30, 1992 · N3793R · Destroyed NTSB MIA89FA111Accident · Serious injuriesField investigationFinal reportCessna 172H · Melbourne, FLThe pilot's selection of an inappropriate runway for takeoff and his inadequate compensation for crosswind conditions.Mar 21, 1989 · N1480F · Substantial damage NTSB MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…Jul 11, 1986 · N1448F · Substantial damage NTSB MIA79DKT15Accident · No injuriesClosedCessna 172 · W Palm Beach, FLDec 10, 1978 · N2425L · Substantial damage NTSB MIA78DLD52Accident · No injuriesClosedCessna 172 · Brandon, FLJun 10, 1978 · N3226L · Substantial damage NTSB MIA78DLD14Accident · No injuriesClosedCessna 172 · Valkaria, FLDec 9, 1977 · N3293L · Substantial damage NTSB MIA77FLD26Accident · Minor injuriesClosedCessna 172H · Cedar Key, FLJan 29, 1977 · N1491F · Substantial damage NTSB MIA76FLD74Accident · Serious injuriesClosedCessna 172H · Windermere, FLJul 29, 1976 · N3700F · Substantial damage NTSB MIA73AM010Accident · 2 fatalClosedCessna 172H · Cedar Key, FLJul 20, 1972 · N1644F · Destroyed NTSB MIA72DLD49Accident · No injuriesClosedCessna 172 · Sebring, FLFeb 19, 1972 · N3831R · Substantial damage NTSB MIA71DLD68Accident · No injuriesClosedCessna 172H · Clearwater, FLMay 29, 1971 · N2462L · Substantial damage NTSB MIA71FKT20Accident · Minor injuriesClosedCessna 172H · Pahokee, FLNov 26, 1970 · N3809R · Substantial damage NTSB MIA70AM080Accident · 1 fatalClosedCessna 172H · St Petersburg, FLApr 6, 1970 · N2506L · Destroyed NTSB MIA69F0241Accident · Serious injuriesClosedCessna 172H · Chokoloskee, FLNov 8, 1968 · N2545L · Substantial damage NTSB MIA69F0180Accident · No injuriesClosedCessna 172 · Mcintosh, FLAug 31, 1968 · N1606F · Substantial damage NTSB MIA69D0047Accident · No injuriesClosedCessna 172 · Labelle, FLJul 6, 1968 · N8004L · Destroyed NTSB MIA69F0043Accident · Serious injuriesClosedCessna 172 · Palatka, FLJun 30, 1968 · N2758L · Destroyed NTSB MIA67F0385Accident · Serious injuriesClosedCessna 172 · Miami, FLJan 26, 1967 · N1430F · No damage NTSB MIA67F0343Accident · No injuriesClosedCessna 172 · Miami, FLDec 25, 1966 · N1480F · Substantial damage NTSB MIA67D0331Accident · No injuriesClosedCessna 172 · Venice, FLNov 19, 1966 · N1761F · Substantial damage