Skip to content

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

15 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164B. 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

19772026

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 ('3952802')) 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 ('3952802'))
  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 ('3952802'))
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 MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.May 22, 2000 · N6744K · Substantial damage NTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.Jun 20, 1997 · N6816Q · Substantial damage NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…Apr 21, 1997 · N6601Q · Substantial damage NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.Mar 6, 1995 · N6619Q · Substantial damage NTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.Sep 29, 1994 · N48572 · Substantial damage NTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.Aug 18, 1993 · N6731Q · Destroyed NTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…Jul 10, 1986 · N48593 · Destroyed NTSB ATL84LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Rosedale, MSThe plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over.May 9, 1984 · N6793K · Substantial damage NTSB ATL80FKQ09Accident · No injuriesClosedGrumman G-164B · Clarksdale, MSJun 19, 1980 · N6765Q · Substantial damage NTSB MIA78DKQ33Accident · No injuriesClosedGrumman G-164B · Benton, MSAug 20, 1978 · N6645Q · Substantial damage NTSB MIA78FKQ29Accident · No injuriesClosedGrumman G-164B · Charlestown, MSAug 3, 1978 · N6780Q · Substantial damage NTSB MIA78FK030Accident · Minor injuriesClosedGrumman G-164B · Charleston, MSAug 3, 1978 · N48497 · Destroyed NTSB MIA77FKQ29Accident · No injuriesClosedGrumman G-164B · Houston, MSAug 4, 1977 · N48628 · Substantial damage NTSB MIA77FKQ26Accident · No injuriesClosedGrumman G-164B · Tchula, MSAug 2, 1977 · N63D · Substantial damage NTSB MIA77FKQ15Accident · No injuriesClosedGrumman G-164B · Pugh City, MSMay 19, 1977 · N48646 · Destroyed