NTSB investigations: Grumman G-164A, 1983
9 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.
Cases per year
| 1966 | 2 |
|---|---|
| 1967 | 3 |
| 1968 | 4 |
| 1969 | 21 |
| 1970 | 12 |
| 1971 | 17 |
| 1972 | 21 |
| 1973 | 25 |
| 1974 | 26 |
| 1975 | 34 |
| 1976 | 30 |
| 1977 | 23 |
| 1978 | 20 |
| 1979 | 21 |
| 1980 | 8 |
| 1981 | 10 |
| 1982 | 9 |
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 6 |
| 1986 | 9 |
| 1987 | 7 |
| 1988 | 7 |
| 1989 | 4 |
| 1990 | 13 |
| 1991 | 7 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 4 |
| 2009 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2018 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983
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" DESCRun 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 ATL83LA348Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clinton, KYThe plt reported that he was spraying a field that was bordered by obstacles. When he was about half way thru a procedure turn, the eng began 'backfiring & losing power.' The plt moved the throttle to about the 1/2 power setting, hoping the condition would be…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.…NTSB ATL83LA260Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Hazlehurst, MSThe acft collided with a tree and the ground shortly after takeoff with a heavy load on a hot day. The acft had 1600 lbsof dry fertilizer, 42 gallons of fuel for takeoff. The plt stated he got into 'downdrafts' in the rolling hills and he jettisoned the load…NTSB FTW83LA298Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Grubbs, ARThe agricultural acft nosed over during landing. The plt said he was attemping to steer the acft around standing puddlesof water on a wet private airstrip when directional control was lost and the acft nosed over in a ditch.NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB FTW83LA275Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Newport, ARAccording to the plt, after he took off, he was unable to maintain alt & began dumping his load of 1500 lbs of chemicals. He turned back toward the airstrip, but was forced to land short of a bean field. After touchdown, the acft rolled into a small drainage…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…NTSB ATL83LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Adams, TNThe acft nosed over during a forced landing after a power loss. The plt stated he made two swath runs when the acft lost power. Unable to maintain altitude, he dumped the load and prepared for a landing. The landing field was newlyplowed, wet and the acft dug…NTSB FTW83LA107Accident · No injuriesLimited investigationFinal reportGrumman G164A-450 · Clyde, TXThe acft collided with a powerline and crashed during a forced landing after a engine failure. The pilot reported that he was pulling out from a swath run when the engine cut out,backfired and started running again. The pilot decided to return to elmdale, on…