# NTSB investigations, 2009, ID: Collision with terr/obj (non-CFIT)

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 WPR10CA089](https://openairdocs.org/ntsb/WPR10CA089.md): Cessna 172M · Albion, ID · Accident · No injuries · Data collection · Final report · Dec 24, 2009 · N1883V · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.
- [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 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 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 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 WPR09FA379](https://openairdocs.org/ntsb/WPR09FA379.md): Piper PA-22-150 · Saint Charles, ID · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2009 · N6905B · Destroyed
  > The pilot’s failure to maintain terrain clearance while maneuvering.
- [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.
- [NTSB WPR09LA343](https://openairdocs.org/ntsb/WPR09LA343.md): Cessna U206G · Yellow Pine, ID · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 2009 · N71BS · Substantial damage
  > The pilot's failure to maintain clearance from the trees while taking off in a high-density altitude. Contributing to the accident were the pilot's failure to perform pre-takeoff performance calculations, his positioning of the elevator trim in a nose-down…
- [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 WPR09LA299](https://openairdocs.org/ntsb/WPR09LA299.md): Ayres S2R-600 · Saint Anthony, ID · Accident · No injuries · Limited investigation · Final report · Jun 19, 2009 · N3089K · Destroyed
  > A total loss of engine power for undetermined reasons.
- [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 WPR09CA181](https://openairdocs.org/ntsb/WPR09CA181.md): Max A Boesiger Jr Pulsar · Riddle, ID · Accident · No injuries · Data collection · Final report · Apr 6, 2009 · N610RJ · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.
- [NTSB WPR09FA116](https://openairdocs.org/ntsb/WPR09FA116.md): Piper PA-24-260 · Hagerman, ID · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2009 · N8810P · Destroyed
  > The student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…

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