# NTSB investigations: Grumman American Avn. AA-1B, 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 FTW02FA037](https://openairdocs.org/ntsb/FTW02FA037.md): Grumman American AA-1B · Patterson, LA · Accident · 1 fatal · Field investigation · Final report · Nov 19, 2001 · N6530L · Substantial damage
  > The pilot's mismanagement of fuel with the positioning of the fuel selector in the off position and his failure to maintain airspeed resulting in fuel starvation, and the airplane entering into a stall.
- [NTSB MIA01LA167](https://openairdocs.org/ntsb/MIA01LA167.md): Grumman American AA-1B · Oak Hill, FL · Accident · No injuries · Limited investigation · Final report · Jun 19, 2001 · N8957L · Substantial damage
  > A partial loss of engine power while at a low altitude cruise due to fuel contamination, and the subsequent emergency descent and landing to a rural road resulting in collision with tree and mailbox post.
- [NTSB SEA01LA037](https://openairdocs.org/ntsb/SEA01LA037.md): Grumman American AA-1B · Cottage Grove, OR · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 2001 · N9988L · Destroyed
  > The flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…

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

This list as a web page: https://openairdocs.org/ntsb?model=3960103&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.