# NTSB investigations: Cessna 172K, 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 GAA19CA020](https://openairdocs.org/ntsb/GAA19CA020.md): Cessna 172 · Lawrenceville, GA · Accident · No injuries · Data collection · Final report · Oct 14, 2018 · N996SB · Substantial damage
  > The student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.
- [NTSB ERA13FA062](https://openairdocs.org/ntsb/ERA13FA062.md): Cessna 172K · Savannah, GA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2012 · N78304 · Substantial damage
  > The pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.
- [NTSB ERA10FA502](https://openairdocs.org/ntsb/ERA10FA502.md): Cessna 172 · Chatsworth, GA · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2010 · N84249 · Substantial damage
  > The pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…
- [NTSB ATL07CA058](https://openairdocs.org/ntsb/ATL07CA058.md): Cessna 172K · Cornelia, GA · Accident · No injuries · Data collection · Final report · Mar 22, 2007 · N46567 · Substantial damage
  > The failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.
- [NTSB MIA95LA075](https://openairdocs.org/ntsb/MIA95LA075.md): Cessna 172K · Wrightsville, GA · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 1995 · N79157 · Substantial damage
  > The pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.
- [NTSB ATL88LA033](https://openairdocs.org/ntsb/ATL88LA033.md): Cessna 172K · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1987 · N7140G · Substantial damage
  > The student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…
- [NTSB ATL86LA096](https://openairdocs.org/ntsb/ATL86LA096.md): Cessna 172K · Stone Mountain, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 15, 1986 · N7374G · Substantial damage
  > Shortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…
- [NTSB ATL83FA238](https://openairdocs.org/ntsb/ATL83FA238.md): Cessna 172K · Millhaven, GA · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1983 · N78160 · Substantial damage
  > The plt & his son took off at night to participate in the search for a downed acft. Subsequently, they found the burning wreckage of the downed plane. They saw people moving around the accident scene & made a pass over it by diving with the landing light on.…
- [NTSB MIA79FKG10](https://openairdocs.org/ntsb/MIA79FKG10.md): Cessna 172 · Chamblee, GA · Accident · No injuries · Closed · Nov 8, 1978 · N7208G · Substantial damage
- [NTSB MIA72KHD12](https://openairdocs.org/ntsb/MIA72KHD12.md): Cessna 172K · Jonesboro, GA · Accident · No injuries · Closed · Jun 9, 1972 · N46468 · Substantial damage
- [NTSB MIA72AM011](https://openairdocs.org/ntsb/MIA72AM011.md): Cessna 172K · Atlanta, GA · Accident · 1 fatal · Closed · Aug 13, 1971 · N79407 · Destroyed
- [NTSB MIA71DKG72](https://openairdocs.org/ntsb/MIA71DKG72.md): Cessna 172 · Lithonia, GA · Accident · No injuries · Closed · Apr 11, 1971 · N79566 · Substantial damage
- [NTSB MIA71FKG57](https://openairdocs.org/ntsb/MIA71FKG57.md): Cessna 172 · Statesboro, GA · Accident · Serious injuries · Closed · Jan 13, 1971 · N79570 · 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072430&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.