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 MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB LAX95LA137Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Honolulu, HIIntentional ditching due to the flightcrew's failure to properly manage the fuel system, and operation of the airplane in an excessively overweight condition.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB NYC95WA235Accident · 2 fatalForeign investigationDouglas DC-3C · Lobito, Central African RepublicNTSB MIA95LA040Accident · No injuriesLimited investigationFinal reportCessna 208B · Memphis, TNThe inability of the pilot of Cessna 208, N927FE to see Douglas DC3, N24320, as he taxied to takeoff due to inoperative tail navigation lights and beacon lights on the DC3 and due to glare on the wet taxiway.NTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.NTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.NTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB FTW94LA119Accident · Serious injuriesLimited investigationFinal reportCessna 208 · Whitewright, TXThe inadvertent stall when too many parachutist hung on the outside of the aircraft.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB DCA94WA036Accident · No injuriesForeign investigationBeech 2000 (Starship) · Roskilde, DenmarkNTSB FTW94LA003Accident · No injuriesLimited investigationFinal reportCessna 208B · Dfw Airport, TXThe pilot's disregard for the issued safety advisory.NTSB LAX93LA337Accident · No injuriesLimited investigationFinal reportCessna 208B · Los Angeles, CAThe inattention of the driver of a service truck to yield to aircraft and subsequent collision with the airplane as it crossed the service roadway.NTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.NTSB MIA92LA169Accident · No injuriesLimited investigationFinal reportCessna 425 · Greenwood, MSFailure of the pilot-in-command to maintain his descent rate resulting in an undershoot. Contributing to the accident was the chip detector failure due to improper quality control by the manufacturer.NTSB ANC92LA123Accident · No injuriesLimited investigationFinal reportBeech C99 · Nuiqsut, AKThe pilot's improper inflight planning/preparation, and his failure to attain the proper touchdown point. Contributing to the accident was the downdraft.NTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.NTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.NTSB ANC91FA142Accident · No injuriesField investigationFinal reportCessna 208 · Dillingham, AKThe pilot's inattentive preflight inspection which resulted in his failure to properly secure the engine oil tube filler cap resulting in the loss of engine oil and oil pressure and the pilot's failure to properly compensate for wind conditions during the…NTSB FTW91DRG04Accident · Serious injuriesFinal reportAir Tractor AT-402 · Taft, TXThe pilot's failure to maintain proper terrain clearance.NTSB CHI91DER07Accident · No injuriesFinal reportPiper PA-36-375 · Breckentidge, MNThe pilot's failure to take adequate remedial action during the attempted climb out. A related factor is the premature lift off.NTSB MIA91IA117Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Ochopee, FLFailure of the student to use the checklist, inadequate supervision by the pic/cfi, and inadequate supervision by the FAA principle operations inspector.NTSB CHI91LA103Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Chicago, ILAn excessive landing flare by the copilot. Factors associated with the accident are the inoperative wing flaps and the captain's inadequate supervison.NTSB NYC90FA104Accident · No injuriesField investigationFinal reportShort Brothers SD3-60-200 · Jamaica, NYPilot factor in that the pilot taxied into a hold position that was too close to a departing B-747, which resulted in the a/c being blown into a blast fence. Contributing was the lack of available information from the aircraft manufacturer which would have…NTSB NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.NTSB LAX90LA110Accident · No injuriesLimited investigationFinal reportCessna 208B · Lanai, HIThe pilot's misjudgement of the glide path angle while executing a forced landing at the Lanai airport. Contributing to the accident was the failure of the pilot to properly secure the oil filter cap prior to departure.NTSB MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB MIA89LA193Accident · No injuriesLimited investigationFinal reportCessna 208B · Fort Myers, FLImproper flare by the pilot for landing and improper remedial action. A contributing factor was the lack of airspeed on final approach.NTSB DEN88IA207Incident · No injuriesIncident investigationFinal reportBeech 1900 · Denver, CONTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…NTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…NTSB LAX87LA250Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Grand Canyon, AZWhile taxiing for takeoff, the underside of the left wing struck the boom of a backhoe parked adjacent to the aircraft ramp. The unattended backhoe was parked in a dirt area adjacent to the ramp with the boom in the extended position while the operator was on…NTSB ATL87FA161Accident · No injuriesField investigationFinal reportCessna 208B · Atlanta, GAThe two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…NTSB LAX87DVA09Accident · No injuriesFinal reportAyres S2R-T34 · Mendota, CADuring an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the…NTSB ANC86LA147Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot was unable to avoid a large floating log in his water lane path during takeoff. He struck the log, lost control of the airplane and crashed.NTSB DEN85LA244Accident · No injuriesLimited investigationFinal reportCessna 425 · Boulder, COThe plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…NTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…NTSB FTW82DA372Accident · No injuriesFinal reportAir Tractor AT-400 · Muleshoe, TXPilot collided with a water spraying machine while making crop spray pass. Landing gear tore off.NTSB FTW82DA301Accident · No injuriesFinal reportBeech B99A · Abilene, TXThe pilot was in the left seat and was getting a check ride from the chief pilot who was in the right seat. After making a series of touch-and-go landings, the aircraft pulled slightly to the left during a takeoff. A full pattern was then flown to runway 17R…NTSB FTW81IA026Incident · No injuriesClosedBeech E18S · Albuquerque, NMNTSB FTW81FPM04Accident · No injuriesClosedBeech E18S · Tulsa, OKNTSB FTW80FPD28Accident · No injuriesClosedAero-Comdr S-2R · Grandbury, TXNTSB ANC80FA025Accident · Minor injuriesClosedDehavnd Can DHC-6 · Kenai, AKNTSB LAX78DUJ99Accident · No injuriesClosedAero Comdr S2R · Gila Bend, AZNTSB CHI78FEE14Accident · No injuriesClosedBeech E18 · Chicago, ILNTSB MIA69D0396Accident · No injuriesClosedBeech E18S · Nassau, Burkina FasoNTSB UNK65X0805Accident · No injuriesClosedBeechcraft E18 · East Boston, MA