NTSB investigations: Pratt & Whitney JT8D-1
15 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-1, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52044')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52044')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB CHI99IA136Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dubuque, IAthe frozen elevator control. Factors to the incident were the rain and the low temperature.NTSB FTW97IA363Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200RS · Salt Lake City, UTThe captain's failure to maintain directional control during landing roll. Factors were the loss of hydraulic pressure in the 'A' hydraulic system, the thrust reverser failure on the number one engine, and flight crew coordination not being maintained.NTSB CHI97IA195Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Flint, MIAn electrical short in the wiring of the left wingtip oscillating position light auto transformer and a failure of the system circuit breaker.NTSB CHI91IA297Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Detroit, MIInadequate maintenance inspection of the main landing gear actuator assembly by company maintenance personnel. A factor in the incident is inadequate design of the landing gear actuator by the manufacturer.NTSB CHI91IA058Incident · Minor injuriesIncident investigationFinal reportBoeing B727-223 · Des Moines, IAAn oil leak originating from the auxiliary power unit which created smoke in the passenger cabin after it passed through the air conditioning/heating system equipment and associated duct work.NTSB ATL90IA060Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Louisville, KYThe disabling of the main landing gear torque link which allowed the truck to rotate freely. The torque link was disabled when excessive vibration was generated by excessive play of the torque link pins in their bushings.NTSB DEN90IA012Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Monte Vista, COThe poor inflight planning and decisions made by the flight crew following the failure of the number two generator constant speed drive unit. Contributing factors to the accident were the failure of the no. 2 generator constant speed drive unit and the crew's…NTSB LAX89IA315Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Los Angeles, CAA fatigue crack in the right gear wheel well.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…NTSB FTW86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Corpus Christi, TXThe pilot made an intentional gear-up landing (left main only) after numerous attempts to lower it were unsuccessful. The small steel nut which had jammed the left main gear door unlatching mechanism fell into that position sometime after the gear was…NTSB CHI86IA121Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Detroit, MIWhile taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…NTSB NYC86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Boston, MATwo of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft…NTSB NYC84IA192Incident · No injuriesIncident investigationFinal reportBoeing 727-31 · Flushing, NYAfter takeoff flt attendant reported aft airstair partially open. Flt engineer checked & confirmed airstair open aprx 18 inches. Remedial action performed to no avail. Unscheduled landing performed without incident. As acft turned onto taxiway airstair…NTSB SEA82IA101Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Boise, IDAfter a gate delay to load late passengers, the flight was cleared for takeoff on runway 28L. About 4 seconds after rotation speed was called, the stickshaker activated and the takeoff was aborted. A readout of the CVR indicated that the thrust reversers were…