NTSB investigations: Grumman G-164A, 1974
26 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 | 2 |
|---|---|
| 1967 | 3 |
| 1968 | 4 |
| 1969 | 21 |
| 1970 | 12 |
| 1971 | 17 |
| 1972 | 21 |
| 1973 | 25 |
| 1974 | 26 |
| 1975 | 34 |
| 1976 | 30 |
| 1977 | 23 |
| 1978 | 20 |
| 1979 | 21 |
| 1980 | 8 |
| 1981 | 10 |
| 1982 | 9 |
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 6 |
| 1986 | 9 |
| 1987 | 7 |
| 1988 | 7 |
| 1989 | 4 |
| 1990 | 13 |
| 1991 | 7 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 4 |
| 2009 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2018 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1974
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 year(c."eventDate") = 1974
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 OAK75DVG32Accident · No injuriesClosedGrumman G-164A · Knights Ldg, CANTSB FTW75FRD12Accident · No injuriesClosedGrumman G-164A · Clinton, LANTSB LAX75DUJ34Accident · No injuriesClosedGrumman G-164 · Aguila, AZNTSB MIA75DKQ17Accident · No injuriesClosedGrumman G-164 · Cleveland, MSNTSB FTW75DPG19Accident · No injuriesClosedGrumman G-164A · Almyra, ARNTSB FTW75DPG22Accident · No injuriesClosedGrumman G-164 · Newark, ARNTSB FTW75FPG16Accident · No injuriesClosedGrumman G-164 · Dewitt, ARNTSB MIA75FKG17Accident · No injuriesClosedGrumman G-164A · Perry, GANTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MONTSB MIA75DKG14Accident · No injuriesClosedGrumman G-164A · Edison, GANTSB IAD75DLT02Accident · No injuriesClosedGrumman G-164A · New Castle, TNNTSB LAX75DVA04Accident · No injuriesClosedGrumman G-164A · Ducor, CANTSB FTW75DPG01Accident · No injuriesClosedGrumman G-164A · Walnut Ridge, ARNTSB FTW74FRJ38Accident · Minor injuriesClosedGrumman G-164A · Mer Rouge, LANTSB FTW74FRD41Accident · No injuriesClosedGrumman G-164A · Gueydan, LANTSB FTW74DRD40Accident · Minor injuriesClosedGrumman G-164A · Morrow, LANTSB MIA74DKT80Accident · Serious injuriesClosedGrumman G-164A · Andytown, FLNTSB FTW74FRD39Accident · No injuriesClosedGrumman G-164A · Jennings, LANTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVNTSB MKC74FCA25Accident · No injuriesClosedGrumman G-164A · New Madrid, MONTSB FTW74DRD33Accident · No injuriesClosedGrumman G-164A · Gueydan, LANTSB FTW74DRD32Accident · No injuriesClosedGrumman G-164A · Abbeville, LANTSB FTW74DRD28Accident · Serious injuriesClosedGrumman G-164A · Lake Charles, LANTSB OAK74DVG42Accident · No injuriesClosedGrumman G-164A · Williams, CANTSB OAK74DVM18Accident · No injuriesClosedGrumman G-164 · San Lucas, CANTSB MIA74FLA30Accident · No injuriesClosedGrumman G-164 · Hastings, FL