Skip to content

NTSB investigations: Grumman G-164, TX

53 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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 FTW93LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Liverpool, TXThe loss of engine power due to the failure of the engine blower. A factor was the lack of suitable terrain at the pilot's disposal.Oct 29, 1992 · N637U · Substantial damage NTSB FTW92LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Bayside, TXThe pilot's inadequate visual lookout.Apr 30, 1992 · N468RF · Destroyed NTSB FTW86FRG24Accident · No injuriesFinal reportGrumman G-164 · La Feria, TXAs the plt was making a swath run, he started to cross under power lines, but saw the profile view of a road marker. When he pulled up to avoid the road marker, the acft struck the wires, rolled to the left & collided with the ground.Jun 5, 1986 · N552Y · Destroyed NTSB FTW81DQG59Accident · No injuriesClosedGrumman G-164 · Whiteface, TXAug 21, 1981 · N635U · Substantial damage NTSB FTW80FRG51Accident · Minor injuriesClosedGrumman G-164 · Santa Rosa, TXJun 25, 1980 · N614U · Substantial damage NTSB FTW80DPA04Accident · No injuriesClosedGrumman G-164 · Lott, TXDec 8, 1979 · N472Y · Substantial damage NTSB FTW78FRA19Accident · No injuriesClosedGrumman G-164A · Baytown, TXMay 1, 1978 · N636U · Substantial damage NTSB FTW77DPD41Accident · No injuriesClosedGrumman G-164 · Hamlin, TXSep 24, 1977 · N619U · Substantial damage NTSB FTW77DRG48Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXApr 25, 1977 · N472Y · Substantial damage NTSB FTW76DRG50Accident · Minor injuriesClosedGrumman G-164 · Placedo, TXApr 27, 1976 · N485Y · Destroyed NTSB FTW76DQG35Accident · No injuriesClosedGrumman G-164 · Slayton, TXNov 1, 1975 · N464Y · Substantial damage NTSB FTW76DRA05Accident · No injuriesClosedGrumman G-164 · El Campo, TXJul 18, 1975 · N658Y · Substantial damage NTSB FTW74DRH03Accident · No injuriesClosedGrumman G-164 · Los Fresnos, TXJun 30, 1974 · N656U · Destroyed NTSB FTW74FRG92Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXJun 1, 1974 · N461RF · Substantial damage NTSB FTW74FRG13Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXAug 8, 1973 · N10278 · Substantial damage NTSB FTW74FRG05Accident · No injuriesClosedGrumman G-164 · Mcallen, TXJul 26, 1973 · N63W · Substantial damage NTSB FTW74FPD02Accident · No injuriesClosedGrumman G-164 · De Leon, TXJul 20, 1973 · N648U · Substantial damage NTSB FTW73FRG94Accident · No injuriesClosedGrumman G-164 · Rangerville, TXJun 30, 1973 · N10227 · Substantial damage NTSB FTW73DRA22Accident · No injuriesClosedGrumman G-164A · Anahuac, TXApr 23, 1973 · N578Y · Substantial damage NTSB FTW73FRA17Accident · No injuriesClosedGrumman G-164 · Hockley, TXMar 12, 1973 · N658Y · Substantial damage NTSB FTW73FQG23Accident · Serious injuriesClosedGrumman G-164 · Roby, TXNov 3, 1972 · N10231 · Destroyed NTSB FTW73DRG05Accident · Minor injuriesClosedGrumman G-164A · Harlingen, TXJul 23, 1972 · N940X · Destroyed NTSB FTW71FRA53Accident · Minor injuriesClosedGrumman G-164 · Anahuac, TXMay 10, 1971 · N658U · Substantial damage NTSB FTW71FRA54Accident · No injuriesClosedGrumman G-164 · Eagle Lake, TXApr 26, 1971 · N10281 · Substantial damage NTSB FTW71FRA01Accident · No injuriesClosedGrumman G-164 · Raywood, TXJul 1, 1970 · N364Y · Substantial damage NTSB FTW71DRA03Accident · No injuriesClosedGrumman G-164 · Calvert, TXJul 1, 1970 · N667Y · Destroyed NTSB FTW70FRA17Accident · No injuriesClosedGrumman G-164 · Devers, TXMay 13, 1970 · N10262 · Destroyed NTSB FTW70F0248Accident · No injuriesClosedGrumman G-164 · Post, TXOct 15, 1969 · N459RF · Substantial damage NTSB FTW70F0240Accident · No injuriesClosedGrumman G-164 · Spur, TXSep 17, 1969 · N468RF · Substantial damage NTSB FTW70D0113Accident · No injuriesClosedGrumman G-164 · Lavilla, TXJul 3, 1969 · N694Y · Substantial damage NTSB FTW70D0019Accident · Minor injuriesClosedGrumman G-164 · Alvin, TXMay 24, 1969 · N660U · Destroyed NTSB FTW68D0552Accident · No injuriesClosedGrumman G-164 · Katy, TXApr 15, 1968 · N658Y · Substantial damage NTSB FTW68D0542Accident · No injuriesClosedGrumman G-164 · Liberty, TXMar 29, 1968 · N10287 · Substantial damage NTSB FTW68D0498Accident · No injuriesClosedGrumman G-164 · El Campo, TXMar 16, 1968 · N743Y · Substantial damage NTSB FTW68F0117Accident · No injuriesClosedGrumman G-164 · San Benito, TXJul 20, 1967 · N10235 · Substantial damage NTSB FTW68F0083Accident · No injuriesClosedGrumman G-164 · Raywood, TXJul 3, 1967 · N654Y · Substantial damage NTSB FTW68F0078Accident · No injuriesClosedGrumman G-164 · Manvel, TXJun 8, 1967 · N603U · Substantial damage NTSB FTW67D0587Accident · No injuriesClosedGrumman G-164 · Dayton, TXApr 25, 1967 · N492Y · Substantial damage NTSB FTW67D0585Accident · No injuriesClosedGrumman G-164 · Dayton, TXApr 24, 1967 · N10287 · Substantial damage NTSB FTW67D0215Accident · Minor injuriesClosedGrumman G-164 · Mcadoo, TXSep 8, 1966 · N460RF · Substantial damage NTSB FTW67D0230Accident · No injuriesClosedGrumman G-164 · Blessing, TXAug 19, 1966 · N721Y · Substantial damage NTSB FTW67F0151Accident · No injuriesClosedGrumman G-164 · Katy, TXAug 5, 1966 · N486Y · Substantial damage NTSB FTW67D0106Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXJul 22, 1966 · N485Y · Substantial damage NTSB FTW66F0188Accident · No injuriesClosedGrumman G-164 · Otey, TXAug 2, 1965 · N721Y · Substantial damage NTSB FTW66D0144Accident · No injuriesClosedGrumman G-164 · Santa Maria, TXJun 29, 1965 · N143W · Substantial damage NTSB FTW66F0071Accident · No injuriesClosedGrumman G-164 · Winters, TXMay 8, 1965 · N331Y · Substantial damage NTSB FTW65F0040Accident · No injuriesClosedGrumman G-164 · Tomball, TXApr 27, 1965 · N658Y · Substantial damage NTSB FTW65F0031Accident · No injuriesClosedGrumman G-164 · Edcouch, TXApr 24, 1965 · N10397 · Substantial damage NTSB FTW65F0021Accident · No injuriesClosedGrumman G-164 · Dayton, TXApr 12, 1965 · N595Y · Destroyed NTSB UNK64X2713Accident · No injuriesClosedGrumman G164 · Port Lavaca, TXJul 8, 1964 · N472Y · Substantial damage