NTSB investigations: Pratt & Whitney PT6A series
650 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, newest first
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'))
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'))
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 CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.NTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.NTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.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 SEA01LA080Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T45 · Royal City, WALoss of engine power for undetermined reasons. Trees were a factor.NTSB IAD01LA048Accident · No injuriesLimited investigationFinal reportCessna 208B · Plattsburgh, NYThe incorrect installation of the propeller reversing lever and carbon block assembly, which resulted in a loss of propeller thrust.NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.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 LAX01LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802 A · Maricopa, AZInadequate selection of landing facilities and improper placement of vehicles near the runway. An additional factor was the use of a runway which resulted in a downwind landing.NTSB CHI01FA084Accident · Minor injuriesField investigationFinal reportBeech 1900D · Chicago, ILThe flightcrew not lowering the landing gear and/or verifying the landing gear position as required by three separate checklists, which resulted in an inadvertent gear-up landing. A factor to the accident was the flightcrew not complying with the required…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 NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB LAX01LA019Accident · Serious injuriesLimited investigationFinal reportBeech 300 · Concord, CAthe pilot's delayed decision to abort the takeoff and his failure to utilize the propeller's reverse pitch function.NTSB MIA00IA266Incident · No injuriesIncident investigationFinal reportBeech 1900C · Miami, FLThe excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…NTSB FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB MIA00WA236Accident · No injuriesForeign investigationBeech B200 · Spanish Cay, BahamasNTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.NTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.NTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.NTSB LAX00GA185Accident · Serious injuriesFinal reportBeech 65-90 · China Lake, CAthe inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line. .NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB ANC00LA033Accident · No injuriesLimited investigationFinal reportCessna 208B · Holy Cross, AKAn in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.NTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB CHI00FA071Accident · No injuriesField investigationFinal reportBeech 1900D · Escanaba, MIthe failure of the flightcrew to maintain directional control due to unsafe/hazardous conditions on the runway that was not relayed to them. Factors were the uneven snow covered runway and the snowbank.NTSB MIA00WA062Accident · No injuriesForeign investigationBeech 99A · St. Barthelemy, WNNTSB 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 ANC00LA017Accident · No injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.NTSB MIA00WA033Accident · Minor injuriesForeign investigationBeech C90B · Charallave, VenezuelaNTSB NYC00WA014Accident · No injuriesForeign investigationCessna 208B · Lake Erie, CanadaNTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB LAX99TA274Accident · No injuriesFinal reportAir Tractor AT-802A · Elko, NVThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude margin while engaged in fire fighting operations.NTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.NTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.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 ANC99LA107Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKA failure of ground handling personnel to verify a release procedure/directive, and removal of the airplane's tiedown, and subsequent collision with a parked airplane.NTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.NTSB ANC99LA066Accident · No injuriesLimited investigationFinal reportde Havilland DHC 2 MK III · Anchorage, AKThe certificated flight instructor's inadequate supervision of the duel student. Factors associated with the accident were the student's inadvertent stall, and a surging turboshaft engine.NTSB ATL99LA026Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · La Tortue, HaitiInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).NTSB NYC99WA028Accident · No injuriesForeign investigationCessna 208B · Hamilton, CanadaNTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.