NTSB investigations: Grumman G-164
5 cases on aircraft the registry lists as Grumman G-164, where the first occurrence was “Loss of control - on ground/water”. 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 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 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\" = 260))
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" = 260))
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 FTW93LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe pilot's failure to compensate for the crosswind. A factor was the crosswind.NTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.NTSB MKC87LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Knobel, ARThe PIC stated that the acft was struck by a gust of wind, and he lost control. The PIC applied rt rudder towards a 1OFT ditch in an att to get over it. The acft was too heavy to fly over the ditch and the acft impacted into the ditch. A review of wx cond's…NTSB LAX83LA101Accident · No injuriesLimited investigationFinal reportGrumman G164 · Avenal, CADuring a landing after a spraying operation, the right brake failed and the aircraft collided with a berm before nosing over. The pilot said the right brake failed to keep aircraft on the runway when the rudder became ineffective. The 'o' ring part number an…NTSB LAX82DA187Accident · No injuriesFinal reportGrumman G-164A · Pleasant Grove, CAAs the aircraft slowed during the landing roll, it began to drift right when the rudder became ineffective. The pilot was unable to obtain left braking action to maintain directional control. Subsequently, the right main gear struck a small earth bank and the…