NTSB investigations: Grumman G-164
9 cases on aircraft the registry lists as Grumman G-164, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1987 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952702')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952702')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX03LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Hamilton City, CAThe pilot's failure to maintain adequate airspeed to avert stalling during a low altitude turn.NTSB CHI02CA194Accident · No injuriesData collectionFinal reportGrumman G-164 · Browning, ILthe failure of the pilot-in-command to maintain sufficient airspeed while maneuvering. The initial stages of a stall/mush condition, and the low maneuvering altitude due to the agricultural application pass, were contributing factors.NTSB FTW98LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Huntington, UTThe pilot's failure to maintain adequate airspeed.NTSB FTW95LA328Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe inadvertent stall as a result of the pilot's failure to maintain airspeed during the approach.NTSB MKC87LA107Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Newport, ARThe pilot stated that he was spraying a rice field in formation with another airplane when his aircraft experienced an inflight upset due to the propwash, or wake turbulence, generated by the other aircraft. The landing gear struck a rice levee and was…NTSB MIA84FA051Accident · 1 fatalField investigationFinal reportGrumman C-164 · South Bay, FLAs the acft initiated a turn to start dusting, it was observed to lose altitude rapidly & collide with the ground. The acft was 470 lbs over max gross takeoff weight. The area was affected by gusty winds from the south, & the plt's initial turn to the field…NTSB DEN83LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Yuma, COThe acft was observed to turn shortly after lift-off at a very low altitude. It then maneuvered to a climb attitude, but as the acft pitched nose up the eng noise was heard to get louder. The acft settled in a nose high attitude, struck powerlines & fell to…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 LAX82DVG25Accident · Serious injuriesFinal reportGrumman G-164 · Richvale, CADuring a procedure turn of the swath run the pilot stated he was low and slow and collided with powerlines. The aircraft crashed and burned.