NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A
17 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164A, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 3 |
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 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 ('3952801')
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\" = 353))
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 ('3952801')
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" = 353))
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 FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.NTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…NTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.NTSB ATL93LA084Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamilton, ALThe pilot's failure to properly calculate fuel consumption at an increased power setting, which resulted in fuel exhaustion and loss of engine power. Trees at the forced landing area were a factor in the accident.NTSB FTW90DPG03Accident · No injuriesFinal reportGrumman G164-A · Rondo, ARThe power loss for undetermined reasons.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.NTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.NTSB DEN87DTE03Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Springfield, COThe plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a…NTSB MKC87LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Forrest City, ARWhile doing a repositioning operation, with an ag acft, the engine quit, due to fuel exhaustion. The PIC said that a visual inspection of the fuel supply would have prevented the accident. He said that in an attempt to turn back to a dirt strip, the acft…NTSB LAX87DVG07Accident · No injuriesFinal reportGrumman G-164A · Lambertsville, CAThe pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during…NTSB MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…NTSB FTW85LA309Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tallulah, LADuring an aerial application operation, the eng lost power & the plt made an emergency landing in a soy bean field. While on the landing roll, the acft nosed over. The operator reported that he did not see or smell any fuel around the acft; he believed that…NTSB ATL85LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Athens, ALDuring an aerial application flight the aircraft lost power due to fuel exhaustion. The pilot made an emergency landing in a corn field. The pilot stated that he visually checked the fuel prior to take off and it appeared as if there was enough fuel to…NTSB LAX84LA474Accident · No injuriesLimited investigationFinal reportGrumman 164A · Goodyear, AZPlt reported pwr loss occurred during night aerial application. Acft nosed over during forced landing in crop field. Investigation failed to reveal any evidence of a mechanical failure/malfunction. Engine was test run to extent permitted by damage and no…NTSB ATL83LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Estill, SCDuring a swath run, the acft began to lose power, so the plt aborted the mission & started back to the arpt to land. However, before reaching the arpt, the eng quit running & the plt landed in a field. During the landing, the acft was extensively damaged. An…NTSB ATL82FIG07Accident · 1 fatalFinal reportGrumman G-164A · Frederick, MDThe pilot reported that 1 to 2 ounces of water was drained from the low point fuel sump, but no water was detected from the other sumps. He stated that he drained the sump until no water was detected. During the flight, the engine surged twice, then lost…