NTSB investigations: Pratt & Whitney JT8D series, 2007
4 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\") = 2007
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") = 2007
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 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 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 CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…NTSB MIA07LA068Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-83 (MD-83) · Sanford, FLThe flight crew's failure to complete the checklist and adhere to airplane placards. Contributing to the accident was a separation of a B-nut on the rudder power hydraulic shut off valve for undetermined reasons.