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 FTW68F0078Accident · No injuriesClosedGrumman G-164 · Manvel, TXJun 8, 1967 · N603U · Substantial damage NTSB CHI68D0164Accident · No injuriesClosedGrumman G-164 · Central City, KYJun 5, 1967 · N10258 · Destroyed NTSB FTW68D0036Accident · Serious injuriesClosedGrumman G-164 · Gueydan, LAMay 31, 1967 · N515Y · Substantial damage NTSB OAK67D0316Accident · No injuriesClosedGrumman G-164 · Live Oak, CAMay 24, 1967 · N657Y · Substantial damage NTSB FTW67D0594Accident · No injuriesClosedGrumman G-164 · Washington, LAMay 11, 1967 · N10240 · Substantial damage NTSB MIA67D0525Accident · No injuriesClosedGrumman G-164 · Shelby, MSMay 10, 1967 · N645U · Substantial damage NTSB FTW67F0570Accident · No injuriesClosedGrumman G-164 · Church Point, LAMay 5, 1967 · N526Y · Substantial damage NTSB FTW67D0609Accident · No injuriesClosedGrumman G-164 · Dewitt, ARMay 4, 1967 · N10226 · 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 FTW67F0540Accident · Serious injuriesClosedGrumman G-164 · Church Point, LAApr 22, 1967 · N621U · Destroyed NTSB MIA67F0435Accident · No injuriesClosedGrumman G-164 · Clewiston, FLMar 8, 1967 · N10268 · Substantial damage NTSB SEA67D0250Accident · No injuriesClosedGrumman G-164 · Prescott, WAMar 6, 1967 · N517Y · Substantial damage NTSB FTW67D0468Accident · Serious injuriesClosedGrumman G-164 · Pine Bluff, ARMar 3, 1967 · N473Y · Destroyed NTSB FTW67D0244Accident · No injuriesClosedGrumman G-164 · Leavchville, AROct 7, 1966 · N10237 · Substantial damage NTSB FTW67F0214Accident · Minor injuriesClosedGrumman G-164 · Tupelo, ARSep 8, 1966 · N466Y · 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 MIA67F0110Accident · No injuriesClosedGrumman G-164 · Lodi, MSAug 18, 1966 · N597Y · Substantial damage NTSB MIA67F0112Accident · No injuriesClosedGrumman G-164 · Sand Hill, MSAug 13, 1966 · N10229 · 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 FTW67D0205Accident · No injuriesClosedGrumman G-164 · Mittie, LAJul 8, 1966 · N591Y · Substantial damage NTSB MKC67F0067Accident · Serious injuriesClosedGrumman G-164 · Warren, MNJul 4, 1966 · N604U · Destroyed NTSB MIA67F0054Accident · No injuriesClosedGrumman G-164 · Sasser, GAJun 27, 1966 · N692Y · Destroyed NTSB SEA66A0063Accident · No injuriesClosedGrumman G-164 · Chester, MTMay 29, 1966 · N517Y · No damage NTSB MKC66F0592Accident · No injuriesClosedGrumman G-164 · Charleston, MOMay 12, 1966 · N608U · Substantial damage NTSB FTW66F0692Accident · Serious injuriesClosedGrumman G-164 · Broken Arrow, OKMay 8, 1966 · N695Y · Destroyed NTSB FTW67F0027Accident · No injuriesClosedGrumman G164 · Abbeville, LAApr 29, 1966 · N468RF · Substantial damage NTSB OAK66F0266Accident · No injuriesClosedGrumman G-164 · Richvale, CAApr 21, 1966 · N617Y · Substantial damage NTSB OAK66F0274Accident · No injuriesClosedGrumman G-164 · Butte City, CAApr 20, 1966 · N729Y · Substantial damage NTSB FTW66D0637Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAApr 18, 1966 · N657U · Substantial damage NTSB OAK66D0225Accident · No injuriesClosedGrumman G-164 · Chico, CAApr 5, 1966 · N716Y · Destroyed NTSB FTW66F0506Accident · No injuriesClosedGrumman G-164 · Portland, ARFeb 2, 1966 · N10204 · Substantial damage NTSB LAX66F0197Accident · No injuriesClosedGrumman G-164 · Buttonwillow, CADec 26, 1965 · N10220 · Substantial damage NTSB FTW66F0478Accident · No injuriesClosedGrumman G-164 · Portland, ARSep 4, 1965 · N523Y · Substantial damage NTSB FTW66F0468Accident · No injuriesClosedGrumman G-164 · Gould, ARAug 21, 1965 · N464Y · Substantial damage NTSB FTW66F0477Accident · No injuriesClosedGrumman G-164 · Helena, ARAug 19, 1965 · N464RF · Substantial damage NTSB MIA66F0194Accident · No injuriesClosedGrumman T-G164 · Charleston, MSAug 17, 1965 · N10278 · Substantial damage NTSB NYC66F0206Accident · No injuriesClosedGrumman G164 · Elmira, NYAug 12, 1965 · N631U · Substantial damage NTSB FTW66F0198Accident · No injuriesClosedGrumman G-164 · Welsh, LAAug 11, 1965 · N10275 · Substantial damage NTSB FTW66F0188Accident · No injuriesClosedGrumman G-164 · Otey, TXAug 2, 1965 · N721Y · Substantial damage NTSB FTW66D0177Accident · No injuriesClosedGruman G-164 · Hunter, ARJul 13, 1965 · N714Y · Substantial damage NTSB MIA66F0138Accident · Serious injuriesClosedGrumman G-164 · Shellman, GAJul 10, 1965 · N597Y · Substantial damage NTSB FTW66D0144Accident · No injuriesClosedGrumman G-164 · Santa Maria, TXJun 29, 1965 · N143W · Substantial damage NTSB FTW66D0093Accident · No injuriesClosedGrumman G-164 · Washington, LAJun 8, 1965 · N10240 · Substantial damage NTSB FTW66F0092Accident · No injuriesClosedGrumman G-164 · Eunice, LAJun 7, 1965 · N459Y · Substantial damage NTSB MKC66F0024Accident · No injuriesClosedGrumman G-164 · Manhattan, KSJun 3, 1965 · N692Y · Substantial damage NTSB MIA65D0118Accident · No injuriesClosedGrumman G-164 · Belle Glade, FLMay 15, 1965 · N10271 · Substantial damage NTSB FTW66F0071Accident · No injuriesClosedGrumman G-164 · Winters, TXMay 8, 1965 · N331Y · Substantial damage