# Ongoing NTSB investigations: Piper PA-28-235

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 CEN27LA019](https://openairdocs.org/ntsb/CEN27LA019.md): Piper PA-28-235 · Cedar Rapids, IA · Accident · Minor injuries · Class 3 · Limited · Investigation open · Oct 18, 2026 · N8759W
- [NTSB ANC26LA053](https://openairdocs.org/ntsb/ANC26LA053.md): Piper PA-28-235 · Key West, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 14, 2026 · N15564 · Substantial damage
  > On June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…
- [NTSB CEN26LA042](https://openairdocs.org/ntsb/CEN26LA042.md): Piper PA-28-235 · Castle Rock, CO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N9143W · Substantial damage
  > On November 10, 2025, about 1815 mountain standard time, a Piper PA-28-235 airplane, N9143W, was substantially damaged when it was involved in an accident near Castle Rock, Colorado. The pilot and one passenger reported no injuries. A second passenger…

## 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."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102810&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.