Major NTSB investigations: Pratt & Whitney Canada PT6A-60A
12 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2008 | 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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
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 LAX08MA277Accident · 10 fatalMajor investigationFinal reportBeech A100 · Moab, UTThe pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.NTSB NYC06MA192Accident · 1 fatalMajor investigationFinal reportEmbraer 110P1 · Pownal, VTThe pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…NTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…NTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…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 ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ANC84MA037Accident · No injuriesMajor investigationFinal reportEmbraer EM-110P1 · Cordova, AKDuring a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…NTSB DCA79AA019Accident · 1 fatalClosedDehavilland DHC-6 · Hyannis, MANTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WA