# NTSB investigations, 2009, 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 WPR10LA032](https://openairdocs.org/ntsb/WPR10LA032.md): Powrachute PC 2000 · Leadore, ID · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 2009 · N4036U · Substantial damage
  > The stuck throttle cable and the pilot's failure to maintain adequate airspeed during landing, which resulted in an inadvertent aerodynamic stall and hard landing.
- [NTSB WPR09LA463](https://openairdocs.org/ntsb/WPR09LA463.md): Frazier Tangent · Nampa, ID · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2009 · N72TZ · Substantial damage
  > The pilot's failure to maintain pitch control of the airplane.
- [NTSB WPR09FA409](https://openairdocs.org/ntsb/WPR09FA409.md): Stemme S10-VT · Mackay, ID · Accident · 1 fatal · Field investigation · Final report · Aug 19, 2009 · N35MP · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.
- [NTSB WPR09LA378](https://openairdocs.org/ntsb/WPR09LA378.md): Gray RV-6 · Caldwell, ID · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2009 · N69KG · Destroyed
  > The pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.

## 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") = 2009
  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=2009

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