NTSB investigations: Grumman American Avn. AA-5A, 1991
4 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\") = 1991
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") = 1991
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 DEN92FA020Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Monte Vista, COAn inadvertent stall by the pilot in command at an altitude insufficient to effect recovery. Factors were: aircraft gross weight above maximum; physical impairment of the pilot; lack of total experience; lack of recent experience; and lack of experience in…NTSB NYC92LA007Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boxboro, MAThe pilot's failure to perform an adequate preflight to remove ice/frost from the aircraft wings.NTSB LAX92LA008Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Flagstaff, AZAn inadvertent stall/mush due to the pilot's failure to maintain the appropriate airspeed during the takeoff attempt. Factors in the accident were the high density altitude and the inadequate preflight planning by the pilot.NTSB NYC91LA113Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Pleasant Valley, NYThe failure of the pilot of N5232K to maintain visual contact and separation with N9763U.