# NTSB investigations: Cessna 172H, 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 ERA17LA075](https://openairdocs.org/ntsb/ERA17LA075.md): Cessna 172 · Bridgeport, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2016 · N3772F · Substantial damage
  > The pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.
- [NTSB ATL00LA060](https://openairdocs.org/ntsb/ATL00LA060.md): Cessna 172H · Foley, AL · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2000 · N2849L · Substantial damage
  > The pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.
- [NTSB MIA99LA144](https://openairdocs.org/ntsb/MIA99LA144.md): Cessna 172H · Sylvan Springs, AL · Accident · No injuries · Limited investigation · Final report · May 1, 1999 · N5105G · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB ATL92LA134](https://openairdocs.org/ntsb/ATL92LA134.md): Cessna 172H · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1992 · N8198L · Substantial damage
  > The pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.
- [NTSB ATL85LA108](https://openairdocs.org/ntsb/ATL85LA108.md): Cessna 172H · Bessemer, AL · Accident · No injuries · Limited investigation · Final report · Mar 6, 1985 · N5105G · Substantial damage
  > The plt was taxiing to the rwy on a narrow taxiway when the left wing struck a t hangar support post.
- [NTSB ATL83LA027](https://openairdocs.org/ntsb/ATL83LA027.md): Cessna 172H · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1982 · N2633L · Substantial damage
  > Pilot made a hard off airport landing after loss of power. He had used a prolonged slip to lose altitude and the engine stopped. Then he could not reach the runway. The fuel selector was found on left tank. Left tank had less than two gallons of fuel.
- [NTSB MIA73DKJ65](https://openairdocs.org/ntsb/MIA73DKJ65.md): Cessna 172H · Birmingham, AL · Accident · No injuries · Closed · Jun 3, 1973 · N3824R · Substantial damage
- [NTSB MIA71FKJ49](https://openairdocs.org/ntsb/MIA71FKJ49.md): Cessna 172H · Camden, AL · Accident · Minor injuries · Closed · Apr 21, 1971 · N2660L · Substantial damage
- [NTSB MIA69F0442](https://openairdocs.org/ntsb/MIA69F0442.md): Cessna 172 · Opelika, AL · Accident · No injuries · Closed · Apr 21, 1969 · N1429F · 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 ('2072424'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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