NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A
652 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, 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 ('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.
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 ('3952801'))
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 FTW82FPG18Accident · Serious injuriesFinal reportGrumman G-164A · Casa, ARThe aircraft collided with rising terrain during a procedure turn. While spraying a rice field.NTSB FTW82DA277Accident · Serious injuriesFinal reportChampion 7AC · Justin, TXThe aerial application aircraft was returning to land when it collided with another aircraft that was on a straight-in final approach. The pilot of the other aircraft stated that he was below and ahead at about 150 feet AGL when the collision occurred. Both…NTSB FTW82DA273Accident · No injuriesFinal reportGrumman G-164A · Mccrory, ARThe agriculture aircraft lost power during takeoff and an emergency forced landing was made in a soybean field. During the landing roll, the aircraft flipped over.NTSB FTW82DA258Accident · Serious injuriesFinal reportGrumman G-164B · Swifton, ARThe pilot was engaged in an aerial application flight over a rice field with multiple high tension wires. At the beginning of a swath run, the aircraft struck power lines and crashed. The pilot had no recollection of the accident.NTSB FTW82DA239Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe pilot had just finished spraying and was on his way back to the airport when the engine failed. A field with grass was selected for an emergency landing. During the landing roll, the aircraft encountered ruts and nosed over. The operator reported that the…NTSB FTW82FRD15Accident · Serious injuriesFinal reportGrumman G-164A · Egan, LAAs the plt was adjusting the powerplant & prop controls the eng accelerated, & at the same time oil covered the windshield. The acft went down into a bean field & flipped over. Disassembly of the eng revealed the rear counterweight trailing pin worn &…NTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…NTSB FTW82DA205Accident · No injuriesFinal reportGrumman G-164A · Angleton, TXWhile concentrating on his flagger, the pilot misjudged his altitude and allowed the aircraft to collide with a levee. The pilot then dumped his load and made an emergency landing, during which time, the aircraft nosed over.NTSB ATL82FIG07Accident · 1 fatalFinal reportGrumman G-164A · Frederick, MDThe pilot reported that 1 to 2 ounces of water was drained from the low point fuel sump, but no water was detected from the other sumps. He stated that he drained the sump until no water was detected. During the flight, the engine surged twice, then lost…NTSB LAX82DA194Accident · Minor injuriesFinal reportGrumman G-164A · Woodland, CAThe aircraft collided with wires and crashed during a crop dusting operation. The aircraft hit wires during a turn at the end of a swath run.NTSB FTW82FPG12Accident · 1 fatalFinal reportGrumman G-164 · Ethel, ARThe acft collided with power lines during the start of a swath run.NTSB MKC82DA085Accident · No injuriesFinal reportGrumman G-164A · Tekamah, NEOn the third spray run the pilot stated that the aircraft engine had a loss of power. He attempted to fly back to the airport but was forced to make an emergency landing in an open field. During the landing roll the aircraft nosed over in the soft mud. Engine…NTSB FTW82DA187Accident · No injuriesFinal reportGrumman G-164A · Pine Bluff, ARDuring landing the right main landing gear dropped into a ditch alongside the runway and the aircraft nosed over.NTSB FTW82DA179Accident · Minor injuriesFinal reportGrumman G-164A · Farmington, NMOn takeoff for an aerial application flight at maximum gross weight the aircraft began to settle. The aircraft impacted the ground in a slightly nose-down attitude. Investigation revealed the accident site elevation was 5300 feet MSL and the takeoff was made…NTSB FTW82DA169Accident · No injuriesFinal reportGrumman G164A · Welsh, LADuring the initial takeoff with a load of fertilizer the engine lost power and the load was dumped. A forced landing wasmade in a plowed, wet field and the aircraft nosed over. Investigation revealed the cylinder head failed.NTSB FTW82DA160Accident · No injuriesFinal reportGrumman G-164A · Oberlin, LAThe pilot reported that during landing, his left brake failed. He elected to go-around. However, while maneuvering to avoid a building, the aircraft struck a rice dike and crashed. The pilot reported that the left brake thrust plate had broken during the…NTSB SEA82DA058Accident · No injuriesFinal reportGrumman G-164A · S. Of Echo, ORDuring a spray run the pilot experienced a power loss. After pulling up to 100 feet AGL and turning 90 degrees the engine ceased to operate. The pilot completed a forced landing in a nearby soft wheat field and after rolling approximately 300 feet the…NTSB FTW82DRJ04Accident · Minor injuriesClosedGrumman G-164A · Elm Grove, LANTSB CHI81DEV35Accident · Minor injuriesClosedGrumman G-164A · Dana, INNTSB CHI81DEV32Accident · No injuriesClosedGrumman G-164A · Hudson, ILNTSB MKC81FCA22Accident · No injuriesClosedGrumman G-164A · Fisk, MONTSB FTW81DPG58Accident · No injuriesClosedGrumman G-164A · Piggott, ARNTSB LAX81FVA55Accident · No injuriesClosedGrumman G-164A · Caruthers, CANTSB CHI81FEM30Accident · No injuriesClosedGrumman G-164A · Howard City, MINTSB FTW81DPD32Accident · No injuriesClosedGrumman G-164A · Vernon, TXNTSB DEN81DTM40Accident · No injuriesClosedGrumman AG-CAT · Park Valley, UTNTSB LAX81DVG47Accident · No injuriesClosedGrumman G-164 · Colusa, CANTSB CHI81FEX20Accident · No injuriesClosedGrumman G-164A · Remington, INNTSB LAX82FVA47Accident · Serious injuriesClosedGrumman G-164A · Pixley, CANTSB FTW81FPG45Accident · 1 fatalClosedGrumman G-164A · Lonoke, ARNTSB FTW81DPG46Accident · No injuriesClosedGrumman G-164 · Holly Grove, ARNTSB FTW81DPG42Accident · No injuriesClosedGrumman G-164A · Wilson, ARNTSB FTW81FPG40Accident · No injuriesClosedGrumman G-164B · Wynne, ARNTSB FTW81DRJ18Accident · No injuriesClosedGrumman G-164A · Bonita, LANTSB FTW81FRD28Accident · No injuriesClosedGrumman G-164A · Morse, LANTSB FTW81DRD26Accident · No injuriesClosedGrumman G-164A · Iowa, LANTSB FTW81FRA36Accident · No injuriesClosedGrumman G-164A · Garwood, TXNTSB FTW81DRD23Accident · No injuriesClosedGrumman G-164A · Kinder, LANTSB FTW81FRA25Accident · No injuriesClosedGrumman G-164A · Rosharon, TXNTSB LAX81DVG26Accident · No injuriesClosedGrumman G-164 · Liberty Island, CANTSB FTW81DRD17Accident · No injuriesClosedGrumman G-164A · Lake Charles, LANTSB FTW81DRG29Accident · No injuriesClosedGrumman G-164A · San Saba, TXNTSB LAX81DVA08Accident · No injuriesClosedGrumman G-164A · Bakersfield, CANTSB FTW81DPG01Accident · No injuriesClosedGrumman G-164A · Sherrill, ARNTSB FTW80FRA51Accident · No injuriesClosedGrumman G-164A · Winnie, TXNTSB ATL80FKQ22Accident · No injuriesClosedGrumman G-164 · Clarksdale, MSNTSB ATL80FA080Accident · No injuriesClosedGrumman G-164A · Samson, ALNTSB FTW80DRD51Accident · No injuriesClosedGrumman G-164A · Kinder, LANTSB FTW80DPG50Accident · No injuriesClosedGrumman G-164A · Tuckerman, ARNTSB ATL80FLQ22Accident · No injuriesClosedGrumman G-164A · Garfield, KY