# NTSB investigations: Gulfstream American AA-5B: Loss of engine power(partial) - mech failure/malf

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 MIA04LA097](https://openairdocs.org/ntsb/MIA04LA097.md): Gulfstream American AA5B · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · Jun 14, 2004 · N4516V · Substantial damage
  > The failure of the number three cylinder exhaust valve which resulted in the partial loss of engine power. The pilot's misjudgment of speed and distance resulted in an overrun of the runway.
- [NTSB BFO94LA010](https://openairdocs.org/ntsb/BFO94LA010.md): Gulfstream American AA-5B · Sterling, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1993 · N28215 · Substantial damage
  > Separation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.
- [NTSB DEN82DA141](https://openairdocs.org/ntsb/DEN82DA141.md): American AA5B · Broomfield, CO · Accident · Minor injuries · Final report · Jul 22, 1982 · N28218 · Substantial damage
  > The pilot was conducting local area pleasure sightseeing flights when the aircraft failed to climb during a normal departure. She landed the aircraft in a plowed field. Investigation revealed the flight was conducted at a density altitude approximately 8,750…

## 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 ('3970106')
    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" = 352))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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