NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B
426 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164B. 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, newest first
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952802'))
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 ('3952802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA83LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Klamath Falls, ORThe acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and…NTSB MIA83LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Altha, FLThe plt stated that the eng began losing power during an aerial application mission. Subsequently, he landed in a muddy field & the acft nosed over. He stated that the indupartial loss of power.NTSB DEN83LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Page, NDWhile spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…NTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…NTSB FTW83LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kaplan, LAWhile departing from a private strip, the plt took off to the north in calm winds. When he returned to land, the wind had begun blowing from the southwest at 20 KTS; thus, he elected to land toward the south. A truck was parked at the apch end of the strip,…NTSB LAX83LA222Accident · No injuriesLimited investigationFinal reportGrumman 164B · Lodi, CAThe aircraft was rolling for takeoff at dawn when it collided with another crop duster taxiing in the opposite directionthe aircraft taking off had rolled about 100 feet when the pilot saw a red light on the runway and aborted the takeoff and attempted to…NTSB ATL83LA168Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · New Hope, ALThe acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…NTSB LAX83LA172Accident · Minor injuriesLimited investigationFinal reportGrumman American G164-B · Near Madera, CAThe acft hit a chuck hole in high grass during takeoff roll from a field for an aerial application mission. The left landing gear separated from the acft. The weather was VMC and no flight plan was filed. The pilot sustained minor injuries. The flight was…NTSB SEA83LA063Accident · No injuriesLimited investigationFinal reportGrumman 164B · Toppenish, WAThe aircraft nosed over in a ditch during a landing on a gravel road after an aerial application flight. The pilot said that he lost directional control during landing rollout and one main gear went into a ditch. The aircraft then nosed over and came to rest…NTSB LAX83LA057Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Westley, CAThe acft collided with a dirt berm during a swath run tearing off both main landing gear. The acft continued to fly & an emergency landing was made at crow's landing nas. The plt attributed his inability to maintain sufficient ground clearance to the haze &…NTSB LAX83LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Coolidge, AZThe pilot stated that he flew into a dust devil while in a downwind, procedure turn and the aircraft stalled. Reportedly, he dumped his load and applied full power, but he was able to recover before the plane hit the ground, left wing first. The pilot…NTSB ATL83LA004Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Rowland, NCThe aircraft was being ferried to a nearby airport for winter storage. Immediately after takeoff, the engine began running rough and RPM was lost. The pilot turned and landed in a plowed field where the aircraft nosed over during the landing roll. The pilot…NTSB LAX82DA365Accident · No injuriesFinal reportGrumman G-164B · Delano, CAAircraft collided with wires during spraying of grapes. No air or ground survey made which was a normal procedure. Work pressure created the deviation.NTSB ATL82DA276Accident · No injuriesFinal reportGrumman G-164B · Society Hill, ALAircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.NTSB ATL82DA254Accident · No injuriesFinal reportGrumman G164B · Sampson, ALThe aircraft lost power during a swath run, the pilot attempted to lighten the load but the aircraft collided with a tree. When interviewed the pilot stated that the aircraft was sold for salvage. No examination of the engine was possible but he indicated…NTSB DEN82DA157Accident · No injuriesFinal reportCessna 172 · Grafton, NDThe pilot stated that when he began to taxi he noticed a Cessna 172 with its engine running in front of a hangar, about 500 feet ahead and to his left. Continuing his taxi, the pilot's attention was diverted by an aircraft on the right. When he looked forward…NTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…NTSB FTW82DA287Accident · No injuriesFinal reportGrumman G-164B · Humnoke, ARThe pilot reported that during takeoff, the left main gear got off the side of the rough airstrip and into a rice field. Subsequently, the plane flipped over.NTSB FTW82DA279Accident · No injuriesFinal reportGrumman G-164B · Beedeville, ARThe pilot proceeded to the job site with a load of urea. He circled for about 15 minutes waiting for the flagmen to arrive, then elected to return to the airport. As he leveled the plane, he experienced a gradual loss of power and was unable to maintain…NTSB MKC82DA116Accident · No injuriesFinal reportGrumman G164A · Ericson, NEThe aircraft was flown from the loading area to the field intended for treatment. Upon arrival, the pilot reduced power and entered an observation fly-by. When the aircraft started to settle the pilot's application of power failed to arrest the descent. The…NTSB FTW82DRA22Accident · Serious injuriesFinal reportGrumman G-164 · Hardin, TXThe pilot reported that he struck power lines while flying under them during a swath run. Also, he indicated that a thunderstorm was rapidly approaching the field at the time the accident occurred.NTSB FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.NTSB LAX82DVA12Accident · No injuriesFinal reportGrumman G-164B · Valley Home, CAThe pilot reported that during takeoff, there was a partial loss of engine power and the aircraft settled back to the ground. The aircraft touched down on soft terrain about 1/4 mile from the runway and flipped over. The aircraft caught on fire and burned…NTSB ATL81DLA15Accident · No injuriesClosedGrumman G-164B · Pelham, GANTSB LAX81DUJ91Accident · Minor injuriesClosedGrumman G-164B · Tonapah, AZNTSB LAX81DVD39Accident · Serious injuriesClosedGrumman G-164B · Tracy, CANTSB DEN81FTK20Accident · Minor injuriesClosedGrumman G-164B · Platte, SDNTSB ATL81FKG40Accident · Minor injuriesClosedGrumman G-164 · Hazlehurst, GANTSB FTW81DRD39Accident · No injuriesClosedGrumman G-164B · Mowata, LANTSB MKC81DCJ25Accident · Serious injuriesClosedGrumman G-164B · Ewing, NENTSB ATL81DKG37Accident · No injuriesClosedGrumman G-164B · Preston, GANTSB FTW81DRJ21Accident · No injuriesClosedGrumman G-164B · Shreveport, LANTSB FTW81FQG40Accident · No injuriesClosedGrumman G-164B · Springlake, TXNTSB LAX81FVG41Accident · No injuriesClosedGrumman G-164 · Davis, CANTSB SEA81FYP18Accident · 1 fatalClosedGrumman G-164B · Harrison, IDNTSB FTW81DPG28Accident · No injuriesClosedGrumman G-164B · Lexa, ARNTSB FTW81DA093Accident · 2 fatalClosedGrumman G-164B · Danbury, TXNTSB CHI81DER36Accident · No injuriesClosedGrumman G-164B · Angus, MNNTSB FTW81DRJ13Accident · No injuriesClosedGrumman G-164B · Mer Rouge, LANTSB FTW81DRD22Accident · No injuriesClosedGrumman G-164B · Swords, LANTSB FTW81FPJ16Accident · No injuriesClosedGrumman G-164B · Billings, OKNTSB ATL81FLT06Accident · No injuriesClosedGrumman G-164B · Brownsville, TNNTSB DEN81FTE27Accident · No injuriesClosedGrumman G-164B · Yellow Jacket, CONTSB LAX81DVA29Accident · No injuriesClosedGrumman G-164B · Farmington, CANTSB FTW81FRA22Accident · Serious injuriesClosedGrumman G-164B · Lissie, TXNTSB FTW81DPG10Accident · No injuriesClosedGrumman G-164B · Carlisle, ARNTSB ATL80FLG01Accident · No injuriesClosedGrumman G-164B · Kingstree, SCNTSB ATL80DKW03Accident · No injuriesClosedGrumman G-164B · Portland, TNNTSB MKC80DCQ30Accident · No injuriesClosedGrumman G-164B · Cimarron, KSNTSB CHI80FET24Accident · No injuriesClosedGrumman G-164 · Howe, IN