NTSB investigations: Pratt & Whitney Canada JT15D-4 series, 2002
5 cases on aircraft whose registry engine model is Pratt & Whitney Canada JT15D-4 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1986 | 1 |
|---|---|
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 5 |
| 2005 | 2 |
| 2007 | 3 |
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\") = 2002
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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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") = 2002
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX02LA252Accident · No injuriesLimited investigationFinal reportCessna S550 · Big Bear City, CAThe pilot's failure to obtain the proper touchdown point which resulted in an overrun. Contributing factors were the pilot's improper in-flight planning, improper use of performance data, the tailwind condition, failure to perform a go-around, and the…NTSB FTW02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Bethany, OKthe anomalous elevator trim system and the pilot's failure to note its improper setting prior to takeoff.NTSB CHI02LA115Accident · No injuriesLimited investigationFinal reportCessna 551 · Lake in Hills, ILThe deer on the runway.NTSB CHI02FA097Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Anderson, INMissed approach not executed and flight to a destination alternate not performed by the flight crew. The tail wind and snow/ice covered runway were contributing factors.NTSB NYC02FA059Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Cleveland, OHThe pilot's failure to obtain the proper touch down point on the runway, and the pilot-in-commands failure to initiate a go-round. Factors in the accident were the tailwind condition, the snow-covered runway.