Skip to content

Final NTSB investigations: Pratt & Whitney JT8D-5

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

19712026

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 ('52046')) 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 ('52046'))
  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 ('52046'))
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 DFW07LA155Accident · 1 fatalLimited investigationFinal reportBoeing 737-232 · Tunica, MSGorund service personal's removal of the portable stairway prior to the main cabin door being secured. Factors were the high winds and heavy rain.Jul 10, 2007 · N332DL · No damage NTSB NYC07LA121Accident · No injuriesLimited investigationFinal reportDouglas DC-9-31 · Syracuse, NYThe senior ground agent's failure to follow written procedures and directives.May 18, 2007 · N1799U · Substantial damage NTSB CHI02FA289Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Minneapolis, MNThe fatigue failure of the main landing gear strut due to inclusions in the material, residual stresses, and dissolved hydrogen content.Sep 22, 2002 · N941N · Substantial damage NTSB CHI01IA046Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Chicago, ILFailure of the captain to maintain clearance from the other airplane that was stopped. Factors relating to this accident were the snow-covered taxiways and the ground controller disregarding the captain's warning of the unsafe/hazardous situation of being…Dec 14, 2000 · N9342 · 2 aircraft · Minor damage NTSB MIA99FA005Accident · No injuriesField investigationFinal reportBoeing 727-224 · Miami, FLThe catastrophic failure of the 8th stage high pressure compressor disk from cadmium embrittlement as a result of improper adherence to the prescribed plating procedures and requirements by the company that last plated the disk. Contributing to the accident…Oct 7, 1998 · N66734 · Substantial damage NTSB SEA97FA202Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Seattle, WAfatigue failure of the nose landing gear upper lock link, due in part to reduced strength after the manufacturing process was changed from forged to machined plate stock; and inadequate non-destructive inspection process for testing the link.Sep 2, 1997 · N951AS · Substantial damage NTSB NYC91IA165Incident · No injuriesIncident investigationFinal reportBoeing 727-254 · Buffalo, NYChaffing fire detector loop on the number one engine.Jul 2, 1991 · N913TS · No damage NTSB CHI91IA078Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · St. Paul, MNThe partial failure of the airplane's auxiliary power unit, and the inadequate component produced by the manufacturer.Jan 21, 1991 · N295US · Minor damage NTSB MIA90IA039Incident · No injuriesIncident investigationFinal reportBoeing 727 · Ormond Beach, FLFailure of the pilot in command in the Beech 300 to comply with an ATC clearance in a timely manner, while diverting his attention, and failure of the ATC controller to assure that IFR separation was maintained.Dec 15, 1989 · N64339 · 2 aircraft · No damage NTSB BFO88IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Baltimore, MDTwa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…Dec 5, 1987 · N924L · 2 aircraft · No damage NTSB DCA86AA018Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Erie, PADrg arrival, the crew of us air flt 499 lndd on rwy 24, which was cvrd with snw. Rprtdly, while lndg, the acft touched dwn aprx 1800 to 2000' bynd the displaced threshold. Altho armed, the spoilers did not auto-deploy, so the capt operatedthem manually. He…Feb 21, 1986 · N961VJ · Substantial damage NTSB LAX84AA132Accident · No injuriesFinal reportBoeing 727-224 · New York, NYDuring apch the crew was advised of a windshear on final apch of +10 to -15 KTS at 700 ft & 400 ft AGL. Winds were reported 170 deg at 26 KTS gusting to 40 KTS. The plt added 20 KTS to his v-ref speed of 132 KTS & selected auto-spoilerdeployment. Prior to…Dec 28, 1983 · N79750 · Substantial damage NTSB CHI83IA063Incident · No injuriesIncident investigationFinal reportDouglas DC9-30 · Pellston, MIBefore departing traverse city the captain was informed that emmet city arpt was sanded at about 1736 and that icy runway conditions were turning to slush. He was also told that rwy 32 would be sanded again prior to his arrival. This was accomplished, with a…Dec 19, 1982 · N9344 · No damage NTSB FTW82DA139Accident · No injuriesFinal reportBoeing 727-200 · Austin, TXThe left main gear collapsed & partially separated from the acft structure. Examination of the gear assembly revealed a failed drag strut assembly #65-57903-11. There was evidence of a pre-existing crack prior to the strut separation. The stress corrosion…Apr 19, 1982 · N32717 · Substantial damage NTSB MKC81FA051Accident · No injuriesClosedDouglas DC-9 · St.Louis, MOAug 13, 1981 · N924L · Substantial damage NTSB FTW81DA092Accident · Serious injuriesClosedDouglas DC-9 · New Orleans, LAMay 18, 1981 · N1295L · No damage NTSB CHI79FA047Accident · No injuriesClosedDouglas DC-9 · Mosinee, WIApr 21, 1979 · N941N · Substantial damage NTSB MIA75IM042Incident · No injuriesClosedBoeing 727 · Birmingham, ALJan 8, 1975 · N7642U · Minor damage NTSB CHI74AC040Accident · No injuriesClosedBoeing 727 · Madison, WIDec 9, 1973 · N259US · Substantial damage NTSB IAD71II039Incident · No injuriesClosedBoeing 727 · Dulles Int Apt, DCFeb 15, 1971 · N7644U · No damage