NTSB investigations: Grumman American Avn. G-164

6 cases on aircraft the registry lists as Grumman American Avn. G-164. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19792026

NTSB investigations: Grumman American Avn. G-164 per year, 1979–2026: 6 cases
1979	1
1980	1
1981	2
1985	1
1998	1

Where

Open the map

Latest cases

Query with 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 ('3960201')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('3960201'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW98LA296Accident · No injuriesLimited investigationFinal reportGrumman G164A · Stratton, COA power loss for reasons undetermined. A factor was the muddy corn field.Jul 3, 1998 · N36RA · Substantial damage NTSB FTW85LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164A-600 · Dalhart, TXThe plt had accumulated 12 hrs experience in this model acft. He stated the acft bounced on the rough airstrip, and he applied too much brake on the next touchdown. The acft nosed over, damaging the top wing and empennage.May 30, 1985 · N36RA · Substantial damage NTSB FTW81DPG36Accident · No injuriesClosedGrumman G-164 · Hughes, ARMay 30, 1981 · N11KQ · Destroyed NTSB FTW81DPJ25Accident · Minor injuriesClosedGrumman G-164 · Burns Flat, OKMay 8, 1981 · N11KF · Substantial damage NTSB MKC80DCD31Accident · Minor injuriesClosedGrumman G-164 · Hampton, IAAug 30, 1980 · N13MZ · Substantial damage NTSB MKC79DCD36Accident · No injuriesClosedGrumman G-164 · Masonville, IAAug 29, 1979 · N13MZ · Destroyed