NTSB investigations: Pratt & Whitney Canada PT6A-60A, CA
15 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A. 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
| 1968 | 1 |
|---|---|
| 1981 | 1 |
| 1988 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 2002 | 2 |
| 2005 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2014 | 2 |
| 2016 | 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\" = 'CA' 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 ('52043', '51999'))
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" = 'CA' 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 ('52043', '51999'))
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 WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…NTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.NTSB WPR14LA102Accident · No injuriesLimited investigationFinal reportBeech C90 · Columbia, CAThe pilot’s unstabilized night visual approach, which resulted in a hard landing and the collapse of all three landing gear.NTSB WPR09LA228Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marysville, CAThe failure of both pilots to see and avoid the other airplane while making their final approach for landing.NTSB LAX08CA151Accident · No injuriesData collectionFinal reportBeech B200 · Travis AFB, CAThe pilot inadvertently raised the landing gear during landing roll.NTSB LAX05CA250Accident · No injuriesData collectionFinal reportAyres S2R-134 · Kerman, CAthe pilot's failure to obtain an adequate airspeed during an attempted takeoff.NTSB LAX05LA100Accident · 1 fatalLimited investigationFinal reportAyres S2R · Firebaugh, CAthe loss of engine power during takeoff climb resulting from the fatigue failure of one of the compressor turbine blades; the cause of the fatigue failure could not be definitively determined.NTSB LAX02LA226Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Firebaugh, CAThe overload fracture and separation of the left main gear strut assembly due the left landing gear's encounter with a chuck hole in the private airstrip's asphalt pavement. A factor in the accident was the inadequate maintenance of the airstrip's surface.NTSB LAX02FA101Accident · 3 fatalField investigationFinal reportCessna 425 · San Jose, CAthe pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…NTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.NTSB LAX92LA300Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Five Points, CAThe failure of airport personnel to perform the necessary runway maintenance. Contributing to this accident was the dark night and high vegetation.NTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…NTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…NTSB LAX81DVA63Accident · No injuriesClosedAyres S2R · Huron, CANTSB LAX69A0026Accident · No injuriesClosedDehavilland DHC-6 · Avalon, CA