Fatal NTSB investigations: Grumman G-164A
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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1990 | 2 |
| 1997 | 2 |
| 2006 | 1 |
| 2008 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.NTSB SEA97LA099Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Rosalia, WAThe pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB NYC90DHA01Accident · 1 fatalFinal reportGrumman G-164A · Hunlock Creek, PAThe pilot's failure to maintain adequate clearance from obtacles, and his failure to see and avoid the electrical transmission line.NTSB DEN80FTA13Accident · 1 fatalClosedGrumman G-164A · Sand Springs, MTNTSB MIA79FKT51Accident · 1 fatalClosedGrumman G-164A · Clewiston, FLNTSB LAX78FUJ87Accident · 1 fatalClosedGrumman G-164A · Buckeye, AZNTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LANTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSNTSB SEA76FYG49Accident · 1 fatalClosedGrumman G-164A · Oakesdale, WANTSB LAX76FVA47Accident · 1 fatalClosedGrumman G-164A · Bakersfield, CANTSB MKC75FCA22Accident · 1 fatalClosedGrumman G-164A · Laforge, MONTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MONTSB SEA72AS005Accident · 2 fatalClosedCallair A-9 · Nyssa, ORNTSB OAK71FVA24Accident · 1 fatalClosedGrumman G-164A · Kerman, CA