# NTSB investigations, 2009, WA: Nose over/nose down

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 WPR10CA096](https://openairdocs.org/ntsb/WPR10CA096.md): Stinson SR-8B · Auburn, WA · Accident · No injuries · Data collection · Final report · Dec 23, 2009 · N17119 · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB WPR10CA073](https://openairdocs.org/ntsb/WPR10CA073.md): Cessna 172M · Diamond Point, WA · Accident · No injuries · Data collection · Final report · Dec 6, 2009 · N20186 · Substantial damage
  > The pilot's inadequate compensation for the variable and unfavorable wind conditions.
- [NTSB WPR09LA423](https://openairdocs.org/ntsb/WPR09LA423.md): Cessna TU206G · Ballard, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 2009 · N682RC · Substantial damage
  > The pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.
- [NTSB WPR09CA306](https://openairdocs.org/ntsb/WPR09CA306.md): Jenkins Jack Glastar SP · Coupeville, WA · Accident · No injuries · Data collection · Final report · Jun 22, 2009 · N5617 · Substantial damage
  > The pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.
- [NTSB WPR09CA276](https://openairdocs.org/ntsb/WPR09CA276.md): Cessna A185F · Wenatchee, WA · Accident · No injuries · Data collection · Final report · Jun 2, 2009 · N1015F · Substantial damage
  > The pilot's misjudged approach and failure to attain the proper touchdown point.
- [NTSB WPR09CA260](https://openairdocs.org/ntsb/WPR09CA260.md): Stinson SR-8B · Tacoma, WA · Accident · No injuries · Data collection · Final report · May 24, 2009 · N17119 · Substantial damage
  > The application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.
- [NTSB WPR09CA252](https://openairdocs.org/ntsb/WPR09CA252.md): Cessna 185E · Tacoma, WA · Accident · No injuries · Data collection · Final report · May 18, 2009 · N70083 · Substantial damage
  > The pilot's failure to maintain directional control while landing with a crosswind.
- [NTSB WPR09CA191](https://openairdocs.org/ntsb/WPR09CA191.md): Remos Gemini Remos · Jefferson, WA · Accident · Serious injuries · Data collection · Final report · Apr 9, 2009 · N249SW · Substantial damage
  > The pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.

## 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" = 'WA' 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" = '096' 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/096/sequence?state=WA&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.
