NTSB investigations: Grumman G-164, KS

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

19652026

NTSB investigations: Grumman G-164, KS per year, 1965–2026: 7 cases
1965	1
1969	1
1973	1
1974	1
1997	2
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."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

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\" = '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"

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" = '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

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 CHI98LA264Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Hoxie, KSthe total failure of the engine's left magneto.Jul 21, 1998 · N698Y · Substantial damage NTSB CHI97LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Satanta, KSThe pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.Jul 2, 1997 · N10397 · Substantial damage NTSB CHI97LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Council Grove, KSthe 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.Jun 14, 1997 · N663B · Destroyed NTSB MKC75FCQ13Accident · Minor injuriesClosedGrumman G-164 · Valley Ctr, KSAug 29, 1974 · N10283 · Substantial damage NTSB MKC73DCQ26Accident · No injuriesClosedGrumman G-164 · Attica, KSMar 21, 1973 · N646Y · Substantial damage NTSB MKC70D0155Accident · No injuriesClosedGrumman G-164 · Johnson, KSAug 29, 1969 · N518Y · Substantial damage NTSB MKC66F0024Accident · No injuriesClosedGrumman G-164 · Manhattan, KSJun 3, 1965 · N692Y · Substantial damage