NTSB investigations: Pratt & Whitney JT8D series, 1997
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
| 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\") = 1997
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") = 1997
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 MIA98LA002Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Cross City, FLThe in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.NTSB FTW97IA365Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83(MD-83) · New Orleans, LARunway overrun for undetermined reasons.NTSB NYC97LA095Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe vehicle's driver failure to maintain adequate clearance from and resulted in a collision with a parked aircraft.NTSB LAX97IA170Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Tucson, AZan undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.NTSB FTW97IA119Incident · No injuriesIncident investigationFinal reportBoeing 727-2K5 · Dfw Airport, TXfailure of the outer bearing for undetermined reason(s).NTSB IAD97FA052Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 · Cleveland, OHThe pilot in command did not maintain control while utilizing the full auto-land system. Factors to this accident were a contaminated runway, a crosswind, and inadequate guidance provided in the aircraft manual.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 FTW97IA084Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Oklahoma City, OKexistence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.