NTSB investigations, 1973, WY
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1973
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") = 1973 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 DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYNTSB DEN74FTC22Accident · Minor injuriesClosedPiper PA-28 · Casper, WYNTSB DEN74AD028Accident · 3 fatalClosedCessna 182 · Cokeville, WYNTSB DEN74DTC21Accident · No injuriesClosedMaule M4220C · Gillette, WYNTSB DEN74DTC20Accident · No injuriesClosedPiper PA-25 · Upton, WYNTSB DEN74AD018Accident · 2 fatalClosedPiper PA-18 · Lusk, WYNTSB DEN74FTC18Accident · No injuriesClosedPiper PA-20 · Cheyenne, WYNTSB DEN74DTC19Accident · No injuriesClosedPiper PA-28 · Rock Springs, WYNTSB DEN74AD016Accident · 2 fatalClosedBellanca 14-193 · Arlington, WYNTSB DEN74FTC15Accident · No injuriesClosedBeech 65-A90 · Casper, WYNTSB DEN74DTC17Accident · No injuriesClosedPiper PA-24 · Wheatland, WYNTSB DEN74DTC13Accident · No injuriesClosedPiper PA-18 · Wheatland, WYNTSB DEN74FTC12Accident · No injuriesClosedCessna 310 · Cokeville, WYNTSB DEN74FTC11Accident · Minor injuriesClosedCessna 411 · Farson, WYNTSB DEN74AD011Accident · 1 fatalClosedCessna 195 · Worland, WYNTSB DEN74DTC10Accident · Minor injuriesClosedPiper PA-18 · Rocky Point, WYNTSB DEN74DTC09Accident · No injuriesClosedPiper PA-28 · Laramie, WYNTSB DEN74FTC14Accident · No injuriesClosedCessna 310P · Rock Springs, WYNTSB DEN74DTC08Accident · No injuriesClosedCessna 210 · Greybull, WYNTSB DEN74DTC07Incident · No injuriesClosedTaylorcraft DC12D · Evanston, WYNTSB DEN74FTC06Accident · Serious injuriesClosedPiper PA-32 · Savery, WYNTSB DEN74AD005Accident · 1 fatalClosedPiper PA-18 · Sheridan, WYNTSB DEN74FTC05Accident · Minor injuriesClosedAeronca 7BCM · Rock Springs, WYNTSB DEN74DTC04Accident · No injuriesClosedChampion 7GCBC · Colony, WYNTSB DEN74FTC02Accident · No injuriesClosedBeech D18S · Encampment, WYNTSB DEN74DTC01Accident · Minor injuriesClosedCessna T210 · Pinedale, WYNTSB DEN73FTC29Accident · Serious injuriesClosedSnow S2C · Sheridan, WYNTSB DEN74DTC03Accident · No injuriesClosedPiper PA-18 · Lovell, WYNTSB DEN73FTC27Accident · No injuriesClosedCessna 180 · Kemmerer, WYNTSB DEN73FTC28Accident · No injuriesClosedHughes 269A · Baggs, WYNTSB DEN73AD053Accident · 1 fatalClosedBerkshire C-70 · Burns, WYNTSB DEN73DTC26Accident · No injuriesClosedHelio H-395 · Jackson, WYNTSB DEN73DTC25Accident · No injuriesClosedCessna T210J · Riverton, WYNTSB DEN73DTC24Accident · No injuriesClosedBellanca 7GCBC · Rock River, WYNTSB DEN73DTC23Accident · No injuriesClosedPiper PA-18 · Buffalo, WYNTSB DEN73AD046Accident · 3 fatalClosedPiper PA-24 · Laramie, WYNTSB DEN73AD045Accident · 2 fatalClosedCessna 210 · Farson, WYNTSB DEN73FTC21Accident · Minor injuriesClosedPiper PA-18A · Bosler, WYNTSB DEN73DTC22Accident · No injuriesClosedCessna 180A · Glendo, WYNTSB DEN73DTC20Accident · No injuriesClosedPiper PA-28R · Laramie, WYNTSB DEN73FTC19Accident · No injuriesClosedHughes 269A · Hanna, WYNTSB DEN73AD038Accident · 4 fatalClosedMooney M20F · Saratoga, WYNTSB DEN73FTC18Accident · Minor injuriesClosedPiper PA-28 · Cheyenne, WYNTSB DEN73DTC17Accident · No injuriesClosedCessna 180 · Gillette, WYNTSB DEN73DTC16Accident · No injuriesClosedMooney M20F · Sheridan, WY