# NTSB investigations: Piper PA-32R-300, OK

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 GAA19CA554](https://openairdocs.org/ntsb/GAA19CA554.md): Piper PA32R · Owasso, OK · Accident · No injuries · Data collection · Final report · Sep 16, 2019 · N6887J · Substantial damage
  > The pilot's improper altitude and airspeed control during landing, which resulted in the airplane landing long and a subsequent runway overrun and impact with a drainage culvert.
- [NTSB CEN09FA562](https://openairdocs.org/ntsb/CEN09FA562.md): Piper PA-32R-300 · Tulsa, OK · Accident · 5 fatal · Field investigation · Final report · Sep 5, 2009 · N1228H · Destroyed
  > The non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.
- [NTSB FTW84FA342](https://openairdocs.org/ntsb/FTW84FA342.md): Piper PA-32R-300 · Tulsa, OK · Accident · Serious injuries · Field investigation · Final report · Aug 9, 1984 · N5105F · Substantial damage
  > On climbout from a night takeoff, a complete power loss occurred. The plt attempted to return to the airport, but insufficient altitude was available. During an ensuing forced landing, the acft collided with trees before ground impact. An investigation…

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

This list as a web page: https://openairdocs.org/ntsb?model=7103213&state=OK

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