NTSB investigations: Grumman American Avn. AA-5A, CA

13 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

NTSB investigations: Grumman American Avn. AA-5A, CA per year, 1977–2026: 13 cases
1977	2
1978	2
1979	1
1980	1
1981	1
1983	1
1984	1
1989	1
1994	1
1996	1
2000	1

Where

Open the map

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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

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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  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

Run 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 LAX01FA027Accident · Serious injuriesField investigationFinal reportGrumman American AA-5A · Gardena, CAThe engine lost power for undetermined reasons.Oct 26, 2000 · N26470 · Substantial damage NTSB LAX97LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Banning, CAThe pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.Dec 29, 1996 · N9944U · Substantial damage NTSB LAX95FA068Accident · 2 fatalField investigationFinal reportGrumman AA-5A · San Luis Obispo, CAthe pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…Dec 31, 1994 · N26443 · Destroyed NTSB LAX89FA093Accident · 1 fatalField investigationFinal reportGrumman AA5A · Lake View, CAThe pilot's inadvertent flight into a box canyon.Jan 22, 1989 · N26313 · Destroyed NTSB LAX85FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Gorman, CAThe plt was on a night x-country flt. When the acft did not arrive at its destination, a search was initiated. On 12/12/84, the plane was found where it had impacted an area of rising terrain while approaching the tehachapi mountains. Impact occurred on a…Dec 13, 1984 · N26131 · Destroyed 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…Jul 1, 1983 · N9945U · Destroyed NTSB LAX82DUQ02Accident · No injuriesClosedGrum Amer AA-5A · Van Nuys, CANov 11, 1981 · N26353 · Substantial damage NTSB LAX80FUA23Accident · No injuriesClosedGrumman AA-5A · Fullerton, CASep 18, 1980 · N26456 · Substantial damage NTSB LAX79DUG18Accident · No injuriesClosedStolamph AA-5A · Big Bear City, CAFeb 22, 1979 · N9871U · Destroyed NTSB OAK78FA023Accident · 2 fatalClosedGrumman AA-5A · Red Bluff, CAMar 21, 1978 · N9740U · Destroyed NTSB LAX78FA026Accident · 3 fatalClosedGrum Amer AA-5A · Fontana, CAFeb 12, 1978 · N9842U · Substantial damage NTSB OAK77DVD47Accident · No injuriesClosedGrum Amer AA5A · Concord, CAAug 6, 1977 · N9798U · Substantial damage NTSB LAX77DUQ35Accident · No injuriesClosedGrum Amer AA5-A · Oxnard, CAJun 19, 1977 · N9641U · Substantial damage