NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 CHI66F0475Accident · No injuriesClosedErcoupe 415-C · Stevens Pt, WINTSB CHI66F0521Accident · Serious injuriesClosedCessna 172D · Walworth, WINTSB CHI66F0497Accident · No injuriesClosedCulver LCA · Superior, WINTSB CHI66F0505Accident · Minor injuriesClosedTaylorcraft DCO-65 · Waupaca, WINTSB CHI66F0467Accident · No injuriesClosedPiper PA-24 · Eau Claire, WINTSB CHI66D0436Accident · Minor injuriesClosedStinson 108-3 · Portage, WINTSB CHI66F0480Accident · No injuriesClosedPiper PA-28 · Milwaukee, WINTSB CHI66A0038Accident · 2 fatalClosedCessna 310F · Minocqua, WINTSB CHI66A0033Accident · 1 fatalClosedBeech 35 · Delton, WINTSB CHI66D0463Accident · No injuriesClosedChampion 7FC · Coon Valley, WINTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WINTSB CHI66D0460Accident · No injuriesClosedPiper PA-28 · Cashton, WINTSB CHI66A0028Accident · 1 fatalClosedAeronca 7AC · Whitewater, WINTSB CHI66A0026Accident · No injuriesClosedDouglas DC-3 · Stevens Pt., WINTSB CHI66D0442Accident · No injuriesClosedCessna 210 · Delavan, WINTSB CHI66A0022Accident · 2 fatalClosedCessna 182 · Burlington, WINTSB CHI66F0178Accident · No injuriesClosedCessna 140 · Milwaukee, WINTSB CHI66D0493Accident · No injuriesClosedPiper PA-24 · Crivitz, WINTSB CHI66A0019Accident · 1 fatalClosedMooney M-20C · Beloit, WINTSB CHI66F0300Accident · Serious injuriesClosedNardi FN333 · Three Lakes, WINTSB CHI66D0362Accident · No injuriesClosedBeechcraft F35 · Seymour, WINTSB CHI66F0424Accident · Serious injuriesClosedPiper J-3 · De Pere, WINTSB CHI66D0411Accident · No injuriesClosedBeechcraft F35 · Baraboo, WINTSB CHI66F0216Accident · Minor injuriesClosedPiper PA-28 · Delavan, WINTSB CHI66F0168Accident · Serious injuriesClosedComonwealth 185 · Baraboo, WINTSB CHI66I0016Incident · No injuriesClosedBoeing B-720 · Milwaukee, WINTSB CHI66F0423Accident · No injuriesClosedCessna 310B · Milwaukee, WINTSB CHI66A0015Accident · 4 fatalClosedBeech B35 · Boulder Jct, WINTSB CHI66A0011Accident · 1 fatalClosedAircoupe A-2 · Langlade, WINTSB CHI65D0151Accident · No injuriesClosedBeechcraft H35 · Madison, WINTSB CHI66F0189Accident · No injuriesClosedBeechcraft A-35 · Green Bay, WINTSB CHI66F0152Accident · Minor injuriesClosedStinson 108-2 · Beaver Dam, WINTSB CHI66A0009Accident · 1 fatalClosedCessna 150C · Wausau, WINTSB CHI66F0170Accident · No injuriesClosedCessna 195 · Oshkosh, WINTSB CHI66F0428Accident · Minor injuriesClosedFairchild M-62A3 · Pulaski, WINTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WINTSB CHI66F0166Accident · No injuriesClosedStinson 108 · Lac Duflambeu, WINTSB CHI66F0364Accident · No injuriesClosedPiper PA-12 · Dallas, WINTSB CHI66A0002Accident · 1 fatalClosedPiper PA-16 · Lake Delton, WINTSB CHI66A0001Accident · 2 fatalClosedTaylorcraft BC-12D · Mineral Point, WINTSB CHI66F0047Accident · Minor injuriesClosedNo American SNJ-5 · Hales Corner, WINTSB CHI66F0141Accident · Serious injuriesClosedComonwealth 7000 · Sparta, WINTSB CHI66F0471Accident · No injuriesClosedBeechcraft H35 · Delavan, WINTSB CHI66F0113Accident · Minor injuriesClosedStinson 108-2 · Kenosha, WINTSB CHI66D0348Accident · No injuriesClosedPiper PA-24 · Wausau, WINTSB CHI66F0163Accident · No injuriesClosedNavion B · Portage, WINTSB CHI66F0142Accident · No injuriesClosedLuscombe 8F · Milwaukee, WINTSB CHI66D0162Accident · No injuriesClosedPiper PA-22 · Lake Geneva, WINTSB CHI65A0106Accident · No injuriesClosedHughes 269B · Gile, WINTSB CHI66D0112Accident · No injuriesClosedAeronca 15AC · Wisconsin Dls, WI