# NTSB investigations: Cessna 172RG, AL

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 ERA13CA028](https://openairdocs.org/ntsb/ERA13CA028.md): Cessna 172RG · Mobile, AL · Accident · No injuries · Data collection · Final report · Oct 11, 2012 · N4939V · Substantial damage
  > The pilot’s failure to perform the before landing checklist and extend the landing gear before touchdown. Contributing to the accident was the designated pilot examiner’s inadequate remedial action.
- [NTSB ATL04CA186](https://openairdocs.org/ntsb/ATL04CA186.md): Cessna 172RG · Montgomery, AL · Accident · No injuries · Data collection · Final report · Sep 15, 2004 · N948SM · Substantial damage
  > The separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.
- [NTSB ATL96LA063](https://openairdocs.org/ntsb/ATL96LA063.md): Cessna 172RG · Gulf Shores, AL · Accident · No injuries · Limited investigation · Final report · Mar 10, 1996 · N6612V · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.
- [NTSB ATL90LA172](https://openairdocs.org/ntsb/ATL90LA172.md): Cessna 172RG · Ozark, AL · Accident · No injuries · Limited investigation · Final report · Sep 17, 1990 · N6411V · Substantial damage
  > Inadequate engine overhaul procedures which allowed the installation of the engine plug without safety wire to hold it in place, and which resulted in oil starvation of the engine.
- [NTSB ATL87LA145](https://openairdocs.org/ntsb/ATL87LA145.md): Cessna 172RG · Ozark, AL · Accident · Minor injuries · Limited investigation · Final report · May 22, 1987 · N6363R · Substantial damage
  > The inst plt indicated that during airwork procedures practice in the LCL area, the right wing seemed to be heavy. He indicated that he switched the fuel selector from both to right tank. After about 20-30 minutes, they returned to the airport and entered…

## 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" = 'AL' 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=AL

---
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.