Skip to content

NTSB investigations: Pratt & Whitney JT3D-3&3B

26 cases on aircraft whose registry engine model is Pratt & Whitney JT3D-3&3B. 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

19642026

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52039')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52039'))
  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 ('52039'))
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 ANC11CA101Accident · Serious injuriesData collectionFinal reportDouglas DC-8-62F · Yakota, JapanThe passenger's decision to ignore the fasten seatbelt sign, resulting in serious injury to the passenger during a turbulence encounter.Sep 10, 2011 · N71CX · No damage NTSB DCA06MA022Accident · Minor injuriesClass 1 · MajorFinal reportDouglas DC-8 · Philadelphia, PAan in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…Feb 8, 2006 · N748UP · Destroyed NTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.Jun 17, 2000 · N831AL · No damage NTSB DEN00FA078Accident · No injuriesField investigationFinal reportDouglas DC-8-62F · Denver, COThe failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.Apr 28, 2000 · N990CF · Substantial damage NTSB SEA98IA141Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAThe flight crew's failure to perform a missed approach upon failing to attain and/or maintain proper course/runway alignment and glidepath on final approach, resulting in a high-sink-rate landing and subsequent separation of a main landing gear wheel from the…Jul 18, 1998 · N921R · Minor damage NTSB FTW98IA196Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-51 · Brownsville, TXThe flightcrew experienced physical impairment resulting from an accumulation in the cockpit of carbon dioxide fumes produced by dry ice, a hazardous material, carried in the main cargo compartment.Apr 30, 1998 · N507DC · No damage NTSB DCA98WA032Incident · No injuriesForeign investigationMcdonnell Douglas DC8-73 · Koln-Bonn, GermanyMar 8, 1998 · N812UP · No damage NTSB MIA97IA050Incident · No injuriesIncident investigationFinal reportDouglas DC8-62 · Orlando, FLThe failure of the captain to center the rudder and close all engine throttles during an aborted takeoff resulting in an uncontrolled turn to the right due to nose wheel steering through the rudder pedals and asymmetric engine thrust. A factor in the incident…Dec 31, 1996 · N804AX · Minor damage NTSB FTW93IA067Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC8-55 · Dfw Airport, TXFailure of an engine turbine wheel for undetermined reasons.Jan 15, 1993 · N8041U · Minor damage NTSB MIA92IA166Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Miami, FLFailure of the aircraft operator maintenance personnel to adequately lubricate and seal the main landing gear bogie beam swivel joint as required by manufacturer and operator maintenance program requirements. This allowed moisture to enter the swivel joint…Aug 22, 1992 · N748UP · Minor damage NTSB DCA89RA056Accident · 174 fatalForeign investigationMcDonnell Douglas DC-8-62 · Paramaribo, SurinameJun 7, 1989 · N1809E · Destroyed NTSB MIA80RA003Accident · Minor injuriesClosedDouglas DC-8 · Panama Cty, St. Pierre & MiquelonOct 14, 1979 · N1809E · Substantial damage NTSB CHI77IA051Incident · No injuriesClosedBoeing 707 · Chicago, ILJun 22, 1977 · N7590A · Minor damage NTSB LAX74IL063Incident · Minor injuriesClosedBoeing 707 · Phoenix, AZMar 20, 1974 · N7571A · No damage NTSB MIA74AM019Accident · Serious injuriesClosedDouglas DC-8 · Belle Glade, FLAug 20, 1973 · N821E · No damage NTSB DEN73AD041Accident · No injuriesClosedBoeing 707 · Denver, COMar 5, 1973 · N7577A · Substantial damage NTSB MIA72AM086Accident · Serious injuriesClosedDouglas DC8-51 · Alma, GAFeb 26, 1972 · N821E · No damage NTSB CHI70IC067Incident · No injuriesClosedBoeing 707 · Chicago, ILMar 28, 1970 · N7591A · No damage NTSB FTW70A0018Accident · No injuriesClosedDouglas DC-8 · Dallas, TXSep 17, 1969 · N8008D · Substantial damage NTSB MIA69I0007Incident · No injuriesClosedDouglas DC-8 · No.Atlantic Ocean (Atlantic Ocean)Aug 5, 1968 · N1804 · No damage NTSB UNK68X0135Accident · Minor injuriesClosedDouglas DC-8 · Quito, EcuadorApr 23, 1968 · N1804 · Substantial damage NTSB NYC68O0105Incident · No injuriesClosedBoeing 707 · Jamaica, NYMar 7, 1968 · N7551A · No damage NTSB NYC67A0127Accident · Serious injuriesClosedBoeing 707 123B · Newark, NJMar 11, 1967 · N7553A · No damage NTSB LAX67I0056IncidentClosedBoeing 720B · Los Angeles, CADec 2, 1966 · N57205 · Substantial damage NTSB LAX65A0086Accident · No injuriesClosedBoeing B-720B · Los Angeles, CAMay 3, 1965 · N57201 · Substantial damage NTSB UNK64X1624Incident · Minor injuriesClosedDouglas DC-8 · Kress City, TXMay 5, 1964 · N804E · Minor damage