NTSB investigations: Pratt & Whitney JT8D series, FL
9 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2011 | 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\" = 'FL' 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" = 'FL' 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 ERA11CA367Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Miami, FLThe in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.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.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 MIA99IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Orlando, FLA discharged battery due to a loss of electrolyte, and the latent shorted failures of the No. 1 and 2 generator control unit (GCU) blocking diodes (CR910) for undetermined reasons. These failures resulted in an excessive current drawn from both GCUs, during…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 DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…NTSB MIA96LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Pensacola, FLThe passenger failure to follow the instructions to be seated and utilize a seatbelt. Contributing to the accident was the in flight encounter with turbulence.NTSB MIA88IA240Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Pensacola, FLThe captain stated that he crossed the final approach fix at 3000 feet, continued the approach, touched down at 140 knots at the end of the touchdown zone, but could not stop the acft and ran off the end of runway 16. According to tower personnel and…NTSB MIA87IA068Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLThe regularly scheduled air carrier flight was climbing to altitude when the engine oil pressure and quantity dropped to zero on the #3 engine; it was shut down. Shortly thereafter, the #1 engine oil pressure dropped to zero. It was reduced to idle and the…