NTSB investigations: Grumman American Avn. AA-5A, 1986
2 cases on aircraft the registry lists as Grumman American Avn. AA-5A. 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
| 1976 | 5 |
|---|---|
| 1977 | 12 |
| 1978 | 18 |
| 1979 | 14 |
| 1980 | 5 |
| 1981 | 7 |
| 1982 | 8 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2007 | 4 |
| 2008 | 4 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2023 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960106'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960106'))
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 MKC86LA158Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Audubon, IAThe pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…NTSB ATL86LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Fayetteville, NCDuring landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition.