NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, 1974

22 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer 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

19712026
NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, 1974 per year, 1971–2026: 652 cases
19711
197211
197315
197422
197531
197641
197738
197841
197935
198025
198125
198222
198319
198424
198514
198612
198718
198822
198923
199011
199117
199221
199317
199412
199519
199615
19978
199810
19997
20002
20016
20025
20031
20043
200510
20065
20073
20085
20094
20101
20116
20123
20131
20141
20155
20164
20173
20191
20202
20221
20231
20243

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 ('3952801'))
  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 FTW75DRJ20Accident · No injuriesClosedGrumman G-164A · Natchitoches, LANov 22, 1974 · N7804 · Substantial damageNTSB LAX75DUJ22Accident · No injuriesClosedGrumman G-164A · Buckeye, AZAug 24, 1974 · N4529 · Substantial damageNTSB OAK75FVG18Accident · No injuriesClosedGrumman G-164A · Davis, CAAug 21, 1974 · N8376 · Substantial damageNTSB FTW75DPG08Accident · No injuriesClosedGrumman G-164A · Dumas, ARJul 26, 1974 · N4456 · Substantial damageNTSB FTW75DRG05Accident · No injuriesClosedGrumman 164-A · San Benito, TXJul 16, 1974 · N9793 · Substantial damageNTSB SEA75DYA04Accident · No injuriesClosedGrumman G-164A · Burley, IDJul 14, 1974 · N7365 · Substantial damageNTSB FTW74DPG78Accident · No injuriesClosedGrumman G-164A · Wheatley, ARJun 20, 1974 · N4859 · DestroyedNTSB MIA74DKJ63Accident · No injuriesClosedGrumman G-164 · Moundville, ALJun 16, 1974 · N9725 · Substantial damageNTSB FTW74DPG71Accident · No injuriesClosedGrumman G-164A · West Memphis, ARJun 11, 1974 · N9678 · Substantial damageNTSB FTW74FRD48Accident · No injuriesClosedGrumman G-164A · Kaplan, LAJun 10, 1974 · N9700 · Substantial damageNTSB FTW74DPG66Accident · No injuriesClosedGrumman G-164A · Carlisle, ARMay 27, 1974 · N7934 · Substantial damageNTSB CHI74FEA41Accident · No injuriesClosedGrumman G-164A · Madison, INMay 24, 1974 · N9830 · Substantial damageNTSB FTW74DPG65Accident · No injuriesClosedGrumman G-164 · St.Charles, ARMay 23, 1974 · N8384 · Substantial damageNTSB MIA74DLD87Accident · No injuriesClosedGrumman G-164A · Leesburg, FLMay 18, 1974 · N7986 · Substantial damageNTSB FTW74FRD38Accident · No injuriesClosedGrumman G-164 · Livonia, LAMay 18, 1974 · N7952 · Substantial damageNTSB FTW74DRJ34Accident · No injuriesClosedGrumman G-164A · Bonita, LAMay 17, 1974 · N7443 · Substantial damageNTSB FTW74DRJ29Accident · No injuriesClosedGrumman G-164A · Mer Rouge, LAApr 5, 1974 · N7364 · Substantial damageNTSB FTW74DRA32Accident · No injuriesClosedGrumman G-164A · Barker, TXApr 3, 1974 · N7371 · Substantial damageNTSB CHI74DEV41Accident · No injuriesClosedGrumman G-164A · Ware, ILMar 27, 1974 · N7248 · Substantial damageNTSB FTW74FRA31Accident · 1 fatalClosedGrumman G-164A · Buckeye, TXMar 6, 1974 · N5458 · 2 aircraft · DestroyedNTSB FTW74FRA27Accident · Serious injuriesClosedGrumman G-164A · Brookshire, TXFeb 4, 1974 · N4546 · Substantial damageNTSB OAK74FVG22Accident · No injuriesClosedGrumman G-164 · Zamora, CAJan 30, 1974 · N7445 · Substantial damage