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

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 CHI83LA005](https://openairdocs.org/ntsb/CHI83LA005.md): Grumman AA-1C · Madison, IN · Accident · No injuries · Limited investigation · Final report · Oct 4, 1982 · N8055W · Substantial damage
  > After takeoff from a touch & go the eng lost power. The #1 cyl upper plug lead nut had backed off & the lead was found resting in the plug. The #2 & #4 cyl upper plug lead nuts had backed off & both leads were not in the spark plugs but were resting on the…
- [NTSB CHI82DA235](https://openairdocs.org/ntsb/CHI82DA235.md): Grumman American AA-1C · Danville, IL · Accident · Minor injuries · Final report · Jul 5, 1982 · N9830U · Destroyed
  > The student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the…
- [NTSB NYC82DA138](https://openairdocs.org/ntsb/NYC82DA138.md): Grumman AA-1C · West Haven, CT · Accident · No injuries · Final report · Jul 2, 1982 · N39050 · Substantial damage
  > The student pilot departed bridgeport, CT at 1200 hours and arrived at nantucket, ma at 1345 hours. While en route, he made a touch-and-go at fishers island and practiced stall maneuvers. He departed nantucket at about 1430 hours without refueling.…
- [NTSB MKC82DA111](https://openairdocs.org/ntsb/MKC82DA111.md): Grumman AA1C · St. Louis, MO · Accident · No injuries · Final report · Jul 1, 1982 · N9565U · Substantial damage
  > During a dual training flight the aircraft was allowed to descend into a corn crop short of the runway. The aircraft continued to the runway but landed hard and collapsed the landing gear.

## 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") = 1982
  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&year=1982

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