NTSB investigations, 2000, 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
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.\"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") = 2000 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 DEN01FA030Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-700 · Jackson, WYThe pilot's failure to follow IFR approach procedures and perform a missed approach when the runway was not in sight below approach minimums. Contributing factors were the copilot's failure to follow current ILS approach procedures and use the correct…NTSB DEN01FA028Accident · 2 fatalField investigationFinal reportCessna 172 · Lusk, WYthe pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…NTSB DEN01LA002Accident · Serious injuriesLimited investigationFinal reportHughes 369FF · Baggs, WYimpact with terrain following a total loss of engine power due to fatigue failure of the turbine-to-compressor coupling. A contributing factor was the unsuitable terrain for a forced landing.NTSB DEN00LA176Accident · No injuriesLimited investigationFinal reportBell 206B · Rawlins, WYThe company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.NTSB DEN00LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sheridan, WYThe pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.NTSB DEN00LA166Accident · No injuriesLimited investigationFinal reportCessna 340A · Big Piney, WYCollision with animals during the takeoff roll.NTSB DEN00LA165Accident · Serious injuriesLimited investigationFinal reportGulfstream G-IV · Sheridan, WYthe pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.NTSB DEN00TA160Accident · Minor injuriesFinal reportBell 212 · Jackson, WYLoss of control for undetermined reasons.NTSB DEN00LA157Accident · Serious injuriesLimited investigationFinal reportPhelps Rans S-12 Airaile · Buffalo, WYthe lack of suitable terrain for the forced landing. Contributing factors were the power failure due to a failed rod bearing, and down draft weather condition.NTSB DEN00LA156Accident · No injuriesLimited investigationFinal reportCessna 180K · Douglas, WYThe pilot's failure to maintain control of the aircraft during landing roll. Factors were high winds and crosswinds.NTSB DEN00FA141Accident · 1 fatalField investigationFinal reportMooney M20K · Cheyenne, WYthe airplane's in-flight collision with hilly terrain for undetermined reasons.NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.NTSB DEN00LA079Accident · 1 fatalLimited investigationFinal reportGreen GTX-SE-FI · Gillette, WYThe pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.NTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.NTSB DEN00LA057Accident · No injuriesLimited investigationFinal reportLearjet 60 · Jackson, WYThe pilot not following the airplane manufacturer's recommended landing procedures for a contaminated runway by landing with a tailwind. Factors were the pilot's inadvertent deactivation of the anti-skid protection, the ice contaminated runway, and the snow…NTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.NTSB DEN00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Rock Springs, WYA forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…NTSB DEN00LA036Accident · No injuriesLimited investigationFinal reportBeech B200 · Jackson, WYThe pilot misreading the visual approach lighting system, resulting in his failure to maintain proper alignment with the runway and his selection of an improper touchdown point. Factors were the low ceiling weather conditions and the snow covered runway.