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

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 MKC86LA158](https://openairdocs.org/ntsb/MKC86LA158.md): Grumman AA-5A · Audubon, IA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N9835U · Substantial damage
  > The pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…
- [NTSB MKC82DA038](https://openairdocs.org/ntsb/MKC82DA038.md): Grumman AA-5A · Monona, IA · Accident · No injuries · Final report · Feb 21, 1982 · N9958U · Substantial damage
  > The pilot taxied to the south end of the runway to depart with three passengers. He began a soft field takeoff roll on a soft, wet runway with 10 degrees of flaps. The nose wheel was lifted off early. It was held off as the plane accelerated. The pilot…
- [NTSB MKC79FCD21](https://openairdocs.org/ntsb/MKC79FCD21.md): Grumman AA-5A · Cedar Rapids, IA · Accident · Minor injuries · Closed · Jun 6, 1979 · N9814U · Substantial damage
- [NTSB MKC77FCD33](https://openairdocs.org/ntsb/MKC77FCD33.md): Amer Avco AA-5A · Osage, IA · Accident · No injuries · Closed · Jul 4, 1977 · N9580U · Substantial damage
- [NTSB MKC77FCD28](https://openairdocs.org/ntsb/MKC77FCD28.md): Amer Avco AA-5A · Boone, IA · Accident · No injuries · Closed · Jul 3, 1977 · N9873U · Substantial damage

## 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" = 'IA' 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=IA

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