NTSB investigations: Pratt & Whitney PW4000 series
111 cases on aircraft whose registry engine model is Pratt & Whitney PW4000 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 ('52119'))
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 ('52119'))
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 DCA12WA131Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 27, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB DCA12WA109Accident · Serious injuriesForeign investigationBoeing 777-222 · Narita, JapanNTSB ENG12IA003Incident · No injuriesIncident investigationFinal reportBoeing 747-451 · Detroit, MIThe penetration of turbine blade fragments through the rear turbine case, which punctured the No. 4 bearing oil pressure supply tube, allowing misted oil to contact the hot engine case and ignite the undercowl fire. Contributing to the incident was the…NTSB DCA11FA091Accident · Serious injuriesField investigationFinal reportBoeing 747-422 · Tangshan, Chinaan inadvertent encounter with convectively induced turbulence likely due to radar limitations and convective weather developing upwards into the flight path.NTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.NTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.NTSB DCA10IA082Incident · Minor injuriesIncident investigationFinal reportBoeing 767-322 · Chicago, ILthe brake fire after landing was caused by hydraulic fluid leaking on to hot brakes.NTSB ENG10WA044Incident · No injuriesForeign investigationBoeing 777 · Tokyo, JapanOn July 28, 2010, at about 0904 UTC, the crew of a United Airlines Boeing 777-200B airplane, N219UA, operating as flight 852, heard a loud bang from the right hand (number 2) engine while climbing through 11,000 feet above Mean Sea Level (MSL), followed after…NTSB DCA10FA076Accident · Serious injuriesField investigationFinal reportBoeing 767 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with clear air turbulence.NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.NTSB OPS10IA020Incident · No injuriesIncident investigationFinal reportBoeing 777-222 · San Francisco, CAThe local controller's issuance of a takeoff clearance to the Boeing 777 without ensuring that approved separation would exist with the Cessna 182. Contributing to the incident were tower procedures that permitted transitioning aircraft to cross the runway 28…NTSB DCA10CA032Accident · Serious injuriesData collectionFinal reportBoeing 747 · Anchorage, AKan inadvertent encounter with clear air turbulence.NTSB DCA10FA012Accident · Serious injuriesField investigationFinal reportBoeing 777-200 · New Market, VAThe flight crew’s inadvertent encounter with a small area of cumulous clouds at night that resulted in moderate to severe convectively induced turbulence.NTSB OPS10IA001Incident · No injuriesIncident investigationFinal reportBoeing 767 · Atlanta Hartsfield Intl. Apt. (KATL), GAThe flight crew’s failure to identify the correct landing surface due to fatigue. Contributing to the cause of the incident were (1) the flight crew’s decision to accept a late runway change, (2) the unavailability of the approach light system and the…NTSB DCA09WA066Incident · No injuriesForeign investigationBoeing 767 · Keflavik, IcelandOn July 20, 2009, UAL flight 949, a B767 enroute from London Heathrow to Chicago O'Hare experienced smoke in the cockpit and the crew elected to divert to Keflavik, Iceland. The flight landed without further incident and no injuries among the 11 crew and 178…NTSB DCA09IA064Incident · No injuriesIncident investigationFinal reportAirbus A330-323 · Kagoshima, JapanBrief and temporary blockage of the pitot probes in cruise flight, most likely due to ice crystals aloft, leading to erroneous airspeed indications and airplane automation degradation as designed. Contributing to the incidents were design features of the…NTSB DCA09RA041Accident · 2 fatalClass 5 · ForeignMcdonnell Douglas MD11 · Narita, JapanOn March 23, 2009, at 0649 local time, a FedEx Boeing (McDonnell Douglas) MD-11 crashed upon landing at Narita International Airport (NRT), Narita, Japan. The flight originated at Guangzho Baiyun International Airport (CAN), Guangzho, China. Both pilots were…NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanNTSB OPS08IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Seattle, WAThe diverted attention during taxi of the flight crew in the other aircraft. Contributing to the incident was the air traffic control clearance was not followed by the flight crew of the other aircraft.NTSB CHI08FA050Accident · Serious injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILEmergency evacuation due to dense smoke in the cabin and the possibility of an on-board fire, which resulted in a serious injury to one of the 264 passengers and crew. An additional cause was the failure of an engine bearing, allowing oil to migrate into the…NTSB LAX07LA204Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · OceanicAn in-flight encounter with turbulence that resulted in serious injury to a flight attendant.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB ENG07RA014Accident · No injuriesForeign investigationBoeing 777-200B · London, United KingdomNTSB DCA06WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesNTSB NYC06LA151Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Dulles, VAThe driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.NTSB DCA06WA035Accident · Serious injuriesForeign investigationBoeing 777 · Shanghai, ChinaNTSB DEN06IA034Incident · No injuriesIncident investigationFinal reportBoeing B777-200B · Denver, COthe truck driver's failure to maintain clearance from the airplane and the boom operator's failure to adequately clear the boom from the airplane. Contributing to the accident was the low visibility due to snow and mist.NTSB SEA05LA184Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-223 · Portland, ORThe failure of the flightcrew of the other airplane to maintain clearance while taxiing.NTSB ANC05IA064Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Anchorage, AKThe inadequate installation of the cockpit security door locking device, which resulted in smoke in the cockpit during normal cruise, and a precautionary landing. A factor associated with the incident was the manufacturer's insufficiently defined installation…NTSB DCA05WA043Incident · Minor injuriesForeign investigationBoeing B767 · Buenos Aires, ArgentinaNTSB DCA05WA032Incident · No injuriesForeign investigationBoeing B-767-332 · Nice, FranceNTSB ANC05IA002Incident · No injuriesIncident investigationFinal reportBoeing MD-11F · Anchorage, AKThe operator's failure to provide sufficient weight and balance information to the flight crew, which resulted in a center of gravity aft of the limit, and a tail strike during the takeoff roll. Factors associated with the incident are the operator's improper…NTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.NTSB LAX04LA007Accident · No injuriesLimited investigationFinal reportBoeing 777-22B · San Francisco, CAthe failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…NTSB CHI03LA237Accident · Serious injuriesLimited investigationFinal reportBoeing B777-222 · Chicago, ILThe turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.NTSB CHI03IA097Incident · No injuriesIncident investigationFinal reportBoeing 747-422 · Chicago, ILFailure of company maintenance personnel to fully comply with published maintenance/inspection procedures, as well as the resulting inoperative drain heaters and restricted movement of the aileron control cables. Contributing factors were the impeded waste…NTSB ANC03IA001Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Anchorage, AKThe fatigue fracture of the lower rudder power control module manifold, which resulted in a lower rudder hardover.NTSB MIA02WA176Incident · No injuriesForeign investigationBoeing 767-332ER · Buenos Aires, ArgentinaNTSB ATL01WA106Accident · Serious injuriesForeign investigationBoeing B767-332 · Buenos Aires, ArgentinaNTSB DCA01WA050Incident · No injuriesForeign investigationBoeing 777 · Frankfurt, GermanyNTSB DCA01WA045Incident · No injuriesForeign investigationBoeing B-747-400 · Tokyo, JapanNTSB IAD00IA032Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · New York City, NYThe first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.NTSB CHI00WA045Accident · Serious injuriesForeign investigationBoeing 777-222 · London, United KingdomNTSB DCA00WA007Accident · No injuriesForeign investigationBoeing 777-200 · London, United KingdomNTSB MIA99LA272Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Atlanta, GAFAA approach/departure controller's improper service and failure to coordinate and resolve a conflict between aircraft prior to effecting a frequency change, and the improper application of visual separation rules to a flight in the clouds, resulting the crew…NTSB DCA99WA085Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Shannon, IrelandNTSB CHI99LA184Accident · Serious injuriesLimited investigationFinal reportBoeing 777-222 · Madison, WIthe pilot-in-command's inadequate evaluation of the weather conditions. Factors associated with the accident were the turbulence encountered and the seat belt sign was not illuminated.NTSB LAX99LA212Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)intentional tampering/altering of a galley lift interlock microswitch by unknown persons.NTSB MIA99WA029Accident · Serious injuriesForeign investigationBoeing 777-222B · Concepcion, BoliviaNTSB ATL99WA004Accident · Serious injuriesForeign investigationBoeing 767-332 · Sao Paulo, Brazil