NTSB investigations: Pratt & Whitney JT8D-1, CO

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

NTSB investigations: Pratt & Whitney JT8D-1, CO per year, 1966–2026: 10 cases
1966	1
1971	1
1976	1
1981	1
1984	2
1989	1
1997	1
1998	1
2003	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."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' 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

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.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
  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

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 DEN03LA142Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-81 · Greeley, COthe inflight encounter with severe turbulence.Aug 7, 2003 · N814ME · No damage NTSB FTW98IA208Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Colorado Sprngs, COAn inadvertent inflight collision with a flock of large birds.May 8, 1998 · N116FE · Minor damage NTSB FTW98FA001Accident · Serious injuriesField investigationFinal reportBoeing 727-51C · Denver, COFailure of the bus driver to yield the right of way to oncoming traffic due to his inadequate visual lookout. Factors were visibility restrictions, inadequate driver training by management, and the flight crew's inadequate visual lookout due to their…Oct 1, 1997 · N414EX · Substantial damage 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…Oct 18, 1989 · N922RW · Minor damage NTSB DEN84IA209Incident · No injuriesIncident investigationFinal reportBoeing 727-23 · Denver, COThe acft went off the rwy during landing. The excursion was to the left & was not corrected before the acft made an exit from the rwy. The captain, in a written statement, said that he was anticipating a right x-wind because he was landing on rwy 26L & the…Jul 4, 1984 · N1992 · Minor damage NTSB DEN84IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Denver, COPrior to taxiing at chicago, the plt had the ramp agent(r/a) check the rear airstair as the aft airstair light on the second officer's panel was 'on'. The r/a recycled the airstair & reported that it appeared closed. The light remained onso the plt referred…Mar 22, 1984 · N88709 · No damage NTSB DEN81IA046Incident · No injuriesClosedBoeing 727 · Denver, COJun 27, 1981 · N88708 · Minor damage NTSB DEN76AD032Accident · Serious injuriesClosedBoeing 727 · Denver, COFeb 16, 1976 · N88708 · Substantial damage NTSB DEN71AD046Accident · Serious injuriesClosedBoeing 727 · Denver, COJun 8, 1971 · N32719 · No damage NTSB DEN67I0013Incident · No injuriesClosedBoeing B-727 · Pueblo, COJul 28, 1966 · N7011U · Minor damage