NTSB investigations, 1980, WI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 70 |
|---|---|
| 1965 | 75 |
| 1966 | 88 |
| 1967 | 99 |
| 1968 | 81 |
| 1969 | 93 |
| 1970 | 87 |
| 1971 | 65 |
| 1972 | 74 |
| 1973 | 77 |
| 1974 | 81 |
| 1975 | 69 |
| 1976 | 55 |
| 1977 | 75 |
| 1978 | 90 |
| 1979 | 89 |
| 1980 | 62 |
| 1981 | 69 |
| 1982 | 54 |
| 1983 | 60 |
| 1984 | 64 |
| 1985 | 59 |
| 1986 | 55 |
| 1987 | 48 |
| 1988 | 47 |
| 1989 | 56 |
| 1990 | 47 |
| 1991 | 46 |
| 1992 | 39 |
| 1993 | 55 |
| 1994 | 41 |
| 1995 | 41 |
| 1996 | 35 |
| 1997 | 33 |
| 1998 | 44 |
| 1999 | 44 |
| 2000 | 34 |
| 2001 | 46 |
| 2002 | 37 |
| 2003 | 32 |
| 2004 | 37 |
| 2005 | 38 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 40 |
| 2009 | 23 |
| 2010 | 26 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 18 |
| 2014 | 22 |
| 2015 | 30 |
| 2016 | 28 |
| 2017 | 25 |
| 2018 | 26 |
| 2019 | 19 |
| 2020 | 14 |
| 2021 | 25 |
| 2022 | 23 |
| 2023 | 25 |
| 2024 | 24 |
| 2025 | 24 |
| 2026 | 20 |
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\" = 'WI' 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" = 'WI' 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 CHI81FEP06Accident · No injuriesClosedCessna U206G · Kenosha, WINTSB CHI81FA014Accident · 2 fatalClosedBeech G35 · Harding, WINTSB CHI81FEP07Accident · No injuriesClosedCessna 150L · Spencer, WINTSB CHI81FA005Accident · 1 fatalClosedCessna 172 · Westfield, WINTSB CHI81FEP05Accident · No injuriesClosedCessna 150L · Rhinelander, WINTSB CHI81DEP04Accident · No injuriesClosedPiper PA-28 · Cottage Grove, WINTSB CHI81DEP03Accident · Serious injuriesClosedCessna 150F · Elkhorn, WINTSB CHI81DEP02Accident · No injuriesClosedCessna 172N · Phillips, WINTSB CHI81FEP01Accident · No injuriesClosedPiper PA-28 · Lakewood, WINTSB CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WINTSB CHI80FEP56Accident · Serious injuriesClosedPitts S-1S · Burlington, WINTSB CHI80DER68Accident · No injuriesClosedCessna 150 · Osceola, WINTSB CHI80DEP57Accident · No injuriesClosedCessna 170A · Iola, WINTSB CHI80DEP59Accident · No injuriesClosedGrum-Amer AA-1B · Wilmot, WINTSB CHI80FEP55Accident · 1 fatalClosedBensen B-8M · Franksville, WINTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WINTSB CHI80FEP53Accident · Serious injuriesClosedBell 206 · Grafton, WINTSB CHI80FEP52Accident · No injuriesClosedCessna 180 · Bevent, WINTSB CHI80FEP60Accident · No injuriesClosedPiper PA-28 · Cornucopia, WINTSB CHI80FA066Accident · 1 fatalClosedPiper PA-28 · Antigo, WINTSB CHI80FEP49Accident · Minor injuriesClosedVarga 2150A · Fort Atkinson, WINTSB CHI80FEP51Accident · Serious injuriesClosedPitts S-1C · Fond Du Lac, WINTSB CHI80DEP47Accident · No injuriesClosedPiper PA-28 · Chippewa Falls, WINTSB CHI80FEP48Accident · No injuriesClosedBeech A23-19 · Winneconne, WINTSB CHI80DEP50Accident · No injuriesClosedPiper PA-32 · Dodgeville, WINTSB CHI80FEP44Accident · Minor injuriesClosedPiper PA-28 · Collins, WINTSB CHI80FEP43Accident · No injuriesClosedPiper PA-28R · Green Bay, WINTSB CHI80DEP42Accident · No injuriesClosedSikorsky CH-19E · Plover, WINTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WINTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WINTSB CHI80DEP41Accident · No injuriesClosedBlanik L-13 · Middleton, WINTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WINTSB CHI80FEP38Accident · Minor injuriesClosedCessna 177RG · New Lisbon, WINTSB CHI80FEP39Accident · No injuriesClosedCessna 182K · Wilmot, WINTSB CHI80DEP36Accident · No injuriesClosedBell 47G-3B · Plainfield, WINTSB CHI80DEP35Accident · No injuriesClosedCessna 172D · Delavan, WINTSB CHI80FER45Accident · No injuriesClosedBeech 23 · Deerpark, WINTSB CHI80DEP34Accident · No injuriesClosedCessna 152 · Watertown, WINTSB CHI80FEP31Accident · Serious injuriesClosedTomcat MARK5A · Stockbridge, WINTSB CHI80FA042Accident · 2 fatalClosedGrum-Amer AA-1C · Portage, WINTSB CHI80DEP32Accident · No injuriesClosedStearman A75-N1 · City Point, WINTSB CHI80FEP29Accident · No injuriesClosedCassutt 111M · Stevens Pt, WINTSB CHI80DEP33Accident · No injuriesClosedPiper PA-28 · Bristol, WINTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WINTSB CHI80DEP37Accident · No injuriesClosedCessna 152 · Platteville, WINTSB CHI80DEP28Accident · No injuriesClosedCessna 152 · Tilden, WINTSB CHI80DEP27Accident · Minor injuriesClosedBensen B-8M · Manitowoc, WINTSB CHI80DEP26Accident · Serious injuriesClosedCessna 172F · Stone Lake, WINTSB CHI80DEP23Accident · No injuriesClosedPiper PA-12 · Mount Vernon, WINTSB CHI80DEP24Accident · No injuriesClosedCessna 172K · Waunakee, WI