# NTSB investigations, 2019, ID: Aerodynamic stall/spin

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 WPR20FA015](https://openairdocs.org/ntsb/WPR20FA015.md): Mooney M20J · American Falls, ID · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2019 · N201BJ · Substantial damage
  > The pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…
- [NTSB GAA19CA437](https://openairdocs.org/ntsb/GAA19CA437.md): Piper PA36 · Bancroft, ID · Accident · Minor injuries · Data collection · Final report · Jul 15, 2019 · N57799 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.
- [NTSB GAA19CA283](https://openairdocs.org/ntsb/GAA19CA283.md): Rockwell S2R · Grangeville, ID · Accident · No injuries · Data collection · Final report · May 24, 2019 · N5569X · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.
- [NTSB WPR19FA150](https://openairdocs.org/ntsb/WPR19FA150.md): Beech 35 · Melba, ID · Accident · 1 fatal · Class 3 · Field · Final report · May 19, 2019 · N1888D · Substantial damage
  > The pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.

## 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") = 2019
  AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/241/sequence?state=ID&year=2019

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