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

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 ERA12CA418](https://openairdocs.org/ntsb/ERA12CA418.md): Grumman American Avn. AA-1C · West Chester, PA · Accident · Minor injuries · Data collection · Final report · Jun 27, 2012 · N9675U · Substantial damage
  > The pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.
- [NTSB NYC08FA189](https://openairdocs.org/ntsb/NYC08FA189.md): Grumman American AA-1C · Philadelphia, PA · Accident · 2 fatal · Field investigation · Final report · May 22, 2008 · N9555U · Destroyed
  > The flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB NYC89LA217](https://openairdocs.org/ntsb/NYC89LA217.md): Grumman AA-1C · Philadelphia, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1989 · N9825U · Substantial damage
  > Fuel starvation, due to the pilot's failure to assure the fuel selector was positioned to a tank with adequate fuel for landing, and his failure to follow the proper emergency procedure after the tank emptied.
- [NTSB NYC83LA194](https://openairdocs.org/ntsb/NYC83LA194.md): Grumman AA-1C · Doylestown, PA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N9978U · Substantial damage
  > The student made 2 takeoffs & landings, then waited for traffic to clear the rwy before taking off again. While climbing to traffic pattern altitude on the 3rd takeoff, the eng lost power. An emergency checklist to restart the eng was not completed because of…

## 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" = 'PA' 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=PA

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