NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, FL
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
| 1977 | 1 |
|---|---|
| 1978 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 2016 | 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\" = 'FL' 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" = 'FL' 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 ERA16LA130Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Myakka, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB MIA91LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Clewiston, FLDisintegration of the impeller for undetermined reasons resulting in the total loss of engine power necessitating the forced landing.NTSB MIA89TL#07Accident · No injuriesClass 3Final reportGrumman G-164B · Mims, FLNTSB MIA87LA254Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Bristol, FLThe eng began losing power as the plt was en route to spray a field. He was unable to maintain altitude, dumped the load of chemicals & prepared for an emerg landing. While he was attempting to reach an open field, the acft collided with 100 foot trees, then…NTSB MIA84LA060Accident · Minor injuriesLimited investigationFinal reportGrumman AG-CAT · Homestead, FLThe acft crashed during a forced landing after the engine lost power. Investigation revealed that that # 8 cylinder failed. The original cracking was determined to be from fatigue.NTSB MIA83LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Altha, FLThe plt stated that the eng began losing power during an aerial application mission. Subsequently, he landed in a muddy field & the acft nosed over. He stated that the indupartial loss of power.NTSB MIA78DKJ89Accident · Minor injuriesClosedGrumman G-164B · Vernon, FLNTSB MIA78FKJ77Accident · No injuriesClosedGrumman G-164B · Altha, FLNTSB MIA78DKT21Accident · No injuriesClosedGrumman G-164B · Clewiston, FL