NTSB investigations: Pratt & Whitney JT8D-9 series, 1986
5 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-9 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
| 1969 | 1 |
|---|---|
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 4 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2002 | 2 |
| 2005 | 1 |
| 2008 | 1 |
| 2017 | 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52048'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52048'))
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 LAX87IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Los Angeles, CADrg arr, united flt 282 (Boeing 727, N7255U) was vectored by Los Angeles (lax) TRACON for an ILS rwy 25L apch. While in a dscndg turn at 2100' MSL to intercept the ILS LOC at 2000', the capt saw a helicopter (hel) ahead & pulled up. He estdhis acft passed w/i…NTSB ANC87IA003Incident · No injuriesIncident investigationFinal reportBoeing 727-22C · Anchorage, AKAfter departure, the flight crew retracted the landing gear and noticed a nose gear disagreement light. Upon arriving at Anchorage, the flight crew could not lower the nose gear through normal or manual means. The airplane landed with main gear extended and…NTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…NTSB ATL86LA090Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Memphis, TNAmerican airlines flight 502 experienced a fire warning light illumination on no. 1 engine as the aircraft was climbing through 6000 feet. The pilot declared an emergency and returned to Memphis. Following the landing the pilot ordered a passenger emergency…NTSB DCA86IA017Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Harlingen, TXWhile en route, the company dispatcher notified American flt 844 (via acars) that Harlingen (hrl) had unforecast fog & was 300' obscd with 1/2 mi vis. At 2335, as the flt bgn a dscnt fm FL 310, the same ceiling & vis were rprtd. However, as the flt was clrd…