NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 DEN67D0192Accident · No injuriesClosedPiper PA-28 · Etna, WYNTSB DEN67D0182Accident · No injuriesClosedCessna 310 · Rock Springs, WYNTSB DEN67D0154Accident · No injuriesClosedCessna 182 · Rock River, WYNTSB DEN67A0029Accident · No injuriesClosedCessna 310G · Casper, WYNTSB DEN67F0110Accident · No injuriesClosedCessna 310G · Casper, WYNTSB DEN67D0111Accident · No injuriesClosedPiper J-3 · Riverton, WYNTSB DEN67F0133Accident · No injuriesClosedCessna 210 · Mcfadden, WYNTSB DEN67A0021Accident · Serious injuriesClosedBell 47G3B1 · Old Faithful, WYNTSB DEN67F0112Accident · Minor injuriesClosedCessna 172 · Laramie, WYNTSB DEN67F0097Accident · Serious injuriesClosedCessna 150 · Uffalo, WYNTSB DEN67F0122Accident · No injuriesClosedPiper PA-24 · New Castle, WYNTSB DEN67F0095Accident · Minor injuriesClosedMooney M20 · Rawlins, WYNTSB DEN67F0094Accident · Serious injuriesClosedSchweizer TG-3A · Casper, WYNTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYNTSB MKC67F0181Accident · No injuriesClosedPiper PA-28 · Worland, WYNTSB DEN67D0082Accident · No injuriesClosedCessna 210 · Evanston, WYNTSB DEN67F0083Accident · No injuriesClosedPiper PA-30 · Rock Springs, WYNTSB DEN67D0054Accident · No injuriesClosedStinson L-13 · Sheridan, WYNTSB DEN67D0055Accident · No injuriesClosedMooney M20E · Dubois, WYNTSB DEN67D0078Accident · No injuriesClosedBeech A23 · Evanston, WYNTSB DEN67D0070Accident · No injuriesClosedBeech 35-33 · Rock Springs, WYNTSB DEN67F0068Accident · Serious injuriesClosedAeronca 65-TC · Greybull, WYNTSB DEN67A0007Accident · Serious injuriesClosedBell 47G3B1 · Riverton, WYNTSB DEN67F0067Accident · Minor injuriesClosedCessna 150 · Sundance, WYNTSB DEN67D0041Accident · No injuriesClosedPiper PA-18 · Roset, WYNTSB DEN67D0056Accident · Minor injuriesClosedPiper PA-28 · Pine Bluffs, WYNTSB DEN67A0002Accident · Minor injuriesClosedHiller UH12E · Greybull, WYNTSB DEN67D0030Accident · No injuriesClosedNavy N3N-3 · Elk Mountain, WYNTSB DEN66A0089Accident · No injuriesClosedBell 47D1 · Hyattville, WYNTSB DEN67A0015Accident · 3 fatalClosedPiper PA-24 · Powder River, WYNTSB DEN67D0018Accident · No injuriesClosedBeech S35 · Gillette, WYNTSB DEN66A0084Accident · No injuriesClosedHiller UH-12E · Lonetree, WYNTSB DEN67D0019Accident · No injuriesClosedCessna 175 · Du Bois, WYNTSB DEN66D0307Accident · No injuriesClosedCessna 182 · Big Piney, WYNTSB DEN66D0304Accident · No injuriesClosedInterstate S-1A · Fontenelle, WYNTSB DEN67F0016Accident · Serious injuriesClosedCessna 175 · Alpine, WYNTSB DEN66F0305Accident · Minor injuriesClosedLuscombe 8C · Evanston, WYNTSB DEN67D0017Accident · No injuriesClosedPiper PA-18 · Kaycee, WYNTSB DEN66F0306Accident · Minor injuriesClosedBeech F35 · Evanston, WYNTSB DEN66A0073Accident · No injuriesClosedHughes 269A · Arvada, WYNTSB DEN66I0066Incident · No injuriesClosedBoeing B-727 · Cheyenne, WYNTSB DEN66D0281Accident · No injuriesClosedTaylorcraft BC12-D · Seely, WYNTSB DEN66A0062Accident · No injuriesClosedBoeing B-17G · Cody, WYNTSB DEN66D0274Accident · No injuriesClosedPiper PA-18 · Seely, WYNTSB DEN66D0237Accident · No injuriesClosedChampion 7GCB · Evanston, WYNTSB DEN66D0227Accident · No injuriesClosedPiper PA-28 · Gillette, WYNTSB DEN66D0282Accident · No injuriesClosedPiper J3C · Big Piney, WYNTSB DEN66F0216Accident · No injuriesClosedBeechcraft 23 · Riverton, WYNTSB DEN66F0213Accident · No injuriesClosedCessna 180 · Rock Springs, WYNTSB DEN66D0205Accident · No injuriesClosedCessna 320 · Green River, WY