# Ongoing NTSB investigations, OK: Loss of engine power (partial)

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 CEN27LA029](https://openairdocs.org/ntsb/CEN27LA029.md): Piper PA-28 · Claremore, OK · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 22, 2026 · N5393W · Substantial damage
  > On October 22, 2026, about 1510 central daylight time, a Piper PA-28-160 airplane, N5393W, was substantially damaged when it was involved in an accident near Claremore, Oklahoma. The flight instructor and student pilot were not injured. The airplane was…
- [NTSB CEN26LA248](https://openairdocs.org/ntsb/CEN26LA248.md): Piper PA-30 · Tulsa, OK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 9, 2026 · N8154Y · Substantial damage
  > On July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…

## 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" = 'OK' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '342')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/342/cases?state=OK&status=ongoing

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