NTSB investigations: Pratt & Whitney Canada JT15D 5 series, 2006
2 cases on aircraft whose registry engine model is Pratt & Whitney Canada JT15D 5 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
| 1994 | 1 |
|---|---|
| 1999 | 1 |
| 2002 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
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\") = 2006
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52113'))
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") = 2006
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52113'))
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 ENG06IA020Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Norfolk, VAHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the engine high pressure compressor when the pilots retarded the power levers causing compressor surges and the flameouts of both engines. Contributing factors were…NTSB SEA06MA047Accident · 4 fatalMajor investigationFinal reportCessna 560 · Carlsbad, CAThe captain's delayed decision to execute a balked landing (go-around) during the landing roll. Factors contributing to the accident include the captain's improper decision to land with a tailwind, his excessive airspeed on final approach, and his failure to…