NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, 1990
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\") = 1990
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") = 1990
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 FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.NTSB LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB LAX90DVA04Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Buttonwillow, CAFailure of the #7 cylinder due to a pre-existing crack. The terrain condition was a related factor.NTSB FTW90DRD10Accident · No injuriesFinal reportGrumman G-164B · Mamou, LAPilot misjudged wind information. Factors contributing to the accident were the tailwind, the trees and the levee.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB FTW90DRD08Accident · No injuriesFinal reportSchweizer G-164B · Basile, LAThe pilot's inadequate evaluation of the weather information. A related factor to the accident was the tailwind.NTSB LAX90DVG08Accident · No injuriesFinal reportSchweizer G-164-B · Richvale, CAThe pilot in command's failure to maintain a positive rate of climb during takeoff resulting in the aircraft descending into terrain.NTSB LAX90DUG05Accident · 1 fatalFinal reportGrumman G-164B · Blythe, CAFailure of the pilots of N6708K and N10222 to maintain adequate visual lookout and failure of the pilot of N6708K to follow a prearanged procedure for reversing the direction of flight.NTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.NTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.NTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.NTSB FTW90DPA01Accident · No injuriesFinal reportGrumman G-164B · Bonham, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.