Skip to content

NTSB investigations: Cessna 172G, FL

25 cases on aircraft the registry lists as Cessna 172G. 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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 ERA25LA345Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Williston, FLOn September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Sep 13, 2025 · N345QA · Substantial damage NTSB ERA21LA383Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Miramar, FLThe flight instructor’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation. Contributing to the flight instructor’s injury was her failure to wear the shoulder harness.Sep 28, 2021 · N4118L · Substantial damage NTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.Feb 23, 2011 · N3740L · Substantial damage NTSB ERA11CA069Accident · No injuriesData collectionFinal reportCessna 172G · Winter Haven, FLThe pilot's inadequate preflight/inflight fuel planning resulting in fuel exhaustion and total loss of engine power.Nov 21, 2010 · N3700L · Substantial damage NTSB MIA98LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Leesburg, FLThe pilot's decision to leave the engine running with no one at the controls as he exited the aircraft to check for wheel chocks in place. This resulted in the aircraft moving uncontrolled and eventually colliding with a fence.Sep 1, 1998 · N5797R · Substantial damage NTSB MIA98LA013Accident · No injuriesLimited investigationFinal reportCessna 172G · Panacea, FLThe pilot's improper use of carburetor heat resulting in loss of engine power due to carburetor icing and an in flight collision with trees during a forced landing.Oct 17, 1997 · N4690L · Substantial damage NTSB MIA95LA130Accident · No injuriesLimited investigationFinal reportCessna 172G · Sanford, FLThe pilot's failure to maintain airspeed during a forced landing resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of engine power while descending due to fuel exhaustion, and the…May 18, 1995 · N3722L · Substantial damage NTSB MIA91LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Jacksonville, FLFailure to maintain aircraft control after intentional flight into known adverse weather conditions.Dec 12, 1990 · N5780R · Destroyed NTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…Dec 16, 1988 · N4419L · Substantial damage NTSB MIA86LA089Accident · No injuriesLimited investigationFinal reportCessna 172G · New Smyrna, FLThe flt had been cruising on the right fuel tank. During the descent, carb heat and rich mixture was selected. The eng quit and the plt selected both fuel tanks. Eng pwr was restored briefly during the descent, but not enough to sustain flt. A forced landing…Mar 2, 1986 · N3870L · Substantial damage NTSB MIA82FA014Accident · 1 fatalClosedCessna 172G · St.Petersburg, FLNov 24, 1981 · N3602L · Destroyed NTSB MIA77DLD65Accident · Minor injuriesClosedCessna 172G · Zellwood, FLJun 11, 1977 · N3705L · Substantial damage NTSB MIA76DLA37Accident · No injuriesClosedCessna 172 · Perry, FLMar 12, 1976 · N6097R · Substantial damage NTSB MIA75FLD10Accident · Serious injuriesClosedCessna 172G · Wauchula, FLAug 11, 1974 · N4320L · Substantial damage NTSB MIA73DKT99Accident · No injuriesClosedCessna 172G · Belle Glade, FLMay 18, 1973 · N5971R · Substantial damage NTSB MIA73DKT62Accident · No injuriesClosedCessna 172 · Ft.Lauderdale, FLFeb 10, 1973 · N5770R · Substantial damage NTSB MIA72DLA34Accident · No injuriesClosedCessna 172 · Fernandina, FLMar 28, 1972 · N6058R · Substantial damage NTSB MIA72DKT35Accident · No injuriesClosedCessna 172G · Miami, FLDec 23, 1971 · N3778L · Substantial damage NTSB MIA70FKTI3Accident · Serious injuriesClosedCessna 172G · Clewiston, FLMar 30, 1970 · N4691L · Destroyed NTSB MIA70D0071Accident · No injuriesClosedCessna 172G · Milton, FLJun 28, 1969 · N4256L · Substantial damage NTSB MIA68D0481Accident · No injuriesClosedCessna 172G · Destin, FLApr 6, 1968 · N4668L · Substantial damage NTSB MIA67F0438Accident · No injuriesClosedCessna 172 · Opa Locka, FLMar 13, 1967 · N3618L · Substantial damage NTSB MIA67F0422Accident · Minor injuriesClosedCessna 172 · Opa Locka, FLMar 12, 1967 · N3940L · Substantial damage NTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNov 25, 1966 · N5791R · Destroyed NTSB MIA67F0190Accident · No injuriesClosedCessna 172 · Jay, FLJun 30, 1966 · N3712L · Substantial damage