NTSB investigations: Grumman G-164A, MS
17 cases on aircraft the registry lists as Grumman G-164A. 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
| 1966 | 1 |
|---|---|
| 1971 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1996 | 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\" = 'MS' 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 ('3952704'))
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" = 'MS' 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 ('3952704'))
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 MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.NTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.NTSB MIA86LA198Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Okolona, MSWhile in cruise flt at 100 feet en route to the spraying area the engine 'spit' twice and quit completely. During a forced landing in a field the aircraft encountered mud and nosed over coming to rest inverted. The engine had 100 hours before it was to be…NTSB ATL83LA260Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Hazlehurst, MSThe acft collided with a tree and the ground shortly after takeoff with a heavy load on a hot day. The acft had 1600 lbsof dry fertilizer, 42 gallons of fuel for takeoff. The plt stated he got into 'downdrafts' in the rolling hills and he jettisoned the load…NTSB ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…NTSB ATL81DKQ17Accident · No injuriesClosedGrumman G-164A · West Point, MSNTSB MIA79DKQ19Accident · Minor injuriesClosedGrumman G-164A · Minter City, MSNTSB MIA78DKQ40Accident · No injuriesClosedGrumman G-164 · Hollybluff, MSNTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSNTSB MIA76FKQ23Accident · No injuriesClosedGrumman G-164A · Holly Bluff, MSNTSB MIA75FKQ27Accident · No injuriesClosedGrumman G-164A · Edwards, MSNTSB MIA75DKQ17Accident · No injuriesClosedGrumman G-164 · Cleveland, MSNTSB MIA73FKQ02Accident · Serious injuriesClosedGrumman G-164A · Charleston, MSNTSB MIA73FKQ29Accident · No injuriesClosedGrumman G-164A · Minter City, MSNTSB MIA72FKQ18Accident · No injuriesClosedGrumman G-164A · Oakland, MSNTSB MIA72FKQ09Accident · No injuriesClosedGrumman G-164A · Swan Lake, MSNTSB MIA66F0592Accident · No injuriesClosedGrumman G164A · Exingtom, MS