NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, 1995
14 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\") = 1995
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") = 1995
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 FTW96LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pawnee, OKThe pilot's failure to maintain adequate clearance from the terrain.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.NTSB LAX95LA346Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Avondale, AZthe pilot's failure to plan to avoid wake turbulence.NTSB CHI95LA272Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Wadena, MNthe pilot's inattentiveness during the reversal turn, the pilot not maintaining control of the airplane, and the stall/mush encountered by the pilot.NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.NTSB SEA95LA188Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ephrata, WAThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were crosswinds and gusts.NTSB CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.NTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.NTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.