NTSB investigations: Grumman American Avn. AA-5A, 1983
7 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\") = 1983
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") = 1983
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 FTW84LA066Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Addison, TXThe plt reported that during an ILS apch to land, the eng lost power when the acft was about 1/4 mi from the threshold. He stated that he 'confirmed mixture rich, carb heat on, fuel pump on, fuel fullest tank.' The plt was unable to restart the eng. During an…NTSB CHI84LA031Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Monroe, MIThe pilot stated he developed a high sink rate during landing which resulted in a hard landing. The pilot departed the left side of the runway and entered a ditch.NTSB MKC83LA193Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Keytesville, MOAccording to the pilot, after departure he climbed to 2000 feet MSL, adjusted the throttle for 2500 RPM and leaned the mixture for cruise flight. The engine slowed to 2000 RPM so he selected the opposite fuel tank, moved the mixture to full rich and applied…NTSB FTW83LA378Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Grove, OKThe acft was high & fast on final apch & touched down about 1/3 of the way down the rwy. The nosewheel touched down 1st & the acft began to porpoise. The plt applied power to stop the porpoise, then elected to go around. In order to avoid trees near the end…NTSB LAX83FA314Accident · Serious injuriesField investigationFinal reportGrumman American AA-5A · Livermore, CAThe acft collided with rising terrain during a cross-country in IMC weather. No flt plan was filed for the flt. No weather briefing was obtained by the pilot before takeoff. The distance to be flown was 72 miles and the pilot flew this route about 3 times a…NTSB CHI83LA281Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Monee, ILThe acft crashed on the left wing tip into a bean field during a go-around. The pilot stated that the approach was high. The acft ballooned and bounced at touchdown. The pilot thought that there was not enough runway left so she started a go-around. At about…NTSB ATL83FKG09Accident · No injuriesFinal reportGrumman American AA-5A · Dobbins Afb, GAThe student plt was taxiing for takeoff when she applied right brake where a right turn was needed, however, the acft did not turn as it should. The instructor plt then took control of the acft. He applied right brake, then both brakes, but had negative…