NTSB investigations: Grumman G-164A, 1974

26 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.

Cases per year

19662026
NTSB investigations: Grumman G-164A, 1974 per year, 1966–2026: 433 cases
19662
19673
19684
196921
197012
197117
197221
197325
197426
197534
197630
197723
197820
197921
19808
198110
19829
19839
198413
19856
19869
19877
19887
19894
199013
19917
19924
19934
19944
19952
19964
19974
19982
19992
20005
20012
20023
20031
20043
20053
20063
20072
20084
20091
20113
20123
20132
20141
20153
20182
20231
20243
20251

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1974
    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.

NTSB OAK75DVG32Accident · No injuriesClosedGrumman G-164A · Knights Ldg, CAOct 30, 1974 · N982X · DestroyedNTSB FTW75FRD12Accident · No injuriesClosedGrumman G-164A · Clinton, LAOct 21, 1974 · N5257 · Substantial damageNTSB LAX75DUJ34Accident · No injuriesClosedGrumman G-164 · Aguila, AZOct 3, 1974 · N11AA · DestroyedNTSB MIA75DKQ17Accident · No injuriesClosedGrumman G-164 · Cleveland, MSOct 2, 1974 · N468Y · DestroyedNTSB FTW75DPG19Accident · No injuriesClosedGrumman G-164A · Almyra, ARSep 9, 1974 · N6531 · Substantial damageNTSB FTW75DPG22Accident · No injuriesClosedGrumman G-164 · Newark, ARSep 4, 1974 · N4294 · Substantial damageNTSB FTW75FPG16Accident · No injuriesClosedGrumman G-164 · Dewitt, ARAug 24, 1974 · N989X · Substantial damageNTSB MIA75FKG17Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 20, 1974 · N7996 · DestroyedNTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MOAug 5, 1974 · N6606 · 2 aircraft · Substantial damageNTSB MIA75DKG14Accident · No injuriesClosedGrumman G-164A · Edison, GAAug 2, 1974 · N6659 · Substantial damageNTSB IAD75DLT02Accident · No injuriesClosedGrumman G-164A · New Castle, TNJul 22, 1974 · N6533 · Substantial damageNTSB LAX75DVA04Accident · No injuriesClosedGrumman G-164A · Ducor, CAJul 15, 1974 · N6587 · Substantial damageNTSB FTW75DPG01Accident · No injuriesClosedGrumman G-164A · Walnut Ridge, ARJul 3, 1974 · N7926 · Substantial damageNTSB FTW74FRJ38Accident · Minor injuriesClosedGrumman G-164A · Mer Rouge, LAJun 19, 1974 · N6604 · Substantial damageNTSB FTW74FRD41Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 29, 1974 · N939X · Substantial damageNTSB FTW74DRD40Accident · Minor injuriesClosedGrumman G-164A · Morrow, LAMay 23, 1974 · N5268 · Substantial damageNTSB MIA74DKT80Accident · Serious injuriesClosedGrumman G-164A · Andytown, FLMay 16, 1974 · N6544 · Substantial damageNTSB FTW74FRD39Accident · No injuriesClosedGrumman G-164A · Jennings, LAMay 16, 1974 · N5272 · Substantial damageNTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVMay 14, 1974 · N6538 · Substantial damageNTSB MKC74FCA25Accident · No injuriesClosedGrumman G-164A · New Madrid, MOMay 8, 1974 · N7844 · Substantial damageNTSB FTW74DRD33Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 5, 1974 · N5296 · Substantial damageNTSB FTW74DRD32Accident · No injuriesClosedGrumman G-164A · Abbeville, LAMay 1, 1974 · N6543 · Substantial damageNTSB FTW74DRD28Accident · Serious injuriesClosedGrumman G-164A · Lake Charles, LAApr 18, 1974 · N5345 · Substantial damageNTSB OAK74DVG42Accident · No injuriesClosedGrumman G-164A · Williams, CAApr 17, 1974 · N8366 · DestroyedNTSB OAK74DVM18Accident · No injuriesClosedGrumman G-164 · San Lucas, CAMar 4, 1974 · N7853 · Substantial damageNTSB MIA74FLA30Accident · No injuriesClosedGrumman G-164 · Hastings, FLJan 16, 1974 · N10286 · Destroyed