# Final NTSB investigations: Strength

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 ERA25LA147](https://openairdocs.org/ntsb/ERA25LA147.md): Champion 7AC · Palmetto, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 18, 2025 · N1369E · Substantial damage
  > The flight instructor’s inability to overpower control inputs made by the student pilot during initial climb, which resulted in the airplane impacting powerlines and the ground.
- [NTSB CEN22LA238](https://openairdocs.org/ntsb/CEN22LA238.md): Aerostar International RX 8 · Hot Springs, SD · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 8, 2022 · N9158Z · No damage
  > The passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.
- [NTSB ERA18LA087](https://openairdocs.org/ntsb/ERA18LA087.md): Aero Commander Callair A 9 · Bunn, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 24, 2018 · N8401V · Substantial damage
  > The glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…
- [NTSB ERA16FA043](https://openairdocs.org/ntsb/ERA16FA043.md): Beech A36TC · Orlando, FL · Accident · 2 fatal · Field investigation · Final report · Nov 20, 2015 · N7FG · Destroyed
  > The pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…
- [NTSB CEN10CA257](https://openairdocs.org/ntsb/CEN10CA257.md): Aerostar International S57A · Hilliard, OH · Accident · Serious injuries · Data collection · Final report · May 15, 2010 · N9002Z · No damage
  > The passenger’s inadequate brace for the balloon landing, resulting in injury.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02011020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02011020/cases?status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
