NTSB investigations: Pratt & Whitney JT8D series
20 cases on aircraft whose registry engine model is Pratt & Whitney JT8D series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 2 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52053', '52377')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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 ('52053', '52377')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 LAX06IA301Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83 · Long Beach, CAThe over wing heater blanket wiring installation that had chaffed and arced, which produced an electrical smell in the cabin area.NTSB CHI06FA158Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-83 · Chicago, ILThe jammed nose landing gear due to a failure of the nose landing gear spray deflector for undetermined reasons.NTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.NTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.NTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.NTSB ANC99IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Fairbanks, AKThe restricted/delayed movement of the elevator flight control due to extremely cold weather conditions.NTSB MIA99IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Orlando, FLA discharged battery due to a loss of electrolyte, and the latent shorted failures of the No. 1 and 2 generator control unit (GCU) blocking diodes (CR910) for undetermined reasons. These failures resulted in an excessive current drawn from both GCUs, during…NTSB CHI98IA167Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD82 · Washington, DCThe failure of the Dual Axis Accelerometer.NTSB FTW97IA119Incident · No injuriesIncident investigationFinal reportBoeing 727-2K5 · Dfw Airport, TXfailure of the outer bearing for undetermined reason(s).NTSB IAD97IA048Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Newark, NJfatigue fracture of the upper lock link, which led to the collapse of the nose gear during landing.NTSB NYC96IA169Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Howard Beach, NYfatigue failure of the fore flap attachment fitting, due to grinding marks on the fitting.NTSB CHI96LA011Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-31 · Cedar Rapids, IAinadequate installation of a thrust reverser, driver linkage arm pivot bolt and nut, which resulted in the nut and bolt becoming disconnected. A factor relating to the accident was: the manufacturer's unclear information regarding the type and number of…NTSB CHI93IA352Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · St. Louis, MOa fatigue failure of the power transfer unit caused by a material defect which resulted in a total hydraulic system failure.NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.NTSB ATL92IA025Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAA short in an electrical connector which resulted in its failure. The reason for the short was not determined. A factor was the improper installation of the connector by an unknown maintenance person.NTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.NTSB MKC89IA024Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-31 · Minneapolis, MNThe failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation.NTSB MIA87IA068Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLThe regularly scheduled air carrier flight was climbing to altitude when the engine oil pressure and quantity dropped to zero on the #3 engine; it was shut down. Shortly thereafter, the #1 engine oil pressure dropped to zero. It was reduced to idle and the…NTSB MKC84IA017Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-80 · St. Louis, MODuring landing rollout the aft fiberglass tailcone fell off the acft for undetermined reasons.NTSB FTW84IA007Incident · Minor injuriesIncident investigationFinal reportBoeing B727-023 · Dfw Airport, TXA brake fire resulting from a dragging brake the cause of which was not determined was the reason for an evacuation during taxi back to the ramp because of a brake discrepancy. The slide lost pressure which was attributed to a high heel shoe.