Final NTSB investigations: Pratt & Whitney Canada PT6A-60A
243 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A. 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52043', '51999'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52043', '51999'))
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 ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.NTSB ERA14IA249Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Warren, VTThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR14LA102Accident · No injuriesLimited investigationFinal reportBeech C90 · Columbia, CAThe pilot’s unstabilized night visual approach, which resulted in a hard landing and the collapse of all three landing gear.NTSB ERA14CA030Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Charleston, MSThe pilot's failure to maintain directional control, which resulted in a runway excursion and collision with a fence.NTSB CEN13LA426Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Shannon, ILThe pilot’s inability to maintain an adequate climb rate after encountering a sudden wind shift during takeoff.NTSB ERA13LA138Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Fort Gaines, GAThe total loss of engine power due to fuel starvation as a result of debris in the fuel control unit.NTSB WPR13FA115Accident · 2 fatalField investigationFinal reportBeech E90 · Casa Grande, AZThe pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin.NTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB ANC12CA042Accident · No injuriesData collectionFinal reportBeech 1900C · McGrath, AKThe pilot's unstable approach and overrotation, which resulted in a tailstrike.NTSB ERA12CA382Accident · No injuriesData collectionFinal reportBeech B90 · Savannah, GAThe pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.NTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…NTSB WPR12LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Cheyenne, WYThe flight crew’s failure to properly latch the cabin door before takeoff.NTSB WPR11LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lewistown, MTThe fatigue fracture and separation of the fuel bypass line, which resulted in a total loss of engine power.NTSB ERA11LA330Accident · No injuriesLimited investigationFinal reportBeech C90 · Camden, SCThe pilot's in-flight decision to continue toward his destination, through known significant weather, when safer alternatives were available.NTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB ANC11LA004Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sitka, AKA lightning strike which resulted in substantial damage to the elevator.NTSB OPS10IA574Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-214 · Minneapolis, MNThe Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…NTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.NTSB CEN10LA090Accident · No injuriesLimited investigationFinal reportBeech C-99 · Kearney, NEThe failure of the pilot to maintain adequate airspeed during the approach resulting in a stall. Contributing to the accident was the accumulation of structural icing during the flight.NTSB CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.NTSB ERA09LA394Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Hertford, NCThe in-flight collision with terrain for undetermined reasons.NTSB ERA09LA344Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 Twin · Orange, VAThe pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.NTSB WPR09LA228Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marysville, CAThe failure of both pilots to see and avoid the other airplane while making their final approach for landing.NTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.NTSB CEN09LA173Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pueblo, COThe pilot's improper flare and recovery from a bounced landing.NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB MIA08CA170Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Satartia, MSThe pilot's inadequate visual lookout resulting in the in-flight collision with a 40-foot-tall antenna.NTSB LAX08MA277Accident · 10 fatalMajor investigationFinal reportBeech A100 · Moab, UTThe pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.NTSB CHI08CA212Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Clinton, ILThe inadequate in-flight planning/decision making and the altitude/clearance not maintained by the pilot during the aerial application. A contributing factor was the guy wire.NTSB LAX08CA151Accident · No injuriesData collectionFinal reportBeech B200 · Travis AFB, CAThe pilot inadvertently raised the landing gear during landing roll.NTSB SEA08CA113Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Waitsburg, WAThe pilot's failure to maintain clearance from the terrain while maneuvering at low altitude. Contributing to the accident was the rising terrain.NTSB DFW08LA055Accident · 1 fatalLimited investigationFinal reportPilatus PC-12/45 · Oklahoma City, OKThe line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.NTSB ANC08IA026Incident · Minor injuriesIncident investigationFinal reportBeech 1900 · Aniak, AKA hazardous leak from carbon dioxide cylinders due to the failure of the flight crew to properly load and secure the cylinders, resulting in crew incapacitation. Factors contributing to the incident were improper hazardous materials procedures used by the…NTSB NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.NTSB DFW07CA104Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Benoit, MSThe pilot's failure to maintain clearance with the crops which resulted in a ground loop. A contributing factor was the narrow airstripNTSB DEN07LA090Incident · No injuriesLimited investigationFinal reportBeech 200 · Angel Fire, NMThe pilot's inability to maintain clearance from the snow bank. Contributing factors were the pilot's failure to perform a go-around/missed approach procedure after observing snow removal equipment on the runway, the pilot's improper in-flight planning and…NTSB NYC06MA192Accident · 1 fatalMajor investigationFinal reportEmbraer 110P1 · Pownal, VTThe pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…NTSB CHI06LA062Accident · No injuriesLimited investigationFinal reportBeech A100 · Sault Ste Marie, MIThe inadequate in-flight decision to continue the approach to land, directional control not maintained, and the contaminated runway. Contributing factors were flight to destination alternate not performed, a notice to airman not issued by airport personnel…NTSB SEA06FA022Accident · 1 fatalField investigationFinal reportCessna 425 · Belgrade, MTThe pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.NTSB DFW05CA225Accident · No injuriesData collectionFinal reportAyres S2R-T15 · Taylor, TXThe pilot's misjudgement while landing resulting in an overrun. A factor was fluctuating engine power.NTSB DEN05FA126Accident · 4 fatalField investigationFinal reportCessna 425 · Lone Tree, COThe pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB LAX05CA250Accident · No injuriesData collectionFinal reportAyres S2R-134 · Kerman, CAthe pilot's failure to obtain an adequate airspeed during an attempted takeoff.NTSB DFW05FA170Accident · 5 fatalField investigationFinal reportBeech E90 · New Roads, LAThe pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.NTSB IAD05LA073Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 · Rittman, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a stall and subsequent impact with the ground.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB LAX05LA100Accident · 1 fatalLimited investigationFinal reportAyres S2R · Firebaugh, CAthe loss of engine power during takeoff climb resulting from the fatigue failure of one of the compressor turbine blades; the cause of the fatigue failure could not be definitively determined.NTSB ANC05LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Toksook Bay, AKThe pilot's inadequate compensation for the gusty crosswind wind condition, which resulted in a loss of control during the landing roll, and the collapse of the nose landing gear. Factors associated with the accident were the crosswind and wind gusts.