Skip to content

Final NTSB investigations: Pratt & Whitney 127

11 cases on aircraft whose registry engine model is Pratt & Whitney 127. 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

19942026

Where

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52132')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52132'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52132'))
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 CEN10IA084Incident · No injuriesIncident investigationFinal reportATR ATR72 · Dallas, TXA fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…Dec 26, 2009 · N494AE · Minor damage NTSB MIA07LA086Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 72-212 · San Juan, PRIn-flight encounter with turbulence that resulted in injuries to a flight attendant and a passenger.Apr 28, 2007 · N407AT · No damage NTSB DCA04MA045Accident · Serious injuriesClass 1 · MajorFinal reportATR 72 · San Juan, PRthe captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.May 9, 2004 · N438AT · Destroyed NTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.Mar 1, 2003 · N642AS · No damage NTSB MIA03LA055Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR72-212 · San Juan, PRThe aft passenger stair handrail collapsing due to undetermined reasons.Feb 8, 2003 · N448AM · No damage NTSB MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.Dec 1, 1998 · N414WF · No damage NTSB FTW97IA222Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-12 · Dallas, TXthe engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…Jun 14, 1997 · N438AT · Minor damage NTSB CHI95IA313Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Chicago, ILimproper installation of the #7 and #8 fuel nozzle manifold transfer tubes by company maintenance personnel, and an inadequate exhaust drain fitting gasket, which resulted in fuel leaks at the respective 'O' ring/gasket fittings; blockage of the fuel/oil…Sep 6, 1995 · N414WF · Minor damage NTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…Jul 10, 1995 · N440AM · Minor damage NTSB FTW95IA096Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Dfw Airport, TXThe uncommanded activation of the brake system on the right main landing gear for undetermined reason.Jan 17, 1995 · N408AT · Minor damage NTSB DCA95MA001Accident · 68 fatalClass 1 · MajorFinal reportATR ATR-72-212 · Roselawn, INthe loss of control, attributed to a sudden and unexpected aileron hinge moment reversal that occurred after a ridge of ice accreted beyond the deice boots while the airplane was in a holding pattern during which it intermittently encountered supercooled…Oct 31, 1994 · N401AM · Destroyed