NTSB investigations: Grumman American Avn. G-164A

7 cases on aircraft the registry lists as Grumman American Avn. G-164A. 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

19732026

NTSB investigations: Grumman American Avn. G-164A per year, 1973–2026: 7 cases
1973	1
1975	1
1980	1
1981	1
1985	1
2007	1
2015	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 ('3960202')) 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 ('3960202'))
  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 ('3960202'))
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 GAA15CA250Accident · No injuriesData collectionFinal reportGrumman American Avn. G 164A · Welsh, LAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.Aug 28, 2015 · N8761H · Substantial damage NTSB ATL07LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Pittsgrove, NJA partial loss of engine power due to low compression for undetermined reasons.Sep 29, 2007 · N8761H · Substantial damage NTSB CHI85FA226Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Red Lake Falls, MNThe plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a…Jun 8, 1985 · N6761Q · Destroyed NTSB ATL81DKQ12Accident · No injuriesClosedGrumman G-164A · Holly Bluff, MSJun 4, 1981 · N6715Q · Destroyed NTSB FTW80DPG40Accident · No injuriesClosedGrumman G-164A · Cash, ARJul 2, 1980 · N6761Q · Substantial damage NTSB FTW76FRA08Accident · Serious injuriesClosedGrumman G-164A · East Bernard, TXAug 15, 1975 · N7805 · Destroyed NTSB FTW73FRG93Accident · 1 fatalClosedGrumman G-164A · Laferia, TXJun 28, 1973 · N7805 · Destroyed