NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, 2010
13 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\") = 2010
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") = 2010
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 ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.NTSB CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.NTSB WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.NTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.NTSB CEN10CA426Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Alexandria, LAThe loss of engine power for undetermined reasons.NTSB CEN10CA402Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Independence, IAThe pilot's failure to pay attention to the power lines and his subsequent failure to maintain clearance from the corn field during the aerial application flight.NTSB CEN10CA386Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Chillicothe, MOThe pilot's failure to maintain aircraft control during takeoff.NTSB ERA10CA313Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Mayfield, KYThe pilot's improper recovery from a bounced landing, resulting in a nose-over.NTSB WPR10CA289Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Courtland, CAThe pilot's failure to maintain clearance from terrain during low-altitude maneuvers.NTSB WPR10LA212Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZA partial loss of engine power during the takeoff roll for undetermined reasons.NTSB CEN10CA201Accident · No injuriesData collectionFinal reportGrumman G-164B · Forest City, MOThe pilot's failure to maintain aircraft control during landing, which resulted in an encounter with wet/muddy terrain and a subsequent nose over.NTSB WPR10LA139Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colfax, WAA partial loss of engine power due to carburetor ice as a result of the pilot's failure to use carburetor heat.NTSB WPR10LA122Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAA partial loss of engine power during takeoff due to a bird's nest being sucked into the induction air ducting.