Skip to content

NTSB investigations: Grumman G-164A, LA

60 cases on aircraft the registry lists as Grumman 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

19682026

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" = 'LA' 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 ('3952704')) 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\" = 'LA' 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 ('3952704'))
  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" = 'LA' 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 ('3952704'))
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 CEN24LA364Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-164A · LaPlace, LATotal loss of engine power during the agricultural application flight for reasons that could not be determined.Sep 21, 2024 · N6565 · Substantial damage NTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.Aug 29, 2018 · N956X · Substantial damage NTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.Mar 10, 2005 · N5327 · Substantial damage NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.Jul 25, 1990 · N7854 · Destroyed NTSB FTW90DRD12Accident · Minor injuriesFinal reportGrumman G-164A · Bastrop, LAThe pilot's improper engine procedures during ground operations and prior to takeoff which resulted in fouled spark plugs.Jun 10, 1990 · N6572 · Destroyed NTSB FTW90DRD03Accident · No injuriesFinal reportGrumman G-164A · Glynn, LALoss of directional control on the ground, due to intermittent locking of the right brake during the landing roll.Feb 22, 1990 · N930X · Substantial damage NTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.May 29, 1989 · N5267 · Destroyed NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…Aug 14, 1988 · N979X · Substantial damage NTSB FTW86LRD22Accident · No injuriesFinal reportGrumman G-164A · Franklin, LADuring aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.Jul 22, 1986 · N920X · Substantial damage NTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.May 21, 1986 · N5407 · Substantial damage NTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…Jul 1, 1982 · N6562 · Substantial damage NTSB FTW82FRD14Accident · No injuriesFinal reportGrumman G-164A · Kaplan, LAThe operator reported that the pilot was making a left turn to line up with the flagman when the aircraft stalled and went down into trees. The temperature was reported to be 95 deg. There was no mention of injuries in the operator's accident report…Jun 5, 1982 · N5261 · Destroyed NTSB FTW80DRJ26Accident · No injuriesClosedGrumman G164A · Crowville, LAJun 30, 1980 · N917X · Substantial damage NTSB FTW79FRD41Accident · No injuriesClosedGrumman G-164A · Basile, LAJun 18, 1979 · N6586 · Substantial damage NTSB FTW79DRD32Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAMay 22, 1979 · N6603 · Substantial damage NTSB FTW79DRD31Accident · No injuriesClosedGrumman G-164A · Kaplan, LAMay 22, 1979 · N5262 · Destroyed NTSB FTW79DRD25Accident · No injuriesClosedGrumman G-164A · Midland, LAMay 4, 1979 · N5334 · Destroyed NTSB FTW79FPD19Accident · No injuriesClosedGrum Amer G-164 · Lake Arthur, LAMar 15, 1979 · N6603 · Substantial damage NTSB FTW78FRD37Accident · No injuriesClosedGrumman G-164A · Pine Prairie, LAJun 13, 1978 · N5322 · Substantial damage NTSB FTW78DRD36Accident · Serious injuriesClosedGrumman G-164A · Kaplan, LAJun 12, 1978 · N9944 · Substantial damage NTSB FTW78DRD33Accident · No injuriesClosedGrumman G-164A · Basile, LAJun 8, 1978 · N5413 · Substantial damage NTSB FTW78FRD27Accident · No injuriesClosedGrumman G-164 · Elton, LAMay 11, 1978 · N5413 · Substantial damage NTSB FTW78DRJ15Accident · No injuriesClosedGrumman G-164A · Bonita, LAApr 2, 1978 · N6635Q · Substantial damage NTSB FTW77FRJ20Accident · No injuriesClosedGrumman G-164A · Gilliam, LAAug 30, 1977 · N959X · Substantial damage NTSB FTW77FRD24Accident · Serious injuriesClosedGrumman G-164A · Ville Platte, LAAug 21, 1977 · N5264 · Destroyed NTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LAAug 8, 1977 · N5417 · Destroyed NTSB FTW77DRJ09Accident · No injuriesClosedGrumman G-164A · Bastrop, LAJun 11, 1977 · N7902 · Substantial damage NTSB FTW76DRD55Accident · No injuriesClosedGrumman G-164A · Thibodaux, LAJul 25, 1976 · N6585 · 2 aircraft · Minor damage NTSB FTW76DRD38Accident · No injuriesClosedGrumman G-164A · Kaplan, LAApr 19, 1976 · N5262 · Substantial damage NTSB FTW76DRD35Accident · No injuriesClosedGrumman G-164 · Oakdale, LAMar 31, 1976 · N6590 · Substantial damage NTSB FTW76DRJ04Accident · No injuriesClosedGrumman G-164A · Rayville, LAAug 11, 1975 · N5256 · Destroyed NTSB FTW75DRD65Accident · No injuriesClosedGrumman G-164A · Eunice, LAJun 6, 1975 · N5257 · Substantial damage NTSB FTW75FRD55Accident · No injuriesClosedGrumman G-164A · Iota, LAMay 20, 1975 · N677U · Destroyed NTSB FTW75FRD51Accident · No injuriesClosedGrumman G-164A · E.Lake Charles, LAMay 13, 1975 · N6535 · Substantial damage NTSB FTW75FRD49Accident · No injuriesClosedGrumman G-164A · Abbeville, LAMay 10, 1975 · N4963 · 2 aircraft · Substantial damage NTSB FTW75FRD48Accident · No injuriesClosedGrumman G-164A · Mermentau, LAMay 9, 1975 · N979X · Substantial damage NTSB FTW75FRD47Accident · No injuriesClosedGrumman G-164A · Morse, LAMay 9, 1975 · N956X · Substantial damage NTSB FTW75FRD12Accident · No injuriesClosedGrumman G-164A · Clinton, LAOct 21, 1974 · N5257 · Substantial damage NTSB FTW74FRJ38Accident · Minor injuriesClosedGrumman G-164A · Mer Rouge, LAJun 19, 1974 · N6604 · Substantial damage NTSB FTW74FRD41Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 29, 1974 · N939X · Substantial damage NTSB FTW74DRD40Accident · Minor injuriesClosedGrumman G-164A · Morrow, LAMay 23, 1974 · N5268 · Substantial damage NTSB FTW74FRD39Accident · No injuriesClosedGrumman G-164A · Jennings, LAMay 16, 1974 · N5272 · Substantial damage NTSB FTW74DRD33Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 5, 1974 · N5296 · Substantial damage NTSB FTW74DRD32Accident · No injuriesClosedGrumman G-164A · Abbeville, LAMay 1, 1974 · N6543 · Substantial damage NTSB FTW74DRD28Accident · Serious injuriesClosedGrumman G-164A · Lake Charles, LAApr 18, 1974 · N5345 · Substantial damage NTSB FTW74DRJ15Accident · No injuriesClosedGrumman G-164 · Mer Rouge, LAOct 6, 1973 · N6625 · Substantial damage NTSB FTW74FRD13Accident · No injuriesClosedGrumman G-164A · Indian Village, LASep 17, 1973 · N6609 · Destroyed NTSB FTW74DRD08Accident · Minor injuriesClosedGrumman G-164A · Welsh, LAAug 27, 1973 · N6647 · Destroyed NTSB FTW74DRD07Accident · No injuriesClosedGrumman G-164A · Bell City, LAAug 7, 1973 · N5305 · Substantial damage NTSB FTW73DRD35Accident · No injuriesClosedGrumman G-164A · Abbeville, LAJun 4, 1973 · N7839 · Substantial damage