# NTSB investigations, AL: On ground/water encounter with terrain/water

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 ATL03LA096](https://openairdocs.org/ntsb/ATL03LA096.md): Cessna 150G · Morris, AL · Accident · No injuries · Limited investigation · Final report · May 13, 2003 · N2970S · Substantial damage
  > The pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.
- [NTSB MIA97LA236](https://openairdocs.org/ntsb/MIA97LA236.md): Cessna 182Q · Butler, AL · Accident · No injuries · Limited investigation · Final report · Aug 18, 1997 · N86TC · Substantial damage
  > The failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.
- [NTSB MIA96TA221](https://openairdocs.org/ntsb/MIA96TA221.md): Bell OH-58A · Wetumpka, AL · Accident · No injuries · Final report · Sep 3, 1996 · N160SA · Substantial damage
  > The student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.
- [NTSB ATL95LA126](https://openairdocs.org/ntsb/ATL95LA126.md): Cessna A188B · Decatur, AL · Accident · No injuries · Limited investigation · Final report · Jul 3, 1995 · N6296G · Substantial damage
  > The pilot's selection of unsuitable terrain for a precautionary landing. Which resulted in the collapse of the main landing gear. The undetermined aircraft problem and rough/uneven terrain were related factors.
- [NTSB ATL94LA172](https://openairdocs.org/ntsb/ATL94LA172.md): Bell 47D1 Wasp · Hazel Green, AL · Accident · No injuries · Limited investigation · Final report · Sep 13, 1994 · N908B · Substantial damage
  > Undetermined.
- [NTSB ATL92LA006](https://openairdocs.org/ntsb/ATL92LA006.md): Grumman G164 · Bay Minette, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 1991 · N590Y · Substantial damage
  > The rough/uneven runway condition caused by the sink hole.
- [NTSB ATL92LA005](https://openairdocs.org/ntsb/ATL92LA005.md): Cessna 182 · Pinson, AL · Accident · No injuries · Limited investigation · Final report · Oct 13, 1991 · N9342X · Substantial damage
  > The failure of the pilot to visually detect and attain proper alignment with the runway.
- [NTSB ATL86LA134](https://openairdocs.org/ntsb/ATL86LA134.md): Piper PA-38 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N25737 · Substantial damage
  > During the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the…
- [NTSB ATL85LA192](https://openairdocs.org/ntsb/ATL85LA192.md): Grumman G-164 · Ashford, AL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1985 · N609U · Substantial damage
  > The plt was returning to the private ag strip after completing a spray run. During the landing the pilot found that the left brake was inop. In order to prevent running off end of the 1500 ft rwy, the plt elected to ground loop the aircraft. During the…
- [NTSB ATL85LA164](https://openairdocs.org/ntsb/ATL85LA164.md): Cessna 177B · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · May 16, 1985 · N34494 · Substantial damage
  > The acft drifted right of rwy center line during landing roll & the plt aborted the landing by applying full pwr. The acft continued off the rwy and the nose wheel dug into the soft soil resulting in the acft nosing over.
- [NTSB ATL82DKJ09](https://openairdocs.org/ntsb/ATL82DKJ09.md): Cessna 310L · Auburn, AL · Accident · No injuries · Final report · Jan 11, 1982 · N424VW · Substantial damage
  > The pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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