NTSB investigations: Pratt & Whitney PT6A series
17 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series, where the first occurrence was “In flight encounter with weather”. 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
| 1992 | 1 |
|---|---|
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 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 SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.NTSB DFW06CA031Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Osceola, ARThe pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.NTSB DEN05LA109Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Canon City, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the crosswind and windshear conditions.NTSB CHI04FA043Accident · 2 fatalField investigationFinal reportPiper PA46-500TP · Daytona Beach, FLThe unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.NTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.NTSB ANC03LA071Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Kotzebue, AKThe airplane encountered unforecast turbulence, which resulted in serious injury to the pilot.NTSB FTW03FA089Accident · Serious injuriesField investigationFinal reportCessna 208B · San Angelo, TXThe flight crew's failure to cycle the deice boots prior to conducting a simulated forced landing and their failure to maintain adequate airspeed during the maneuver, which resulted in an inadvertent stall and subsequent loss of control. A contributing factor…NTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…NTSB ANC02FA020Accident · No injuriesField investigationFinal reportCessna 208B · Barrow, AKThe pilot's continued flight into adverse weather conditions, and an inadvertent stall. Factors associated with the accident are fog, obscuration, and icing conditions.NTSB DEN01FA041Accident · 9 fatalField investigationFinal reportBeech 65-A90 · Lake Point, UTthe pilot's exercise of poor judgment and his failure to maintain a safe altitude/clearance above the water. Contributing factors were the weather conditions that included low ceiling and visibility obscured by snow and mist, an inadequately equipped airplane…NTSB ATL00LA018Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Adjuntas, PRThe pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.NTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…NTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…NTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.