# NTSB investigations, ID: Part(s) separation from AC

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 WPR24LA122](https://openairdocs.org/ntsb/WPR24LA122.md): Cessna 180A · Nordman, ID · Accident · No injuries · Class 3 · Limited · Final report · Apr 4, 2024 · N5281D · Substantial damage
  > Maintenance personnel's improper installation of the left main landing gear wheel assembly, which resulted in a loss of torque and subsequent separation of the wheel and axle assembly from the main landing gear leg during landing.
- [NTSB WPR24LA098](https://openairdocs.org/ntsb/WPR24LA098.md): Cessna 182A · Weippe, ID · Accident · No injuries · Class 4 · Limited · Final report · Feb 22, 2024 · N6323B · Substantial damage
  > The pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.
- [NTSB WPR17LA078](https://openairdocs.org/ntsb/WPR17LA078.md): Swearingen SA226 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Mar 20, 2017 · N158WA · Substantial damage
  > Company maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.
- [NTSB WPR12CA401](https://openairdocs.org/ntsb/WPR12CA401.md): Piper PA-22-108 · Lewiston, ID · Accident · No injuries · Data collection · Final report · Sep 4, 2012 · N4798Z · Substantial damage
  > The pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.
- [NTSB WPR12LA143](https://openairdocs.org/ntsb/WPR12LA143.md): Reich Glastar · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Mar 22, 2012 · N617G · Substantial damage
  > The failure of a propeller blade at the hub due to fatigue cracking.
- [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…

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

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