NTSB investigations: Cessna 172G, GA
17 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.
Cases per year
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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\" = '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 ('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" = '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 ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA26LA012Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Sandersville, GAOn October 10, 2025, about 2015 eastern daylight time, a Cessna 172G, N4390L, was substantially damaged when it was involved in an accident near Sandersville, Geogia. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB ATL02LA135Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Perry, GAThe pilot's inadequate preflight inspection that resulted in fuel starvation due to fuel system contamination and the subsequent loss of engine power.NTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.NTSB ATL93FA059Accident · 3 fatalField investigationFinal reportCessna 172G · Jackson, GAThe pilots inadequate preflight planning and his failure to properly compensate for the wind. A factor was the unfavorable wind condition at the time of take off.NTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.NTSB ATL89LA102Accident · No injuriesLimited investigationFinal reportCessna 172G · Coolidge, GAFuel contamination of an unknown origin, failure of company maintenance personnel to locate and remove all contamination, continued operation of the aircraft by the pilot after the cause of a known engine problem was not determined, and subsequent fuel…NTSB ATL81FKG35Accident · No injuriesClosedCessna 172G · Louisville, GANTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GANTSB MIA75FKG54Accident · No injuriesClosedCessna 172G · Baxley, GANTSB MIA74FKG25Accident · No injuriesClosedCessna 172G · Prattsburg, GANTSB MIA72FKG42Accident · No injuriesClosedCessna 172G · Dahlonega, GANTSB MIA70DKG46Accident · Serious injuriesClosedCessna 172 · Columbus, GANTSB MIA69A0045Accident · 2 fatalClosedCessna 172 · Dalton, GANTSB MIA69F0211Accident · Serious injuriesClosedCessna 172 · Lithonia, GANTSB MIA68D0124Accident · No injuriesClosedCessna 172 · Glenville, GANTSB MIA67D0117Accident · No injuriesClosedCessna 172 · Nashville, GA