Skip to content

NTSB investigations: Grumman G-164

435 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, newest first

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."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.\"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."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 FTW76DPH02Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARAug 23, 1976 · N636U · Substantial damage NTSB DEN76DTC43Accident · Minor injuriesClosedGrumman G-164 · Hawk Springs, WYAug 9, 1976 · N73WJ · Destroyed NTSB MIA76FKQ41Accident · No injuriesClosedGrumman G-164 · Minter City, MSJul 29, 1976 · N651Y · Substantial damage NTSB FTW76FPG79Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARJul 12, 1976 · N645U · Destroyed NTSB FTW76FRD54Accident · Serious injuriesClosedGrumman G-164 · Maringouin, LAJul 11, 1976 · N462RF · Substantial damage NTSB OAK76DVG85Accident · No injuriesClosedGrumman G-164A · Willows, CAJun 27, 1976 · N594Y · Substantial damage NTSB OAK76FVG83Accident · No injuriesClosedGrumman G-164A · Princeton, CAJun 10, 1976 · N729Y · Substantial damage NTSB MIA76DKJ68Accident · Minor injuriesClosedGrumman G-164 · Perdido Beach, ALJun 7, 1976 · N10245 · Destroyed NTSB DEN76FTM31Accident · Serious injuriesClosedGrumman G-164 · Morgan, UTJun 2, 1976 · N491Y · Destroyed NTSB FTW76FRD46Accident · No injuriesClosedGrumman G-164 · Simmesport, LAMay 18, 1976 · N461RF · Substantial damage NTSB FTW76DRG50Accident · Minor injuriesClosedGrumman G-164 · Placedo, TXApr 27, 1976 · N485Y · Destroyed NTSB OAK76DVG67Accident · Minor injuriesClosedGrumman G-164 · Richvale, CAApr 21, 1976 · N10284 · Substantial damage NTSB CHI76DET29Accident · No injuriesClosedGrumman G-164 · Ft Wayne, INFeb 26, 1976 · N655U · Substantial damage NTSB OAK76DVA38Accident · Minor injuriesClosedGrumman G-164 · Los Banos, CAFeb 16, 1976 · N10295 · Substantial damage NTSB FTW76FRD22Accident · No injuriesClosedGrumman G-164 · Iowa, LANov 25, 1975 · N11983 · Substantial damage NTSB OAK76DVG34Accident · No injuriesClosedGrumman G-164 · Brooks, CANov 15, 1975 · N10259 · Substantial damage NTSB FTW76DQG35Accident · No injuriesClosedGrumman G-164 · Slayton, TXNov 1, 1975 · N464Y · Substantial damage NTSB FTW76DPG10Accident · No injuriesClosedGrumman G-164 · Devalls Bluff, ARAug 1, 1975 · N740Y · Substantial damage NTSB MKC76DCA04Accident · No injuriesClosedGrumman G-164 · Randlees, MOJul 29, 1975 · N602Y · Substantial damage NTSB OAK76FVG11Accident · Minor injuriesClosedGrumman G-164 · Live Oak, CAJul 24, 1975 · N10222 · Substantial damage NTSB FTW76DRA05Accident · No injuriesClosedGrumman G-164 · El Campo, TXJul 18, 1975 · N658Y · Substantial damage NTSB FTW76DPG02Accident · No injuriesClosedGrumman G-164 · Beedeville, ARJul 10, 1975 · N473Y · Substantial damage NTSB FTW76DPG03Accident · No injuriesClosedGrumman G-164A · Dumas, ARJul 7, 1975 · N523Y · Substantial damage NTSB SEA75DYG49Accident · Minor injuriesClosedGrumman G-164 · Dayton, WAJun 20, 1975 · N10243 · Destroyed NTSB FTW75DRJ35Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 26, 1975 · N484Y · Substantial damage NTSB FTW75DPG88Accident · No injuriesClosedGrumman G-164A · Dumas, ARMay 18, 1975 · N522Y · Destroyed NTSB OAK75DVG67Accident · No injuriesClosedGrumman G-164 · Wheatland, CAMay 17, 1975 · N722Y · Substantial damage NTSB OAK75DVG61Accident · No injuriesClosedGrumman G-164 · Biggs, CAMay 9, 1975 · N10219 · Substantial damage NTSB MIA75FKT73Accident · No injuriesClosedGrumman G-164 · Belle Glade, FLApr 1, 1975 · N601Y · Substantial damage NTSB MIA75FKJ57Accident · No injuriesClosedGrumman G-164 · Southside, ALApr 1, 1975 · N497Y · Substantial damage NTSB LAX75DUJ36Accident · No injuriesClosedGrumman G-164A · Roll, AZOct 15, 1974 · N5238 · Destroyed NTSB MKC75FCD16Case · No injuriesClosedGrumman G-164 · Alexander, IASep 7, 1974 · N12LW · Substantial damage NTSB MKC75FCQ13Accident · Minor injuriesClosedGrumman G-164 · Valley Ctr, KSAug 29, 1974 · N10283 · Substantial damage NTSB MIA75DKQ06Accident · No injuriesClosedGrumman G-164 · Rolling Fork, MSAug 14, 1974 · N462Y · Destroyed NTSB FTW75FRD06Accident · No injuriesClosedGrumman G-164 · Branch, LAAug 6, 1974 · N631U · Substantial damage NTSB FTW75DPG12Accident · No injuriesClosedGrumman G-164 · Coy, ARAug 3, 1974 · N586Y · Substantial damage NTSB SEA75FTA05Accident · No injuriesClosedGrumman G-164 · Baker, MTJul 25, 1974 · N664U · Substantial damage NTSB DEN75FTE02Accident · Serious injuriesClosedGrumman G-164 · Fort Lupton, COJul 11, 1974 · N667Y · Destroyed NTSB FTW75FRD03Accident · Minor injuriesClosedGrumman G-164 · Jeanerette, LAJul 8, 1974 · N464RF · Substantial damage NTSB FTW74DRH03Accident · No injuriesClosedGrumman G-164 · Los Fresnos, TXJun 30, 1974 · N656U · Destroyed NTSB FTW74DPM28Accident · No injuriesClosedGrumman G-164 · Atoka, OKJun 17, 1974 · N481Y · Substantial damage NTSB CHI74FET21Accident · Minor injuriesClosedGrumman G-164 · Sodus, MIJun 4, 1974 · N646Y · Destroyed NTSB FTW74FRG92Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXJun 1, 1974 · N461RF · Substantial damage NTSB MKC74DCD34Accident · No injuriesClosedGrumman G-164 · Donnellson, IAMay 25, 1974 · N12LW · Substantial damage NTSB FTW74DPG60Accident · No injuriesClosedGrumman G-164 · Carlisle, ARMay 23, 1974 · N526Y · Substantial damage NTSB FTW74FRD37Accident · No injuriesClosedGrumman G-164 · Opelousas, LAMay 17, 1974 · N619U · Substantial damage NTSB MKC74DTK15Accident · Serious injuriesClosedGrumman G-164 · Hayes, SDMay 12, 1974 · N615U · Substantial damage NTSB OAK74DVG52Accident · No injuriesClosedGrumman G-164 · Live Oak, CAMay 5, 1974 · N10206 · Destroyed NTSB FTW74DRD30Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAApr 20, 1974 · N462RF · Substantial damage NTSB OAK74DVG47Accident · No injuriesClosedGrumman G-164 · Grimes, CAApr 18, 1974 · N73646 · Substantial damage