NTSB investigations: Pratt & Whitney PT6A series, 2000
20 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\") = 2000
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") = 2000
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 NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB LAX01LA019Accident · Serious injuriesLimited investigationFinal reportBeech 300 · Concord, CAthe pilot's delayed decision to abort the takeoff and his failure to utilize the propeller's reverse pitch function.NTSB MIA00IA266Incident · No injuriesIncident investigationFinal reportBeech 1900C · Miami, FLThe excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…NTSB FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB MIA00WA236Accident · No injuriesForeign investigationBeech B200 · Spanish Cay, BahamasNTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.NTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.NTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.NTSB LAX00GA185Accident · Serious injuriesFinal reportBeech 65-90 · China Lake, CAthe inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line. .NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB ANC00LA033Accident · No injuriesLimited investigationFinal reportCessna 208B · Holy Cross, AKAn in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.NTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB CHI00FA071Accident · No injuriesField investigationFinal reportBeech 1900D · Escanaba, MIthe failure of the flightcrew to maintain directional control due to unsafe/hazardous conditions on the runway that was not relayed to them. Factors were the uneven snow covered runway and the snowbank.