Skip to content

NTSB investigations, WI

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 CHI77FEP60Accident · No injuriesClosedCessna 170 · Mosinee, WISep 5, 1977 · N2667V · Substantial damage NTSB CHI77FEP59Accident · Minor injuriesClosedBell 47J2A · Plymouth, WISep 5, 1977 · N6769D · Substantial damage NTSB CHI77DEP57Accident · No injuriesClosedCessna 150 · New Holstein, WIAug 27, 1977 · N704RP · Substantial damage NTSB CHI77FEP58Accident · No injuriesClosedBeech 95-A55 · Milwaukee, WIAug 25, 1977 · N200KL · Substantial damage NTSB CHI77FA069Accident · 4 fatalClosedCessna 170 · Florence, WIAug 23, 1977 · N4052V · Destroyed NTSB CHI77DEP56Accident · No injuriesClosedCessna 172M · Dodgeville, WIAug 21, 1977 · N5240R · Substantial damage NTSB CHI77DEP55Accident · Minor injuriesClosedChampion 7EC · Waukesha, WIAug 20, 1977 · N8569E · Substantial damage NTSB CHI77DEP51Accident · No injuriesClosedGR Lakes 2T-1A2 · Menomonee, WIAug 14, 1977 · N6018L · Substantial damage NTSB CHI77DEP50Accident · No injuriesClosedSchweizer 1-26B · West Bend, WIAug 14, 1977 · N2780Z · Substantial damage NTSB CHI77FEP53Accident · Serious injuriesClosedPietenpol GN1 · Wis.Rapids, WIAug 8, 1977 · N83951 · Substantial damage NTSB CHI77DEP54Accident · No injuriesClosedStarduster BR-2 · Pardeeville, WIAug 5, 1977 · N9BR · Substantial damage NTSB CHI77FA063Accident · 3 fatalClosedAero Comdr 720 · Wausau, WIAug 4, 1977 · N688R · Destroyed NTSB CHI77FEP49Accident · Serious injuriesClosedHughes 269B · Waupaca, WIAug 2, 1977 · N9448F · Substantial damage NTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WIAug 1, 1977 · N12204 · 2 aircraft · Destroyed NTSB CHI77FEP47Accident · Serious injuriesClosedCessna 172 · Lake Geneva, WIJul 31, 1977 · N7409A · Substantial damage NTSB CHI77EEP48Accident · 1 fatalClosedBellanca 14-13 · Prairie Du Chn, WIJul 30, 1977 · N86709 · Substantial damage NTSB CHI77DEP52Accident · No injuriesClosedBeech B-19 · Milwaukee, WIJul 30, 1977 · N1990L · Substantial damage NTSB CHI77DEP46Accident · No injuriesClosedGrum Amer AA1B · Waunakee, WIJul 25, 1977 · N9698L · Substantial damage NTSB CHI77FEP45Accident · No injuriesClosedBellanca 17-30A · Milwaukee, WIJul 18, 1977 · N39867 · Substantial damage NTSB CHI77DEP44Accident · No injuriesClosedCessna 182 · Burlington, WIJul 16, 1977 · N2683G · Substantial damage NTSB CHI77FER04Accident · 1 fatalClosedPiper PA-24 · Superior, WIJul 4, 1977 · N8898 · Substantial damage NTSB CHI77FEP42Accident · No injuriesClosedCessna 188B · Nekoosa, WIJul 4, 1977 · N4915Q · Substantial damage NTSB CHI77DEP40Accident · No injuriesClosedBellanca 7AC · Kaukauna, WIJun 26, 1977 · N85118 · Substantial damage NTSB CHI77FEP43Accident · No injuriesClosedMaule M4220C · Hayward, WIJun 25, 1977 · N7622E · Substantial damage NTSB CHI77FEP41Accident · No injuriesClosedSnow S2C · Nekoosa, WIJun 25, 1977 · N1670S · Substantial damage NTSB CHI77FEP38Accident · Minor injuriesClosedBeech A23 · Portage, WIJun 19, 1977 · N1479L · Substantial damage NTSB CHI77FEP39Accident · No injuriesClosedPiper PA-32 · Madison, WIJun 17, 1977 · N15635 · Substantial damage NTSB CHI77DEP35Accident · Serious injuriesClosedReplica BE-2C · Neenah, WIJun 14, 1977 · N1914B · Substantial damage NTSB CHI77FA049Accident · 4 fatalClosedPiper PA-24 · Grafton, WIJun 11, 1977 · N6349P · Destroyed NTSB CHI77FEP37Accident · No injuriesClosedCessna 172A · Sturgeon Bay, WIJun 7, 1977 · N9712T · Substantial damage NTSB CHI77DEP36Accident · Minor injuriesClosedPiper PA-32 · Clam Lake, WIJun 2, 1977 · N8383C · Substantial damage NTSB CHI77FA046Accident · 4 fatalClosedPiper PA-24 · Evansville, WIMay 27, 1977 · N9326P · Destroyed NTSB CHI77DEP34Accident · No injuriesClosedAeronca 7AC · Waunakee, WIMay 6, 1977 · N1162E · Substantial damage NTSB CHI77FEP33Accident · Minor injuriesClosedCessna 150 · Waukesha, WIApr 26, 1977 · N51392 · Substantial damage NTSB CHI77DEP32Accident · No injuriesClosedCessna 207 · Wausau, WIApr 15, 1977 · N1567U · Destroyed NTSB CHI77FA039Accident · 3 fatalClosedNa Rockwell 112 · Hudson, WIApr 10, 1977 · N1404J · Destroyed NTSB CHI77FEP30Accident · Serious injuriesClosedPiper PA-28 · Kansasville, WIApr 9, 1977 · N489FL · Destroyed NTSB CHI77DEP31Accident · No injuriesClosedCessna 150 · Berlin, WIApr 9, 1977 · N23448 · Destroyed NTSB CHI77DEP26Accident · No injuriesClosedCessna 182 · Kenosha, WIMar 29, 1977 · N1813X · Substantial damage NTSB CHI77DEP25Accident · No injuriesClosedCessna 172 · Janesville, WIMar 29, 1977 · N2JA · Substantial damage NTSB CHI77FEP28Accident · Serious injuriesClosedCessna 210D · Boscobel, WIMar 26, 1977 · N3924Y · Substantial damage NTSB CHI77FEP29Accident · Minor injuriesClosedCessna 172 · Janesville, WIMar 25, 1977 · N4352Q · Substantial damage NTSB CHI77DEP27Accident · No injuriesClosedPiper PA-28 · Waupun, WIMar 20, 1977 · N56140 · Substantial damage NTSB CHI77FEP24Accident · Minor injuriesClosedBeech C45H · Milwaukee, WIMar 18, 1977 · N9929Z · Destroyed NTSB CHI77DEP22Accident · No injuriesClosedCessna 150 · Pewaukee, WIMar 10, 1977 · N6120G · Substantial damage NTSB CHI77DEP20Accident · No injuriesClosedCessna 172 · Delavan, WIFeb 25, 1977 · N2113Y · Substantial damage NTSB CHI77DER03Accident · No injuriesClosedCessna 120 · Downsville, WIFeb 20, 1977 · N4276N · Substantial damage NTSB CHI77FEP19Accident · Minor injuriesClosedBeech K35 · Clintonville, WIFeb 19, 1977 · N9521R · Substantial damage NTSB CHI77FEP21Accident · No injuriesClosedCessna 150 · La Crosse, WIFeb 18, 1977 · N8098F · Substantial damage NTSB CHI77DEP17Accident · No injuriesClosedCessna 182F · Milwaukee, WIFeb 15, 1977 · N3578Y · Substantial damage