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

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA15CA153](https://openairdocs.org/ntsb/GAA15CA153.md): Grumman American Avn. AA 5A · Mackay, ID · Accident · No injuries · Data collection · Final report · Jul 1, 2015 · N9887U · Substantial damage
  > The student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.
- [NTSB LAX08CA125](https://openairdocs.org/ntsb/LAX08CA125.md): Grumman AA-5A · Atlanta, ID · Accident · Minor injuries · Data collection · Final report · May 4, 2008 · N9720U · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.
- [NTSB LAX07CA248](https://openairdocs.org/ntsb/LAX07CA248.md): Grumman American AA5A · Elk River, ID · Accident · No injuries · Data collection · Final report · Aug 3, 2007 · N27166 · Substantial damage
  > The pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during landing.
- [NTSB SEA76AS059](https://openairdocs.org/ntsb/SEA76AS059.md): Grum Amer AA-5A · Boise, ID · Accident · 5 fatal · Closed · Jul 5, 1976 · N9724U · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 ('3960106'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3960106&state=ID

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.