# Final NTSB investigations: Pratt & Whitney Canada PW535A

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 ERA19LA180](https://openairdocs.org/ntsb/ERA19LA180.md): Cessna 560 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · May 24, 2019 · N832R · Destroyed
  > Impact with water for reasons that could not be determined based on the available information.
- [NTSB CEN16IA103](https://openairdocs.org/ntsb/CEN16IA103.md): Cessna 560 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Feb 9, 2016 · N774SB · No damage
  > The loss of aileron trim due to the lack of separation between the cannon head on the back of autopilot cannon plug and the aileron trim tab control gear. Contributing to the incident was the lack of guidance in the airplane maintenance manual to verify…
- [NTSB CHI06FA193](https://openairdocs.org/ntsb/CHI06FA193.md): Cessna 560 · Cresco, IA · Accident · 2 fatal · Field investigation · Final report · Jul 19, 2006 · N636SE · Substantial damage
  > The flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen…
- [NTSB LAX06FA211](https://openairdocs.org/ntsb/LAX06FA211.md): Cessna 560 · Upland, CA · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2006 · N486SB · Destroyed
  > The pilot's unstabilized approach to the runway and failure to obtain the proper touchdown point, which resulted in a runway overrun.

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

This list as a web page: https://openairdocs.org/ntsb?engine=52134&status=final

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