NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B
23 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164B, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB DFW06CA113Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · De Witt, ARThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the gusty winds.NTSB DFW05CA212Accident · No injuriesData collectionFinal reportGrumman G164B · Alexandria, LAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.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 FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB FTW99LA134Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164-B · Garwood, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A related factor was the high density altitude.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.NTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.NTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.NTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.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 CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.NTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.NTSB LAX94LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Chico, CAthe failure of the pilot to obtain/maintain sufficient flying speed during a downwind takeoff and climb, compounded by his reluctance to use full available takeoff power.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 DEN89LA160Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Holden, UTThe pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.NTSB MKC87LA095Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARThe acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80…NTSB CHI85LA265Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Thief River Fl, MNThe acft collided with the ground shortly after takeoff about 800 ft from the end of the rwy. The plt stated that at about 5 pt afl the acft stalled and fell into a field off the end of the rwy.NTSB MKC84LA148Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Humnoke, ARPlt stated he noticed a vibration in the acft on two flts prior to the accident flt. Plt felt forward pressure on the stick so he attempted to trim the acft. The acft nosed forward colliding with the terrain. Inspection disclosed no preimpact…NTSB LAX84LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAAt about 75 ft AGL in a procedure turnaround the acft stalled & collided with orange trees.NTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…NTSB MKC82DA116Accident · No injuriesFinal reportGrumman G164A · Ericson, NEThe aircraft was flown from the loading area to the field intended for treatment. Upon arrival, the pilot reduced power and entered an observation fly-by. When the aircraft started to settle the pilot's application of power failed to arrest the descent. The…