NTSB investigations: Pratt & Whitney Canada PT6A-60A, FL
13 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
| 1972 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2008 | 1 |
| 2017 | 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\" = 'FL' 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" = 'FL' 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 WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB MIA04LA071Accident · Serious injuriesLimited investigationFinal reportBeech Be-300 · Daytona Beach, FLThe pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.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 MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…NTSB MIA01LA054Accident · No injuriesLimited investigationFinal reportBeech 200 · Naples, FLThe failure of the pilot to obtain assistance from the FBO in the form of a marshaller and failure of the pilot to maintain clearance resulting in the on-ground collision with the light pole.NTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB MIA90IA039Incident · No injuriesIncident investigationFinal reportBoeing 727 · Ormond Beach, FLFailure of the pilot in command in the Beech 300 to comply with an ATC clearance in a timely manner, while diverting his attention, and failure of the ATC controller to assure that IFR separation was maintained.NTSB MIA89FA124Accident · Serious injuriesField investigationFinal reportBeech C-45H · Tampa, FLFuel contamination of the left engine fuel system which resulting in a failure of the left engine.NTSB MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…NTSB MIA86FA113Accident · Serious injuriesField investigationFinal reportBeech 65-90 · Fort Pierce, FLFlt experienced loss of power in both engines due to fuel starvation. The pilots failed to operate fuel transfer switches to transfer fuel from the wing tanks into the nacelle tanks which feed the engines. The pilot in command had 16 total hours in the king…NTSB MIA73AM006Accident · No injuriesClosedBeech D18S · Jacksonville, FL