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

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 ERA20CA065](https://openairdocs.org/ntsb/ERA20CA065.md): American AA5 · Rutherfordton, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Jan 5, 2020 · N9593U · Substantial damage
  > The pilot's failure to maintain control of the airplane during an intentional aerodynamic stall, which resulted in a spin and subsequent collision with terrain.
- [NTSB ERA11LA342](https://openairdocs.org/ntsb/ERA11LA342.md): Grumman American Avn. AA-5A · Linden, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 2011 · N8476B · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons.
- [NTSB ATL86LA086](https://openairdocs.org/ntsb/ATL86LA086.md): Grumman American AA5A · Fayetteville, NC · Accident · No injuries · Limited investigation · Final report · Mar 6, 1986 · N26171 · Substantial damage
  > During landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition.
- [NTSB IAD78DKM24](https://openairdocs.org/ntsb/IAD78DKM24.md): Grum Amer AA-5A · Greensboro, NC · Accident · No injuries · Closed · Sep 10, 1978 · N9905U · Substantial damage
- [NTSB IAD78FLJ15](https://openairdocs.org/ntsb/IAD78FLJ15.md): Grum Amer AA5A · Belhaven, NC · Accident · Serious injuries · Closed · Jun 20, 1978 · N9637U · Substantial damage
- [NTSB IAD78DKM08](https://openairdocs.org/ntsb/IAD78DKM08.md): Grum Amer AA-5A · Greensboro, NC · Accident · No injuries · Closed · Mar 2, 1978 · N9928U · 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" = 'NC' 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=NC

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