NTSB investigations: Pratt & Whitney JT8D series, NY
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
| 1976 | 1 |
|---|---|
| 1987 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2003 | 1 |
| 2015 | 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\" = 'NY' 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" = 'NY' 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 DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB NYC03FA186Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Jamaica, NYA fractured nose gear spray deflector due to contact with a tow bar during pushback, which subsequently jammed and prevented nose gear extension during landing. A factor in this accident was the tow operator's failure to detect the damaged spray deflector.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 NYC97MA005Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…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 NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB NYC77FA011Accident · No injuriesClosedDouglas DC-9 · Buffalo, NY