Skip to content

NTSB investigations: Pratt & Whitney JT8D-1

95 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-1. 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, newest first

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 ('52044')) 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 ('52044'))
  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 ('52044'))
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 MKC84IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Kansas City, MOWhile taxiing to rwy 01 for takeoff, the plt noticed a snow removal vehicle operating in reverse, approaching his acft. He tried to maneuver to the rt to avoid a collision but the snow removal vehicle struck the leading edge of the lt wing. The driver of the…Mar 20, 1984 · N88706 · Minor damage NTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…Dec 20, 1983 · N994Z · Substantial damage NTSB LAX84IA461Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Santa Ana, CAJust after takeoff the left engine failed due to a fatigue failure of the 7 th stage rear compression stator assembly several homes under the fligh path sustained fire & debris damage when engine parts departed the acft. The acft returnedto the airport and…Sep 27, 1983 · N302RC · No damage NTSB LAX83IA316Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Los Angeles, CADuring taxi into the terminal the acft left wing hit a parked tow truck boom. The tow truck was not authorized to be parked in the clear zone due to its height.Jul 2, 1983 · N88708 · Minor damage NTSB FTW83IA044Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircrew reported that they broke out of the clouds at about 744 ft AGL while on an ILS approach and that the ceiling was ragged. At about 500 ft AGL, the captain turned on the windshield wipers. The first officer was flying the aircraft from thr right…Nov 23, 1982 · N846AA · Minor damage NTSB SEA82IA101Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Boise, IDAfter a gate delay to load late passengers, the flight was cleared for takeoff on runway 28L. About 4 seconds after rotation speed was called, the stickshaker activated and the takeoff was aborted. A readout of the CVR indicated that the thrust reversers were…Jul 5, 1982 · N919RW · Minor damage NTSB FTW82DA010Accident · Serious injuriesClosedBoeing 727 · Dal Ftw Arpt, TXOct 13, 1981 · N6816 · No damage NTSB DEN81IA046Incident · No injuriesClosedBoeing 727 · Denver, COJun 27, 1981 · N88708 · Minor damage NTSB NYC79DA041Accident · No injuriesClosedBoeing 727 · Philadelphia, PAApr 19, 1979 · N6821 · Substantial damage NTSB MKC79IA021Incident · No injuriesClosedBoeing B727 · Minneapolis, MNMar 2, 1979 · N2819W · Minor damage NTSB ANC79IA038Incident · Minor injuriesClosedBoeing 727 · Yakutat, AKFeb 23, 1979 · N314AS · No damage NTSB MIA79AA049Accident · Serious injuriesClosedDouglas DC-9 · Miami, FLFeb 9, 1979 · N8910E · Destroyed NTSB DCA78IA018Incident · No injuriesClosedDouglas DC-9 · Oshkosh, WIJul 21, 1978 · N959N · Minor damage NTSB LAX78IA056Incident · Minor injuriesClosedBoeing 727 · Los Angeles, CAJun 27, 1978 · N2821W · 2 aircraft · No damage NTSB IAD78FA067Accident · Serious injuriesClosedBoeing 727 · Erlanger, KYMay 21, 1978 · N1974 · Minor damage NTSB MKC76AK063Accident · Serious injuriesClosedBoeing 727 · Minneapolis, MNJun 12, 1976 · N2820W · No damage NTSB SEA761S041Incident · No injuriesClosedDouglas DC-9 · Spokane, WAApr 1, 1976 · N9333 · No damage NTSB IAD76II057Incident · No injuriesClosedBoeing 727 · Washington, DCFeb 19, 1976 · N7624U · Minor damage NTSB SEA76AS036Accident · Serious injuriesClosedBoeing 727 · Boise, IDFeb 16, 1976 · N7629U · No damage NTSB DEN76AD032Accident · Serious injuriesClosedBoeing 727 · Denver, COFeb 16, 1976 · N88708 · Substantial damage NTSB LAX76AL045Accident · Serious injuriesClosedBoeing 727 · Los Angeles, CAJan 17, 1976 · N2821W · Minor damage NTSB MKC76IK030Incident · No injuriesClosedDouglas DC-9 · St Louis, MONov 29, 1975 · N994Z · Minor damage NTSB MKC75IK032Incident · No injuriesClosedDouglas DC-9 · Minneapolis, MNDec 19, 1974 · N8910E · Minor damage NTSB FTW74IF077Incident · No injuriesClosedBoeing 727 · Sierra Blanca, TXApr 30, 1974 · N4736 · Minor damage NTSB MIA74AM055Accident · Serious injuriesClosedBoeing 727 · Tampa, FLJan 4, 1974 · N7624U · Minor damage NTSB IAD74AI035Accident · Minor injuriesClosedDouglas DC-9 · Greensboro, NCDec 17, 1973 · N8978E · Substantial damage NTSB SEA73IS038Incident · No injuriesClosedDouglas DC-9 · Spokane, WAJun 22, 1973 · N9338 · Minor damage NTSB MKC73AK056Accident · Minor injuriesClosedBoeing 727 · Wichita, KSMar 3, 1973 · N12307 · Substantial damage NTSB NYC72AN150Accident · Serious injuriesClosedBoeing 727 · Flushing, NYJun 10, 1972 · N1992 · Minor damage NTSB DEN71AD046Accident · Serious injuriesClosedBoeing 727 · Denver, COJun 8, 1971 · N32719 · No damage NTSB CHI71AC068Accident · Serious injuriesClosedBoeing 727 · Cincinnati, OHMar 29, 1971 · N6816 · No damage NTSB LAX71AL040Accident · No injuriesClosedBoeing 727 · Burbank, CADec 16, 1970 · N88709 · Substantial damage NTSB NYC70IN101Incident · 1 fatalClosedDouglas DC-9 · Boston, MAMar 17, 1970 · N8925E · No damage NTSB LAX70S0002Incident · No injuriesClosedDouglas DC-9 · Los Angeles, CAOct 17, 1969 · N9330 · Minor damage NTSB IAD70I0015Incident · No injuriesClosedDouglas DC-9 · Chantilly, VAAug 15, 1969 · N977Z · Minor damage NTSB IAD70I0006Incident · No injuriesClosedBoeing 727 · Washington, DCJul 20, 1969 · N1974 · No damage NTSB OAK69A0062Accident · Serious injuriesClosedDouglas DC-9 · Las Vegas, NVApr 24, 1969 · N9337 · No damage NTSB LAX69A0043Accident · Serious injuriesClosedBoeing 727 · San Diego, CAJan 16, 1969 · N7624U · No damage NTSB DCA68A0004Accident · 2 fatalClosedDouglas DC-9 · St Louis, MOMar 27, 1968 · N970Z · 2 aircraft · Substantial damage NTSB NYC67A0073Accident · No injuriesClosedBoeing B-727 · Flushing, NYNov 2, 1966 · N1983 · Substantial damage NTSB DEN67I0013Incident · No injuriesClosedBoeing B-727 · Pueblo, COJul 28, 1966 · N7011U · Minor damage NTSB MKC65A0053Accident · No injuriesClosedBoeing B-727 · Kansas City, MOMar 17, 1965 · N846TW · Substantial damage NTSB CHI65I0072Incident · No injuriesClosedBoeing B-727 · Covington, KYFeb 6, 1965 · N1975 · No damage NTSB UNK65X0940Incident · No injuriesClosedBoeing 727 · New York, NYDec 6, 1964 · N1971 · Minor damage NTSB UNK64X2587Incident · No injuriesClosedBoeing 727 · W Palm Beach, FLJul 1, 1964 · N8108N · Minor damage