NTSB investigations: Pratt & Whitney JT9D-3A, 1995
3 cases on aircraft whose registry engine model is Pratt & Whitney JT9D-3A. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2008 | 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\") = 1995
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52050'))
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") = 1995
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52050'))
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 MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB NYC95IA192Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYfailure and separation of the #1 engine turbine shroud assembly, which resulted in an uncontained engine failure, a puncture of the #2 outboard reserve fuel tank plate, and a fuel leak.NTSB CHI95LA188Accident · Serious injuriesLimited investigationFinal reportBoeing 767-222 · Champagne, ILan in-flight encounter with turbulence.