Skip to content

NTSB investigations: Cessna 172F, GA

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

19652026

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" = 'GA' 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 ('2072414')) 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\" = 'GA' 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 ('2072414'))
  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" = 'GA' 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 ('2072414'))
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 ERA22LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Hampton, GAThe student pilot’s application of excessive left brake during the landing roll, resulting in a loss of directional control and a runway excursion. The flight instructor’s inadequate remedial action was a factor in the accident.Apr 30, 2022 · N5704R · Substantial damage NTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…Nov 25, 2020 · N8125U · 2 aircraft · Substantial damage NTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 17, 2011 · N5419R · Substantial damage NTSB ATL06CA106Accident · Serious injuriesData collectionFinal reportCessna 172F · Rome, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with the ground.Jul 21, 2006 · N5324R · Substantial damage NTSB ATL99LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Buchanan, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice during glide and cruise, and rough and uneven terrain.Sep 6, 1999 · N7883U · Substantial damage NTSB ATL99LA001Accident · No injuriesLimited investigationFinal reportCessna C-172F · Ball Ground, GAThe pilots failure to maintain directional control of the airplane on take-off, during gusty conditions, resulting in a collision with a tree.Oct 1, 1998 · N5588R · Substantial damage NTSB ATL95LA029Accident · No injuriesLimited investigationFinal reportCessna 172F · Carrollton, GAThe pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.Dec 18, 1994 · N5440R · Substantial damage NTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…May 21, 1988 · N8374U · Substantial damage NTSB ATL85LA255Accident · No injuriesLimited investigationFinal reportCessna 172E · Villa Rica, GAThe plt took off from the stockmar arpt on a local flt. After flying in the local area, he returned at dusk to land, but inadvertently made an approach to another arpt that was located about 1/2 mi from the stockmar arpt. He did not realized that he was…Aug 22, 1985 · N8499U · Substantial damage NTSB ATL84FA033Accident · 1 fatalField investigationFinal reportCessna 172F · Brunswick, GAThe acft was observed entering a cloud layer about 500 ft AGL after takeoff. Another witness observed the acft's navigational lights in a circling motion as the acft plunged to the ground.Oct 31, 1983 · N5236F · Destroyed NTSB ATL81FKG25Accident · No injuriesClosedCessna 172F · Statesboro, GAJun 14, 1981 · N1117T · Substantial damage NTSB ATL81FA075Accident · 1 fatalClosedCessna 172 · Rocky Face, GAMay 21, 1981 · N5414R · Destroyed NTSB MIA79DLA37Accident · Minor injuriesClosedCessna 172 · Folkston, GAJul 8, 1979 · N8451U · Destroyed NTSB MIA74FKG21Accident · No injuriesClosedCessna 172F · Jasper, GASep 1, 1973 · N7870U · Substantial damage NTSB MIA70F0307Accident · No injuriesClosedCessna 172F · Chamblee, GADec 14, 1969 · N8555U · Substantial damage NTSB MIA69F0353Accident · No injuriesClosedCessna 172 · Fairburn, GADec 19, 1968 · N8134U · Substantial damage NTSB MIA68D0291Accident · No injuriesClosedCessna 172 · Buena Vista, GANov 12, 1967 · N7864U · Substantial damage NTSB MIA67D0542Accident · No injuriesClosedCessna 172 · Lincolnton, GAMar 25, 1967 · N5504R · Substantial damage NTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damage NTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GAAug 23, 1966 · N8309U · Substantial damage NTSB MIA66D0456Accident · No injuriesClosedCessna 172 · Villa Rica, GAMar 9, 1966 · N8595U · Substantial damage NTSB MIA65D0018Accident · Minor injuriesClosedCessna 172 · Elberton, GAMar 19, 1965 · N8212U · Substantial damage