NTSB investigations, 1992, 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
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\") = 1992
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") = 1992 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 SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB SEA93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Moran Junction, WYThe pilot in command's attempting flight into known adverse weather conditions and his subsequent inability to maintain altitude. Factors contributing to the accident were icing conditions and trees.NTSB SEA93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Evanston, WYThe pilot's disregard of hazardous weather advisory, resulting in flt into forecast icing conditions in an acft not equipped or certified for the flt, and the improper inflt planning by pilot during the VFR approach that resulted in impact with terrain short…NTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.NTSB SEA92LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Smoot, WYThe pilot in command's delayed go-around. Factors contributing to the accident were the pilot in command's selection of unsuitable terrain and trees.NTSB SEA92LA210Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Arlington, WYThe pilot in command's failure to touch down at the proper landing point on the road. A factor contributing to the accident was high density altitude.NTSB DEN92FA093Accident · 1 fatalField investigationFinal reportCessna 172M · Evanston, WYLoss of control for undetermined reasons.NTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.NTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.NTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.NTSB DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.NTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.NTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.NTSB SEA92LA138Accident · Minor injuriesLimited investigationFinal reportNavion H · Gillette, WYAn engine power loss due to the collapse of the induction air ducting, inadequate maintenance, and improper approval of the modification.NTSB SEA92LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mckinnon, WYWater in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.NTSB SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.NTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.NTSB SEA92LA044Accident · 2 fatalLimited investigationFinal reportLockheed P2V-7 · Dixon, WYThe pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…