# NTSB investigations, 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 WPR26LA053](https://openairdocs.org/ntsb/WPR26LA053.md): Tecnam P2008 · Blackfoot, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 10, 2025 · N208CM · Substantial damage
  > The student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night.
- [NTSB WPR25FA153](https://openairdocs.org/ntsb/WPR25FA153.md): American Champion 7GCBC · Big Creek, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 9, 2025 · N342H · Substantial damage
  > On May 9, 2025, about 0900 mountain daylight time, an American Champion Aircraft 7GCBC, N342H, was substantially damaged when it was involved in an accident near Big Creek, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25LA036](https://openairdocs.org/ntsb/WPR25LA036.md): Cessna 180 · Owinza, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 13, 2024 · N9493C
  > The pilot’s failure to maintain clearance from the water during a low pass over a lake.
- [NTSB WPR24FA288](https://openairdocs.org/ntsb/WPR24FA288.md): Textron T206H · Yellow Pine, ID · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 29, 2024 · N712AM · Destroyed
  > On August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR22LA212](https://openairdocs.org/ntsb/WPR22LA212.md): Aviat A-1B · Big Creek, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 10, 2022 · N55HU · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with fencing.
- [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 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 LAX08CA210](https://openairdocs.org/ntsb/LAX08CA210.md): Cessna TU206G · Coeur d'Alene, ID · Accident · No injuries · Data collection · Final report · Jul 1, 2008 · N4776U · Substantial damage
  > The pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.

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

This list as a web page: https://openairdocs.org/ntsb-events/470/cases?state=ID

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