NTSB investigations: Grumman G-164, 1982
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.
Cases per year
| 1964 | 27 |
|---|---|
| 1965 | 24 |
| 1966 | 20 |
| 1967 | 28 |
| 1968 | 24 |
| 1969 | 27 |
| 1970 | 18 |
| 1971 | 22 |
| 1972 | 17 |
| 1973 | 28 |
| 1974 | 20 |
| 1975 | 16 |
| 1976 | 20 |
| 1977 | 17 |
| 1978 | 9 |
| 1979 | 11 |
| 1980 | 9 |
| 1981 | 11 |
| 1982 | 7 |
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 4 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2008 | 3 |
| 2010 | 2 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 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\") = 1982
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 year(c."eventDate") = 1982
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" 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 ATL82DA280Accident · No injuriesFinal reportGrumman G-164 · Greenville, KYAccording to the caretaker of muhlenburg airport, N143W was having carburetor problems when it arrived to refuel prior to the accident flight. The caretaker stated that the pilot left the engine running while he refueled because the pilot said it wouldn't…NTSB LAX82DVG26Accident · No injuriesFinal reportGrumman G-164 · Williams, CAThe pilot was applying a granular herbicide to a rice field with low voltage wires on the west border and high voltage lines located diagonally across the field. During a pass from west to east, he crossed over the low voltage wires and lowered the nose to…NTSB DEN82DTK05Accident · No injuriesFinal reportGrumman G-164 · Murdo, SDDuring a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.NTSB LAX82DVG25Accident · Serious injuriesFinal reportGrumman G-164 · Richvale, CADuring a procedure turn of the swath run the pilot stated he was low and slow and collided with powerlines. The aircraft crashed and burned.NTSB LAX82DA187Accident · No injuriesFinal reportGrumman G-164A · Pleasant Grove, CAAs the aircraft slowed during the landing roll, it began to drift right when the rudder became ineffective. The pilot was unable to obtain left braking action to maintain directional control. Subsequently, the right main gear struck a small earth bank and the…NTSB LAX82DA181Accident · Minor injuriesFinal reportGrumman G-164 · 10 West Of Bigg, CADuring takeoff, the engine began to vibrate and lose power. While landing in the only available area, one of the main gear dug into a soft spot and the aircraft flipped over. An investigation revealed that the no. 4 cylinder had become cracked from the front…NTSB LAX82DA127Accident · No injuriesFinal reportGrumman G-164 · Bakersfield, CAOn takeoff roll the right main tire blew causing the aircraft to veer to the right, leave the runway, and nose over in the soft mud.