# NTSB investigations: Cessna 172, 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 ATL01LA101](https://openairdocs.org/ntsb/ATL01LA101.md): Cessna 172 · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Aug 2, 2001 · N7006A · Substantial damage
  > The pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.
- [NTSB ATL01LA018](https://openairdocs.org/ntsb/ATL01LA018.md): Cessna 172 · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Nov 30, 2000 · N8507B · Substantial damage
  > The pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.
- [NTSB ATL99LA059](https://openairdocs.org/ntsb/ATL99LA059.md): Cessna 172 · Florala, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1999 · N8968B · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.
- [NTSB ATL99LA041](https://openairdocs.org/ntsb/ATL99LA041.md): Cessna 172 · Centre, AL · Accident · No injuries · Limited investigation · Final report · Jan 12, 1999 · N6700A · Substantial damage
  > The pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.
- [NTSB ATL93LA112](https://openairdocs.org/ntsb/ATL93LA112.md): Cessna 172 · St. Elmo, AL · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1993 · N8322B · Substantial damage
  > The pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.
- [NTSB ATL89LA168](https://openairdocs.org/ntsb/ATL89LA168.md): Cessna 172 · Centreville, AL · Accident · No injuries · Limited investigation · Final report · Jun 23, 1989 · N70RS · Substantial damage
  > The student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.
- [NTSB ATL85FA060](https://openairdocs.org/ntsb/ATL85FA060.md): Cessna 172 · Hamilton, AL · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N4093F · Destroyed
  > Initiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…
- [NTSB ATL81FKJ34](https://openairdocs.org/ntsb/ATL81FKJ34.md): Cessna 172 · Bay Minette, AL · Accident · No injuries · Closed · Aug 31, 1981 · N7006A · Substantial damage
- [NTSB MIA78DKJ50](https://openairdocs.org/ntsb/MIA78DKJ50.md): Cessna 172 · Huntsville, AL · Accident · Minor injuries · Closed · Jun 12, 1978 · N6136E · Substantial damage
- [NTSB MIA77FKJ88](https://openairdocs.org/ntsb/MIA77FKJ88.md): Cessna 172 · Weaver, AL · Accident · Serious injuries · Closed · Aug 31, 1977 · N8302B · Substantial damage
- [NTSB MIA75FKJ42](https://openairdocs.org/ntsb/MIA75FKJ42.md): Cessna 172 · Columbia, AL · Accident · No injuries · Closed · Feb 8, 1975 · N6238E · Substantial damage
- [NTSB MIA70D0164](https://openairdocs.org/ntsb/MIA70D0164.md): Cessna 172 · Gadsden, AL · Accident · No injuries · Closed · Sep 29, 1969 · N8302B · Substantial damage
- [NTSB MIA69F0327](https://openairdocs.org/ntsb/MIA69F0327-191632.md): Cessna 172 · Enterprise, AL · Accident · No injuries · Closed · Jan 26, 1969 · N8822B · Substantial damage
- [NTSB MIA69F0193](https://openairdocs.org/ntsb/MIA69F0193.md): Cessna 172 · Clopton, AL · Accident · No injuries · Closed · Sep 27, 1968 · N8822B · Substantial damage
- [NTSB MIA67D0535](https://openairdocs.org/ntsb/MIA67D0535.md): Cessna 172 · Brewton, AL · Accident · No injuries · Closed · Jun 20, 1966 · N4021F · Substantial damage
- [NTSB MIA66D0359](https://openairdocs.org/ntsb/MIA66D0359.md): Cessna 172 · Aliceville, AL · Accident · No injuries · Closed · Oct 17, 1965 · N8385B · Substantial damage
- [NTSB MIA65A0105](https://openairdocs.org/ntsb/MIA65A0105.md): Cessna 172 · Evergreen, AL · Accident · 2 fatal · Closed · Apr 24, 1965 · N8004B · Destroyed
- [NTSB UNK64X2521](https://openairdocs.org/ntsb/UNK64X2521.md): Cessna 172 · Gadsen, AL · Accident · No injuries · Closed · Jun 27, 1964 · N7300A · 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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