NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 DEN81FTC07Accident · No injuriesClosedCessna 182 · Worland, WYNTSB DEN81FA013Accident · 1 fatalClosedPiper PA-24 · Teton Village, WYNTSB DEN81FTC06Accident · No injuriesClosedCessna 150K · Wright, WYNTSB DEN81FTC05Accident · No injuriesClosedCessna 172 · Rock Springs, WYNTSB DEN81FTC04Accident · Minor injuriesClosedCessna 150M · Casper, WYNTSB DEN81FTC03Accident · No injuriesClosedPiper PA-20 · Cody, WYNTSB DEN81FTC02Accident · No injuriesClosedDehavilland DH82A · Evanston, WYNTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYNTSB DEN80FAMS1Accident · 2 fatalClosedMooney M20F · Buffalo, WYNTSB DEN81FA006Accident · 1 fatalClosedCessna 182K · Rock Springs, WYNTSB MKC81FA003Accident · 2 fatalClosedCessna 182H · Newcastle, WYNTSB DEN81FTC01Accident · No injuriesClosedCessna 170 · Wright, WYNTSB DEN80DTC31Accident · Minor injuriesClosedCessna 182-TR · Sundance, WYNTSB MKC80FA054Accident · 4 fatalClosedBeech V35 · Jackson, WYNTSB DEN80FTC30Accident · Serious injuriesClosedCessna 210K · Jackson, WYNTSB DEN80FTC29Accident · Serious injuriesClosedCessna 120 · Afton, WYNTSB DEN80FA054Accident · 1 fatalClosedPiper PA-24R · Jackson, WYNTSB DEN80FTC27Accident · No injuriesClosedCessna 310Q · Evanston, WYNTSB DEN80DTC28Accident · No injuriesClosedHiller UH-12E · Greybull, WYNTSB DEN80FTC25Accident · No injuriesClosedPiper PA-28R · Encampment, WYNTSB DEN80FTC20Accident · No injuriesClosedHughes 269C · Edgerton, WYNTSB DEN80FA052Accident · 2 fatalClosedAerospatial SA315 · Meeteetse, WYNTSB DEN80DTC26Accident · No injuriesClosedPiper PA-18 · Lysite, WYNTSB DEN80FTC22Accident · Serious injuriesClosedAerospatle 315B · Afton, WYNTSB DEN80FTC23Accident · No injuriesClosedPiper PA-25 · Aladdin, WYNTSB DEN80DTC24Accident · No injuriesClosedAerospatle SA315B · Pinedale, WYNTSB DEN80FTC21Accident · No injuriesClosedPiper PA-16 · Rock Springs, WYNTSB DEN80FTC19Accident · Minor injuriesClosedCessna 152 · Sheridan, WYNTSB DEN80FTC18Accident · Minor injuriesClosedCessna 210L · Mountain View, WYNTSB DEN80FA038Accident · No injuriesClosedAlouette SA315B · Jackson, WYNTSB DEN80FTC17Accident · No injuriesClosedPiper PA-18 · Cheyenne, WYNTSB DEN80FA036Accident · 1 fatalClosedCessna TR182 · Wheatland, WYNTSB DEN80FTC16Accident · 2 fatalClosedCessna R172K · Cheyenne, WYNTSB DEN80FA033Accident · No injuriesClosedBeech 58 · Casper, WYNTSB DEN80FTC14Accident · No injuriesClosedPiper PA-18 · Hulett, WYNTSB DEN80FTC13Accident · Minor injuriesClosedCessna TU206G · Farson, WYNTSB DEN80FTC12Accident · Minor injuriesClosedHughes 369D · Chugwater, WYNTSB DEN80DTC10Accident · No injuriesClosedSwearingen SA26T · Jackson, WYNTSB DEN80DTC08Accident · No injuriesClosedLuscombe 8E · Cheyenne, WYNTSB DEN80FTC09Accident · No injuriesClosedCessna 172N · Rock Springs, WYNTSB DEN80FTC07Accident · No injuriesClosedCessna 152 · Lander, WYNTSB DEN80DTC06Accident · No injuriesClosedCessna 172N · Kemmerer, WYNTSB DEN80FTC05Accident · No injuriesClosedHiller Acft UH-12D · Mckennon, WY