# NTSB investigations: Grumman G-164, KS

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 CHI98LA264](https://openairdocs.org/ntsb/CHI98LA264.md): Grumman G-164 · Hoxie, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1998 · N698Y · Substantial damage
  > the total failure of the engine's left magneto.
- [NTSB CHI97LA193](https://openairdocs.org/ntsb/CHI97LA193.md): Grumman G-164 · Satanta, KS · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N10397 · Substantial damage
  > The pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.
- [NTSB CHI97LA167](https://openairdocs.org/ntsb/CHI97LA167.md): Grumman G-164 · Council Grove, KS · Accident · No injuries · Limited investigation · Final report · Jun 14, 1997 · N663B · Destroyed
  > the pilot's selection of an unsuitable area for landing and the fence post. Factors relating to this accident were the pilot's inability to see the fence post due to the high vegetation, and the soft dirt.
- [NTSB MKC75FCQ13](https://openairdocs.org/ntsb/MKC75FCQ13.md): Grumman G-164 · Valley Ctr, KS · Accident · Minor injuries · Closed · Aug 29, 1974 · N10283 · Substantial damage
- [NTSB MKC73DCQ26](https://openairdocs.org/ntsb/MKC73DCQ26.md): Grumman G-164 · Attica, KS · Accident · No injuries · Closed · Mar 21, 1973 · N646Y · Substantial damage
- [NTSB MKC70D0155](https://openairdocs.org/ntsb/MKC70D0155.md): Grumman G-164 · Johnson, KS · Accident · No injuries · Closed · Aug 29, 1969 · N518Y · Substantial damage
- [NTSB MKC66F0024](https://openairdocs.org/ntsb/MKC66F0024.md): Grumman G-164 · Manhattan, KS · Accident · No injuries · Closed · Jun 3, 1965 · N692Y · Substantial damage

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

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

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