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 NYC07FA065Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Dartmouth, MABoth pilots' failure to maintain aircraft control during a missed approach.NTSB CHI07LA063Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Cape Girardeau, MOThe company pilot's poor judgment before and during the flight, including turning the oxygen system ready switch to the OFF position after he conducted the preflight inspection and using an unapproved checklist, which did not provide guidance for a fractured…NTSB CHI07LA059Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Harbor Springs, MIThe pilot's failure to maintain aircraft control and adequate airspeed during landing flare. Contributing to the accident was the aerodynamic stall/mush encountered at a low altitude.NTSB CHI07CA049Accident · No injuriesData collectionFinal reportBeech 99 · Mosinee, WIThe pilot encountering the unsuitable terrain during the landing. Factors were the dark night and the snowbank.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 CHI07IA067Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Fort Wayne, INThe fatigue failure/separation of the engine mount's nose gear actuator attachment foot, and the manufacturer's inadequate engine mount/nose gear actuator attachment design.NTSB DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…NTSB ATL07CA011Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Linden, ALThe pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.NTSB DFW06CA206Accident · No injuriesData collectionFinal reportBeech B200 · Hondo, TXThe collision with an unmarked pothole in the taxiway while taxiing for departure. A contributing factor was the obscuration by water.NTSB CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB DFW06LA198Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Parkdale, ARThe failure of a compressor turbine blade for undetermined reasons, which resulted in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.NTSB DFW06CA182Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Marvell, ARThe pilot's failure to maintain clearance with terrain during takeoff.NTSB DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.NTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB DFW06CA155Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Minturn, ARThe pilot's inadequate inflight planning/decision, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.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 DFW06CA146Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Tuckerman, ARThe loss of engine power due to water contamination in the fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA137Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Winchester, ARThe pilot's failure to abort the takeoff following the partial loss of engine power for undetermined reasons. A contributing factor was the rising embankment at the end of the runway.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB DFW06LA121Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-802A · Jasper, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable landing for the pilot to execute the forced landing.NTSB LAX06CA142Accident · No injuriesData collectionFinal reportAir Tractor 502A · Stanfield, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB SEA06LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Portland, ORA partial loss of engine power for an undetermined reason during the initial takeoff climb resulting in an in-flight collision with objects.NTSB ANC06CA012Accident · No injuriesData collectionFinal reportCessna 208 · Brevig Mission, AKThe pilot's inadequate compensation for crosswind conditions, which resulted in the left wing striking the ground while taxiing. A factor in the accident was a crosswind.NTSB ANC06CA011Accident · No injuriesData collectionFinal reportCessna 208B · Newtok, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in the airplane exiting the runway, encountering snow, and the nose gear collapsing. Factors associated with the accident were the gusting wind and the icy runway.NTSB ATL06LA022Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-110P1 · Orangeburg, SCThe pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.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 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 NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB DFW06LA010Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Round Rock, TXThe loss of engine power due to the failure of the engine-driven fuel pump. A contributing factor was the inadequate inspection of the engine driven fuel pump.NTSB NYC06LA011Accident · No injuriesLimited investigationFinal reportBeech 1900D · Ogdensburg, NYA collision with a coyote during the takeoff roll, which resulted in a nosegear collapse and subsequent impact with the runway. A factor was the nighttime condition.NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB DFW05CA191Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Gassoway, LAThe pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.NTSB LAX05LA244Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Globe, AZThe fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.NTSB IAD05RA102Accident · 6 fatalForeign investigationPilatus PC-6 · Brasilito, Costa RicaNTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.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 LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.NTSB DFW05IA150Incident · No injuriesIncident investigationFinal reportCessna 208B · Clarendon, TXThe loss of total engine power due to damage of the compressor stator vanes caused by a foreign object. A contributing factor was an in-flight ingestion of bird(s).NTSB DFW05CA131Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Cherry Valley, ARThe pilot's failure to calculate take off-distance performance data, which resulted in insufficient runway length for take off. Factors were the tailwind and high gross weight.NTSB ANC05IA048Incident · No injuriesIncident investigationFinal reportReims F406 · Nome, AKThe failure of the nose gear up lock actuator bracket during the landing approach due to fatigue cracking, which resulted in a nose wheel up landing. A factor associated with the incident is the mechanical binding of the nose wheel locking mechanism.NTSB DFW05CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dumas, ARThe pilot's failure to maintain clearance from the power lines.NTSB ATL05LA046Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402A · Bainbridge, GAThe pilot's inadequate management of the fuel supply, which resulted in fuel starvation.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 DCA05WA019Accident · Serious injuriesForeign investigationShort Brothers SD3-60 · Ontario, Canada