# NTSB investigations, 2009, ID: Runway excursion

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 WPR09CA444](https://openairdocs.org/ntsb/WPR09CA444.md): Beech V35 · Hailey, ID · Accident · No injuries · Data collection · Final report · Sep 13, 2009 · N81895 · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during landing in crosswind conditions.
- [NTSB WPR09CA392](https://openairdocs.org/ntsb/WPR09CA392.md): Piper PA-38-112 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Aug 11, 2009 · N939RG · Substantial damage
  > The failure of the student pilot to maintain directional control during landing.
- [NTSB WPR09CA346](https://openairdocs.org/ntsb/WPR09CA346.md): Flight Design Ctsw · Sulphur Creek, ID · Accident · No injuries · Data collection · Final report · Jul 10, 2009 · N199CT · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB WPR09CA332](https://openairdocs.org/ntsb/WPR09CA332.md): Cessna 182M · Wilson Bar, ID · Accident · Minor injuries · Data collection · Final report · Jul 6, 2009 · N71186 · Destroyed
  > The pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.
- [NTSB WPR09CA304](https://openairdocs.org/ntsb/WPR09CA304.md): Stucker Virgil A Avid Magnu · Emmett, ID · Accident · No injuries · Data collection · Final report · Jun 21, 2009 · N777DV · Substantial damage
  > The pilot's improper landing flare and recovery from a bounced landing.
- [NTSB WPR09CA233](https://openairdocs.org/ntsb/WPR09CA233.md): Cessna 172R · Coeur d'Alene, ID · Accident · No injuries · Data collection · Final report · May 9, 2009 · N2383Q · Substantial damage
  > The student pilot's inadequate compensation for the crosswinds while landing.
- [NTSB WPR09LA201](https://openairdocs.org/ntsb/WPR09LA201.md): Brinker / Garner BI-PLANE · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Apr 17, 2009 · N375CB · Substantial damage
  > Loss of control during the landing roll for undetermined reasons.

## 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" = '300' 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/300/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.
