NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 DEN82FA009Accident · No injuriesClosedAerospatial SA316B · Cokeville, WYNTSB DEN82FA006Accident · 2 fatalClosedMitsubishi MU-2B · Saratoga, WYNTSB DEN82FTC01Accident · No injuriesClosedPiper PA-28 · Powell, WYNTSB DEN81FTC28Accident · No injuriesClosedPiper PA-18 · 25m S Gillette, WYNTSB DEN81FTC25Accident · Minor injuriesClosedBeech H18S · Gillette, WYNTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYNTSB DEN81FTC26Accident · Minor injuriesClosedHughes 369D · Cokeville, WYNTSB DEN81AA064Accident · 5 fatalClosedMitsubishi MU-2B · Riverton, WYNTSB DEN81FA062Accident · Minor injuriesClosedHughes 369D · Afton, WYNTSB DEN81FTC24Accident · Minor injuriesClosedCessna 177RG · Cheyenne, WYNTSB DEN81FA061Accident · 3 fatalClosedPiper PA-28 · 40 Mi S Casper, WYNTSB DEN81FA060Accident · 1 fatalClosedCessna T207 · Casper, WYNTSB DEN81FA059Accident · Serious injuriesClosedBell 206-B3 · Alpine, WYNTSB DEN81DTC23Accident · No injuriesClosedPiper PA-12 · Cody, WYNTSB DEN81FA057Accident · 1 fatalClosedAerospatial 316B · Alpine, WYNTSB DEN81DTC22Accident · No injuriesClosedPiper PA-28 · Ft Bridger, WYNTSB DEN81FTC21Accident · Serious injuriesClosedPiper PA-28 · Rawlins, WYNTSB DEN81FTC20Accident · Minor injuriesClosedPiper PA-28 · Sundance, WYNTSB DEN81FA051Accident · 2 fatalClosedPiper PA-16 · Ten Sleep, WYNTSB DEN81FTC19Accident · No injuriesClosedCessna 180 · Thayne, WYNTSB DEN81FTC17Accident · Minor injuriesClosedCessna TR182 · Cheyenne, WYNTSB DEN81FTC18Accident · Minor injuriesClosedAerospatle SA315B · Meeteetse, WYNTSB DEN81FTC16Accident · No injuriesClosedN American P-51D · Casper, WYNTSB DEN81FA035Accident · 1 fatalClosedBell 206B · Evanston, WYNTSB DEN81FTC15Accident · No injuriesClosedCessna 152 · Gillette, WYNTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYNTSB DEN81FA031Accident · 1 fatalClosedCessna 152 · Cowley, WYNTSB DEN81FA030Accident · 1 fatalClosedPiper PA-32 · Gillette, WYNTSB DEN81FTC14Accident · No injuriesClosedDehavilland DHC-1 · Rawlins, WYNTSB DEN81FTC13Accident · No injuriesClosedCessna 172XP · Moorcroft, WYNTSB DEN81FTC12Accident · No injuriesClosedPiper PA-18 · Ft Bridger, WYNTSB DEN81FA026Accident · 2 fatalClosedPiper PA-28 · Rock Springs, WYNTSB DEN81FA022Accident · No injuriesClosedBell 206A · Evanston, WYNTSB DEN81FTC11Accident · Minor injuriesClosedCessna 140 · Wapiti, WYNTSB DEN81FA020Accident · 1 fatalClosedCessna 206G · Cokeville, WYNTSB DEN81FTC09Accident · No injuriesClosedCessna 182 · Moran Juction, WYNTSB DEN81DTC10Accident · No injuriesClosedCessna 170B · Buffalo, WYNTSB DEN81FTC08Accident · No injuriesClosedBell 206B · Kenmerer, WYNTSB DEN81FA015Accident · 1 fatalClosedCessna 310C · Encampment, WYNTSB DEN81FA014Accident · 6 fatalClosedCessna T310R · Moose, WY