# NTSB investigations: Cessna 172M, 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 ERA24LA114](https://openairdocs.org/ntsb/ERA24LA114.md): Cessna 172M · Brookwood, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Feb 16, 2024 · N9160H · Substantial damage
  > The pilot’s failure to see and avoid powerlines while maneuvering at low altitude.
- [NTSB ATL02LA154](https://openairdocs.org/ntsb/ATL02LA154.md): Cessna 172M · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Aug 9, 2002 · N73461 · Substantial damage
  > The pilot's delayed flare on landing that resulted in a hard landing.
- [NTSB ATL99LA090](https://openairdocs.org/ntsb/ATL99LA090.md): Cessna 172M · Double Springs, AL · Accident · No injuries · Limited investigation · Final report · May 16, 1999 · N20417 · Substantial damage
  > The pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.
- [NTSB ATL93FA136](https://openairdocs.org/ntsb/ATL93FA136.md): Cessna 172M · Harvest, AL · Accident · Serious injuries · Field investigation · Final report · Jul 28, 1993 · N13738 · Substantial damage
  > The pilot's poorly planned approach and the failure of the pilot to execute a go-around.
- [NTSB ATL93LA100](https://openairdocs.org/ntsb/ATL93LA100.md): Cessna 172 · Tuskegee, AL · Accident · No injuries · Limited investigation · Final report · Jun 2, 1993 · N64206 · Substantial damage
  > The pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.
- [NTSB ATL88LA201](https://openairdocs.org/ntsb/ATL88LA201.md): Cessna 172M · Meridianville, AL · Accident · No injuries · Limited investigation · Final report · Jun 26, 1988 · N5075R · Substantial damage
  > The plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…
- [NTSB ATL86LA045](https://openairdocs.org/ntsb/ATL86LA045.md): Cessna C-172M · Andalusia, AL · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N509R · Substantial damage
  > The acft battery power was depleted. The plt hand propped the engine with his wife at the controls. The engine started with the throttle advanced and acft taxied into trees and over an embankment. The wife was not a rated pilot.
- [NTSB ATL82FA153](https://openairdocs.org/ntsb/ATL82FA153.md): Cessna 172M · Alabaster, AL · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1982 · N5443H · Destroyed
  > At 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…
- [NTSB ATL82FKJ04](https://openairdocs.org/ntsb/ATL82FKJ04.md): Cessna 172M · Selma, AL · Accident · No injuries · Closed · Nov 8, 1981 · N82DJ · Destroyed
- [NTSB ATL81DKJ17](https://openairdocs.org/ntsb/ATL81DKJ17.md): Cessna 172 · Maysville, AL · Accident · Minor injuries · Closed · Apr 9, 1981 · N12667 · Destroyed
- [NTSB MIA80DKJ30](https://openairdocs.org/ntsb/MIA80DKJ30.md): Cessna 172 · Clayton, AL · Accident · No injuries · Closed · Apr 22, 1980 · N6624H · Substantial damage
- [NTSB MIA78FKJ75](https://openairdocs.org/ntsb/MIA78FKJ75.md): Cessna 172 · Orrville, AL · Accident · No injuries · Closed · Aug 16, 1978 · N1479V · Substantial damage
- [NTSB MIA78FKJ81](https://openairdocs.org/ntsb/MIA78FKJ81.md): Cessna 172 · Grove Hill, AL · Accident · No injuries · Closed · Sep 3, 1977 · N64260 · Minor damage
- [NTSB MIA76DKJ04](https://openairdocs.org/ntsb/MIA76DKJ04.md): Cessna 172 · Elmore, AL · Accident · No injuries · Closed · Jun 14, 1975 · N12527 · Substantial damage
- [NTSB MIA74DKJ07](https://openairdocs.org/ntsb/MIA74DKJ07.md): Cessna 172 · Andalusa, AL · Accident · No injuries · Closed · Jul 28, 1973 · N20234 · 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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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