NTSB investigations: Grumman American Avn. AA-5, OH

10 cases on aircraft the registry lists as Grumman American Avn. AA-5. 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

19752026

NTSB investigations: Grumman American Avn. AA-5, OH per year, 1975–2026: 10 cases
1975	2
1976	1
1978	2
1980	1
1984	2
1989	1
2005	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" = 'OH' 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 ('3960104')) 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\" = 'OH' 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 ('3960104'))
  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" = 'OH' 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 ('3960104'))
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 NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.Mar 13, 2005 · N6511L · Destroyed NTSB ATL89FA160Accident · Minor injuriesField investigationFinal reportGrumman American AA-5 · Columbus, OHThe student pilot's improperly planned approach, and inadequate supervision by the instructor pilot (CFI), which led to an encounter with wake turbulence and a loss of aircraft control.Jun 15, 1989 · N6506L · Destroyed NTSB ATL85FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman American AA-5 · Dayton, OHAircraft missing on a flight from Dayton, OH to gallipolis, OH two persons on board.Dec 9, 1984 · N9627U · Destroyed NTSB CHI84LA382Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · New Carlisle, OHThe acft collided with trees after overrunning a 2000 ft wet sod airstrip. The plt reported that braking action was poorthe acft went into an evergreen tree nursery before stopping.Sep 5, 1984 · N9596L · Substantial damage NTSB CHI80FEI22Accident · No injuriesClosedGrumman AA-5 · Ravenna, OHMay 23, 1980 · N1358R · Substantial damage NTSB CHI79FEK01Accident · 1 fatalClosedGrum Amer AA-5 · Reno, OHNov 12, 1978 · N7187L · Destroyed NTSB CHI78FEG07Accident · No injuriesClosedGrumman AA-5 · Vandali, OHApr 22, 1978 · N9517L · Substantial damage NTSB CHI76FEI24Accident · Minor injuriesClosedGrum Amer AA-5 · Akron, OHApr 4, 1976 · N9546L · Destroyed NTSB CHI76FEI15Accident · Minor injuriesClosedGrum Amer AA-5 · Wadsworth, OHNov 16, 1975 · N7151L · Substantial damage NTSB CHI75FEI47Accident · No injuriesClosedGrum Amer AA-5 · Wadsworth, OHMay 3, 1975 · N9561L · Substantial damage