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

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 ERA12CA377](https://openairdocs.org/ntsb/ERA12CA377.md): Grumman American Avn. AA-1B · Lawrence, MA · Accident · No injuries · Data collection · Final report · May 31, 2012 · N1608R · Substantial damage
  > The pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.
- [NTSB NYC98LA171](https://openairdocs.org/ntsb/NYC98LA171.md): Grumman American AA-1B · Marston Mills, MA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1998 · N9933L · Substantial damage
  > The pilot's improper landing flare and his delayed go-around.
- [NTSB NYC88LA038](https://openairdocs.org/ntsb/NYC88LA038.md): Grumman AA-1B · Tewksbury, MA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N8993L · Substantial damage
  > The student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…
- [NTSB NYC86LA177](https://openairdocs.org/ntsb/NYC86LA177.md): Grumman AA-1B · Marston Mills, MA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1986 · N2NH · Substantial damage
  > The pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.
- [NTSB NYC83LA003](https://openairdocs.org/ntsb/NYC83LA003.md): Grumman American AA-1B · Ipswich, MA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1982 · N9923L · Substantial damage
  > The pilot descended over water at night and elected to fly over a beach area at 100 to 200 ft AGL. He reported that he lowered the nose briefly to see better. At about that time, the aircraft collided with a sand bank.
- [NTSB NYC81FNA27](https://openairdocs.org/ntsb/NYC81FNA27.md): Grum Amer AA-1B · Tewksbury, MA · Accident · Serious injuries · Closed · Sep 6, 1981 · N6283L · Substantial damage
- [NTSB NYC77FNA31](https://openairdocs.org/ntsb/NYC77FNA31.md): Grum Amer AA1B · Tewksbury, MA · Accident · Serious injuries · Closed · Aug 29, 1977 · N8980L · Substantial damage
- [NTSB NYC76ANA07](https://openairdocs.org/ntsb/NYC76ANA07.md): Grum Amer AA1-B · Stow, MA · Accident · Minor injuries · Closed · Aug 2, 1975 · N8877L · Substantial damage
- [NTSB NYC74FNA12](https://openairdocs.org/ntsb/NYC74FNA12.md): Amer Avco AA1-B · Tewksbury, MA · Accident · Minor injuries · Closed · Aug 30, 1973 · N6273L · 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" = 'MA' 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=MA

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