Skip to content

NTSB investigations: Grumman G-164A

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

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 ('3952704')) 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 ('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.

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 ('3952704'))
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 LAX82DA271Accident · Minor injuriesFinal reportGrumman G-164A · Chandler, AZWhile spraying at night & during the fourth pass under power lines crossing the field, the acft contacted the wires. After the accident the flagger at the field informed the plt that the wind was causing the wires to whip up & down at times.Jul 21, 1982 · N6559 · Substantial damage NTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…Jul 1, 1982 · N6562 · Substantial damage NTSB ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…Jul 1, 1982 · N7397 · Substantial damage NTSB FTW82FRD14Accident · No injuriesFinal reportGrumman G-164A · Kaplan, LAThe operator reported that the pilot was making a left turn to line up with the flagman when the aircraft stalled and went down into trees. The temperature was reported to be 95 deg. There was no mention of injuries in the operator's accident report…Jun 5, 1982 · N5261 · Destroyed NTSB MKC82DA093Accident · Minor injuriesFinal reportGrumman G-164A · Red Cloud, NEThe aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…Jun 1, 1982 · N5253 · Destroyed NTSB FTW82DA177Accident · No injuriesFinal reportGrumman G-164A · Elreno, OKDuring takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over.May 13, 1982 · N7843 · Destroyed NTSB MKC81DCA20Accident · No injuriesClosedGrumman G-164A · Fagus, MOJul 25, 1981 · N677U · Substantial damage NTSB FTW81FRG53Accident · Serious injuriesClosedGrumman G-164A · Mercedes, TXJul 8, 1981 · N6655 · Destroyed NTSB MIA81DKJ10Accident · No injuriesClosedGrumman G-164A · Vernon, FLJun 22, 1981 · N6545 · Substantial damage NTSB ATL81DKQ17Accident · No injuriesClosedGrumman G-164A · West Point, MSJun 21, 1981 · N6535 · Destroyed NTSB MIA81DKT83Accident · No injuriesClosedGrumman G-164A · Immokalee, FLJun 12, 1981 · N6643 · Destroyed NTSB CHI81FEI18Accident · No injuriesClosedGrumman G-164A · Vanlue, OHMay 29, 1981 · N6540 · Substantial damage NTSB FTW81DPG34Accident · No injuriesClosedGrumman G-164B · Griffithville, ARMay 28, 1981 · N6564 · Destroyed NTSB FTW81DRA27Accident · No injuriesClosedGrumman G-164 · Garwood, TXMay 1, 1981 · N974X · Substantial damage NTSB LAX81DVG27Accident · No injuriesClosedGrumman G164 · Maxwell, CAApr 25, 1981 · N22RA · Substantial damage NTSB FTW81DPD17Accident · Minor injuriesClosedGrumman G-164A · Granbury, TXApr 1, 1981 · N6604 · Substantial damage NTSB FTW80FRG55Accident · No injuriesClosedGrumman G-164A · Weslaco, TXJul 6, 1980 · N7494 · Substantial damage NTSB FTW80DRJ26Accident · No injuriesClosedGrumman G164A · Crowville, LAJun 30, 1980 · N917X · Substantial damage NTSB DEN80FTA13Accident · 1 fatalClosedGrumman G-164A · Sand Springs, MTJun 14, 1980 · N667U · Destroyed NTSB FTW80DPG34Accident · No injuriesClosedGrumman G-164A · Conway, ARJun 8, 1980 · N7957 · Substantial damage NTSB DEN80FTE45Accident · Serious injuriesClosedGrumman G-164A · Delta, COMay 26, 1980 · N5410 · Destroyed NTSB FTW80DPG23Accident · No injuriesClosedGrumman G-164A · Gerrard, ARMay 20, 1980 · N5364 · Substantial damage NTSB SEA80DYM24Accident · Minor injuriesClosedGrumman G-164A · Grass Valley, ORMar 20, 1980 · N4236 · Substantial damage NTSB FTW80DRA19Accident · Minor injuriesClosedGrumman G-164A · Nome, TXFeb 22, 1980 · N4326 · Destroyed NTSB LAX80DVA07Accident · No injuriesClosedGrumman G-164A · Lemoore, CADec 15, 1979 · N4728 · Substantial damage NTSB LAX79FVA02Accident · Serious injuriesClosedGrumman G-164A · Madera, CAOct 17, 1979 · N5250 · Destroyed NTSB MIA80FKJ03Accident · No injuriesClosedGrumman G-164A · Vincent, ALOct 8, 1979 · N4593 · Substantial damage NTSB LAX79DVG68Accident · No injuriesClosedGrumman G-164A · Meridian, CAAug 1, 1979 · N6627 · Substantial damage NTSB MIA79DKQ19Accident · Minor injuriesClosedGrumman G-164A · Minter City, MSJul 26, 1979 · N5258 · Destroyed NTSB DEN79FTM21Accident · No injuriesClosedGrumman G-164A · Richfield, UTJul 21, 1979 · N6589 · Substantial damage NTSB SEA79FYM48Accident · No injuriesClosedGrumman G-164A · Hermiston, ORJul 11, 1979 · N5340 · Substantial damage NTSB MKC79DCA20Accident · No injuriesClosedGrumman G-164A · Clarence, MOJul 10, 1979 · N676U · Destroyed NTSB SEA79DYP32Accident · Serious injuriesClosedGrumman G-164A · Lewiston, IDJul 3, 1979 · N25SK · Substantial damage NTSB FTW79FRD41Accident · No injuriesClosedGrumman G-164A · Basile, LAJun 18, 1979 · N6586 · Substantial damage NTSB OAK79DVA34Accident · No injuriesClosedGrumman G164A · Los Banos, CAMay 25, 1979 · N927X · Destroyed NTSB FTW79DRD32Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAMay 22, 1979 · N6603 · Substantial damage NTSB FTW79DRD31Accident · No injuriesClosedGrumman G-164A · Kaplan, LAMay 22, 1979 · N5262 · Destroyed NTSB OAK79DVG41Accident · Serious injuriesClosedGrumman G-164A · Nchico, CAMay 21, 1979 · N5358 · Destroyed NTSB FTW79DRA23Accident · Minor injuriesClosedGrumman G-164A · Danbury, TXMay 19, 1979 · N5328 · Destroyed NTSB FTW79FPG33Accident · Serious injuriesClosedGrumman G-164A · Piggott, ARMay 5, 1979 · N972X · Destroyed NTSB FTW79DRD25Accident · No injuriesClosedGrumman G-164A · Midland, LAMay 4, 1979 · N5334 · Destroyed NTSB IAD79FLT03Accident · No injuriesClosedGrumman G-164 · Newbern, TNApr 10, 1979 · N6604 · Substantial damage NTSB MIA79FKT51Accident · 1 fatalClosedGrumman G-164A · Clewiston, FLApr 6, 1979 · N6659 · Destroyed NTSB FTW79DPG24Accident · No injuriesClosedGrumman G-164A · Vilonia, ARMar 28, 1979 · N7849 · Substantial damage NTSB FTW79FPD19Accident · No injuriesClosedGrum Amer G-164 · Lake Arthur, LAMar 15, 1979 · N6603 · Substantial damage NTSB MIA78DKQ40Accident · No injuriesClosedGrumman G-164 · Hollybluff, MSSep 20, 1978 · N961X · Destroyed NTSB MIA78DLA47Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 21, 1978 · N5186 · Destroyed NTSB LAX78DA066Accident · No injuriesClosedGrumman G-164 · Pixley, CAAug 10, 1978 · N5368 · Substantial damage NTSB NYC78FFJ32Accident · No injuriesClosedGrumman G-164A · Huron, NYJul 31, 1978 · N6572 · Substantial damage NTSB LAX78FUJ87Accident · 1 fatalClosedGrumman G-164A · Buckeye, AZJul 27, 1978 · N7947 · Destroyed