# NTSB investigations: Cessna 172A, GA

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA22LA204](https://openairdocs.org/ntsb/ERA22LA204.md): Cessna 172A · Stockbridge, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 25, 2022 · N7572T · Substantial damage
  > The flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of control
- [NTSB ERA22LA045](https://openairdocs.org/ntsb/ERA22LA045.md): Cessna 172 · Decatur, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 4, 2021 · N172XX · Substantial damage
  > Oil exhaustion due to an oil leak that resulted in a total loss of engine power.
- [NTSB ATL90LA096](https://openairdocs.org/ntsb/ATL90LA096.md): Cessna 172A · Villa Rica, GA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1990 · N7677T · Substantial damage
  > Fuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.
- [NTSB ATL87FA235](https://openairdocs.org/ntsb/ATL87FA235.md): Cessna 172A · Camilia, GA · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1987 · N7559T · Destroyed
  > This flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…
- [NTSB ATL80DKG25](https://openairdocs.org/ntsb/ATL80DKG25.md): Cessna 172A · Athens, GA · Accident · No injuries · Closed · Sep 14, 1980 · N7584T · Substantial damage
- [NTSB MIA76AM088](https://openairdocs.org/ntsb/MIA76AM088.md): Cessna 172A · Milledgeville, GA · Accident · 1 fatal · Closed · May 27, 1976 · N7848T · Destroyed
- [NTSB MIA74AM059](https://openairdocs.org/ntsb/MIA74AM059.md): Cessna 172A · Jackson, GA · Accident · 3 fatal · Closed · Jan 18, 1974 · N7779T · Destroyed
- [NTSB MIA73FKG05](https://openairdocs.org/ntsb/MIA73FKG05.md): Cessna 172A · Rome, GA · Accident · No injuries · Closed · Jul 9, 1972 · N7782T · Substantial damage
- [NTSB MIA70FKG21](https://openairdocs.org/ntsb/MIA70FKG21.md): Cessna 172 · Atlanta, GA · Accident · No injuries · Closed · Mar 26, 1970 · N7552T · Substantial damage
- [NTSB MIA70DKG23](https://openairdocs.org/ntsb/MIA70DKG23.md): Cessna 172 · St Marys, GA · Accident · No injuries · Closed · Mar 26, 1970 · N7332T · Substantial damage
- [NTSB MIA67D0557](https://openairdocs.org/ntsb/MIA67D0557.md): Cessna 172 · Savannah, GA · Accident · No injuries · Closed · Mar 22, 1967 · N7446T · Substantial damage
- [NTSB MIA66F0381](https://openairdocs.org/ntsb/MIA66F0381.md): Cessna 172 · Baxley, GA · Accident · Serious injuries · Closed · Nov 26, 1965 · N9709T · Destroyed
- [NTSB MIA66F0314](https://openairdocs.org/ntsb/MIA66F0314.md): Cessna 172 · Ludowici, GA · Accident · No injuries · Closed · Oct 21, 1965 · N7367T · Substantial damage
- [NTSB UNK64X3524](https://openairdocs.org/ntsb/UNK64X3524.md): Cessna 172 · Macon, GA · Accident · 1 fatal · Closed · Aug 21, 1964 · N7364T · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 ('2072404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072404&state=GA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.