NTSB investigations: Grumman G-164A, NY

8 cases on aircraft the registry lists as Grumman 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

19692026

NTSB investigations: Grumman G-164A, NY per year, 1969–2026: 8 cases
1969	1
1977	2
1978	2
1983	1
2007	1
2011	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."eventStateOrRegion" = 'NY' 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 ('3952704')) 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.\"eventStateOrRegion\" = 'NY' 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 ('3952704'))
  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."eventStateOrRegion" = 'NY' 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 ('3952704'))
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 ERA11LA290Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Albion, NYA bearing failure in the engine’s supercharger section, which resulted in a total loss of engine power during flight. Contributing to the accident was the soft soil of the forced landing site.Apr 29, 2011 · N896X · Substantial damage NTSB NYC07LA207Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Goshen, NYA loss of engine power during cruise flight for undetermined reasons.Sep 1, 2007 · N6578 · Substantial damage NTSB NYC83FFJ02Accident · No injuriesFinal reportGrumman G-164A · Clarkson, NYThe pilot was diverting from the arpt of departure to an alternate arpt because of the severe weather. The turbulence encountered was so severe, according to the pilot's statement, that he lost control of the acft. Partial control was regained but too late to…Apr 30, 1983 · N5309 · Substantial damage NTSB NYC78FFJ32Accident · No injuriesClosedGrumman G-164A · Huron, NYJul 31, 1978 · N6572 · Substantial damage NTSB NYC78FHM22Accident · No injuriesClosedGrumman G-164A · Warwick, NYJul 24, 1978 · N915X · Destroyed NTSB NYC77FHD25Accident · No injuriesClosedGrumman G-164A · Vineland, NYAug 7, 1977 · N910X · Substantial damage NTSB NYC77DFJ35Accident · No injuriesClosedGrumman G-164A · Wolcott, NYJul 15, 1977 · N5353 · Substantial damage NTSB NYC70F0180Accident · Minor injuriesClosedGrumman G-164A · Williamson, NYSep 23, 1969 · N910X · Substantial damage