# NTSB investigations: American AA-1A: In flight encounter with weather

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 FTW98FA299](https://openairdocs.org/ntsb/FTW98FA299.md): Grumman American AA-1A · Larkspur, CO · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1998 · N9453L · Destroyed
  > The pilot inadvertently stalling the airplane and entering an unrecoverable spin. A factor was clear air turbulence.
- [NTSB NYC95LA047](https://openairdocs.org/ntsb/NYC95LA047.md): Grumman American AA-1A · Lancaster, NY · Accident · No injuries · Limited investigation · Final report · Dec 27, 1994 · N9457L · Substantial damage
  > The pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel to return to the home airport after proceeding to an alternate airport and making a missed approach. Factors related to the accident were:…
- [NTSB CHI89LA193](https://openairdocs.org/ntsb/CHI89LA193.md): American AA-1A · Medina, OH · Accident · No injuries · Limited investigation · Final report · Sep 22, 1989 · N9332L · Substantial damage
  > The pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…
- [NTSB SEA89FA186](https://openairdocs.org/ntsb/SEA89FA186.md): American AA-1A · Enumclaw, WA · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1989 · N9473L · Destroyed
  > Attempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.
- [NTSB FTW84LA161](https://openairdocs.org/ntsb/FTW84LA161.md): American AA-1A · Smithville, TX · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N9460L · Substantial damage
  > The pvt non-instrument plt received two wx briefings for his route of flt from madison, MS, to lufkin, TX, to college station, TX, to san antonio, TX. The last briefing from college station fss informed the plt that marginal VFR conditions exsisted along the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0630710&occurrence=240

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