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

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 DEN00LA180](https://openairdocs.org/ntsb/DEN00LA180.md): Grumman American AA-1B · Erie, CO · Accident · No injuries · Limited investigation · Final report · Sep 29, 2000 · N9622L · Substantial damage
  > Inadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…
- [NTSB FTW98FA394](https://openairdocs.org/ntsb/FTW98FA394.md): Grumman American AA-1B · Yoder, CO · Accident · 2 fatal · Field investigation · Final report · Sep 12, 1998 · N6288L · Destroyed
  > The pilot's loss of aircraft control due to not maintaining adequate airspeed and the subsequent inadvertent stall. Factors were the pilot's inadequate preflight and the engine's power failure due to fuel exhaustion.
- [NTSB FTW96FA352](https://openairdocs.org/ntsb/FTW96FA352.md): Grumman American AA-1B · Boulder, CO · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1996 · N6505L · Destroyed
  > The pilot's poor judgment in attempting low altitude flight in mountainous terrain without adequate mountain flying training which led to low altitude maneuvering exceeding the climb capability of the airplane. Factors in the accident were: the pilot's…

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

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