Skip to content

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

16 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

19722026

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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 SEA08CA093Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Dayton, WAThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed. A contributing factor was the sudden windshift.Mar 25, 2008 · N48629 · Substantial damage NTSB SEA01LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waitsburg, WAThe pilot's failure to maintain clearance from the power lines during a pull-up, resulting in an in-flight collision with the lines, loss of control and subsequent in-flight collision with terrain. Contributing factors were the power lines and the pilot's…Feb 28, 2001 · N48651 · Destroyed NTSB SEA99LA074Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAThe pilot-in-command's failure to maintain directional control during the takeoff roll and overloading of the right landing gear strut. Contributing factors were the soft takeoff surface, confined (narrow) takeoff surface, and high vegetation.May 27, 1999 · N9970 · Substantial damage NTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.Jun 6, 1996 · N9793 · Substantial damage NTSB SEA93LA198Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164A · Dayton, WAThe pilot in command's failure to maintain proper clearance from the power lines. The unmarked power lines were a factor.Sep 13, 1993 · N9536 · Destroyed NTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…Apr 14, 1993 · USN · 2 aircraft · Destroyed NTSB SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.Mar 30, 1993 · N8734H · Destroyed NTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.Jun 11, 1992 · N8938H · Substantial damage NTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.Jun 21, 1990 · N29SK · Destroyed NTSB SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.Jun 24, 1989 · N8974H · Substantial damage NTSB SEA89LA059Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Rosalia, WAA loss of engine power due to a supercharger failure. Contributing to the accident was the soft terrain on which the forced landing was made.Mar 25, 1989 · N8792H · Substantial damage NTSB SEA88LA135Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Colfax, WAOn departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.Jul 21, 1988 · N8974H · Substantial damage NTSB SEA85LA074Accident · No injuriesLimited investigationFinal reportGrumman 164A · Ritzville, WADuring landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver.Mar 14, 1985 · N8495 · Substantial damage NTSB SEA83LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Waitsburg, WAThe acft groundlooped into soft dirt and nosed over after a brake malfunction. The pilot stated that upon landing the left brake locked. The pilot tried to maintain directional control with rudder and power. The acft veered right into soft dirt and came rest…Jun 29, 1983 · N9536 · Substantial damage NTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…Jun 9, 1982 · N7365 · Destroyed NTSB SEA73DYG03Accident · No injuriesClosedGrumman G-164A · Touchet, WAJul 14, 1972 · N7372 · Substantial damage