NTSB investigations: Pratt & Whitney Canada PW120
23 cases on aircraft whose registry engine model is Pratt & Whitney Canada PW120. 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 |
|---|---|
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 4 |
| 2003 | 1 |
| 2005 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2023 | 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 ('52114'))
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 ('52114'))
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 DCA23WA436IncidentClass 5 · ForeignAerospatiale/Aeritalia ATR 42-300 · Freeport, BahamasNTSB DCA14CA147Accident · No injuriesData collectionFinal reportDehavilland DHC 8 102 · Harrisburg, PAthe airplanes collision with geese during the takeoff roll.NTSB DCA14CA031Accident · No injuriesData collectionFinal reportDe Havilland DHC8 - 102 · Philadelphia, PAan inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.NTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…NTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.NTSB ANC05LA088Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Anchorage, AKA lightning strike during a normal descent for landing, which resulted in structural damage to the airplane's left aileron.NTSB MIA03WA084Accident · Serious injuriesForeign investigationAerospatiale ATR-42-300 · Santo Domingo, Dominican RepublicNTSB SEA01IA161Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Portland, ORImproper tension of the right control yoke chain; a worn right aileron spring tab hinge bearing; improper tension of the left aileron spring tab aft spring and worn contact stud; improper tension of the right aileron spring tab and a worn contact stud; a worn…NTSB DCA01MA056Accident · 1 fatalMajor investigationFinal reportde Havilland Dash 8-100 · Washington, DCThe ramp agent's impaired performance due to his hyperthyroidism, which was exacerbated by the heat and was inadequately controlled by medication, and possibly also due to the use of an antianxiety medication.NTSB MIA01LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 42-300 · Atlantic Ocean (Atlantic Ocean)The in-flight encounter with moderate to severe turbulence in clouds resulting in the serious injury to the flight attendant. A contributing factor in the accident was the poor in-flight planning by the captain for his allowing beverage service to continue…NTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…NTSB CHI00IA221Incident · No injuriesIncident investigationFinal reportAerospatiale ATR 42-300 · Champaign, ILThe failure of the aileron trim switch due to foreign material contamination.NTSB IAD00IA026Incident · No injuriesIncident investigationFinal reportBoeing - Canada DHC-8-102 · Baltimore, MDthe missing elevator stop bumper that resulted in elevator over-travel and damage to the elevator. A factor in the incident was the abrupt release of the elevator control lock in windy conditions.NTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.NTSB CHI99LA289Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe failure of the ramp service clerk to maintain clearance with the operating propeller. A factor related to the accident the inattentiveness on the part of the clerk.NTSB NYC98LA193Accident · Serious injuriesLimited investigationFinal reportBoeing DHC-8-102 · Islip, NYClear air turbulence.NTSB CHI98LA351Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe wake turbulence encountered by Flight 146.NTSB SEA97LA077Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8 · Wenatchee, WAfailure of the ground marshaller to marshal the airplane into a correct parking place on the ramp, her failure to verify clearance between the right wing of the airplane and the ground de-ice cart, and failure of the flight crew to ensure clearance of the…NTSB ATL94IA048Incident · Minor injuriesIncident investigationFinal reportBoeing DHC-8-102 · Charlotte, NCAn inflight encounter with turbulence, and the flight attendant's failure to fasten her seatbelt.NTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.NTSB MIA93LA090Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Jacksonville, FLThe operator's lack of adequate instructions to crewmembers as to when flight attendants can resume cabin duties after being told to be seated by the captain.NTSB ATL91IA134Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Savannah, GAThe inadequate inspection procedures which allowed the loss of torque on the top retraction fitting attachment bolt which subsequently failed in fatigue. Factors were the loss of hydraulic fluid through a severed line, and the corrosion of a hydraulic…NTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…