NTSB investigations, 1977, 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\") = 1977
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") = 1977 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 DEN78FTC09Accident · No injuriesClosedCessna 150K · Gillette, WYNTSB DEN78DTC08Accident · No injuriesClosedCessna T210L · Thayne, WYNTSB DEN78FTC07Accident · No injuriesClosedCessna 185 · Casper, WYNTSB DEN78DTC06Accident · No injuriesClosedCessna 172 · Pinedale, WYNTSB DEN78DTC05Accident · No injuriesClosedHughes 269A · Rawlins, WYNTSB DEN78FTC04Accident · No injuriesClosedBellanca 17-31 · Lander, WYNTSB DEN78FA006Accident · 2 fatalClosedCessna 182P · Kemmerer, WYNTSB DEN78FTC03Accident · No injuriesClosedPiper PA-28 · Gillette, WYNTSB DEN78FTC02Accident · No injuriesClosedPiper PA-22 · Casper, WYNTSB DEN78DTC01Accident · No injuriesClosedCessna 185 · Hiland, WYNTSB DEN78FA003Accident · 2 fatalClosedMooney M20C · Sheridan, WYNTSB DEN77FTC32Accident · Serious injuriesClosedPiper PA-18 · Weston, WYNTSB DEN77FA060Accident · 2 fatalClosedBellanca 7GCBC · Tensleep, WYNTSB DEN77FTC31Accident · No injuriesClosedCessna 150M · Cheyenne, WYNTSB DEN77FTC30Accident · No injuriesClosedCessna 150 · Bill, WYNTSB DEN77IA057Incident · No injuriesClosedBeech 95-B55 · Cheyenne, WYNTSB DEN77DTC29Accident · Minor injuriesClosedCessna 140 · Cody, WYNTSB SEA77DYA35Accident · No injuriesClosedHughes 369D · Etna, WYNTSB DEN77DTC28Accident · No injuriesClosedCessna T210L · Keyhole, WYNTSB DEN77FTC27Accident · Minor injuriesClosedPiper PA-28 · Greybull, WYNTSB DEN77FTC25Accident · Minor injuriesClosedCessna 150 · Meeteetse, WYNTSB DEN77FTC23Accident · Minor injuriesClosedPiper PA16 · Douglas, WYNTSB DEN77FTC26Accident · No injuriesClosedLuscombe 8A · Gillette, WYNTSB DEN77DTC21Accident · Minor injuriesClosedAerospatial SA315B · Wilson, WYNTSB DEN77DTC22Accident · No injuriesClosedPiper PA-22 · Hulett, WYNTSB DEN77FTC19Accident · 2 fatalClosedDouglas DC-3A · Sheridan, WYNTSB DEN77FTC20Accident · No injuriesClosedCessna T210M · Cody, WYNTSB DEN77FTC18Accident · 1 fatalClosedLuscombe 8A · Walcott, WYNTSB DEN77FTC17Accident · No injuriesClosedCessna 210 · Cheyenne, WYNTSB DEN77FTC16Accident · No injuriesClosedLockheed B-34 · Torrington, WYNTSB DEN77FTC15Accident · Serious injuriesClosedAerospatial SA315B · Jackson, WYNTSB DEN77FA044Accident · 2 fatalClosedBeech 19A · Wheatland, WYNTSB DEN77FTC14Accident · Serious injuriesClosedPiper PA-28R · Thayne, WYNTSB DEN77FTC13Accident · Minor injuriesClosedCessna 172L · Jackson, WYNTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYNTSB DEN77FA040Accident · 4 fatalClosedBeech J35 · Lander, WYNTSB DEN77FTC12Accident · Minor injuriesClosedSudaviation SA315B · Laramie, WYNTSB DEN77DTC11Accident · No injuriesClosedBellanca 8GCBC · Elk Mountain, WYNTSB DEN77FTC10Accident · Serious injuriesClosedCessna T210L · Wamsutter, WYNTSB DEN77FA033Accident · 2 fatalClosedAeronca 7AC · Laramie, WYNTSB DEN77DTC09Accident · Minor injuriesClosedBell 206B · Laramie, WYNTSB DEN77DTC08Accident · No injuriesClosedCessna 172 · Cody, WYNTSB DEN77FA031Accident · 2 fatalClosedCessna 210L · Elk Mountain, WYNTSB DEN77DTC07Accident · No injuriesClosedStinson 108-2 · Laramie, WYNTSB DEN77DTC06Accident · No injuriesClosedStinson 108-2 · Rock Springs, WYNTSB DEN77FA028Accident · 1 fatalClosedCessna 414 · Farson, WYNTSB DEN77DTC05Accident · No injuriesClosedCessna U206 · Cheyenne, WYNTSB DEN77FA020Accident · No injuriesClosedHiller Acft FH1100 · Alpine, WY