NTSB investigations: Pratt & Whitney JT8D series, KY
6 cases on aircraft whose registry engine model is Pratt & Whitney JT8D series. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1993 | 1 |
| 1998 | 2 |
| 1999 | 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.\"eventStateOrRegion\" = 'KY' 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 ('52053', '52377'))
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" = 'KY' 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 ('52053', '52377'))
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 NYC99IA231Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYDeteriorated wire insulation and shorting at a short radius bend to the electrical wiring in the right side alternate static port heater, which resulted in electrical arcing and a fire sustained by overlaying thermal acoustic insulation.NTSB NYC99LA022Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe driver's failure to maintain control of the belt loader. A factor in the accident was the precipitation which may have contributed to the driver's foot slipping off the brake and onto the accelerator, as he approached the airplane.NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.NTSB BFO93LA155Accident · Serious injuriesLimited investigationFinal reportDouglas MD-88 · Lexington, KYThe cabin attendant did not follow published procedures.NTSB MIA88LA090Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-82 · Hickman, KYThe capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…NTSB ATL87IA201Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Frankfort, KYThunderstorms and lightning in the vicinity of the arpt prevented adding fuel to the acft and resulted in a delayed departure. The lou VOR was out of service, and the flt was radar vectored until it was cleared direct to lex and for the apch. At the time of…