NTSB investigations: Pratt & Whitney JT8D series, CA
8 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 DCA09FA022Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-83 · Los Angeles Intl Airport, CAThe first officer's unannounced advancement of the left engine throttle, which led to a sustained application of high thrust that caused the airplane to impact the tug.NTSB SEA08LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-83 · Ontario, CAThe lack of turbulence forecasts available to the flight crew, which resulted in the flight attendants not being seated when the flight encountered severe terrain-induced turbulence. Contributing to the accident were the terrain-induced turbulence, the…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 LAX05LA218Accident · No injuriesLimited investigationFinal reportBoeing 727-230 · San Diego, CAthe inadvertent throttle movement by one of the flight crew and the captain's inadequate supervision during the engine start sequence.NTSB LAX99IA230Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · San Diego, CAfailure of the number three bearing. The resulting oil leak from the bearing led to coke/carbon buildup, which resulted in chafing of the turbine's low-pressure compressor drive shaft on the rear compressor seal tube and subsequent fracture of the drive shaft.NTSB LAX97LA072Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · San Jose, CAThe flight's encounter with severe turbulence while the injured cabin crew was standing.NTSB LAX88IA009Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Ontario, CAFailure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor…NTSB LAX84IA195Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Santa Ana, CAShortly after takeoff a ttl pwr loss was experienced on the number 1 engine. Examination of the engine revealed substantial damage occurred in the compressor section from stage 6 rearward. 40 stage 8 compressor blades were forced completely out of their disk…