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

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 NYC96LA079](https://openairdocs.org/ntsb/NYC96LA079.md): Grumman American AA-1C · Groton, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1996 · N9974U · Substantial damage
  > the pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.
- [NTSB NYC85LA233](https://openairdocs.org/ntsb/NYC85LA233.md): Grumman AA-1C · Wheatland, NY · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N9787U · Substantial damage
  > Acft departed leroy, NY, on an instructional flt to rochester, NY. Fifteen minutes after departure the flt made a forced landing in a bean field. Examination of the acft showed no useable fuel remained.
- [NTSB NYC85LA175](https://openairdocs.org/ntsb/NYC85LA175.md): Grumman AA-1C · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N333FY · Substantial damage
  > The plt was performing a series of touch and go landings at republic arpt when the accident occurred. During the final landing, a hard touch down was made which resulted in a porpoised landing.
- [NTSB NYC79FHJ20](https://openairdocs.org/ntsb/NYC79FHJ20.md): Grum Amer AA1-C · Shirley, NY · Accident · No injuries · Closed · Jul 4, 1979 · N9561U · Substantial damage
- [NTSB NYC79FFA17](https://openairdocs.org/ntsb/NYC79FFA17.md): Grum Amer AA-1C · Oriskany, NY · Accident · No injuries · Closed · Apr 18, 1979 · N39006 · 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" = 'NY' 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 ('3960100'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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