NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, 1987
18 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\") = 1987
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") = 1987
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 FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…NTSB FTW87DQG03Accident · Serious injuriesFinal reportSchweizer G-164-A · Seminole, TXDuring the flare for landing on a county road the aircraft collided with a pickup truck traveling in same direction as the aircraft. The driver of the pickup sustained serious injuries. The pilot was not injured. The pilot stated he did not see the pickup…NTSB FTW87DRD11Accident · 1 fatalFinal reportGrumman G-164A · Bastrop, LAThree flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the…NTSB DEN87DTE03Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Springfield, COThe plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a…NTSB ATL87DKG05Accident · No injuriesFinal reportSchweizer G-164A · Summerdale, ALThe pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine…NTSB DEN87LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Romeo, COThe plt reports that the acft encountered a downdraft during the turn around following a swath run. The aircraft began to settle and collided with the ground, bounced, hit a second time and nosed over. The aircraft was loaded with 280 gals of amine and 70…NTSB MIA87LA211Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Greenwood, MSShortly after takeoff from a 1,800 ft grass strip on a 93 degree f day, the acft, loaded with 1,500 pounds of chemical, began to settle. It then touched down in a field, nosed over & came to rest inverted. The plt stated there was no eng failure or…NTSB MKC87LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Forrest City, ARWhile doing a repositioning operation, with an ag acft, the engine quit, due to fuel exhaustion. The PIC said that a visual inspection of the fuel supply would have prevented the accident. He said that in an attempt to turn back to a dirt strip, the acft…NTSB FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…NTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…NTSB MKC87LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Neelyville, MOThe ag pilot was making a low pass to wave his flagman out of the field. The engine response was slow and he was forced to land. To keep from hitting trees, pilot overbraked and flipped airplane forward to inverted position.NTSB MIA87LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vaiden, MSThe plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with…NTSB FTW87DRD05Accident · No injuriesFinal reportGrumman G-164 · Kaplan, LAThe plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.…NTSB MIA87FA160Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Dundee, MSWhile spraying a rice field, the acft was flying across svrl small dirt banks that had been furrowed for water ctl. Drg a swath run, it struck 3 furrowed banks that were close together, flipped over as it crashed, then burned. Witnessesrprtd the eng was…NTSB LAX87DVG07Accident · No injuriesFinal reportGrumman G-164A · Lambertsville, CAThe pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during…NTSB DEN87FA091Accident · 1 fatalField investigationFinal reportGrumman G-164A · Lamar, COThe aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and…NTSB DEN87LA087Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · La Salle, COWhile conducting an aerial application flt, the plt misjudged the distance to the end of the field and initiated the pull-up too late to avoid impact with a tree. After striking the tree, the acft descended out of control until impact with the ground.NTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…