# NTSB investigations: Schweizer G-164B: 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 FTW92LA119](https://openairdocs.org/ntsb/FTW92LA119.md): Schweizer G-164B · Brinkley, AR · Accident · No injuries · Limited investigation · Final report · Apr 23, 1992 · N3626N · Substantial damage
  > The pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.
- [NTSB LAX91LA362](https://openairdocs.org/ntsb/LAX91LA362.md): Schweizer G164B · Verona, CA · Accident · No injuries · Limited investigation · Final report · Aug 19, 1991 · N7501K · Substantial damage
  > The pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.
- [NTSB MKC90LA076](https://openairdocs.org/ntsb/MKC90LA076.md): Grumman G-164B · Newport, AR · Accident · No injuries · Limited investigation · Final report · Mar 28, 1990 · N3630U · Substantial damage
  > Failure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.
- [NTSB FTW89DRG04](https://openairdocs.org/ntsb/FTW89DRG04.md): Schweizer G-164B · Austwell, TX · Accident · No injuries · Final report · Aug 2, 1989 · N7501Q · Substantial damage
  > Pilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.
- [NTSB LAX88DVG09](https://openairdocs.org/ntsb/LAX88DVG09.md): Schweizer G-164B · Robbins, CA · Accident · No injuries · Final report · Jul 30, 1988 · N3633C · Substantial damage
  > During landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident.

## 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 ('8059055')
    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" = 320))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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