# NTSB investigations, OR: Powerplant sys/comp malf/fail

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 WPR24LA260](https://openairdocs.org/ntsb/WPR24LA260.md): Kitfox Series V · La Grande, OR · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2024 · N53562 · Substantial damage
  > Separation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.
- [NTSB WPR22LA177](https://openairdocs.org/ntsb/WPR22LA177.md): Piper PA-12 · Enterprise, OR · Accident · No injuries · Class 3 · Limited · Final report · May 14, 2022 · N3960M · Substantial damage
  > The inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.
- [NTSB WPR15LA178](https://openairdocs.org/ntsb/WPR15LA178.md): Garlick Helicopters UH 1H · Cove, OR · Accident · No injuries · Limited investigation · Final report · May 31, 2015 · N462CC · Substantial damage
  > The failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.
- [NTSB WPR11LA290](https://openairdocs.org/ntsb/WPR11LA290.md): Christen Industries Pitts S-1T · Alkali Lake, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 2011 · N77MN · Substantial damage
  > The loss of engine oil during cruise flight due to the failure of the front bearing oil seal.
- [NTSB WPR09LA013](https://openairdocs.org/ntsb/WPR09LA013.md): Piper PA-31-350 · Portland, OR · Accident · No injuries · Limited investigation · Final report · Oct 14, 2008 · N3BT · Substantial damage
  > An in-flight engine fire due to the fatigue fracture of an exhaust pipe that resulted from a failure of the pipe's slip joint.
- [NTSB SEA08LA156](https://openairdocs.org/ntsb/SEA08LA156.md): Cessna TR182 · Bend, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2008 · N7XZ · Substantial damage
  > The failure of the crankshaft during cruise flight due to fatigue.
- [NTSB LAX08LA168](https://openairdocs.org/ntsb/LAX08LA168.md): Mkii Lancair Legacy 2000 · Bend, OR · Accident · No injuries · Limited investigation · Final report · Jun 9, 2008 · N199L · Substantial damage
  > A total loss of engine power due to the fatigue failure of the Number 3 cylinder connecting rod.
- [NTSB SEA08LA098](https://openairdocs.org/ntsb/SEA08LA098.md): Kenney RV6 · Aurora, OR · Accident · No injuries · Limited investigation · Final report · Mar 27, 2008 · N65MK · Substantial damage
  > A propeller malfunction for undetermined reasons.

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

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

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