NTSB investigations: Pratt & Whitney JT8D-1, 1987
4 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-1. 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 5 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 1 |
| 1976 | 6 |
| 1978 | 3 |
| 1979 | 4 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 4 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 3 |
| 2003 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52044'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52044'))
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 MIA87IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLDuring descent the B727 crew noted the fire warning light illuminate on the #1 engine. They discharged 2 fire bottles into the engine but the warning light remained illuminated. They declared an emergency and landed at their destination. An emergency…NTSB DCA87RA002Accident · No injuriesForeign investigationBoeing 727-247 · Calgary, CanadaNTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportBoeing 727-224 · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…NTSB CHI87IA067Incident · No injuriesIncident investigationFinal reportBoeing 727-122 · Fort Wayne, INAircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft…