Skip to content

NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, ID

25 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer 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

19732026

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" = 'ID' 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 ('3952801')) 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\" = 'ID' 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 ('3952801'))
  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" = 'ID' 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 ('3952801'))
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 WPR16LA082Accident · No injuriesLimited investigationFinal reportGrumman G164 · Juliaetta, IDA partial loss of engine power due to a crack in the No. 2 cylinder.Mar 12, 2016 · N6894Q · Substantial damage NTSB WPR11LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hazelton, IDA total loss of engine power during low-level maneuvering due to an excessively worn carburetor.May 28, 2011 · N9724 · Substantial damage NTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.Aug 18, 2008 · N6702Q · Substantial damage NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.Jul 19, 2005 · N6702Q · Substantial damage NTSB SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…Apr 5, 2004 · N48564 · Substantial damage NTSB SEA99LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · New Plymouth, IDLoss of engine power due to failure of the supercharger impeller. A contributing factor was the ditch.Jul 7, 1999 · N7869 · Substantial damage NTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…Jul 27, 1996 · N5390 · Substantial damage NTSB SEA96LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164A · New Plymouth, IDa cracked cylinder head, which resulted in partial loss of engine power during takeoff. Factors relating to the accident were: the pilot allowed the gross weight of the airplane to be exceeded, and tall wheat (crop) in the emergency landing area.Jul 15, 1996 · N48442 · Substantial damage NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.Jul 29, 1995 · N48471 · Substantial damage NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.Jul 8, 1995 · N8946H · Substantial damage NTSB SEA92LA142Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Paul, IDLoss of engine power for undetermined reasons and aircraft control not possible by the pilot in command. A factor contributing to the accident was: rough/uneven terrain.Jul 1, 1992 · N5386 · Destroyed NTSB SEA91LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Genesee, IDThe pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.Jul 28, 1991 · N48599 · Destroyed NTSB SEA91LA191Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hamer, IDThe pilot's failure to maintain runway aligment. Factors include high vegetation, and an inadverent ground loop/swerve.Jul 24, 1991 · N6702Q · Substantial damage NTSB SEA91LA105Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Lapwai, IDThe pilot's misjudgment of an aerial application swath run. Factors include a downdraft condition and soft terrain.May 14, 1991 · N8792H · Destroyed NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.Jul 19, 1989 · N8377 · Substantial damage NTSB SEA85LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt had finished spraying a field & was returning to the ag strip when the eng failed. He made an emerg landing in a barley field which was muddy & soft. During the landing roll, the wheels sank in the terrain & the acft nosed over. An exam revealed that…Jun 9, 1985 · N7997 · Substantial damage NTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…May 17, 1984 · N48373 · Substantial damage NTSB SEA82DA127Accident · No injuriesFinal reportGrumman G-164A · Burley, IDAt about 20 ft AGL after takeoff the eng quit. The cause of the eng failure could not be determined.Jul 24, 1982 · N9532 · Destroyed NTSB SEA78DYA24Accident · Minor injuriesClosedGrumman G-164A · Oakley, IDSep 1, 1978 · N7365 · Substantial damage NTSB SEA78DYA12Accident · No injuriesClosedGrumman G-164A · Terreton, IDJun 19, 1978 · N8712H · Substantial damage NTSB SEA76DYA25Accident · No injuriesClosedGrumman G-164A · Hamer, IDJun 5, 1976 · N7863 · Substantial damage NTSB SEA76DYG43Accident · No injuriesClosedGrumman G-164A · Genesee, IDApr 13, 1976 · N7372 · Substantial damage NTSB SEA76DYG42Accident · No injuriesClosedGrumman G-164A · Nezperce, IDApr 9, 1976 · N29SK · Substantial damage NTSB SEA75DYA04Accident · No injuriesClosedGrumman G-164A · Burley, IDJul 14, 1974 · N7365 · Substantial damage NTSB SEA74DYA11Accident · No injuriesClosedGrumman G-164A · Idaho Falls, IDSep 10, 1973 · N7369 · Destroyed