# NTSB investigations: Cessna 172G, 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 MIA98LA036](https://openairdocs.org/ntsb/MIA98LA036.md): Cessna 172G · Hazel Green, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1997 · N3908L · Substantial damage
  > the pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL93FA025](https://openairdocs.org/ntsb/ATL93FA025.md): Cessna 172 · Brownsboro, AL · Accident · 3 fatal · Field investigation · Final report · Nov 20, 1992 · N5952R · Substantial damage
  > The pilot failed to evaluate the wind conditions and took off with a tailwind which resulted in the collision with a tree on the departure end of the runway. Factors were dark night and tailwind.
- [NTSB ATL90LA083](https://openairdocs.org/ntsb/ATL90LA083.md): Cessna 172G · Gulf Shores, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1990 · N4373L · Substantial damage
  > Failure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.
- [NTSB ATL87LA058](https://openairdocs.org/ntsb/ATL87LA058.md): Cessna 172G · Tuskegee, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1987 · N3971L · Substantial damage
  > During a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…
- [NTSB MIA69D0364](https://openairdocs.org/ntsb/MIA69D0364.md): Cessna 172 · Auburn, AL · Accident · No injuries · Closed · Feb 5, 1969 · N1143F · Substantial damage
- [NTSB MIA68F0538](https://openairdocs.org/ntsb/MIA68F0538.md): Cessna 172 · Thomaston, AL · Accident · Serious injuries · Closed · May 19, 1968 · N5810R · Destroyed
- [NTSB MIA68D0520](https://openairdocs.org/ntsb/MIA68D0520.md): Cessna 172 · Gordo, AL · Accident · No injuries · Closed · May 8, 1968 · N5811R · Substantial damage
- [NTSB MIA67D0281](https://openairdocs.org/ntsb/MIA67D0281.md): Cessna 172 · Hazel Green, AL · Accident · No injuries · Closed · Sep 1, 1966 · N5748R · Substantial damage
- [NTSB MIA67D0093](https://openairdocs.org/ntsb/MIA67D0093.md): Cessna 172 · Birmingham, AL · Accident · No injuries · Closed · Jul 28, 1966 · N3823L · Substantial damage

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

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