# NTSB investigations, ID: Debris/dirt/foreign object

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 WPR21LA304](https://openairdocs.org/ntsb/WPR21LA304.md): Cessna 182C · Coeur D Alene, ID · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2021 · N9007T · Substantial damage
  > The pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.
- [NTSB GAA15CA134](https://openairdocs.org/ntsb/GAA15CA134.md): Quicksilver MX · Nampa, ID · Accident · No injuries · Data collection · Final report · Jun 23, 2015 · UNREG · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and a collision with terrain.
- [NTSB SEA08LA114](https://openairdocs.org/ntsb/SEA08LA114.md): Canup Titan Tornado S · Council, ID · Accident · No injuries · Limited investigation · Final report · Apr 26, 2008 · N706BC · Substantial damage
  > The failure of the tip of the wood propeller due to damage caused by a foreign object.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022055'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03022055/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
