NTSB investigations: Pratt & Whitney JT8D-9 series
74 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-9 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 ('52048'))
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 ('52048'))
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 SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…NTSB LAX83IA302Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-32 · Las Vegas, NVDuring the ground run for takeoff a fatigue precipitated failure of the third stage turbine blade occurred with secondary damage to several guide vanes and the fourth stage turbine wheel. Imbalance of the turbine wheel caused the failure of the number six…NTSB CHI83FA251Accident · Serious injuriesField investigationFinal reportBoeing 727-222A · Chicago, ILDuring the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…NTSB LAX83IA257Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Luke Afb, AZWhile descending through 31,600 ft the master caution & the right 'inlet fuel pressure low' lights illuminated. The fuelquantity transfer circuit breaker was found tripped, & when reset the fuel quantity gauges went to zero. An emergency was declared to…NTSB DCA83AA021Accident · Serious injuriesFinal reportBoeing 737-2H4 · Casper, WYAcft touched down with all landing gear retracted. The gear handle was found in the neutral position. The first officer was distracted by an inop aps and both the captain and the first officer were distracted by a GPWS aural warning on final apch.NTSB FTW83IA094Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Lubbock, TXDuring taxi to takeoff the acft slid off the taxiway into the snow and became stuck. The taxiway was covered with snow &ice.NTSB FTW83IA086Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Memphis, TNDuring a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The…NTSB DCA82AA011Accident · 78 fatalFinal reportBoeing 737-222 · Washington, DCThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-82/08. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Sched…NTSB CHI81IA088Accident · Serious injuriesClosedBoeing 727 · Columbus, OHNTSB MIA81IA063Incident · No injuriesClosedBoeing 727 · Miami, FLNTSB ATL81IA060Incident · Minor injuriesClosedBoeing 727 · Washington, DCNTSB DCA80IA014Incident · Minor injuriesClosedDouglas DC-9 · Washington, DCNTSB CHI79FI070Incident · No injuriesClosedDouglas DC-9 · Chicago, ILNTSB DCA79AA009Accident · No injuriesClosedBoeing 747 · Chicago, ILNTSB NYC77FA086Accident · No injuriesClosedDouglas DC-9 · New York, NYNTSB LAX77AA048Accident · No injuriesClosedBoeing 727 · Tucson, AZNTSB IAD77DA028Accident · Serious injuriesClosedBoeing 727 · Dayton, OHNTSB NYC77IA034Incident · No injuriesClosedBoeing 737 · Flushing, NYNTSB MIA76AM067Accident · Serious injuriesClosedBoeing 727 · Tampa, FLNTSB MIA74IM090Incident · Minor injuriesClosedBoeing 737 · Birmingham, ALNTSB DEN74AD009Accident · Serious injuriesClosedBoeing 737 · Rapid City, SDNTSB SEA74AS006Accident · Serious injuriesClosedBoeing 737 · Missoula, MTNTSB CHI72AC034Accident · No injuriesClosedDouglas DC-9 · Chicago, ILNTSB MIA70I0047Incident · No injuriesClosedDouglas DC-9 · Nashville, TN