NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, AZ
16 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
| 1978 | 3 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1995 | 1 |
| 2010 | 2 |
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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
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 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 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 LAX95LA346Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Avondale, AZthe pilot's failure to plan to avoid wake turbulence.NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB LAX91LA332Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Arizona City, AZFailure of the pilot to maintain an adequate visual outlook to avoid the collision with the power transmission lines. Contributing to the accident was the dark night light conditions that prevailed at the time of the accident.NTSB LAX91LA301Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Eloy, AZThe failure of the pilot to maintain the terrain clearance of the aircraft while maneuvering for a potential emergency landing on a moonless dark night.NTSB LAX88DUJ05Accident · Minor injuriesFinal reportGrumman G-164B · Parker, AZDuring an aerial application flight, the pilot dispensed the load and was returning to the airstrip due to an approaching thunderstorm. Enroute, the visibility was reduced to near zero from blowing dust. The pilot lost control of the airplane and collided…NTSB LAX85LA360Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Tolleson, AZAccording to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and…NTSB LAX84LA423Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Maricopa, AZThe plt added fuel and chemicals for a total of about 230 gallons of cargo. The temperature was 87 degrees and the arpt elevation is 1100 ft. the density alt was not computed and performance not assessed. After takeoff in a crosswind turn the acft 'quit…NTSB LAX83LA407Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Poston, AZDuring takeoff from the unlighted strip the acft went off the right side. The right main landing gear went into the softsandy shoulder & the acft flipped over.NTSB LAX83LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Coolidge, AZThe pilot stated that he flew into a dust devil while in a downwind, procedure turn and the aircraft stalled. Reportedly, he dumped his load and applied full power, but he was able to recover before the plane hit the ground, left wing first. The pilot…NTSB LAX81DUJ91Accident · Minor injuriesClosedGrumman G-164B · Tonapah, AZNTSB LAX79FUJ86Accident · No injuriesClosedGrumman G-164B · Poston, AZNTSB LAX79DUJ01Accident · No injuriesClosedGrumman G-164B · Poston, AZNTSB LAX78FUJ75Accident · No injuriesClosedGrumman G-164B · Coolidge, AZNTSB LAX78DUJ28Accident · No injuriesClosedGrumman G-164B · Coolidge, AZ