NTSB investigations: Grumman G-164, GA
16 cases on aircraft the registry lists as Grumman G-164. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1971 | 1 |
| 1973 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1992 | 1 |
| 1996 | 2 |
| 2010 | 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 ('3952702'))
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 ('3952702'))
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 ERA10CA240Accident · No injuriesData collectionFinal reportGrumman G164 · Hampton, GAA total loss of engine power during a go-around due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB ATL96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Montezuma, GAfailure of the pilot to maintain adequate visual look out, while maneuvering on an aerial application run, which result in his failure to see-and-avoid a power line.NTSB ATL96LA110Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer 164 · Bainbridge, GAThe pilot's misjudgment of the clearance from the trees during the swath run that resulted in the collision.NTSB ATL92LA129Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Donalsonville, GAThe pilot's inadequate preflight inspection of the aircraft, and his failure to detect water in the aircraft fuel system.NTSB ATL83FA172Accident · Minor injuriesField investigationFinal reportGrumman G-164A · Albany, GAThe plt was on an instructional flt in aerial application. After completing a simulated swath run, he entered a turn-around maneuver. During the turn, the engine reportedly quit without any warning & the prop stopped turning. During a forced landing, the plt…NTSB MIA79DKG52Accident · No injuriesClosedGrumman G-164 · Fitzgerald, GANTSB MIA74FKG05Accident · No injuriesClosedGrumman G-164 · Fitzgerald, GANTSB MIA72DKG09Accident · No injuriesClosedGrumman G-164 · Carnegie, GANTSB MIA70F0285Accident · Serious injuriesClosedGrumman G-164 · Morgan, GANTSB MIA70F0125Accident · Minor injuriesClosedGrumman G-164 · Arlington, GANTSB MIA70D0293Accident · No injuriesClosedGrumman G-164 · Americus, GANTSB MIA69F0315Accident · No injuriesClosedGrumman G-164 · Edison, GANTSB MIA68F0180Accident · Serious injuriesClosedGrumman G-164 · Blakely, GANTSB MIA67F0054Accident · No injuriesClosedGrumman G-164 · Sasser, GANTSB MIA66F0138Accident · Serious injuriesClosedGrumman G-164 · Shellman, GANTSB UNK64X3995Accident · Minor injuriesClosedGrumman G164 · Shellnan, GA