# NTSB investigations, ID: Object/animal/substance, general

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 GAA19CA545](https://openairdocs.org/ntsb/GAA19CA545.md): Cessna P206 · Caldwell, ID · Accident · No injuries · Data collection · Final report · Sep 13, 2019 · N4746F · Substantial damage
  > The pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.
- [NTSB GAA18CA311](https://openairdocs.org/ntsb/GAA18CA311.md): Maule M5 · Lewiston, ID · Accident · Minor injuries · Data collection · Final report · May 28, 2018 · N5634Y · Substantial damage
  > The pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.
- [NTSB GAA18CA245](https://openairdocs.org/ntsb/GAA18CA245.md): Ayres S2R · Weipee, ID · Accident · No injuries · Data collection · Final report · Apr 18, 2018 · N40170 · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB WPR10FA440](https://openairdocs.org/ntsb/WPR10FA440.md): Hiller UH 12E · Kamiah, ID · Accident · 3 fatal · Field investigation · Final report · Aug 31, 2010 · N67264 · Substantial damage
  > In-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…
- [NTSB SEA08CA086](https://openairdocs.org/ntsb/SEA08CA086.md): Maule M-4 · Jerome, ID · Accident · No injuries · Data collection · Final report · Mar 5, 2008 · N2039U · Substantial damage
  > The failure of both pilots to maintain directional control of the airplane during takeoff.

## 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", '03022000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03022000/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.
