Skip to content

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

28 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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.Mar 13, 2001 · N5076 · Substantial damage NTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.Aug 2, 1996 · N7362 · Substantial damage NTSB MIA91LA170Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Falcon, MSIn flight encounter with weather, high density altitude. Contributing to the accident was aircraft gross weight which was exceeded.Jun 26, 1991 · N8942H · Substantial damage NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.Aug 24, 1990 · N9650 · Substantial damage NTSB MIA89LA203Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schlater, MSInadequate preflight planning/preparation by the pilot which resulted in the selection of the wrong runway. The tailwindand dirt bank were considered to be contributing factors.Jul 19, 1989 · N4579 · Substantial damage NTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…Apr 1, 1988 · N7961 · Substantial damage NTSB MIA87LA211Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Greenwood, MSShortly after takeoff from a 1,800 ft grass strip on a 93 degree f day, the acft, loaded with 1,500 pounds of chemical, began to settle. It then touched down in a field, nosed over & came to rest inverted. The plt stated there was no eng failure or…Jul 20, 1987 · N10AA · Substantial damage NTSB MIA87LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vaiden, MSThe plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with…Jun 6, 1987 · N9734 · Destroyed NTSB MIA87FA160Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Dundee, MSWhile spraying a rice field, the acft was flying across svrl small dirt banks that had been furrowed for water ctl. Drg a swath run, it struck 3 furrowed banks that were close together, flipped over as it crashed, then burned. Witnessesrprtd the eng was…May 19, 1987 · N4654 · Destroyed NTSB ATL85LA269Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe plt stated that during aerial application maneuver he allowed the airspeed to get too low and the acft settled into a soy bean field. The left wing contacted the crop and the acft cartwheeled.Sep 6, 1985 · N9893 · Substantial damage NTSB ATL85LA018Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe pilot attempted takeoff from an agricultural site which had soft spots from wet conditions. Directional control was lost when one main wheel encountered a soft spot. The aircraft veered into a plowed field and flipped inverted.Oct 19, 1984 · N7867 · Substantial damage NTSB ATL80FKQ22Accident · No injuriesClosedGrumman G-164 · Clarksdale, MSAug 26, 1980 · N48461 · Substantial damage NTSB ATL80FKQ04Accident · No injuriesClosedGrumman G-164A · Boyle, MSMay 25, 1980 · N9734 · Substantial damage NTSB ATL80FKQ03Accident · No injuriesClosedGrumman G-164A · Clarksdale, MSMay 23, 1980 · N7867 · Substantial damage NTSB MIA80FKQ03Accident · Minor injuriesClosedGrumman G-164A · Flora, MSMar 14, 1980 · N48507 · Destroyed NTSB MIA79FKQ25Accident · No injuriesClosedGrumman G-164A · Sunflower, MSAug 27, 1979 · N48437 · Substantial damage NTSB MIA79FKQ22Accident · No injuriesClosedGrumman G-164A · Madison, MSAug 13, 1979 · N8673H · Destroyed NTSB MIA79FKQ16Accident · No injuriesClosedGrumman G-164A · Batesville, MSJul 13, 1979 · N8881H · Substantial damage NTSB MIA79FKQ07Accident · Serious injuriesClosedGrumman G164A · Lucedale, MSApr 18, 1979 · N4573 · Destroyed NTSB MIA78FKQ32Accident · No injuriesClosedGrumman G-164A · Charleston, MSAug 14, 1978 · N8369 · Substantial damage NTSB MIA78KKQ19Accident · No injuriesClosedGrumman G-164A · Sunflower, MSJul 8, 1978 · N8959H · Substantial damage NTSB MIA77FKQ31Accident · No injuriesClosedGrumman G164A · Flora, MSAug 18, 1977 · N48426 · Substantial damage NTSB MIA76FKQ45Accident · No injuriesClosedGrumman G-164A · Flora, MSAug 26, 1976 · N7225 · Substantial damage NTSB MIA76FKQ39|MIA76FK039Accident · No injuriesClosedCessna 188 · Shelby, MSJul 20, 1976 · N21862 · 2 aircraft · Substantial damage NTSB MIA76FKQ34Accident · Minor injuriesClosedGrumman G-164A · Swan Lake, MSJun 8, 1976 · N7961 · Substantial damage NTSB MIA74FLT01Accident · No injuriesClosedGrumman G-164A · Ripley, MSSep 3, 1973 · N4562 · Substantial damage NTSB MIA73FKQ33Accident · No injuriesClosedGrumman G-164A · Boyle, MSJun 27, 1973 · N8389 · Destroyed NTSB MIA73DKQ11Accident · No injuriesClosedGrumman G-164A · Woodville, MSSep 3, 1972 · N8372 · Substantial damage