NTSB investigations: Pratt & Whitney PT6A series, 1995
10 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series. 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
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 6 |
| 1993 | 2 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 23 |
| 1998 | 14 |
| 1999 | 16 |
| 2000 | 20 |
| 2001 | 24 |
| 2002 | 28 |
| 2003 | 34 |
| 2004 | 26 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 22 |
| 2009 | 19 |
| 2010 | 18 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 20 |
| 2014 | 20 |
| 2015 | 15 |
| 2016 | 25 |
| 2017 | 19 |
| 2018 | 15 |
| 2019 | 17 |
| 2020 | 19 |
| 2021 | 9 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 18 |
| 2025 | 11 |
| 2026 | 8 |
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\") = 1995
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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") = 1995
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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 LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB MIA95LA229Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lorida, FLMismanagement of the fuel by the pilot resulting in the total loss of engine power due to fuel exhaustion, and the pilot's poor decision to fly over water en route to the refueling airport.NTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB CHI95LA278Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-400 · Hayti, MOthe pilot inadvertently stalled the airplane. A factor was the reduced power setting.NTSB LAX95LA283Accident · No injuriesLimited investigationFinal reportPZL-Mielec PZL-M-18 · Sacaton, AZThe loss of engine power due to a decoupling of the accessory drive that runs the high pressure engine-driven fuel pump.NTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB LAX95LA137Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Honolulu, HIIntentional ditching due to the flightcrew's failure to properly manage the fuel system, and operation of the airplane in an excessively overweight condition.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.