Major NTSB investigations: Pratt & Whitney JT8D series
9 cases on aircraft whose registry engine model is Pratt & Whitney JT8D 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 per year
| 1987 | 2 |
|---|---|
| 1988 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 2007 | 1 |
| 2015 | 1 |
Where
Open the mapLatest cases
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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52053', '52377'))
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52053', '52377'))
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 DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB DCA07MA310Accident · No injuriesClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 (MD-82) · St. Louis, MOAmerican Airlines’ maintenance personnel’s use of an inappropriate manual engine start procedure, which led to the uncommanded opening of the left engine air turbine starter valve, and a subsequent left engine fire, which was prolonged by the flight crew’s…NTSB NYC97MA005Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…NTSB DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…NTSB DCA96MA008Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-83 · East Granby, CTthe flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…NTSB CHI95MA044Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 · Bridgeton, MOThe Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…NTSB DCA88MZ002Incident · Minor injuriesFinal reportMcdonnell Douglas DC-9-83 · Nashville, TNAmerican flt 132 was loaded with undeclared & improperly marked haz mtrl (hm) packed in a fiber drum. It contained 5 galof 50% hydrogen peroxide solution (oxidizer) & 25 lbs of textreat s-w (corrosive agent; sodium orthosilicate-based mix),shipped by textile…NTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. 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…NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…