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 “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
| 1986 | 1 |
|---|---|
| 1990 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 2 |
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 ('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\" = 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 ('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" = 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 FTW97LA215Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291A · Albuquerque, NMthe sudden encounter with clear air turbulence.NTSB CHI97LA060Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Cape Girardeau, MOclear air turbulence encountered by the flight.NTSB FTW94LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · South Bend, INThe encounter with unforcasted and unreported turbulence.NTSB FTW92LA142Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Palacios, TXThe flight's unexpected encounter with moderate turbulence.NTSB MIA90LA155Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Fort Myers, FLUnforecasted encounter with weather. The airplane encountered severe turblence during enroute descent, resulting in one flight attendant sustaining serious injury, and one passenger sustaining minor injury.NTSB CHI90IA166Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILThe pilot-in-command's inadequate weather evaluation. Factors in the incident were the weather and artcc's failure to issue a weather advisory.NTSB DCA86IA017Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Harlingen, TXWhile en route, the company dispatcher notified American flt 844 (via acars) that Harlingen (hrl) had unforecast fog & was 300' obscd with 1/2 mi vis. At 2335, as the flt bgn a dscnt fm FL 310, the same ceiling & vis were rprtd. However, as the flt was clrd…