Skip to content

Final NTSB investigations: Pratt & Whitney JT9D series

18 cases on aircraft whose registry engine model is Pratt & Whitney JT9D 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

Where

Latest cases

Query with SQL

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 ('52054')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('52054'))
  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 ('52054'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN09LA114Accident · No injuriesLimited investigationFinal reportBoeing 747-212B · Rockford, ILThe ground crew's failure to maintain clearance from the light pole while directing the airplane to parking.Dec 23, 2008 · N486EV · Substantial damage NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…Apr 20, 2008 · N704CK · Minor damage NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.Oct 2, 2003 · N479EV · Minor damage NTSB ANC02LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-128 · Anchorage, AKThe flight crew's inadequate preflight planning, and failure to calculate the airplane weight and balance prior to departure.Dec 28, 2001 · N3203Y · Substantial damage NTSB DCA01MA063Accident · 65 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…Sep 11, 2001 · N612UA · Destroyed NTSB ANC01IA007Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Anchorage, AKRupture and disintegration of main landing gear tires during the takeoff roll, and subsequent damage to the right main gear hydraulic brake system.Oct 15, 2000 · N629US · Minor damage NTSB CHI00IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Lafayette, INThe blocked drain lines in the canted pressure deck and the frozen aileron cable.Jun 7, 2000 · N603UA · No damage NTSB SEA99IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 747-238B · Pacific Ocean (Pacific Ocean)An encounter with Clear Air Turbulence at Flight Level 330.Jan 20, 1999 · N14024 · Minor damage NTSB MIA97IA147Incident · No injuriesIncident investigationFinal reportBoeing 747-2R7F · Miami, FLdisbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.Apr 19, 1997 · N639FE · Minor damage NTSB IAD96IA098Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Jamaica, NYfailure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.Jun 18, 1996 · N606FF · Minor damage NTSB CHI95LA078Accident · No injuriesLimited investigationFinal reportBoeing 747-238B · Belleville, MIthe failure of company maintenance personnel to adequately secure the cargo pallets, and the failure of the flightcrew to detect the deficiency during their preflight inspection.Jan 29, 1995 · N706CK · Substantial damage NTSB ANC93IA188Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Anchorage, AKForeign object damage to the compressor forward fan assembly as a result of the ingestion of a bird.Sep 25, 1993 · N629US · Minor damage NTSB NYC93IA184Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New York, NYThe improper installation of the fairing by company maintenance personnel, resulting in the infligh separation of the fairing in flight.Sep 11, 1993 · N17025 · Minor damage NTSB NYC89IA123Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA-227AC · New York, NYThe failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R.Apr 23, 1989 · N3044J · 2 aircraft · No damage NTSB DCA84AA025Accident · No injuriesFinal reportBoeing 727-222 · Denver, COBefore takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…May 31, 1984 · N7640U · Substantial damage NTSB DEN84IA041Incident · No injuriesIncident investigationFinal reportBoeing 767 · Denver, COOn takeoff roll the no 3 wheel on the right main landing gear fell off the acft. The acft returned and landed without further incident. The wheel bearing was found faileddue to cosmoline contamination.Dec 9, 1983 · N613UA · No damage NTSB LAX84IA040Incident · No injuriesIncident investigationFinal reportBoeing 767 · San Francisco, CADuring pushback the right wingtip of the Boeing 767 struck the rudder of a Douglas DC-9 parked at the adjacent gate. The B-767 was being pushed back by two mechanics, one on thetug & one under the left wing.Nov 2, 1983 · N605TW · Minor damage NTSB SEA70IS044Incident · No injuriesClosedBoeing 747 · Moses Lake, WAMay 24, 1970 · N7470 · Minor damage