Skip to content

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

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

19762026

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 ('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\" = '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 ('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" = '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 ('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 MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.Aug 23, 2000 · N8919H · Substantial damage NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.Oct 12, 1997 · N4983 · Destroyed NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.Aug 7, 1996 · N8672H · Destroyed NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.Apr 18, 1996 · N4238 · Substantial damage NTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.Oct 20, 1994 · N8960H · Substantial damage NTSB ATL94GA111Accident · No injuriesFinal reportGrumman G-164A · Savannah, GAThe pilot's improper landing flare which resulted in a hard landing. A factor was the operators failure to provide a formal emergency dump procedure.Jun 2, 1994 · N9868 · Substantial damage NTSB ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.Jun 14, 1992 · N7357 · Substantial damage NTSB ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.Jul 31, 1989 · N9755 · Substantial damage NTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.Feb 10, 1989 · N9755 · Substantial damage NTSB ATL86FKG10Accident · Minor injuriesFinal reportGrumman American G-164A · Quitman, GAShortly after takeoff a loss of pwr was experienced. The plt attempted to land in a cotton field but the landing gear contacted a stump short of the field. The acft then contacted a ditch and nosed over. Post accident inspection revealed the supercharger…Aug 15, 1986 · N31185 · Substantial damage NTSB ATL83LA019Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Adel, GAFollowing maintenance performed on the aircraft the pilot conducted a check flight. After takeoff the pilot discovered fuel splashing on the windshield and proceeded to abort the takeoff. Upon landing the pilot lost control of the aircraft. The aircraft…Oct 27, 1982 · N7231 · Destroyed NTSB MIA78FKG78Accident · Minor injuriesClosedGrumman G164A · Albany, GASep 13, 1978 · N7929 · Substantial damage NTSB MIA78FKG63Accident · Minor injuriesClosedGrumman G-164A · Lumpkin, GAJul 18, 1978 · N9829 · Destroyed NTSB MIA77FKG72Accident · No injuriesClosedGrumman G-164A · Cuthbert, GASep 6, 1977 · N9829 · Substantial damage NTSB MIA77FKG50Accident · No injuriesClosedGrumman 164A · Bainbridge, GAJul 11, 1977 · N9513 · Substantial damage NTSB MIA76FKG63Accident · No injuriesClosedGrumman G-164A · Sasser, GAMay 12, 1976 · N7929 · Substantial damage