NTSB investigations: Grumman G-164, MS
14 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1969 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1987 | 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 ('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" = '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 ('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 MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…NTSB ATL83LA210Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Alligator, MSThe acft collided with the terrain during an turn to reverse direction on an aerial application flt. The plt said he encountered a wind shear during the turn and was unable to arrest the descent. The acft impacted on the main gear and was substantially…NTSB ATL81DKQ25Accident · No injuriesClosedGrumman G-164 · Rochdale, MSNTSB ATL80FLT09Accident · No injuriesClosedGrumman G-164 · Olive Branch, MSNTSB MIA78FKQ38Accident · No injuriesClosedGrumman G-164 · Philipp, MSNTSB MIA76FKQ41Accident · No injuriesClosedGrumman G-164 · Minter City, MSNTSB MIA75DKQ06Accident · No injuriesClosedGrumman G-164 · Rolling Fork, MSNTSB MIA73DKQ16Accident · No injuriesClosedGrumman G-164 · Monticello, MSNTSB MIA73FKQ02Accident · No injuriesClosedGrumman G-164 · Philipp, MSNTSB MIA69F0436Accident · No injuriesClosedGrumman G-164 · Drew, MSNTSB MIA67D0525Accident · No injuriesClosedGrumman G-164 · Shelby, MSNTSB MIA67F0110Accident · No injuriesClosedGrumman G-164 · Lodi, MSNTSB MIA67F0112Accident · No injuriesClosedGrumman G-164 · Sand Hill, MSNTSB MIA66F0194Accident · No injuriesClosedGrumman T-G164 · Charleston, MS