NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, AL
9 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
| 1980 | 1 |
|---|---|
| 1982 | 3 |
| 1983 | 2 |
| 1994 | 1 |
| 1999 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'AL' 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" = 'AL' 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 ATL07CA018Accident · No injuriesData collectionFinal reportGrumman G-164B · Pine Hill, ALThe pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.NTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.NTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.NTSB ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…NTSB ATL83LA168Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · New Hope, ALThe acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…NTSB ATL82DA276Accident · No injuriesFinal reportGrumman G-164B · Society Hill, ALAircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.NTSB ATL82DA254Accident · No injuriesFinal reportGrumman G164B · Sampson, ALThe aircraft lost power during a swath run, the pilot attempted to lighten the load but the aircraft collided with a tree. When interviewed the pilot stated that the aircraft was sold for salvage. No examination of the engine was possible but he indicated…NTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…NTSB ATL80FKJ26Accident · Serious injuriesClosedGrumman G-164B · Autaugaville, AL