# NTSB investigations: Grumman American Avn. AA-5B, 1997

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 LAX97LA236](https://openairdocs.org/ntsb/LAX97LA236.md): Grumman American AA-5B · Susanville, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1997 · N28299 · Substantial damage
  > the pilot's inadvertent encounter with unfavorable weather conditions during the landing, and his failure to maintain runway alignment. The sudden onset of crosswind gusts beyond the capability of the aircraft was a related factor.
- [NTSB NYC97FA139](https://openairdocs.org/ntsb/NYC97FA139.md): Grumman American AA-5B · Jones Beach, NY · Accident · 3 fatal · Field investigation · Final report · Jul 8, 1997 · N28535 · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…
- [NTSB MIA97FA175](https://openairdocs.org/ntsb/MIA97FA175.md): Grumman American AA-5B · Avon Park, FL · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1997 · N28297 · Destroyed
  > the pilot's failure to maintain airspeed (Vso) during an approach in instrument flight conditions.
- [NTSB MIA97LA067](https://openairdocs.org/ntsb/MIA97LA067.md): Grumman American AA-5B · Salisbury, NC · Accident · No injuries · Limited investigation · Final report · Jan 19, 1997 · N81307 · Destroyed
  > continued operation of the aircraft by the flight instructor (CFI) and student after identifying a brake problem, which resulted in a fire that erupted from the brake system and subsequently destroyed the aircraft.

## 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") = 1997
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960105'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3960105&year=1997

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