NTSB investigations: Grumman American Avn. AA-5, 1975
19 cases on aircraft the registry lists as Grumman American Avn. AA-5. 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
| 1973 | 4 |
|---|---|
| 1974 | 11 |
| 1975 | 19 |
| 1976 | 13 |
| 1977 | 7 |
| 1978 | 9 |
| 1979 | 10 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 5 |
| 1985 | 5 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1975
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960104'))
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") = 1975
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960104'))
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 MIA76DLD33Accident · No injuriesClosedGrum-Amer AA5 · Orlando, FLNTSB CHI76FEI15Accident · Minor injuriesClosedGrum Amer AA-5 · Wadsworth, OHNTSB DEN76DTC19Accident · No injuriesClosedGrum Amer AA5 · Fort Bridger, WYNTSB DEN76DTE31Accident · No injuriesClosedGrum Amer AA5 · Gilman, CONTSB FTW76FPM09Accident · No injuriesClosedGrum Amer AA5 · Grove, OKNTSB NYC76DFA16Accident · No injuriesClosedGrum Amer AA-5 · Haines Falls, NYNTSB CHI76FET16Accident · No injuriesClosedGrum Amer AA5 · Roanoke, INNTSB CHI76DEP15Accident · No injuriesClosedGrum Amer AA-5 · Necedah, WINTSB FTW76DPA02Accident · Minor injuriesClosedGrum Amer AA5 · Farrah, TXNTSB CHI76AC003Accident · 4 fatalClosedGrum Amer AA-5 · Hammond, WINTSB MIA75DLA49Accident · No injuriesClosedGrum Amer AA-5 · Pensacola, FLNTSB MIA7KAM086Accident · 1 fatalClosedGrum Amer AA-5 · Fajardo, PRNTSB CHI75AC087Accident · Serious injuriesClosedGrum Amer AA-5 · Elwood, INNTSB CHI75FEI47Accident · No injuriesClosedGrum Amer AA-5 · Wadsworth, OHNTSB MIA75FLT06Accident · No injuriesClosedGrum Amer AA-5 · Coldwater, MSNTSB NYC75DNA39Accident · No injuriesClosedGrum Amer AA-5 · Tewksbury, MANTSB LAX75O0021Accident · No injuriesClosedGrum Amer AA5 · Puertecitos, MexicoNTSB NYC75AN094Accident · 2 fatalClosedGrum Amer AA5 · Lucama, NCNTSB CHI75DEE45Accident · No injuriesClosedGrum Amer AA-5 · Polo, IL