Skip to content

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

20 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

19742026

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.Sep 22, 1998 · N9774 · Substantial damage NTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.Jul 23, 1993 · N4824 · Substantial damage NTSB ATL93LA116Accident · No injuriesLimited investigationFinal reportGrumman G164A · Brundidge, ALThe broken carburetor accelerator pump piston rivet which lodged under the needle valve, allowed the float chamber to flood with fuel, and the engine to quit. The lack of suitable terrain for a forced landing was a factor.Jun 25, 1993 · N48584 · Substantial damage NTSB ATL93LA084Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamilton, ALThe pilot's failure to properly calculate fuel consumption at an increased power setting, which resulted in fuel exhaustion and loss of engine power. Trees at the forced landing area were a factor in the accident.Apr 29, 1993 · N9696 · Destroyed NTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.Jun 25, 1992 · N5093 · Destroyed NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.May 22, 1989 · N8881H · Substantial damage NTSB ATL88DKG13Accident · No injuriesFinal reportGrumman G-164A · Fadette, ALThe pilot reported a partial power loss during an aerial application flight. The aircraft landed in the crops. The pilot stated that he found the number 3 cylinder partially separated from the engine.Aug 9, 1988 · N8573H · Substantial damage NTSB ATL88DKG07Accident · No injuriesFinal reportGrumman G164A · Clanton, ALMay 16, 1988 · N48438 · Substantial damage NTSB ATL87DKG05Accident · No injuriesFinal reportSchweizer G-164A · Summerdale, ALThe pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine…Jul 30, 1987 · N8881H · Substantial damage NTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…Jun 21, 1987 · N7687 · Substantial damage NTSB ATL85LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Athens, ALDuring an aerial application flight the aircraft lost power due to fuel exhaustion. The pilot made an emergency landing in a corn field. The pilot stated that he visually checked the fuel prior to take off and it appeared as if there was enough fuel to…Jul 29, 1985 · N10AA · Substantial damage NTSB ATL82DA199Accident · No injuriesFinal reportGrumman G-164A · Wetumpka, ALWhile taxiing onto the runway with a load of insecticide, the left main landing gear strut failed. The failure occurred about 2 inches from the fuselage attach point.Jul 13, 1982 · N7234 · Substantial damage NTSB ATL80FA080Accident · No injuriesClosedGrumman G-164A · Samson, ALJul 30, 1980 · N8623H · Substantial damage NTSB MIA79FKJ40Accident · Minor injuriesClosedGrumman G-164A · Rehobeth, ALJun 1, 1979 · N7492 · Destroyed NTSB MIA79FKJ25Accident · No injuriesClosedGrumman G164A · Pleasant Hill, ALMar 5, 1979 · N7936 · Destroyed NTSB MIA78FKJ70Accident · Minor injuriesClosedGrumman G-164A · Prattville, ALAug 5, 1978 · N9930 · Destroyed NTSB MIA77FKJ44Accident · No injuriesClosedGrumman G-164A · Centreville, ALJun 1, 1977 · N4824 · Substantial damage NTSB MIA77FKJ01Accident · 1 fatalClosedGrumman G-164 · Pansey, ALOct 2, 1976 · N23RA · Destroyed NTSB MIA76DKK02Accident · No injuriesClosedGrumman G-164A · Ashford, ALSep 9, 1976 · N9936 · Substantial damage NTSB MIA74DKJ63Accident · No injuriesClosedGrumman G-164 · Moundville, ALJun 16, 1974 · N9725 · Substantial damage