NTSB investigations: Pratt & Whitney JT9D series, Outside the U.S.
11 cases on aircraft whose registry engine model is Pratt & Whitney JT9D 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
| 1994 | 1 |
|---|---|
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2008 | 2 |
| 2010 | 1 |
Latest 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.\"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 ('52054'))
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."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 ('52054'))
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 ENG11WA005Incident · No injuriesForeign investigationBoeing 747 · Chubu, Japan, JapanOn November 28, 2010, at about 06:00 Japan Standard Time (JST), after taking off from Chubu Centrair International Airport, operating as flight EIA238, the crew of an Evergreen International Airlines Boeing 747-200F airplane, registration number N482EV,…NTSB DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…NTSB DCA08RA063Accident · No injuriesForeign investigationBoeing B747-200 · Brussels, BelgiumimportNTSB DCA06WA049Accident · No injuriesForeign investigationBoeing 747-200 · Rio Negro, ColombiaNTSB ENG05RA021Incident · No injuriesForeign investigationBoeing 747-200B · Sapporo, JapanNTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.NTSB DCA00WA049Incident · No injuriesForeign investigationBoeing 747-200 · IrelandNTSB DCA99WA064Accident · No injuriesForeign investigationAirbus Industrie A310 · Manila, PhilippinesNTSB DCA98WA069Incident · No injuriesForeign investigationBoeing 747 · Amsterdam, NetherlandsNTSB MIA95WA143Accident · No injuriesForeign investigationBoeing B-747-238 · Panama City, PanamaNTSB DCA94RA037Accident · No injuriesForeign investigationBoeing 747 · Narita, Japan