NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X0437Accident · Minor injuriesClosedConvair CV-340 · Rock Springs, WYNTSB UNK65X0288Accident · No injuriesClosedBeechcraft B55 · Sheridan, WYNTSB UNK64X4126Accident · Minor injuriesClosedBeechcraft 95B55 · Evanston, WYNTSB UNK64X4102Accident · Minor injuriesClosedBeech 35A33 · Casper, WYNTSB UNK64X4023Accident · No injuriesClosedPiper PA24 · Rock Springs, WYNTSB UNK64X3677Accident · No injuriesClosedGrumman TBM-3E · Casper, WYNTSB UNK64X3617Accident · 2 fatalClosedPiper PA28 · Cody, WYNTSB UNK64X3484Accident · Minor injuriesClosedCorbin Baby ACE · Rawlings, WYNTSB UNK64X3335Accident · No injuriesClosedCessna 170A · Rawlings, WYNTSB UNK64X3297Accident · No injuriesClosedBeechcraft 23 · Lander, WYNTSB UNK64X3225Accident · No injuriesClosedCessna 182A · Rock Springs, WYNTSB UNK64X2921Accident · No injuriesClosedStinson 108-2 · Cheyenne, WYNTSB UNK64X2878Accident · No injuriesClosedPiper J5 · Cody, WYNTSB UNK64X2876Accident · No injuriesClosedCessna 182 · Rock River, WYNTSB UNK64X2726Accident · No injuriesClosedCessna 170B · Wheatland, WYNTSB UNK64X2686Accident · No injuriesClosedMooney MK20 · Rock Springs, WYNTSB DEN65D0017Accident · No injuriesClosedPiper PA-18 · Cody, WYNTSB UNK64X2453Accident · No injuriesClosedBell 47G3B1 · Bondurant, WYNTSB UNK64X2394Accident · No injuriesClosedPiper PA18 · Big Piney, WYNTSB UNK64X2344Accident · 3 fatalClosedBeechcraft A35 · Rawlins, WYNTSB UNK64X2224Accident · No injuriesClosedTaylorcraft BL1265 · Rawlings, WYNTSB UNK64X1998Accident · 1 fatalClosedBeechraft 35 · Sundance, WYNTSB UNK64X1953Accident · No injuriesClosedBeechcraft 35 · Kemmer, WYNTSB UNK64X1912Accident · Minor injuriesClosedCessna 170 · Laramie, WYNTSB UNK64X1870Accident · No injuriesClosedCessna 180F · Norland, WYNTSB UNK64X1853Accident · No injuriesClosedBell 47G3B · Sheridan, WYNTSB UNK64X1849Accident · No injuriesClosedStinson L5 · Cheyenne, WYNTSB UNK64X1782Accident · No injuriesClosedCessna 170 · Frannie, WYNTSB UNK64X1591Accident · No injuriesClosedCessna 172 · Casper, WYNTSB UNK64X1562Accident · No injuriesClosedBellanca 1413 · Buffalo, WYNTSB UNK64X1396Accident · 1 fatalClosedCessna 172 · Dubois, WYNTSB UNK64X1339Accident · No injuriesClosedPiper PA18 · Buffalo Arpt, WYNTSB UNK64X1228Accident · 1 fatalClosedBeechcraft T34B · Medicine Bow, WYNTSB UNK64X0922Accident · No injuriesClosedPiper PA22 · Lander, WYNTSB UNK64X0903Accident · No injuriesClosedCessna 180 · Cheyenne, WYNTSB UNK64X0729Accident · No injuriesClosedChampion 7GCB · Riverton, WYNTSB UNK64X0696Accident · 2 fatalClosedChampion 7GCB · Split Rock, WYNTSB UNK64X0629Accident · 1 fatalClosedPiper PA18 · Gillette, WYNTSB UNK64X0551Accident · 1 fatalClosedCessna 172A · Newcastle, WYNTSB UNK64X0545Accident · No injuriesClosedPiper PA24 · Cheyenne, WYNTSB UNK64X0451Accident · No injuriesClosedCessna 310B · Casper, WYNTSB UNK64X0425Accident · No injuriesClosedPiper PA20 · Glendo, WYNTSB UNK64X0417Accident · Minor injuriesClosedPiper PA18 · Creston Jct, WYNTSB UNK64X0265Accident · No injuriesClosedCessna 172A · Cheyenne, WYNTSB UNK64X0225Accident · No injuriesClosedPiper PA18 · Pinedale, WYNTSB UNK64X0213Accident · 1 fatalClosedCessna 182F · Thernopolis, WYNTSB UNK64X0111Accident · No injuriesClosedCessna 172 · Rawlings, WY