Skip to content

NTSB investigations: Grumman G-164, LA

87 cases on aircraft the registry lists as Grumman G-164. 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

19642026

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 ('3952702')) 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 ('3952702'))
  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 ('3952702'))
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 FTW98LA161Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · St. Joseph, LAThe pilot's failure to maintain clearance from the trees. A factor was the lack of suitable terrain for the ensuing forced landing.Mar 28, 1998 · N617Y · Destroyed NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.Aug 5, 1995 · N732Y · Substantial damage NTSB FTW91LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pioneer, LAThe pilot's use of a runway unsuitable due to recent rains.May 3, 1991 · N7361 · Substantial damage NTSB FTW89DRD09Accident · No injuriesFinal reportSchweizer G-164A · Bunkie, LAThe loss of the number five cylinder in flight, resulting in a loss of engine RPM. The pilot misjudged the landing flare height due to obscured vision from fire and smoke and the airplane stalled and impacted the ground nose first.Jun 23, 1989 · N602Y · Substantial damage NTSB FTW87DRD04Accident · No injuriesFinal reportGrumman G-164 · Rayne, LAThe aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…Apr 16, 1987 · N10259 · Substantial damage NTSB FTW84LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Oak Grove, LAAircraft landed with a flat left main tire, veered left and nosed over inverted.Aug 24, 1984 · N528Y · Substantial damage NTSB FTW81DRJ29Accident · No injuriesClosedGrumman G-164 · Bastrop, LAAug 14, 1981 · N10292 · Destroyed NTSB FTW81DRJ16Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 27, 1981 · N612U · Destroyed NTSB FTW81DRD21Accident · No injuriesClosedGrumman G-164 · Chatagnier, LAApr 28, 1981 · N592Y · Substantial damage NTSB FTW81FRJ01Accident · Serious injuriesClosedGrumman G-164 · Marksville, LAOct 2, 1980 · N494Y · Destroyed NTSB FTW80DRD42Accident · No injuriesClosedGrumman G-164 · Hathaway, LAJun 16, 1980 · N458RF · Substantial damage NTSB FTW79DRD21Accident · No injuriesClosedGrumman G-164A · Church Point, LAApr 16, 1979 · N494Y · Substantial damage NTSB FTW78FRD54Accident · No injuriesClosedGrumman G-164 · Lake Charles, LAAug 31, 1978 · N462RF · Substantial damage NTSB FTW77FRD43Accident · No injuriesClosedGrumman G-164 · Maringouin, LAAug 1, 1977 · N462RF · Destroyed NTSB FTW77DRD33Accident · No injuriesClosedGrumman G-164 · Pine Prairie, LAJun 8, 1977 · N10292 · Substantial damage NTSB FTW77FRD01Accident · No injuriesClosedGrumman G-164 · Maurice, LAOct 9, 1976 · N10264 · Destroyed NTSB FTW76FRD54Accident · Serious injuriesClosedGrumman G-164 · Maringouin, LAJul 11, 1976 · N462RF · Substantial damage NTSB FTW76FRD46Accident · No injuriesClosedGrumman G-164 · Simmesport, LAMay 18, 1976 · N461RF · Substantial damage NTSB FTW76FRD22Accident · No injuriesClosedGrumman G-164 · Iowa, LANov 25, 1975 · N11983 · Substantial damage NTSB FTW75DRJ35Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 26, 1975 · N484Y · Substantial damage NTSB FTW75FRD06Accident · No injuriesClosedGrumman G-164 · Branch, LAAug 6, 1974 · N631U · Substantial damage NTSB FTW75FRD03Accident · Minor injuriesClosedGrumman G-164 · Jeanerette, LAJul 8, 1974 · N464RF · Substantial damage NTSB FTW74FRD37Accident · No injuriesClosedGrumman G-164 · Opelousas, LAMay 17, 1974 · N619U · Substantial damage NTSB FTW74DRD30Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAApr 20, 1974 · N462RF · Substantial damage NTSB FTW74FRD17Accident · No injuriesClosedGrumman G-164 · Eunice, LAOct 25, 1973 · N592Y · Substantial damage NTSB FTW74DRD01Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAJul 16, 1973 · N468RF · Substantial damage NTSB FTW73FRD38Accident · No injuriesClosedGrumman G-164 · Thornwell, LAJun 27, 1973 · N464RF · Substantial damage NTSB FTW73DRD37Accident · Minor injuriesClosedGrumman G-164 · Breaux Bridge, LAJun 25, 1973 · N492Y · Substantial damage NTSB FTW73DRD36Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAJun 5, 1973 · N10292 · Substantial damage NTSB FTW73FRD34Accident · No injuriesClosedGrumman G-164 · Church Point, LAJun 2, 1973 · N552Y · Substantial damage NTSB FTW73DRD22Accident · No injuriesClosedGrumman G-164 · Welsh, LAMay 8, 1973 · N458RF · Substantial damage NTSB FTW73DRD20Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAApr 30, 1973 · N515Y · Substantial damage NTSB FTW72DRD36Accident · No injuriesClosedGrumman G-164 · Welsh, LAJun 20, 1972 · N459RF · Substantial damage NTSB FTW72DRJ27Accident · No injuriesClosedGrumman G-164 · Lake Providnce, LAMay 8, 1972 · N696Y · Substantial damage NTSB FTW72FRD25Accident · No injuriesClosedGrumman G-164 · Welsh, LAMay 6, 1972 · N10210 · Substantial damage NTSB FTW72DRD08Accident · No injuriesClosedGrumman G-164 · Jeanerette, LAAug 14, 1971 · N461RF · Destroyed NTSB FTW71FRD53Accident · No injuriesClosedGrumman G-164 · Crowley, LAJun 15, 1971 · N645U · Substantial damage NTSB FTW71FRD52Accident · No injuriesClosedGrumman G-164 · Perry, LAJun 9, 1971 · N468RF · Substantial damage NTSB FTW71DRD35Accident · Minor injuriesClosedGrumman G-164 · Jennings, LAFeb 19, 1971 · N530Y · Destroyed NTSB FTW71DRD24Accident · No injuriesClosedGrumman G-164 · Welsh, LAOct 30, 1970 · N10291 · Destroyed NTSB FTW71DRD21Accident · No injuriesClosedGrumman G-164 · Jennings, LAOct 15, 1970 · N591Y · Substantial damage NTSB FTW71DRD01Accident · No injuriesClosedGrumman G-164 · Lebeau, LAJul 2, 1970 · N10240 · Destroyed NTSB FTW70FRD18Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAMay 30, 1970 · N590Y · Substantial damage NTSB FTW70F0166Accident · No injuriesClosedGrumman G164 · Deridder, LASep 6, 1969 · N608U · Substantial damage NTSB FTW70D0176Accident · Minor injuriesClosedGrumman G-164 · Jeanerette, LAAug 20, 1969 · N466RF · Substantial damage NTSB FTW70F0063Accident · Minor injuriesClosedGrumman G-164 · Kaplan, LAJun 23, 1969 · N520Y · Substantial damage NTSB FTW70F0059Accident · Minor injuriesClosedGrumman G-164 · Lake Arthur, LAJun 19, 1969 · N552Y · Substantial damage NTSB FTW69F0465Accident · No injuriesClosedGrumman G-164 · Lake Charles, LAApr 29, 1969 · N10275 · Substantial damage NTSB FTW69F0462Accident · Minor injuriesClosedGrumman G-164 · Kaplan, LAApr 16, 1969 · N10278 · Destroyed NTSB FTW69D0421Accident · No injuriesClosedGrumman G-164 · Lake Charles, LAMar 19, 1969 · N10275 · Substantial damage