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.

NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.Jun 7, 2019 · N60642 · Substantial damageNTSB WPR19LA112Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Morganza, LAA loss of aircraft control due to the separation of the elevator pushrod attachment bolt.Apr 16, 2019 · N599LA · Substantial damageNTSB GAA19WA342Incident · No injuriesForeign investigationRaytheon B200 · Lausanne-Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a RAYTHEON B200 airplane that occurred on February 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Feb 2, 2019 · N7779V · No damageNTSB ANC19FA012Accident · 3 fatalClass 2 · FieldFinal reportBeech 200 · Kake, AKA loss of control for reasons that could not be determined based on the available information.Jan 30, 2019 · N13LY · DestroyedNTSB GAA19CA078Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Americus, GAThe pilot's failure to see and avoid a power line during an agricultural application flight.Nov 28, 2018 · N843WA · Substantial damageNTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…Nov 24, 2018 · N781FE · No damageNTSB CEN19FA003Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Placedo, TXThe pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.Oct 12, 2018 · N6135P · DestroyedNTSB GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.Oct 8, 2018 · N1500E · Substantial damageNTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.Sep 3, 2018 · N97WC · Substantial damageNTSB WPR18LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 400 · Grand Forks, NDThe loss of engine power while maneuvering due to the failure of the power turbine blade assembly for reasons that could not be determined based on available evidence.Aug 21, 2018 · N7300M · Substantial damageNTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.Jul 30, 2018 · N205SK · Substantial damageNTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.Jul 11, 2018 · N8508P · DestroyedNTSB CEN18LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT502 · Tappen, NDThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jun 28, 2018 · N502S · Substantial damageNTSB CEN18FA201Accident · 1 fatalField investigationFinal reportAyres S2R · El Reno, OKThe pilot's failure to maintain clearance from tower guy wires while maneuvering during an aerial application flight.May 30, 2018 · N2249B · DestroyedNTSB CEN18LA194Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Qulin, MOThe pilot’s improper weight-and-balance calculations and his decision to take off with the airplane at a high gross weight in high density altitude conditions, which resulted in an attempted takeoff that exceeded the airplane’s performance capability. Also…May 27, 2018 · N6180J · Substantial damageNTSB GAA18CA309Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Nicolaus, CAThe pilot’s failure to maintain adequate clearance from a power transmission wire.May 19, 2018 · N5128N · Substantial damageNTSB GAA18CA187Accident · No injuriesData collectionFinal reportBeech 99 · King Salmon, AKThe pilot’s failure to maintain an adequate approach path and runway centerline during the initial landing, which resulted in a hard landing to the left of the runway and damage to the landing gear and wing.Mar 29, 2018 · N31TN · Substantial damageNTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.Feb 18, 2018 · N700VX · DestroyedNTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.Feb 12, 2018 · N118MF · Substantial damageNTSB ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.Nov 25, 2017 · N863RB · Substantial damageNTSB CEN18LA019Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502B · Olton, TXThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Oct 24, 2017 · N502G · DestroyedNTSB ANC18LA005Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Anchorage, AKThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing. Contributing to the accident was the pilot's fatigue and complacency.Oct 21, 2017 · N363JH · Substantial damageNTSB WPR17LA207Accident · No injuriesLimited investigationFinal reportCessna 208B · Sedona, AZThe pilot's failure to maintain clearance from a light pole while taxiing.Sep 16, 2017 · N786WW · Substantial damageNTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.Aug 16, 2017 · N6082B · Substantial damageNTSB GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.Aug 4, 2017 · N9829B · Substantial damageNTSB WPR17LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802A · Wells, NVThe pilot's failure to maintain directional control during a period of thermal activity, which led to a runway excursion and impact with terrain.Jul 31, 2017 · N70LA · Substantial damageNTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.Jul 21, 2017 · N802TW · Substantial damageNTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.Jul 2, 2017 · N6135P · Substantial damageNTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.Jun 22, 2017 · N700LA · DestroyedNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · Substantial damageNTSB GAA17CA285Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Dumas, TXThe pilot’s failure to maintain lateral control while maneuvering at a low altitude.May 15, 2017 · N319BM · Substantial damageNTSB DCA17FA109Accident · 2 fatalField investigationFinal reportShort Bros. & Harland SD3 30 · Charleston, WVthe flight crew's improper decision to conduct a circling approach contrary to the operator's standard operating procedures (SOP) and the captain's excessive descent rate and maneuvering during the approach, which led to inadvertent, uncontrolled contact with…May 5, 2017 · N334AC · Substantial damageNTSB ANC17FA021Accident · 1 fatalField investigationFinal reportCessna 208B · Chignik Lake, AKThe pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…May 1, 2017 · N803TH · Substantial damageNTSB CEN17LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Vidrine, LAThe total loss of engine power for reasons that could not be determined because an examination of the engine and a test run did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Apr 21, 2017 · N653LA · Substantial damageNTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.Mar 11, 2017 · N865MA · Substantial damageNTSB CEN17LA121Accident · No injuriesLimited investigationFinal reportBeech C90A · Rattan, OKThe loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the…Feb 14, 2017 · N1551C · Substantial damageNTSB 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.Jan 24, 2017 · N216CS · Substantial damageNTSB WPR17LA056Accident · No injuriesLimited investigationFinal reportBeech 99 · Billings, MTThe fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.Jan 19, 2017 · N326CA · Substantial damageNTSB WPR17LA031Accident · No injuriesLimited investigationFinal reportPiper PA 31T · Missoula, MTFailure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.Dec 5, 2016 · N909PW · Substantial damageNTSB CEN17LA027Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Hereford, TXThe pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.Oct 27, 2016 · N8525G · Substantial damageNTSB ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…Oct 2, 2016 · N208SD · DestroyedNTSB DCA16WA242Incident · No injuriesForeign investigationBeech 1900C · Long Key, BahamasThe Bahamas Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a Beech 1900 on September 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of ICAO Annex…Sep 30, 2016 · N376SANTSB GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.Sep 9, 2016 · N750SS · Substantial damageNTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.Aug 19, 2016 · N40499 · DestroyedNTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.Aug 8, 2016 · N634LA · Substantial damageNTSB ANC16FA052Accident · Minor injuriesField investigationFinal reportCessna 210-5 · Wasilla, AKThe failure of both pilots to see and avoid each other while landing at a non-tower-controlled airport, which resulted in a midair collision. Contributing to the accident was the absence of radio calls from the Cessna during the traffic pattern preceding the…Aug 5, 2016 · N1839Z · 2 aircraft · Substantial damageNTSB WPR16FA153Accident · 4 fatalField investigationFinal reportPiper PA-31T · McKinleyville, CAAn inflight fire in the floor area near the main bus tie circuit breaker panel that resulted from chafing between an electrical wire and a hydraulic line and/or airplane structure.Jul 29, 2016 · N661TC · DestroyedNTSB CEN16LA292Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 402 · Sac City, IAThe pilot's failure to maintain adequate clearance from power lines. Contributing to the accident was the pilot's failure to circle over the field to identify hazards before beginning the aerial application.Jul 29, 2016 · N1016G · DestroyedNTSB WPR16LA150Accident · No injuriesLimited investigationFinal reportBeech 65 A90 · Byron, CAThe pilot’s failure to maintain an adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Also causal to the accident was the pilot’s failure to follow prescribed spin…Jul 24, 2016 · N256TA · Substantial damageNTSB WPR16FA148Accident · 1 fatalField investigationFinal reportAir Tractor AT 502B · Zamora, CAThe failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which…Jul 23, 2016 · N502WC · 2 aircraft · Substantial damage