NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 CHI77FEP12Accident · Serious injuriesClosedPiper PA-30A · Madison, WINTSB CHI77FEP13Accident · No injuriesClosedPiper PA-28 · Cable, WINTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WINTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WINTSB CHI77FEP10Accident · Serious injuriesClosedBeech C55 · Eau Claire, WINTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WINTSB CHI77FEP09Accident · No injuriesClosedCessna 310 · Janesville, WINTSB CHI77FEP07Accident · No injuriesClosedPiper PA-32R · Ashippun, WINTSB CHI77FEP08Accident · No injuriesClosedStinson 108-1 · Burlington, WINTSB CHI77FEP06Accident · No injuriesClosedBeech V35R · Cottage Grove, WINTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINTSB CHI77DEP03Accident · Minor injuriesClosedCessna 172 · Middleton, WINTSB CHI77FEP02Accident · No injuriesClosedCessna 210T · Eau Claire, WINTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WINTSB CHI77DEP01Accident · No injuriesClosedMooney M20 · Franklin, WINTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WINTSB CHI76DEP50Accident · No injuriesClosedPiper PA-28 · Ladysmith, WINTSB CHI76DEP48Accident · No injuriesClosedCessna 210 · Big Falls, WINTSB CHI76AC089Accident · 2 fatalClosedCessna 150L · Stevens Point, WINTSB CHI76DEP49Accident · No injuriesClosedBeech B24R · Walworth, WINTSB CHI76DEP47Accident · Minor injuriesClosedBellanca 8GCBC · West Bend, WINTSB CHI76FEP45Accident · Serious injuriesClosedCessna 210 · Hales Corner, WINTSB CHI76DEP46Accident · Serious injuriesClosedCessna 172 · Dodgeville, WINTSB CHI76DEP44Accident · No injuriesClosedPiper PA-24 · La Crosse, WINTSB CHI76AC086Accident · 2 fatalClosedCessna 207 · East Troy, WINTSB CHI76FEP43Accident · No injuriesClosedPiper PA-28R · Withee, WINTSB CHI76FEP42Accident · Minor injuriesClosedMooney M20E · Grafton, WINTSB CHI76AC085Accident · 1 fatalClosedPiper PA-18 · Tomahawk, WINTSB CHI76AC083Accident · 1 fatalClosedPiper PA-28R · Oshkosh, WINTSB CHI77DEP04Accident · No injuriesClosedCessna 310B · Bristol, WINTSB CHI76FEP38Accident · Minor injuriesClosedHughes 269A · Abbotsford, WINTSB CHI76FEP39Accident · Minor injuriesClosedPiper PA-28 · Sturtevant, WINTSB CHI76DEP41Accident · No injuriesClosedBoeing A75N1 · Hartford, WINTSB CHI76FEP40Accident · No injuriesClosedCessna 180J · Rhinelander, WINTSB CHI76FEP37Accident · No injuriesClosedSnow 600S2C · Plainfield, WINTSB CHI76FEP35Accident · Serious injuriesClosedCessna 210 · Schofield, WINTSB CHI76DEP36Accident · No injuriesClosedPiper PA-28 · Ojibwa, WINTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WINTSB CHI76FEP33Accident · No injuriesClosedCessna 180A · Milwaukee, WINTSB CHI76FEP31Accident · Serious injuriesClosedLuscombe 8A · West Bend, WINTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WINTSB CHI76AC059Accident · 1 fatalClosedBoeing A75N1 · Lake Geneva, WINTSB CHI76FEP29Accident · Minor injuriesClosedCessna 182K · Lake Geneva, WINTSB CHI76FEP28Accident · No injuriesClosedPiper PA-28R · Pulaski, WINTSB CHI76DEP27Accident · No injuriesClosedCessna 170A · Hartford, WINTSB CHI76AC052Accident · 1 fatalClosedBeech E18S · Burlington, WINTSB CHI76DER07Accident · No injuriesClosedCessna 150 · Amery, WINTSB CHI76DEP26Accident · No injuriesClosedPiper PA-18 · Milwaukee, WINTSB CHI76AC050Accident · 1 fatalClosedPiper PA-32 · Cable, WINTSB CHI76DEP24Accident · No injuriesClosedPiper PA-20 · Baraboo, WI