Skip to content

NTSB investigations: Grumman G-164A, GA

22 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

19712026

Where

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.Jun 29, 2024 · N7849 · Substantial damage NTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.Jul 12, 2008 · N7395 · Substantial damage NTSB MIA97LA198Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Bainbridge, GAthe pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…Jun 27, 1997 · N903X · Substantial damage NTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.Sep 14, 1990 · N7905 · Destroyed NTSB ATL87DKG07Accident · Serious injuriesFinal reportGrumman G-164A · Alamo, GAThe acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.…Sep 15, 1987 · N6590 · Destroyed NTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…Aug 15, 1983 · N7904 · Destroyed NTSB ATL82DA221Accident · No injuriesFinal reportGrumman G-164 · Donalsonville, GAWhile en route back to the airport, the engine lost power and the pilot landed in a rain soaked, soybean field. During the landing roll, the wheels bogged down in soft earth and the plane nosed over. According to the pilot, there was 10 to 12 gallons of fuel…Jul 29, 1982 · N10286 · Substantial damage NTSB MIA78DLA47Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 21, 1978 · N5186 · Destroyed NTSB MIA78FKG41Accident · No injuriesClosedGrumman G-164A · Albany, GAMay 5, 1978 · N5360 · Substantial damage NTSB MIA77FKG35Accident · Minor injuriesClosedGrumman G-164A · Camilla, GAJun 16, 1977 · N953X · Substantial damage NTSB MIA76FKG88Accident · No injuriesClosedGrumman G-164A · Hatley, GAJul 15, 1976 · N7904 · Substantial damage NTSB MIA76FKG79Accident · Serious injuriesClosedGrumman G-164A · Edison, GAJun 24, 1976 · N6657 · Destroyed NTSB MIA76DKG78Accident · No injuriesClosedGrumman G-164A · Adel, GAJun 11, 1976 · N746Y · Substantial damage NTSB MIA75FKG63Accident · No injuriesClosedGrumman G-164 · Smithville, GAMar 29, 1975 · N936X · Destroyed NTSB MIA75FKG17Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 20, 1974 · N7996 · Destroyed NTSB MIA75DKG14Accident · No injuriesClosedGrumman G-164A · Edison, GAAug 2, 1974 · N6659 · Substantial damage NTSB MIA74FKG33Accident · No injuriesClosedGrumman G-164A · Quitman, GASep 27, 1973 · N7833 · Substantial damage NTSB MIA74DKG13Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 16, 1973 · N7996 · Substantial damage NTSB MIA73FKG84Accident · No injuriesClosedGrumman G-164A · Blakely, GAJun 22, 1973 · N6588 · Substantial damage NTSB MIA73DKG46Accident · No injuriesClosedGrumman G-164A · Quitman, GAOct 14, 1972 · N7833 · Substantial damage NTSB MIA73DKG14Accident · No injuriesClosedGrumman G-164A · Sardis, GAJul 24, 1972 · N6571 · Substantial damage NTSB MIA72DKG20Accident · No injuriesClosedGrumman G-164A · Vada, GAAug 11, 1971 · N905X · Destroyed