NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, GA
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 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 2 |
| 1981 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1998 | 2 |
| 2001 | 1 |
| 2010 | 1 |
| 2012 | 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\" = 'GA' 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" = 'GA' 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 ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.NTSB MIA01LA204Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Edison, GAPartial loss of engine power for undetermined reasons during takeoff resulting in the airplane descending, colliding with the ground, and nosing over.NTSB MIA99LA041Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fort Gains, GAa power loss due to internal damage to the second- and third- stage turbine rotor blades, due to thermal heat, rendering the engine incapable of producing full power, resulting in a forced landing, and subsequent impact with the terrain.NTSB ATL99LA017Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Cuthbert, GAThe fatigue failure of the accessory gear shaft which resulted in fuel starvation and the loss of engine power. A factors was the fuel system filter restriction.NTSB ATL85LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Leesburg, GAThe aircraft suffered a loss of power due to water in fuel and made an emergency landing in a field. During landing roll the aircraft collided with trees at the end of the field.NTSB ATL84FA105Accident · 1 fatalField investigationFinal reportGrumman G-164B · Dawson, GAA failed cylinder head assembly resulted in a total power loss very shortly after takeoff. Witnesses observed the aerial application acft at 30-50 ft AGL over the rwy before it pulled up steeply, rolled and entered a near vertical uncontrolled descent to…NTSB ATL81DLA15Accident · No injuriesClosedGrumman G-164B · Pelham, GANTSB ATL81FKG40Accident · Minor injuriesClosedGrumman G-164 · Hazlehurst, GANTSB ATL81DKG37Accident · No injuriesClosedGrumman G-164B · Preston, GANTSB MIA78FKG52Accident · No injuriesClosedGrumman G-164B · Sylvester, GANTSB MIA78DKG42Accident · No injuriesClosedGrumman G-164B · Sylvester, GANTSB MIA77DKG39Accident · No injuriesClosedGrumman G-164 · Hopeful, GANTSB MIA77DKG05Accident · No injuriesClosedGrumman G-164 · Midville, GA