NTSB investigations: Grumman American Avn. AA-5B, 1978
17 cases on aircraft the registry lists as Grumman American Avn. AA-5B. 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
| 1975 | 3 |
|---|---|
| 1976 | 3 |
| 1977 | 8 |
| 1978 | 17 |
| 1979 | 8 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 9 |
| 1983 | 4 |
| 1984 | 10 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 2 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 4 |
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\") = 1978
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960105'))
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") = 1978
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960105'))
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 NYC79FNA09Accident · No injuriesClosedGrumman AA-5B · Tewksbury, MANTSB MIA79FA024Accident · 1 fatalClosedGrumman AA-5B · Marianna, FLNTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNTSB MIA79F1D09Accident · Serious injuriesClosedGrumman AA-5B · Vero Beach, FLNTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WANTSB NYC78FFJ37Accident · Minor injuriesClosedGrum Amer AA-5B · Cortland, NYNTSB NYC78FGT15Accident · No injuriesClosedGrum Amer AA-5B · Marietta, PANTSB MKC78FA060Accident · 4 fatalClosedAmer Avco AA-5B · North Bend, NENTSB MKC78DER80Accident · No injuriesClosedAmer Avco AA-5B · Cook, MNNTSB CHI78FET29Accident · No injuriesClosedGrum Amer AA-5B · Kentland, INNTSB CHI78FEX25Accident · Serious injuriesClosedGrumman AA5B · Bedford, INNTSB OAK78DVG49Accident · No injuriesClosedGrum Amer AA5B · Angwin, CANTSB NYC78FDH16Accident · Minor injuriesClosedGrum Amer AA5 · Cross Keys, NJNTSB MIA78DKJ46Accident · No injuriesClosedAmer Avco AA-5B · Pensacola, FLNTSB FTW78FQG30Accident · No injuriesClosedGrum-Amer AA5B · Amarillo, TXNTSB NYC78DFJ18Accident · No injuriesClosedGrum Amer AA5B · Rochester, NYNTSB CHI78FA029Accident · 1 fatalClosedGrum Amer AA5-B · Sandusky, OH