# NTSB investigations: Grumman American Avn. AA-1C, 2001

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 MIA02LA036](https://openairdocs.org/ntsb/MIA02LA036.md): Grumman American AA-1C · Pompano Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 2001 · N9515U · Substantial damage
  > The failure of the pilot-in-command to maintain airspeed (Vs), while maneuvering for an emergency landing, resulting in an inadvertent stall and subsequent in-flight collision with terrain. A contributing factor in the accident was the loss of engine power…
- [NTSB NYC01FA169](https://openairdocs.org/ntsb/NYC01FA169.md): Grumman American AA-1C · Medford, NJ · Accident · 2 fatal · Field investigation · Final report · Jul 10, 2001 · N9616U · Destroyed
  > The pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.
- [NTSB CHI01LA099](https://openairdocs.org/ntsb/CHI01LA099.md): Grumman American AA-1C · Dekalb, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 2001 · N9886U · Substantial damage
  > Fuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…

## 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 year(c."eventDate") = 2001
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960100'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3960100&year=2001

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