# NTSB investigations: Atkins ACRO-SPORT

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 CEN13LA225](https://openairdocs.org/ntsb/CEN13LA225.md): Atkins ACRO-SPORT I · Midland, LA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2013 · N5897 · Substantial damage
  > The failure of the left elevator torque tube due to poor quality welds by the manufacturer, which resulted in the loss of pitch control.
- [NTSB FTW88DPA04](https://openairdocs.org/ntsb/FTW88DPA04.md): Atkins ACRO-SPORT · Fort Worth, TX · Accident · No injuries · Final report · Jul 22, 1988 · N5897 · Substantial damage
  > During a personal flight, the engine failed and the pilot made a forced landing into an open field. During the landing, the airplane flipped to the inverted position. Investigation revealed no fuel in the tank or fuel system and no fuel spilled on the ground.

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

This list as a web page: https://openairdocs.org/ntsb?model=0564609

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