NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, 1997
8 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\") = 1997
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") = 1997
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 FTW98LA016Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Altus, OKThe loss of engine power due to the cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.NTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.NTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.NTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.NTSB FTW97LA136Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Swifton, ARthe pilot's improper in-flight planning/decision and failure to maintain positive control of the airplane, while performing an aerobatic maneuver.