NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1199Accident · No injuriesClosedCessna 180 · Rice Lake, WINTSB UNK65X1132Accident · No injuriesClosedPiper PA23 · Abbotsford, WINTSB UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WINTSB UNK65X1053Accident · No injuriesClosedPiper PA22 · Marshfield, WINTSB UNK65X0725Accident · No injuriesClosedCessna 140 · Depere, WINTSB UNK65X0460Accident · No injuriesClosedBeech 35 · Stoughton, WINTSB UNK65X0438Accident · Serious injuriesClosedAeronca 11AC · Boscobel, WINTSB UNK65X0242Accident · No injuriesClosedCessna 140 · Palmyra, WINTSB UNK65X0195Accident · No injuriesClosedPiper PA24 · Ladysmith, WINTSB UNK64X3963Accident · No injuriesClosedLuscombe 8A · Wis Rapids, WINTSB UNK64X3953Accident · 1 fatalClosedLuscombe 8C · Marquette, WINTSB UNK64X3935Accident · No injuriesClosedCessna 182 · Eau Claire, WINTSB UNK64X3904Accident · No injuriesClosedCessna 172 · Danbury, WINTSB UNK64X3864Accident · 2 fatalClosedStinson 108-2 · Wis Rapids, WINTSB UNK64X3808Accident · Serious injuriesClosedPiper J-3 · Muskego, WINTSB UNK64X3711Accident · No injuriesClosedCessna 172 · Delavan, WINTSB UNK64X3499Accident · No injuriesClosedDouglas A-26B · Madison, WINTSB UNK64X3494Accident · No injuriesClosedBoeing A75N1 · Delavan, WINTSB UNK64X3423Accident · Minor injuriesClosedCessna 140 · Waukesea, WINTSB UNK64X3382Accident · No injuriesClosedCessna 172 · Ft Atkinson, WINTSB UNK64X3381Accident · No injuriesClosedBeechcraft M23 · Luck, WINTSB UNK64X3348AccidentClosedChampion 7FC · Coloma, WINTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WINTSB UNK64X3185Accident · No injuriesClosedHughes 269A · Oconomowoc Lk, WINTSB UNK64X3067Accident · Minor injuriesClosedPiper PA22 · Lake Geneva, WINTSB UNK64X3060Accident · 2 fatalClosedTaylorcraft BC12-D · Tomahawk, WINTSB UNK64X2963Accident · No injuriesClosedCessna 140 · Wabeno, WINTSB UNK64X2960Accident · No injuriesClosedCessna 172B · Middletown, WINTSB UNK64X2946Accident · No injuriesClosedPiper PA24 · Eagle River, WINTSB UNK64X2892Accident · No injuriesClosedBellanca 14132 · Hales Corners, WINTSB UNK64X2827Accident · No injuriesClosedTaylorcraft BC12 · Janesville, WINTSB UNK64X2794Accident · No injuriesClosedErcoupe 415CD · Watertown, WINTSB UNK64X2764Accident · Minor injuriesClosedPiper PA22 · Mukwonago, WINTSB UNK64X2738Accident · No injuriesClosedBeechcraft C35 · Sheboygan, WINTSB UNK64X2643Accident · No injuriesClosedMooney MK20D · Monroe Center, WINTSB UNK64X2610Accident · Serious injuriesClosedPiper PA18A · Waupun, WINTSB UNK64X2549Accident · No injuriesClosedLuscombe 8A · Cushing, WINTSB UNK64X2369Accident · No injuriesClosedBeechcraft 35 · Rhinderlander, WINTSB UNK64X2280Accident · Minor injuriesClosedBeechcraft D35 · West Bend, WINTSB UNK64X2180Accident · Minor injuriesClosedBell 47G2A · Montello, WINTSB UNK64X2173Accident · Minor injuriesClosedStinson 108-3 · Solon Springs, WINTSB UNK64X2101Accident · No injuriesClosedBeechcraft H35 · Milwaukee, WINTSB UNK64X2058Accident · Minor injuriesClosedAeronca 7AC · Appleton, WINTSB UNK64X2050Accident · Minor injuriesClosedErcoupe 415C · Mukwonago, WINTSB UNK64X2029Accident · No injuriesClosedPiper PA12 · Withee, WINTSB UNK64X2005Accident · Minor injuriesClosedPiper PA18 · Sturtevant, WINTSB UNK64X1972Accident · No injuriesClosedBeechcraft S35 · Milwaukee, WINTSB UNK64X1917Accident · No injuriesClosedCessna 310 · Milwaukee, WINTSB UNK64X1913Accident · Minor injuriesClosedChampion 7EC · Birchwood, WINTSB UNK64X1850Accident · No injuriesClosedBeechcraft 35-33 · La Crosse, WI