NTSB investigations: Pratt & Whitney JT8D series

14 cases on aircraft whose registry engine model is Pratt & Whitney JT8D series, where the first occurrence was “On ground/water collision with object”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19872026

NTSB investigations: Pratt & Whitney JT8D series per year, 1987–2026: 14 cases
1987	2
1991	4
1996	2
1998	2
2002	1
2004	1
2005	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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 ('52053', '52377') 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" = 310)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('52053', '52377')
      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\" = 310))
  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 ('52053', '52377')
    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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…Jun 27, 2007 · N213UA · 2 aircraft · Minor damage NTSB LAX05LA218Accident · No injuriesLimited investigationFinal reportBoeing 727-230 · San Diego, CAthe inadvertent throttle movement by one of the flight crew and the captain's inadequate supervision during the engine start sequence.Jun 28, 2005 · N357KP · Substantial damage NTSB NYC05LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Providence, RIThe vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.Dec 20, 2004 · N402A · Substantial damage NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.Jul 2, 2002 · N911DL · Substantial damage NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.Oct 11, 1998 · N997DL · Substantial damage NTSB CHI98IA275Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Saint Louis, MOthe failure of the flight crew to maintain clearance from the sweeper truck. A factor in the incident was the sweeper truck.Jul 25, 1998 · N9620D · Minor damage NTSB SEA97IA040Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Seattle, WAThe failure of the left wing walker to verify the clearance between the left wing and the fuel truck during taxi, and his delay in signaling the lead marshaller to alert the pilot to stop the aircraft prior to impact. Factors contributing to the incident…Dec 21, 1996 · N941AS · Minor damage NTSB ANC97IA011Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Anchorage, AKThe ground crew's failure to maintain communication with the flight crew while loading cargo after pushback and engine start, and the ground and flightcrew's failure to follow the procedure outlined in their manuals concerning use of marshallers during…Dec 6, 1996 · N954AS · Minor damage NTSB NYC92FA009Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Newark, NJFailure of the crew of the B-737, N7385F, to maintain adequate visual lookout while taxiing, and failure by air traffic controllers to provide traffic information and/or issue warnings to either flightcrew. A factor was the after-landing task saturation of…Oct 17, 1991 · N498AA · 2 aircraft · Substantial damage NTSB CHI91LA301Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILThe flight crew's failure to maintain adequate clearance from obstacles during ground operations. A related factor is the failure of the drivers of the escort vehicle and the semi trailer to follow established procedures and directives.Sep 23, 1991 · N442AA · Substantial damage NTSB FTW91LA137Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Dfw Airport, TXThe captain of the other aircraft misjudged clearance between his aircraft and the standing commuter airplane. A factor was the failure by the second pilot of the other airplane to identify a hazardous condition.Jul 27, 1991 · N491AA · 2 aircraft · Minor damage NTSB ATL91FA090Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe van driver's inadequate visual lookout and poor division of attention.May 6, 1991 · N938DL · Substantial damage NTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…Dec 27, 1987 · N72830 · Minor damage NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…Aug 20, 1987 · N951R · 2 aircraft · Substantial damage