# NTSB investigations: Cessna 172RG, 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 GAA19CA138](https://openairdocs.org/ntsb/GAA19CA138.md): Cessna 172RG · Atlanta, GA · Accident · No injuries · Data collection · Final report · Feb 13, 2019 · N5223V · Substantial damage
  > The pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…
- [NTSB MIA08LA053](https://openairdocs.org/ntsb/MIA08LA053.md): Cessna C-172RG · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Feb 7, 2008 · N6562V · Substantial damage
  > A cracked nose gear actuator o-ring resulting in hydraulic fluid exhaustion, and collapse of the main gear.
- [NTSB ATL04IA138](https://openairdocs.org/ntsb/ATL04IA138.md): Cessna 172RG · Chamblee, GA · Incident · No injuries · Incident investigation · Final report · May 11, 2004 · N6562V · No damage
  > The fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.
- [NTSB MIA98LA165](https://openairdocs.org/ntsb/MIA98LA165.md): Cessna 172RG · Roberta, GA · Accident · No injuries · Limited investigation · Final report · May 17, 1998 · N6562V · Substantial damage
  > The pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.
- [NTSB ATL94FA156](https://openairdocs.org/ntsb/ATL94FA156.md): Cessna 172RG · Atlanta, GA · Accident · 2 fatal · Field investigation · Final report · Aug 14, 1994 · N9340D · Substantial damage
  > The pilot's inadequate preflight planning in that he operated the aircraft at a weight which exceeded the maximum takeoff weight and his improper use of flaps during takeoff.
- [NTSB ATL84FA168](https://openairdocs.org/ntsb/ATL84FA168.md): Cessna 172RG · Dallas, GA · Accident · 2 fatal · Field investigation · Final report · May 6, 1984 · N6293V · Destroyed
  > Approximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…

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

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