OpenAirDocs.org

NTSB investigations: Grumman American Avn. AA-5A

5 cases on aircraft the registry lists as Grumman American Avn. AA-5A, where the first occurrence was “In flight encounter with weather”. 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

19822026

Where

Open the map

Latest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960106')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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.

NTSB FTW99LA219Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Wayton, ARThe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…Aug 12, 1999 · N9775U · Substantial damageNTSB DEN88FA054Accident · 3 fatalField investigationFinal reportGulfstream American AA-5A · Elbert, COThe acft collided with slightly rising terrain with the rt wing slightly down and the nose attitude level. Following the first contact, the acft skipped about 90 ft and the 2nd impact was in a more pronounced rt wing low and nose down attitude. The canopy was…Jan 17, 1988 · N9937U · DestroyedNTSB 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 · DestroyedNTSB 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 · DestroyedNTSB ATL82DA234Accident · No injuriesFinal reportGrumman American AA-5A · Providence, KYDense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not…Aug 12, 1982 · N9722U · Substantial damage