# NTSB investigations: Pratt & Whitney Canada PT6A-60A, 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 DFW08LA055](https://openairdocs.org/ntsb/DFW08LA055.md): Pilatus PC-12/45 · Oklahoma City, OK · Accident · 1 fatal · Limited investigation · Final report · Jan 3, 2008 · N398J · No damage
  > The line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.
- [NTSB DFW05LA031](https://openairdocs.org/ntsb/DFW05LA031.md): Beech B200 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2004 · N6PE · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.
- [NTSB FTW83LA158](https://openairdocs.org/ntsb/FTW83LA158.md): Piper PA-31T1 · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N879SW · Substantial damage
  > Witnesses reported that the landing gear was lowered at the outer marker on an ILS approach. The pilot stated that he extended full flaps at about 400 feet AGL just as they broke out of the clouds. Almost immediately after landing the pilot retracted the…

## 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.engine_model_code IN ('52043', '51999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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