NTSB investigations: Grumman American Avn. AA-5B, ID

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

19762026

NTSB investigations: Grumman American Avn. AA-5B, ID per year, 1976–2026: 4 cases
1976	1
1984	1
1996	2

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" = 'ID' 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 ('3960105')) 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\" = 'ID' 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 ('3960105'))
  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" = 'ID' 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 ('3960105'))
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 SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.Aug 8, 1996 · N28765 · Substantial damage NTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.Jul 8, 1996 · N28452 · Destroyed NTSB SEA84LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Driggs, IDDuring a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in…Apr 15, 1984 · N28291 · Destroyed NTSB SEA76DYA18Accident · Serious injuriesClosedGrum Amer AA-5B · Mccall, IDFeb 8, 1976 · N74307 · Destroyed