# NTSB investigations: Pratt & Whitney Canada JT15D-4 series, 2007

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 SEA08LA041](https://openairdocs.org/ntsb/SEA08LA041.md): Cessna 551 · Coeur d'Alene, ID · Accident · No injuries · Limited investigation · Final report · Dec 3, 2007 · N551GF · Substantial damage
  > The pilot's failure to maintain aircraft control during landing roll out. Contributing to the accident was the slush contaminated runway and the crosswind weather conditions.
- [NTSB CHI07MA160](https://openairdocs.org/ntsb/CHI07MA160.md): Cessna 550 · Milwaukee, WI · Accident · 6 fatal · Class 1 · Major · Final report · Jun 4, 2007 · N550BP · Destroyed
  > The National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…
- [NTSB NYC07FA058](https://openairdocs.org/ntsb/NYC07FA058.md): Cessna 550 · Butler, PA · Accident · Serious injuries · Field investigation · Final report · Jan 24, 2007 · N492AT · Substantial damage
  > The copilot's failure to maintain the proper airspeed, and failure to obtain the proper touchdown point, and the pilot-in-command's inadequate supervision, which resulted in an overrun. Contributing to the accident was the PIC's failure to activate the speed…

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

This list as a web page: https://openairdocs.org/ntsb?engine=52112&year=2007

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