# NTSB investigations: Grumman G-164B

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 CEN15LA377](https://openairdocs.org/ntsb/CEN15LA377.md): Grumman G 164B · Sac City, IA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2015 · N311AL · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CHI84FA250](https://openairdocs.org/ntsb/CHI84FA250.md): Grumman G-164B · Warren, MN · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1984 · N6533K · 2 aircraft · Destroyed
  > N9367K was on departure and climbout to aerial application operations. N6533K was about to enter the traffic pattern to land and reload. Marks on respective airframes indicate N9367K was above and approaching N6533K from the latter's forward left quarter;…
- [NTSB SEA80FA029](https://openairdocs.org/ntsb/SEA80FA029.md): Grumman G-164B · Cle Elum, WA · Accident · 1 fatal · Closed · May 18, 1980 · N48432 · Destroyed
- [NTSB CHI79FEV17](https://openairdocs.org/ntsb/CHI79FEV17.md): Grumman G-164B · Sandoval, IL · Accident · No injuries · Closed · Apr 18, 1979 · N6703K · Substantial damage
- [NTSB MIA78FLG33](https://openairdocs.org/ntsb/MIA78FLG33-139304.md): Grumman G-164B · Little Rock, SC · Accident · No injuries · Closed · Aug 16, 1978 · N6764Q · Destroyed
- [NTSB SEA78DYP43](https://openairdocs.org/ntsb/SEA78DYP43.md): Grumman G-164B · Ellensburg, WA · Accident · No injuries · Closed · Jul 29, 1978 · N48432 · Substantial damage
- [NTSB OAK78FVD47](https://openairdocs.org/ntsb/OAK78FVD47.md): Grumman G-164B · Manteca, CA · Accident · 1 fatal · Closed · Jul 20, 1978 · N9256A · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=3952703

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