NTSB investigations: Pratt & Whitney Canada PT6A-60A, 1991
8 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\") = 1991
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") = 1991
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 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 ANC92FA006Accident · No injuriesField investigationFinal reportBeech BE-99 · Allakaket, AKWas the pilot-in-command misjudged the proper touchdown point on the runway. Contributing to the accident was the snow-covered terrain and a snowbank.NTSB DEN91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Santa Fe, NMInadvertent deactivation of aircraft brakes by unqualified person.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.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 FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.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 CHI91LA067Accident · No injuriesLimited investigationFinal reportBeech 200 · Vichy, MOA restricted visual outlook and go-around was not performed by the pilot. Factors related to the accident were a dark night, fog and glare, ice covered runway and whiteout conditions.