# NTSB investigations: Pratt & Whitney Canada PW150A, ID

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 DCA20CA010](https://openairdocs.org/ntsb/DCA20CA010.md): De Havilland DHC8 · Boise, ID · Accident · No injuries · Data collection · Final report · Oct 29, 2019 · N402QX · Substantial damage
  > a bird strike during climb out.
- [NTSB SEA02IA044](https://openairdocs.org/ntsb/SEA02IA044.md): Bombardier DHC-8-401 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Mar 2, 2002 · N410QX · No damage
  > The partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…

## 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" = 'ID' 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 ('52167'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52167&state=ID

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