Fatal NTSB investigations: Pratt & Whitney PT6A series, 2007
9 cases on aircraft whose registry engine model is Pratt & Whitney PT6A 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
| 1983 | 1 |
|---|---|
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 8 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 5 |
| 2007 | 9 |
| 2008 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 9 |
| 2015 | 2 |
| 2016 | 8 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 1 |
Where
Latest 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\") = 2007
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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") = 2007
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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 CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.NTSB LAX08MA007Accident · 10 fatalMajor investigationFinal reportCessna 208B · Naches, WAThe pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…NTSB DEN08FA003Accident · 3 fatalField investigationFinal reportRaytheon C90A · Pagosa Springs, COThe pilot's failure to maintain clearance from mountainous terrain. Contributing to the accident was the pilot's inadequate preflight planning, improper in-flight planning and decision making, the dark night, and the controller's failure to issue a safety…NTSB ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.NTSB CHI07LA213Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Laurel, IAThe pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.NTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandNTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB DEN07WA060Accident · 1 fatalForeign investigationPiper PA-31T · Rieschweiler, GermanyNTSB NYC07FA065Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Dartmouth, MABoth pilots' failure to maintain aircraft control during a missed approach.