# NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B, AZ

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 LAX85LA332](https://openairdocs.org/ntsb/LAX85LA332.md): Gulfstream-Schweizer Gulfstream AM G-164B · Poston, AZ · Accident · No injuries · Limited investigation · Final report · Jul 29, 1985 · N8133K · Substantial damage
  > The plt reported weather conditions during the night aerial application flt were 'clear and winds of 15 KTS with gusts to 20 KTS. After three unsuccessful attempts to line up for the spray run, the plt said he allowed the acft to 'get too low and slow' while…
- [NTSB LAX83FUJ17](https://openairdocs.org/ntsb/LAX83FUJ17.md): Gulfstream-Schweizer G-164B · Queen Creek, AZ · Accident · No injuries · Final report · Sep 22, 1983 · N8081K · Substantial damage
  > The eng lost power & the acft nosed over in a soft plowed field. The #1 cylinder articulating rod had separated.

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

This list as a web page: https://openairdocs.org/ntsb?model=3979904&state=AZ

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