NTSB investigations, 1996, WY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1996
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") = 1996 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 SEA97FA033Accident · 1 fatalField investigationFinal reportBeech B36TC · Jackson, WYfailure of the pilot to follow IFR procedures. High terrain, low ceiling, icing conditions, and a possible anomaly with the VOR were related factors.NTSB SEA97LA021Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Laramie, WYVFR flight by the pilot into instrument meteorological conditions (IMC), his misjudged speed/distance on final approach for landing, and his failure to attain the proper touchdown point during the landing. Factors relating to the accident include snow, low…NTSB SEA97LA015Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Casper, WYloss of power for undetermined reason(s). A factor relating to the accident was: the pilot was operating outside height/velocity curve parameters, when the loss of power occurred.NTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.NTSB SEA96TA207Accident · Minor injuriesFinal reportBell 206L-3 · Sheridan, WYthe pilot's improper in-flight planning/decision, concerning maneuvers to position the helicopter for aerial application; and inadvertent loss of tail rotor effectiveness, which resulted in loss of directional control and subsequent collision with the…NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.NTSB SEA96LA191Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lander, WYthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors relating to the accident were: the variable and gusty wind conditions.NTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.NTSB SEA96LA190Accident · No injuriesLimited investigationFinal reportAviat A-1 · Worland, WYoverload failure of the landing gear axle, after its design stress limits had been exceeded at some undetermined time.NTSB SEA96LA140Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Jackson, WYAn improper screw installation by an unknown individual into the instrument panel, which restricted movement of the gear handle resulting in premature disengagement of the normal landing gear extension system. A factor was one or more improperly adjusted nose…NTSB SEA96LA126Accident · No injuriesLimited investigationFinal reportPrice Berkut · Jackson, WYfailure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB SEA96LA081Accident · Minor injuriesLimited investigationFinal reportForth Acro 2 · Rock Springs, WYthe pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.NTSB SEA96MA079Accident · 3 fatalClass 1 · MajorFinal reportCessna 177B · Cheyenne, WYthe pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…NTSB SEA96LA068Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Point Of Rocks, WYthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control due to spatial disorientation. Factors relating to the accident were: the low ceiling and snow.NTSB SEA96TA050Accident · No injuriesFinal reportBell 206B · Kemmerer, WYthe selection of an unsuitable landing zone by the pilot.