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 CEN22LA371Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T65 · Wyman / Washington, IAThe pilot not maintaining sufficient altitude to clear an obstruction during the aerial application flight.NTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.NTSB CEN22LA310Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Wyoming, ILThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.NTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA22WA137Accident · 3 fatalClass 5 · ForeignBeech C90A · Temixco, MexicoNTSB CEN22LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Grapevine, TXThe failure of the pilot of the second aircraft to maintain a safe distance from the lead airplane while taxiing, which resulted in a ground collision.NTSB CEN22LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Gulfport, MSThe failure of the right main landing gear actuator, which led to a gear-up landing.NTSB CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.NTSB CEN21FA376Accident · 1 fatalClass 3 · FieldFinal reportSocata TBM 700 · Urbana, OHThe pilot’s failure to arrest the airplane’s left roll and rapid descent for reasons that could not be determined based on the available evidence.NTSB WPR21LA313Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 425 · Helena, MTA flameout of both engines due to fuel starvation for reasons that could not be determined due to the airplane’s damage.NTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.NTSB ERA21LA287Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46-500TP · Manteo, NCThe improperly secured pneumatic compressor discharge air (P3) line coupling nut on the engine, which ultimately allowed the nut to back off resulting in a partial loss of engine power.NTSB CEN21LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAyres S2R-T34 · Leoti, KSThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in his inability to maintain airplane control during low-level flight and an impact with terrain. Contributing to the accident was the…NTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.NTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.NTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.NTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.NTSB CEN20WA423IncidentClass 5 · ForeignCessna 208B · Beef Island, British Virgin IslandsNTSB WPR20CA312Accident · No injuriesClass 4 · Data collectionFinal reportBeechcraft C90A · Fortuna, CAA collision with a deer while landing at night.NTSB WPR20LA246Accident · 2 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Elgin, NVThe trailing pilot’s failure to maintain separation from the lead airplane during a fire retardant deployment flight, which resulted in the trailing airplane flying through a plume of retardant and the trailing pilot’s subsequent loss of visibility that led…NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.NTSB CEN20LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT402 · Pine Bluff, ARThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and a loss of airplane control. Contributing was a partial loss of engine power for undetermined reasons.NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.NTSB CEN20CA190Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Bunkie, LAThe pilot's failure to maintain directional control during takeoff.NTSB CEN20CA153Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Mamou, LAThe airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain.NTSB WPR20LA128Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA31T · Billings, MTThe degraded airplane performance after takeoff for reasons that could not be determined from available evidence.NTSB CEN20LA143Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Pecan Gap, TXThe pilot did not maintain adequate clearance from tree, which resulted in a collision with a tree and subsequent impact with terrain.NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.NTSB CEN20CA103Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Bunkie, LAThe pilot's failure to lock the tailwheel before landing, which resulted in his loss of directional control during the landing roll, a runway excursion onto soft ground, and a subsequent ground loop.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 CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB ANC20LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Hooper Bay, AKThe pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility…NTSB ANC20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 200 · Unalaska, AKThe pilot’s improper decision to takeoff downwind and to load the airplane beyond its allowable gross weight and center of gravity limits, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the inadequacy of the…NTSB WPR20CA046Accident · No injuriesData collectionFinal reportBeech 350 · Visalia, CAThe single-engine pilot's failure to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB ANC20LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Honolulu, HIThe pilot of the Cessna's failure to set the parking brake before diverting his attention inside the airplane, which resulted in his airplane colliding with the airplane ahead of it on the taxiway.NTSB CEN20LA013Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502 · Lamesa, TXThe pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.NTSB GAA20CA021Accident · No injuriesData collectionFinal reportWingtip To Wingtip Panzl S-330 · Cedartown, GA***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…NTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.NTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.NTSB CEN19FA259Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Sumner, IAThe pilot’s impairment by medical conditions and/or medications, which resulted in the airplane’s impact with power lines and terrain.NTSB GAA19CA453Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Stanton, TXThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.NTSB ANC19LA031Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208 · Bethel, AKThe pilot’s failure to maintain adequate airspeed while maneuvering during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall at low altitude. Contributing to the accident, was the…NTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…NTSB GAA19CA352Accident · No injuriesData collectionFinal reportAir Tractor AT402 · Liberal, KSThe pilot's failure to see and avoid a windmill tower while maneuvering at low altitude.NTSB GAA19CA354Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · La Ward, TXThe pilot's failure to maintain clearance from a wire during an aerial application flight in sun glare conditions.