# NTSB investigations, WY: 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 WPR23LA283](https://openairdocs.org/ntsb/WPR23LA283.md): Beech C35 · Rock Springs, WY · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 20, 2023 · N620D · Substantial damage
  > Maintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.
- [NTSB WPR22LA253](https://openairdocs.org/ntsb/WPR22LA253.md): Cessna P210N · Buffalo, WY · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 14, 2022 · N731BJ · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into localized instrument meteorological conditions, which resulted in an encounter with convective turbulence and a subsequent loss of control and in-flight breakup.
- [NTSB WPR21LA108](https://openairdocs.org/ntsb/WPR21LA108.md): Abbett Gerry Lancair Evolution · Saratoga, WY · Accident · No injuries · Class 3 · Limited · Final report · Feb 8, 2021 · N7569A · Substantial damage
  > A windshield failure during cruise flight due to stress concentrations in the bond area as a result of improper assembly of the windshield.
- [NTSB CEN17FA035](https://openairdocs.org/ntsb/CEN17FA035.md): Stamper RV-10 · Dubois, WY · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2016 · N924WY · Destroyed
  > The pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…
- [NTSB CEN16LA330](https://openairdocs.org/ntsb/CEN16LA330.md): Hiller UH 12D · Cokeville, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 2016 · N97TH · Substantial damage
  > Failure of the control rotor cuff due to fatigue.
- [NTSB WPR12LA030](https://openairdocs.org/ntsb/WPR12LA030.md): Piper PA-31T · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Nov 8, 2011 · N39EH · Substantial damage
  > The flight crew’s failure to properly latch the cabin door before takeoff.
- [NTSB WPR10CA437](https://openairdocs.org/ntsb/WPR10CA437.md): Holt Herbert L Long EZ · Afton, WY · Accident · No injuries · Data collection · Final report · Aug 29, 2010 · N31939 · Substantial damage
  > The pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.

## 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" = 'WY' 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" = '338' 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/338/sequence?state=WY

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