# NTSB investigations, TN: 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 NYC08CA040](https://openairdocs.org/ntsb/NYC08CA040.md): Piper PA-28-140 · Murfreesboro, TN · Accident · No injuries · Data collection · Final report · Nov 16, 2007 · N4396T · Substantial damage
  > The flight instructor's inadequate remedial action and failure to maintain runway alignment.
- [NTSB ATL07LA016](https://openairdocs.org/ntsb/ATL07LA016.md): Boeing 717-200 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Nov 11, 2006 · N956AT · Substantial damage
  > The captain's inadequate visual look out during taxi.
- [NTSB ATL05CA059](https://openairdocs.org/ntsb/ATL05CA059.md): Ecker Starduster 1 · Millington, TN · Accident · No injuries · Data collection · Final report · Mar 6, 2005 · N74EK · Substantial damage
  > The malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.
- [NTSB ATL03LA027](https://openairdocs.org/ntsb/ATL03LA027.md): Cessna 182S · Nashville, TN · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 2002 · N416ES · Substantial damage
  > The pilot's failure to maintain visual lookout and his inattentiveness during taxi that resulted in an on ground collision with an embankment. A factor was the fog.
- [NTSB MIA02LA145](https://openairdocs.org/ntsb/MIA02LA145.md): Air Tractor AT-301 · Dyer, TN · Accident · No injuries · Limited investigation · Final report · Jun 28, 2002 · N73088 · Substantial damage
  > The failure of the pilot to maintain wingtip clearance with corn crops at the edge of the road resulting in the collision with the crops.
- [NTSB ATL00LA052](https://openairdocs.org/ntsb/ATL00LA052.md): Cessna 172M · Clinton, TN · Accident · No injuries · Limited investigation · Final report · Apr 30, 2000 · N13330 · Substantial damage
  > The pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.
- [NTSB ATL99LA137](https://openairdocs.org/ntsb/ATL99LA137.md): Gettis H. Hudson Corban Baby ACE · Pleasant View, TN · Accident · No injuries · Limited investigation · Final report · Jan 30, 1999 · N24562 · Substantial damage
  > The failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.
- [NTSB ATL97LA088](https://openairdocs.org/ntsb/ATL97LA088.md): Air Tractor AT-402B · Ridgely, TN · Accident · No injuries · Limited investigation · Final report · Jun 23, 1997 · N6128W · Substantial damage
  > The pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.
- [NTSB ATL93LA015](https://openairdocs.org/ntsb/ATL93LA015.md): Cessna 152 · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Oct 25, 1992 · N49164 · Substantial damage
  > The pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.
- [NTSB ATL91LA122](https://openairdocs.org/ntsb/ATL91LA122.md): Learjet 23 · Columbia, TN · Accident · No injuries · Limited investigation · Final report · Jul 2, 1991 · N500FM · Substantial damage
  > The pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.
- [NTSB ATL87LA108](https://openairdocs.org/ntsb/ATL87LA108.md): Piper PA-28R-180 · Lebanon, TN · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N4974J · Substantial damage
  > The plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…
- [NTSB ATL87LA099](https://openairdocs.org/ntsb/ATL87LA099.md): Grumman G-164 · Shelbyville, TN · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N654Y · Destroyed
  > The acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…
- [NTSB ATL85LA139](https://openairdocs.org/ntsb/ATL85LA139.md): Bellanca 8GCBC · Elizabethton, TN · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N86756 · Substantial damage
  > Pilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift.

## 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" = 'TN' 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=TN

---
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.
