NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, 1986
12 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 per year
| 1971 | 1 |
|---|---|
| 1972 | 11 |
| 1973 | 15 |
| 1974 | 22 |
| 1975 | 31 |
| 1976 | 41 |
| 1977 | 38 |
| 1978 | 41 |
| 1979 | 35 |
| 1980 | 25 |
| 1981 | 25 |
| 1982 | 22 |
| 1983 | 19 |
| 1984 | 24 |
| 1985 | 14 |
| 1986 | 12 |
| 1987 | 18 |
| 1988 | 22 |
| 1989 | 23 |
| 1990 | 11 |
| 1991 | 17 |
| 1992 | 21 |
| 1993 | 17 |
| 1994 | 12 |
| 1995 | 19 |
| 1996 | 15 |
| 1997 | 8 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 10 |
| 2006 | 5 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 6 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 3 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 3 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1986
AND 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 year(c."eventDate") = 1986
AND 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 MIA87FA022Accident · 1 fatalField investigationFinal reportGrumman G-164A · Orlando, FLWhile the plt was making a banner pick-up, witnesses saw the acft engage the banner & enter a climb. The plt released the banner, then the acft mushed into a partially built hangar, crashed & burned. The plt, who was on fire, exited the rgt canopy hatch.…NTSB MKC86LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bayard, NEThe plt stated he encountered downdrafts near trees he was going to overfly while in a turnaround maneuver to spray crops. Instead of flying over the trees, the plt stated that the acft descended into the ground near the trees while in the turn. Wind…NTSB ATL86FKG10Accident · Minor injuriesFinal reportGrumman American G-164A · Quitman, GAShortly after takeoff a loss of pwr was experienced. The plt attempted to land in a cotton field but the landing gear contacted a stump short of the field. The acft then contacted a ditch and nosed over. Post accident inspection revealed the supercharger…NTSB MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…NTSB FTW86LRD18Accident · No injuriesFinal reportGrumman G-164A · Bastrop, LAThe acft came to rest inverted with the engine under water after a power loss and forced landing. The plt stated that he started losing power in the turn to line up for his first aerial application run. The acft settled to ground impact in a landing attitude…NTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.NTSB MKC86LA114Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Winona, KSThe pilot stated that he borrowed the airplane from his father to practice takeoffs and landings at his father's private, crop dusting airstrip. There were no chemicals onboard, according to the pilot. He further stated that on a go-around maneuver, and as he…NTSB FTW86LRD14Accident · No injuriesFinal reportGrumman G-164A · Guedan, LAThe pilot lost engine power at an altitude of about 150 feet AGL following takeoff. He impacted a raised roadbed during the forced landing, flipped inverted, slid to a stop, and burned. The fire damage prevented determination of the cause of engine failure.NTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…NTSB LAX86DVA05Accident · No injuriesFinal reportGrumman G164A · Snelling, CAThe plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The…NTSB FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…