NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, 1987
11 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 per year
| 1976 | 4 |
|---|---|
| 1977 | 16 |
| 1978 | 24 |
| 1979 | 13 |
| 1980 | 23 |
| 1981 | 23 |
| 1982 | 14 |
| 1983 | 17 |
| 1984 | 16 |
| 1985 | 5 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 11 |
| 1989 | 14 |
| 1990 | 14 |
| 1991 | 13 |
| 1992 | 10 |
| 1993 | 14 |
| 1994 | 18 |
| 1995 | 14 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 11 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 1 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 2 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 13 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 3 |
| 2023 | 6 |
| 2024 | 4 |
| 2025 | 1 |
Where
Latest 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 ('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 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 ('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 LAX87DVA12Accident · No injuriesFinal reportGrumman G164B · Buttonwillow, CADuring an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed…NTSB MIA87LA254Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Bristol, FLThe eng began losing power as the plt was en route to spray a field. He was unable to maintain altitude, dumped the load of chemicals & prepared for an emerg landing. While he was attempting to reach an open field, the acft collided with 100 foot trees, then…NTSB MKC87LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Holly Grove, ARThe pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures.NTSB FTW87DRD14Accident · No injuriesFinal reportGrumman G-164B · Oak Grove, LAAfter completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the…NTSB LAX87DVA10Accident · No injuriesFinal reportGrumman G-164B · Taft, CADuring a repositioning flight, the plt landed the aircraft on a dirt road. During the landing roll the left wing struck an irrigation standpipe. The aircraft turned rapidly which collapsed the main landing gear. There were no mechancial failures or…NTSB FTW87DRA06Accident · No injuriesFinal reportGrumman G-164B · Beaumont, TXDrg the initial climb after takeoff, the eng began losing RPM & the plt was unable to return to the arpt. He selected a pasture area for an emerg landing, but the eng contd losing power. While landing on soft terrain with tall wet grass, the acft nosed over.…NTSB MKC87LA133Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mcdougal, ARThe ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total…NTSB FTW87DRA03Accident · No injuriesFinal reportGrumman G-164B · Egypt, TXAcft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in…NTSB MKC87LA095Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARThe acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80…NTSB LAX87DVG03Accident · No injuriesFinal reportGrumman G-164B · Marysville, CAAt the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded…NTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.