NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 DEN66D0196Accident · No injuriesClosedPiper PA-24 · Riverton, WYNTSB DEN66D0191Accident · No injuriesClosedCessna 182 · Frannie, WYNTSB FTW66D0378Accident · No injuriesClosedGrumman G-164 · Sheridan, WYNTSB DEN66D0150Accident · No injuriesClosedPiper PA-20 · Casper, WYNTSB DEN66F0157Accident · No injuriesClosedPiper PA-23 · Cheyenne, WYNTSB DEN66F0141Accident · No injuriesClosedErcoupe 415C · Cheyenne, WYNTSB DEN66F0125Accident · Minor injuriesClosedCessna 182C · Laramie, WYNTSB DEN66D0126Accident · Minor injuriesClosedBellanca 14-19 · Douglas, WYNTSB DEN66D0145Accident · Serious injuriesClosedBeechcraft A45 · Pinedale, WYNTSB DEN66F0131Accident · No injuriesClosedCessna 172 · Albin, WYNTSB DEN66A0024Accident · Minor injuriesClosedBell 47G3B1 · Jackson, WYNTSB DEN66A0019Accident · No injuriesClosedPiper PA-22 · Cheyenne, WYNTSB DEN66D0124Accident · No injuriesClosedCessna 180 · Medicine Bow, WYNTSB DEN66F0105Accident · No injuriesClosedPiper PA-23 · Evanston, WYNTSB DEN66D0106Accident · No injuriesClosedBeechcraft B55 · Big Piney, WYNTSB DEN66D0098Accident · No injuriesClosedPiper PA-11 · Big Piney, WYNTSB DEN66A0015Accident · 2 fatalClosedChampion 7EC · Cheyenne, WYNTSB DEN66D0075Accident · No injuriesClosedPiper PA-18 · Lysite, WYNTSB DEN66A0006Accident · 3 fatalClosedPiper PA-23 · Douglas, WYNTSB DEN66D0091Accident · Minor injuriesClosedCallair A-5 · Lovell, WYNTSB DEN66D0060Accident · No injuriesClosedPiper PA-28 · Saratoga, WYNTSB DEN66D0074Accident · Minor injuriesClosedCessna 185 · Jackson, WYNTSB DEN66A0010Accident · No injuriesClosedHughes 269B · Cody, WYNTSB DEN66F0053Accident · No injuriesClosedForney 415-CD · Cheyenne, WYNTSB DEN66A0004Accident · No injuriesClosedHiller UH-12E · Meeteetse, WYNTSB DEN66F0019Accident · No injuriesClosedBeechcraft K-35 · Cheyenne, WYNTSB DEN66D0054Accident · No injuriesClosedPiper PA-18A · Upton, WYNTSB DEN66D0020Accident · No injuriesClosedCessna 195 · Moran, WYNTSB DEN65F0115Accident · No injuriesClosedPiper PA-24 · Sheridan, WYNTSB DEN65A0082Accident · 2 fatalClosedChampion 7ECA · Alcova, WYNTSB DEN66D0010Accident · No injuriesClosedCessna 182 · Mountain View, WYNTSB DEN65F0097Accident · Minor injuriesClosedCessna 172 · Sundance, WYNTSB DEN65F0090Accident · No injuriesClosedPiper PA-12 · Wheatland, WYNTSB DEN65F0079Accident · No injuriesClosedMooney M20A · Cheyenne, WYNTSB DEN65D0088Accident · No injuriesClosedPiper PA-11 · Pinedale, WYNTSB DEN65F0070Accident · No injuriesClosedSwift GC-1B · Rawlins, WYNTSB DEN65D0086Accident · No injuriesClosedLuscombe 8E · Lovell, WYNTSB DEN65D0078Accident · No injuriesClosedCessna 150B · Wheatland, WYNTSB DEN65D0089Accident · No injuriesClosedCessna 170 · Douglas, WYNTSB DEN65D0069Accident · No injuriesClosedBeechcraft 95 · Rock Springs, WYNTSB DEN65A0069Accident · 1 fatalClosedCessna 182A · 8s Cheyenne, WYNTSB DEN65D0080Accident · Minor injuriesClosedPiper PA-25 · Lebarge, WYNTSB DEN65D0071Accident · No injuriesClosedStinson 108 · Worland, WYNTSB DEN65D0065Accident · Minor injuriesClosedChampion 7CCM · Alva, WYNTSB DEN65F0059Accident · No injuriesClosedChampion 7BCM · Afton, WYNTSB DEN65D0087Accident · No injuriesClosedCessna 182 · Pine Bluffs, WYNTSB DEN65F0030Accident · No injuriesClosedMooney M20C · Newcastle, WYNTSB DEN65F0019Accident · No injuriesClosedCessna 180 · Lander, WYNTSB DEN65A0058Accident · 2 fatalClosedPiper PA-24 · Cheyenne, WYNTSB DEN65F0011Accident · No injuriesClosedBeechcraft S-35 · Cheyenne, WY