NTSB investigations: Pratt & Whitney Canada PT6A-60A, 2024
5 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 3 |
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 5 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 9 |
| 1990 | 1 |
| 1991 | 8 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 9 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 5 |
| 2025 | 8 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2024
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 year(c."eventDate") = 2024
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 CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.NTSB ERA24LA354Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Asheboro, NCThe pilot’s failure to extend the landing gear before landing.NTSB ANC24LA064Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-2T · Petersville, AKAn in-flight loss of thrust due to an uncommanded feathering of the propeller for reasons that could not be determined.NTSB OPS24FA031IncidentClass 3 · FieldPreliminary reportAirbus Industrie A319-132 · Arlington, VAOn May 29, 2024, at about 1021 eastern daylight time (EDT), American Airlines (AAL) flight 2134 (AAL2134), an Airbus Industries A319-132, and N250AA a Hawker Beechcraft Corporation B300C were involved in a runway incursion that resulted in a loss of…NTSB ERA24FA097Accident · Serious injuriesClass 3 · FieldFinal reportBeech C99 · Londonderry, NHThe pilot’s failure to ensure that the cockpit door was secured before flight, which resulted in its separation during initial climb and a subsequent loss of control.