NTSB investigations: Pratt & Whitney PT6A series, CO
28 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
| 1985 | 1 |
|---|---|
| 1988 | 1 |
| 1992 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
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 CEN26LA127Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B36TC · Durango, COThe pilot’s improper landing flare and subsequent loss of directional control while attempting to land during high crosswind conditions.NTSB CEN20LA083Accident · No injuriesClass 3 · LimitedFinal reportPiaggio P180 · Broomfield, COThe pilot’s loss of directional control on the snow-covered runway, which resulted in a runway excursion.NTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.NTSB GAA15CA194Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Monte Vista, COThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with objects.NTSB ENG14IA018Incident · No injuriesIncident investigationFinal reportPiper PA46 500TP · Denver, COThe pilots' incorrect activation of the Manual Override Lever, during ground operation, in an attempt to correct a sub-idle speed condition of the engine, resulting in an over-temperature of the CT blades, their subsequent distress and failure of the engine.…NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB DCA13FA148Accident · No injuriesField investigationFinal reportBeech 1900D · Telluride, COFailure of the left main landing gear actuator internal lock to engage in the locked position for undetermined reasons.NTSB ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN11LA323Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Arriba, COThe pilot’s controlled flight into terrain for undetermined reasons.NTSB CEN10LA315Accident · No injuriesLimited investigationFinal reportBeech 1900D · Denver, COThe pre-existent damage of the right-hand landing gear actuator attachment lug which led to fatigue cracking and eventual overload failure resulting in a collapsed gear upon landing.NTSB CEN09FA126Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Hayden, COThe pilot's loss of control due to snow/ice contamination on the airplane's lifting surfaces as a result of his decision not to deice the airplane before departure.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 DEN07LA030Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Steamboat Springs, COThe inadequate design of the engine mount, which caused an uncommanded left turn, loss of directional control, and impact with snow-covered terrain. Contributing to the accident was the low nose gear tire pressure.NTSB DEN06IA019Incident · No injuriesIncident investigationFinal reportBeech 1900D · Telluride, COThe tug driver's failure to maintain adequate clearance from the airplane resulting in the baggage cart striking the airplane's stabilon. A factor contributing to the incident was the tug driver's failure to consider the extra height of the cart in relation…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 DEN05IA092Incident · No injuriesIncident investigationFinal reportBeech 1900D · Grand Junction, COthe flight crew's diverted attention while the number 2 engine was operating and failure to maintain aircraft control which resulted in an inadvertent taxi of the airplane into an airport security fence.NTSB DEN05IA046Incident · Minor injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe tug driver's failure to maintain operational control of the tug, resulting in impact with an airplane. Contributing factors include the tug driver's improper procedure, the tug driver's inadequate initial ground equipment training, and the…NTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.NTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.NTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…NTSB DEN01FA094Accident · 1 fatalField investigationFinal reportCessna 208B · Steamboat Spngs, COan inadvertent stall during an instrument approach, which resulted in a loss of control. Contributing factors were the pilot's attention being diverted by an abnormal indication, conditions conducive to airframe icing, and the pilot's lack of total experience…NTSB DEN01FA075Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Englewood, COthe pilot's spatial disorientation, which led to his failure to maintain aircraft control. A contributing factor was the pilot's decision to intentionally fly into known adverse weather that consisted of low ceilings, obscuration, and ice fog.NTSB DEN99LA149Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402A · Mead, COThe pilot's failure to follow proper approach to landing procedures as outlined in the Airplane Flight Manual. A factor was the 6-foot tall corn stalks.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 FTW97LA088Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Longmont, COFailure of the pilot to refuel the airplane, resulting in fuel exhaustion. Factors were the pilot's reference to similar but different aircraft performance charts, and the operator's failure to provide the pilot with the proper performance charts.NTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.NTSB DEN88IA207Incident · No injuriesIncident investigationFinal reportBeech 1900 · Denver, CONTSB DEN85LA244Accident · No injuriesLimited investigationFinal reportCessna 425 · Boulder, COThe plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…