# NTSB investigations: Grumman American Avn. AA-1B, LA

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 FTW81DRD19](https://openairdocs.org/ntsb/FTW81DRD19.md): Grum Amer AA-1B · Grand Isle, LA · Accident · No injuries · Closed · Apr 23, 1981 · N8985L · Substantial damage
- [NTSB FTW79DRD05](https://openairdocs.org/ntsb/FTW79DRD05.md): Grum Amer AA-1B · Thibodaux, LA · Accident · Minor injuries · Closed · Oct 25, 1978 · N1423R · Substantial damage
- [NTSB FTW78DRD51](https://openairdocs.org/ntsb/FTW78DRD51.md): Grum Amer AA1B · Thibodaux, LA · Accident · No injuries · Closed · Aug 21, 1978 · N9975L · Substantial damage
- [NTSB FTW76FRD56](https://openairdocs.org/ntsb/FTW76FRD56.md): Grum Amer AA1-B · Eunice, LA · Accident · Serious injuries · Closed · Jul 28, 1976 · N1497R · Substantial damage
- [NTSB FTW76DRD12](https://openairdocs.org/ntsb/FTW76DRD12.md): Grum Amer AA1-B · Thibodaux, LA · Accident · No injuries · Closed · Sep 28, 1975 · N9937L · Substantial damage
- [NTSB FTW75FRD17](https://openairdocs.org/ntsb/FTW75FRD17.md): Amer Avco AA1-B · Houma, LA · Accident · No injuries · Closed · Dec 10, 1974 · N6515L · Substantial damage
- [NTSB FTW74DRJ36](https://openairdocs.org/ntsb/FTW74DRJ36.md): Amer Avco AA1-B · Blanchard, LA · Accident · No injuries · Closed · May 23, 1974 · N9669L · Substantial damage
- [NTSB FTW74FRD09](https://openairdocs.org/ntsb/FTW74FRD09.md): Amer Avco AA1-B · Slidell, LA · Accident · No injuries · Closed · Sep 9, 1973 · N9917L · Substantial damage
- [NTSB FTW74FRJ02](https://openairdocs.org/ntsb/FTW74FRJ02.md): Amer Avco AA-1B · West Monroe, LA · Accident · Minor injuries · Closed · Jul 2, 1973 · N6277L · 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" = 'LA' 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 ('3960103'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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