NTSB investigations, 1994, 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\") = 1994
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") = 1994 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 SEA95LA032Accident · Minor injuriesLimited investigationFinal reportPitts S-2B · Afton, WYThe pilot's failure to maintain directional control, and his inadequate remedial action. Factors include snow covered terrain at the edge of the runway.NTSB SEA95LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Medicine Bow, WYThe failure of the magneto system due to shorting of both magneto coils to the magneto housing and the lack of suitable terrain to make a forced landing.NTSB SEA95LA027Accident · No injuriesLimited investigationFinal reportCessna 180 · Lonetree, WYThe restricted movement of the carburebor float.NTSB SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB SEA95FA012Accident · 2 fatalField investigationFinal reportUnited Consultant UC-1 · Pinedale, WYAircraft control was not maintained. Factors to the accident were: rough water and downdrafts.NTSB SEA95FA011Accident · 4 fatalField investigationFinal reportCessna 310R · Rawlins, WYThe pilot-in-command's not maintaining clearance with terrain. Factors contributing to the accident were high terrain, dark night conditions, and the pilot-in-command's not obtaining/ maintaining the proper climb rate.NTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.NTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.NTSB SEA94LA210Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-109B · Rock Springs, WYAircraft control was not maintained. Factors to the accident were: high density altitude and wind gusts.NTSB SEA94LA187Accident · No injuriesLimited investigationFinal reportBeech P-35 · Laramie, WYLoss of engine power for undetermined reasons. Factors include fence posts struck during rollout at the emergency landing site.NTSB SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.NTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.NTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.NTSB SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB SEA94LA089Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Gillette, WYProcedures/directives were not followed and partial failure of the landing gear selector switch. A factor to the accident was an inoperative gear warning system.NTSB SEA94LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Evanston, WYThe pilot's inadequate compensation for wind conditions. Factors include gusty crosswind, and the pilot's lack of total experience.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.NTSB SEA94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cheyenne, WYThe pilot's improper use of the carburetor heat. A factor to the accident was carburetor icing conditions.