NTSB investigations: Pratt & Whitney Canada PT6A-60A
11 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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 ('52043', '51999')
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\" = 240))
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 ('52043', '51999')
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" = 240))
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 DEN05FA051Accident · 3 fatalField investigationFinal reportBeech BE-90 · Rawlins, WYThe pilot's inadvertent flight into adverse weather [severe icing] conditions, resulting in an aerodynamic stall impact with rising, mountainous terrain during approach. A factor contributing to the accident was the pilot's inadequate planning for the…NTSB MIA04FA049Accident · 2 fatalField investigationFinal reportBeech C90 · Homestead, FLThe pilot's inadequate in-flight planning/decision which resulted in an encounter with rain showers and turbulence, a loss of aircraft control, and overstress of the airframe.NTSB DEN03LA095Accident · No injuriesLimited investigationFinal reportCessna 425 · Pueblo, COthe pilot's inadvertent flight into adverse weather conditions. Contributing factors include the encounter with severe turbulence and hail.NTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.NTSB MIA00FA229Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Raleigh, NCthe pilot's continued VFR flight into IMC conditions, by failing to maintain altitude, and descending from VFR conditions into IMC, which resulted in him subsequently impacting with trees. Factors in this accident were: reduced visibility due to dark night…NTSB NYC91LA068Accident · No injuriesLimited investigationFinal reportBeech 200 · Johnstown, PAThe pilot's failure to maintain proper directional control of the airplane during landing, resulting in a collision with a snow bank and runway marker. A factor relating to the accident was the low visibility during landing.NTSB ATL90LA182Accident · Serious injuriesLimited investigationFinal reportHelio HST-550A · Mobile, ALThe pilot's intentional attempted takeoff with a known tailwind component. Factors relating to the accident were the tailwind, trees and utility lines on the departure end of the takeoff area.NTSB CHI89FA078Accident · Minor injuriesField investigationFinal reportCessna 208A · Mt. Zion, ILThe pilot's intentional flight into known adverse weather. Contributing factors were the pilot's poor evaluation of the weather information given him by the air traffic controllers.NTSB DEN86FA137Accident · No injuriesField investigationFinal reportBeech BE-99C · Laramie, WYThis part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the…NTSB DEN86MA061Accident · 5 fatalMajor investigationFinal reportCessna 425 · Granby, CODrg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility…NTSB NYC85FA141Accident · 2 fatalField investigationFinal reportBeech BE-200 · Hamptonburgh, NYPlt filed IFR for 2 flight legs; baltimore, MD to teterboro, NJ & teterboro to montgomert, NY (orange co arpt). The plt received a preflight wx briefing & was advised that the forecast for stewart, NY, about 10 mis form montgomery was sky partially obscured…