NTSB investigations, 2001, WY
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 47 |
|---|---|
| 1965 | 52 |
| 1966 | 50 |
| 1967 | 55 |
| 1968 | 47 |
| 1969 | 53 |
| 1970 | 42 |
| 1971 | 34 |
| 1972 | 38 |
| 1973 | 45 |
| 1974 | 37 |
| 1975 | 42 |
| 1976 | 38 |
| 1977 | 48 |
| 1978 | 45 |
| 1979 | 34 |
| 1980 | 43 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 44 |
| 1984 | 32 |
| 1985 | 20 |
| 1986 | 31 |
| 1987 | 16 |
| 1988 | 22 |
| 1989 | 14 |
| 1990 | 18 |
| 1991 | 21 |
| 1992 | 18 |
| 1993 | 24 |
| 1994 | 24 |
| 1995 | 15 |
| 1996 | 16 |
| 1997 | 12 |
| 1998 | 21 |
| 1999 | 21 |
| 2000 | 20 |
| 2001 | 17 |
| 2002 | 16 |
| 2003 | 19 |
| 2004 | 16 |
| 2005 | 17 |
| 2006 | 13 |
| 2007 | 13 |
| 2008 | 18 |
| 2009 | 4 |
| 2010 | 9 |
| 2011 | 26 |
| 2012 | 18 |
| 2013 | 15 |
| 2014 | 11 |
| 2015 | 14 |
| 2016 | 10 |
| 2017 | 11 |
| 2018 | 13 |
| 2019 | 11 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 13 |
| 2023 | 6 |
| 2024 | 16 |
| 2025 | 9 |
| 2026 | 13 |
Where
Latest 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\") = 2001
AND c.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
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") = 2001 AND c."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 DEN02TA011Accident · No injuriesFinal reportCessna 206 · Casper, WYfailure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.NTSB DEN02LA006Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Casper, WYThe pilot's failure to maintain clearance from another parked airplane while taxiing. Contributing factors were the night light conditions, and the pilot's fatigue from a long day.NTSB DEN01LA156Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kemmerer, WYthe loss of tail rotor effectiveness while air taxiing. Contributing factors were the high winds and gusts, and the pilot's limited experience in aircraft make/model.NTSB DEN01LA154Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Kemmerer, WYloss of tail rotor effectiveness while hovering. A contributing factor was the wind gust.NTSB DEN01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Rock Springs, WYthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…NTSB DEN01LA145Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B-2 · Cody, WYthe pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.NTSB DEN01LA144Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kemmerer, WYfuel exhaustion due to the pilot's failure to refuel the aircraft, which resulted in a loss of engine power. A contributing factor was the unsuitable steep terrain on which to make a forced landing.NTSB DEN01LA142Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Rock Springs, WYthe right main tire blowing out in flight, which resulted in a loss of directional control during landing.NTSB DEN01FA135Accident · 1 fatalField investigationFinal reportBeech V-35A · Lusk, WYthe pilot's inadequate visual lookout, which resulted in an inadvertent collision with transmission wires.NTSB DEN01TA134Accident · No injuriesFinal reportBell 205A-1 · Jackson, WYthe Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.NTSB DEN01LA125Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Cody, WYthe failure of the turbine assembly due to an over temperature condition. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.NTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…NTSB DEN01LA067Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Buffalo, WYfailure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.NTSB DEN01LA060Accident · No injuriesLimited investigationFinal reportBell 407 · Jackson, WYThe pilot's failure to maintain adequate lateral and vertical clearance during landing. Factors were the clouds and snow-covered high terrain.NTSB DEN01LA057Accident · No injuriesLimited investigationFinal reportEurocopter France AS-350-B2 · Powder River, WYThe pilot's failure to maintain aircraft control during aircraft shut down procedures. Contributing factors were: the snow and ice covered field and the confined landing areas unsuitable obstacle clearance.NTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.