NTSB investigations: Pratt & Whitney JT8D-1
5 cases on aircraft whose registry engine model is Pratt & Whitney JT8D-1, where the first occurrence was “In flight encounter with weather”. 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
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1990 | 1 |
| 2003 | 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\" = 240))
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" = 240))
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 DEN03LA142Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-81 · Greeley, COthe inflight encounter with severe turbulence.NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…NTSB ANC87FA021Accident · Serious injuriesField investigationFinal reportBoeing 727-222 · Anchorage, AKAbout 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt…NTSB ATL86LA202Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Montgomery, ALDuring flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi…NTSB ATL84LA235Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Augusta, GADuring a turbulence encounter a pax standing in the rear of the cabin fell and suffered a fractured leg. The seat belt sign was illuminated for the entire flt. At the direction of the capt, in-flt service by the flt attendants was terminated. The injured pax…