NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, 2001
10 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
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\") = 2001
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") = 2001
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 FTW01LA203Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Lydia, LAthe pilot's failure to maintain clearance with a marked tower while maneuvering.NTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.NTSB SEA01LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Quincy, WAThe failure of the impeller assembly as a consequence of impeller rub and binding within the impeller collector case for undetermined reasons.NTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.NTSB FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA01LA204Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Edison, GAPartial loss of engine power for undetermined reasons during takeoff resulting in the airplane descending, colliding with the ground, and nosing over.NTSB FTW01LA136Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Powhatan, ARthe pilot's failure to maintain obstacle clearance while maneuvering after takeoff.NTSB LAX01LA195Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Butte City, CAa fatigue failure of a propeller bolt.NTSB FTW01LA119Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Rosharon, TXthe pilot's failure to maintain aircraft control while maneuvering. Factors were the weather conditions and the muddy terrain.NTSB MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.