# NTSB investigations: Grumman G-164A: In flight collision 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 MIA97LA198](https://openairdocs.org/ntsb/MIA97LA198.md): Grumman G-164B · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1997 · N903X · Substantial damage
  > the pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…
- [NTSB SEA97LA099](https://openairdocs.org/ntsb/SEA97LA099.md): Grumman G-164A · Rosalia, WA · Accident · 1 fatal · Limited investigation · Final report · May 6, 1997 · N7926 · Destroyed
  > The pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.
- [NTSB FTW95LA253](https://openairdocs.org/ntsb/FTW95LA253.md): Grumman G-164A · Bigelow, AR · Accident · No injuries · Limited investigation · Final report · Jun 20, 1995 · N7937 · Substantial damage
  > The pilot's failure to maintain clearance with terrain.
- [NTSB FTW93LA156](https://openairdocs.org/ntsb/FTW93LA156.md): Grumman G-164A · Trumann, AR · Accident · No injuries · Limited investigation · Final report · May 15, 1993 · N6556 · Substantial damage
  > Pilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.
- [NTSB FTW90DRA09](https://openairdocs.org/ntsb/FTW90DRA09.md): Grumman G-164A · Altair, TX · Accident · No injuries · Final report · Sep 14, 1990 · N6566 · Destroyed
  > The pilot's use of improper terrain for takeoff.
- [NTSB FTW90DRD14](https://openairdocs.org/ntsb/FTW90DRD14.md): Grumman G-164A · Sommerset, LA · Accident · 1 fatal · Final report · Jul 25, 1990 · N7854 · Destroyed
  > The pilot's failure to attain adequate clearance above crops at the end of the runway.
- [NTSB FTW86LRD22](https://openairdocs.org/ntsb/FTW86LRD22.md): Grumman G-164A · Franklin, LA · Accident · No injuries · Final report · Jul 22, 1986 · N920X · Substantial damage
  > During aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.
- [NTSB DEN84LA253](https://openairdocs.org/ntsb/DEN84LA253.md): Grumman G-164A · Arthur, ND · Accident · No injuries · Limited investigation · Final report · Aug 17, 1984 · N5332 · Substantial damage
  > Acft flown at high gross weight in high density altitude conditions. The plt said takeoff pwr was added too late to stopthe descent at the start of a spray run.
- [NTSB MKC84LA154](https://openairdocs.org/ntsb/MKC84LA154.md): Grumman G-164A · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · May 30, 1984 · N937X · Substantial damage
  > While the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952704')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3952704&occurrence=230

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