NTSB investigations: Pratt & Whitney PW2037, FL
6 cases on aircraft whose registry engine model is Pratt & Whitney PW2037. 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
| 1989 | 1 |
|---|---|
| 1993 | 3 |
| 2003 | 1 |
| 2007 | 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\" = 'FL' 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 ('52117'))
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" = 'FL' 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 ('52117'))
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 OPS07IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe probable cause of this incident was the United flightcrews' inadvertant entry onto an active runway.NTSB MIA03FA130Accident · Serious injuriesField investigationFinal reportBoeing 757-232 · Tampa, FLa torching of the right engine caused by an abnormally high flow fuel during engine start for undetermined reasons. The torching resulted in an unwarranted evacuation of the airplane and serious injuries to three passengers . A contributing factor in the…NTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.NTSB MIA93LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Miami, FLThe failure of the pilot-in-command to anticipate turbulence in observed weather and request that flight attendants be seated, before encountering the observed weather.NTSB MIA93FA073Accident · No injuriesField investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe improper use of elevator flight control during the landing by the pilot in command.NTSB MIA89IA248Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLImproper use of the elevator control.