NTSB investigations: Pratt & Whitney JT8D-9 series

7 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-9 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-9 series per year, 1987–2026: 7 cases
1987	1
1990	1
1996	1
1998	1
2000	1
2002	2

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 ('52048') 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 ('52048')
      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 ('52048')
    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 NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…Jan 20, 2002 · N837AT · Substantial damage NTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.Jan 3, 2002 · N262FE · Substantial damage NTSB NYC01FA062Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Jamaica, NYThe low cycle fatigue fracturing of the approach lighting cover securing bolts.Dec 28, 2000 · N769NC · Substantial damage NTSB NYC98LA177Accident · No injuriesLimited investigationFinal reportDouglas DC-9-30 · Philadelphia, PAthe failure of the fuel truck driver to follow airport operating procedures, and yield the right-of-way to the airplane. Factors were the stopped airplane, which obscured the fuel truck from the approaching airplane and the approaching airplane from the fuel…Sep 2, 1998 · N927VJ · Substantial damage NTSB MIA96LA107Accident · No injuriesLimited investigationFinal reportBoeing 727-225 · Memphis, TNfailure of the flightcrew to maintain clearance from construction equipment while taxiing after landing. Factors relating to the accident were: failure of operator personnel to supply the flightcrew with current NOTAM information, failure of ATC personnel to…Mar 27, 1996 · N468FE · Substantial damage NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…Jan 19, 1990 · N44UE · 2 aircraft · Destroyed NTSB MIA88IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Miami, FLPlt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc…Dec 27, 1987 · N54344 · Minor damage