NTSB investigations: Pratt & Whitney JT8D series, 2002
7 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
| 1966 | 1 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1983 | 3 |
| 1984 | 2 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 5 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 7 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 11 |
| 1997 | 8 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2023 | 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 year(c.\"eventDate\") = 2002
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 year(c."eventDate") = 2002
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 ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.NTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…NTSB CHI02FA148Accident · No injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe failure of the right main landing gear due to fatigue.NTSB ANC02FA023Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKThe MD-11 flight crew's failure to maintain clearance while taxiing and the other's airplane's (MD-82) ground-marshaling personnel's failure to follow procedures/directives when they did not display an emergency stop signal to the crew of the MD-11. Factors…NTSB ANC02LA015Accident · No injuriesLimited investigationFinal reportBoeing 727-100 · Kotzebue, AKThe pilot's decision to continue an unstabalized approach to landing. A factor associated with the accident is the pilot's failure to attain proper alignment with the runway.NTSB CHI02LA069Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-41 · Indianapolis, INThe passenger fell off the side of the slide during the emergency evacuation. Factors were the emergency evacuation and the erratic ignition exciter.