NTSB investigations: Pratt & Whitney PT6A series
26 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 5 |
| 2000 | 3 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 4 |
| 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034')
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\" = 130))
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 ('52032', '52034')
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" = 130))
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 SEA07LA133Accident · No injuriesLimited investigationFinal reportBeech B-99 · Billings, MTThe total failure of the nose landing gear actuator and the subsequent nose gear collapse during landing.NTSB CHI07IA067Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Fort Wayne, INThe fatigue failure/separation of the engine mount's nose gear actuator attachment foot, and the manufacturer's inadequate engine mount/nose gear actuator attachment design.NTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…NTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.NTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB ANC05IA048Incident · No injuriesIncident investigationFinal reportReims F406 · Nome, AKThe failure of the nose gear up lock actuator bracket during the landing approach due to fatigue cracking, which resulted in a nose wheel up landing. A factor associated with the incident is the mechanical binding of the nose wheel locking mechanism.NTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.NTSB CHI04LA213Accident · No injuriesLimited investigationFinal reportCessna 208B · Big Rapids, MIThe pilot's failure to verify that the cargo door was latched properly prior to flight and the subsequent in-flight opening of the door. A contributing factor was the box which departed the cargo compartment and struck the horizontal stabilizer.NTSB ATL04IA098Incident · No injuriesIncident investigationFinal reportCessna 208B · Tunica, MSThe pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.NTSB ATL04IA073Incident · No injuriesIncident investigationFinal reportCessna 208B · Auburn, ALThe fatigue fracture of the wire rope portion on the rudder control cable assembly due to improper installation and inadequate procedures by the aircraft manufacturer.NTSB CHI03IA153Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIFailure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…NTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.NTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…NTSB LAX00GA185Accident · Serious injuriesFinal reportBeech 65-90 · China Lake, CAthe inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line. .NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB ANC00LA033Accident · No injuriesLimited investigationFinal reportCessna 208B · Holy Cross, AKAn in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.NTSB ANC98IA004Incident · No injuriesIncident investigationFinal reportCessna 208B · Kasigluk, AKinadequate inspection of the aileron by company maintenance personnel, and the pilot's inadequate preflight inspection of the aileron, which led to the jamming of the left aileron due to loose balance weight retaining screws.NTSB FTW97LA331Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Pineland, TXfailure of the right main wheel brake, during the landing roll. A factor relating to the accident was: the pilot's failure (or inability) to maintain directional control of the airplane, after loss of right braking action.NTSB NYC97IA123Incident · No injuriesIncident investigationFinal reportBeech 1900D · Clarksburg, WVThe right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.NTSB LAX97LA125Accident · No injuriesLimited investigationFinal reportCessna 425 · Fresno, CAfailure of the right brake to function, due to the installation mechanic's failure to completely bleed all air from the lines. A factor in the accident was the pilot's decision to fly the unairworthy aircraft before the engine/propeller installation had been…NTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…NTSB CHI97IA029Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hopkensville, KYthe materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB DEN88IA207Incident · No injuriesIncident investigationFinal reportBeech 1900 · Denver, CONTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…NTSB DEN85LA244Accident · No injuriesLimited investigationFinal reportCessna 425 · Boulder, COThe plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…