Skip to content

NTSB investigations, WI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI75FEP62Accident · Serious injuriesClosedSchweizer SGS2 · West Bend, WIMay 31, 1975 · N1204S · Substantial damage NTSB CHI75FEP60Accident · No injuriesClosedCessna 150L · Milwaukee, WIMay 31, 1975 · N1254Q · Substantial damage NTSB CHI75FEP55Accident · No injuriesClosedN.American Navion · Shawano, WIMay 26, 1975 · N6724C · Substantial damage NTSB CHI75DEP59Accident · No injuriesClosedGlobe GC-1B · Milwaukee, WIMay 25, 1975 · N80923 · Substantial damage NTSB CHI75FEP57Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIMay 24, 1975 · N43041 · Substantial damage NTSB CHI75DEP56Accident · No injuriesClosedCessna 140 · Reedsville, WIMay 21, 1975 · N1893V · Destroyed NTSB CHI75FEP54Accident · Minor injuriesClosedFlaglor-Hag H-1 · Merrill, WIMay 18, 1975 · N3518 · Substantial damage NTSB CHI75FEP53Accident · Minor injuriesClosedFairchild 24W-41 · Union Grove, WIMay 18, 1975 · N28504 · Substantial damage NTSB CHI75DEP61Accident · No injuriesClosedCessna 414 · Janesville, WIMay 17, 1975 · N33DS · Substantial damage NTSB CHI75DEP63Accident · No injuriesClosedCessna 150H · Middleton, WIMay 13, 1975 · N50006 · Substantial damage NTSB CHI75DEP58Accident · No injuriesClosedCessna 182 · Milwaukee, WIMay 10, 1975 · N42871 · Substantial damage NTSB CHI75AC086Accident · No injuriesClosedPiper PA-16 · Janesville, WIMay 10, 1975 · N5382H · 2 aircraft · Minor damage NTSB CHI75FEP52Accident · Serious injuriesClosedWeber W8 · Shullsburg, WIMay 4, 1975 · NONE · Destroyed NTSB CHI75FEP51Accident · No injuriesClosedPiper PA-25 · Monroe, WIApr 29, 1975 · N7645Z · Substantial damage NTSB CHI75DEP49Accident · No injuriesClosedStinson 108-3 · Sturtevant, WIApr 10, 1975 · N508C · Substantial damage NTSB CHI75DER06Accident · No injuriesClosedCessna 180 · River Falls, WIMar 28, 1975 · N9121C · Substantial damage NTSB CHI75AC069Accident · 3 fatalClosedBeech A24R · Beaver, WIMar 21, 1975 · N9707Q · Destroyed NTSB CHI75EEP50Accident · No injuriesClosedErco 415-C · Oconto, WIMar 16, 1975 · N99836 · Substantial damage NTSB CHI75DEP47Accident · No injuriesClosedMaule M4220C · Waupaca, WIMar 14, 1975 · N9874M · Substantial damage NTSB CHI75FEP46Accident · Serious injuriesClosedPiper PA-28 · Wisconsin Rpds, WIMar 13, 1975 · N16455 · Substantial damage NTSB CHI75DEP48Accident · No injuriesClosedLuscombe 8A · Hales Corners, WIMar 13, 1975 · N2704K · Substantial damage NTSB CHI75AC073Accident · Serious injuriesClosedDouglas DC-10 · Lacrosse, WIMar 13, 1975 · N149US · No damage NTSB CHI75FEP43Accident · No injuriesClosedBeech V35 · Janesville, WIMar 5, 1975 · N9517Q · Substantial damage NTSB CHI75FEP42Accident · Serious injuriesClosedCessna 337A · Kenosha, WIMar 5, 1975 · N5358S · Substantial damage NTSB CHI75AC061Accident · 2 fatalClosedBeech 95 · Waterford, WIMar 5, 1975 · N2061C · Destroyed NTSB CHI75AC060Accident · No injuriesClosedBeech G18S · Oshkosh, WIMar 4, 1975 · N188X · Substantial damage NTSB CHI75FEP41Accident · No injuriesClosedStinson 108-2 · Dodgeville, WIMar 2, 1975 · N9401K · Substantial damage NTSB NYC75DEP45Accident · No injuriesClosedPiper PA-32 · Lake Geneva, WIMar 1, 1975 · N8502N · Substantial damage NTSB CHI75DER05Accident · Minor injuriesClosedCessna 182C · Superior, WIFeb 23, 1975 · N8778T · Substantial damage NTSB CHI75AC054Accident · 1 fatalClosedBeech V35BTC · Waukesha, WIJan 22, 1975 · N580A · Destroyed NTSB CHI75FEP37Accident · No injuriesClosedAeronca 11AC · Waupaca, WIJan 2, 1975 · N9428E · Substantial damage NTSB CHI75FEP36Accident · No injuriesClosedCessna 170B · Waukesha, WIDec 28, 1974 · N3120B · Substantial damage NTSB CHI75DEP38Accident · No injuriesClosedCessna 150H · Wilmot, WIDec 24, 1974 · N50169 · Substantial damage NTSB CHI75DEP39Accident · No injuriesClosedBeech 95-B55 · Milwaukee, WIDec 19, 1974 · N7981K · Substantial damage NTSB CHI75DEP34Accident · No injuriesClosedBeech A23-19 · Delavan, WINov 28, 1974 · N6971Q · Substantial damage NTSB CHI75DEP35Accident · No injuriesClosedCessna 172F · Crandon, WINov 27, 1974 · N5583R · Substantial damage NTSB CHI75AC040Accident · No injuriesClosedPiper J3C-65 · Pickett, WINov 9, 1974 · N26046 · No damage NTSB CHI75DEP32Accident · No injuriesClosedCessna 175 · Brooklyn, WINov 3, 1974 · N1100S · Substantial damage NTSB CHI75FEP33Accident · 2 fatalClosedCessna 150L · Slinger, WIOct 30, 1974 · N10430 · Destroyed NTSB CHI75FEP31Accident · Serious injuriesClosedCessna 182P · Racine, WIOct 28, 1974 · N21534 · Substantial damage NTSB CHI75AC036Accident · 1 fatalClosedBellanca 17-30A · Lakewood, WIOct 24, 1974 · N14746 · Destroyed NTSB CHI75FEP28Accident · Serious injuriesClosedPiper PA-23 · Wautoma, WIOct 20, 1974 · N1450P · Substantial damage NTSB CHI75DEP30Accident · No injuriesClosedCessna 172L · Crivitz, WIOct 13, 1974 · N19644 · Substantial damage NTSB CHI75DEP27Accident · No injuriesClosedMaule M4220C · Eagle River, WIOct 8, 1974 · N51436 · Substantial damage NTSB CHI75FEP25Accident · No injuriesClosedStinson V-77 · Belleville, WISep 28, 1974 · N69856 · Substantial damage NTSB CHI75FEP29Accident · Serious injuriesClosedPiper PA-30 · Chippewa Fls, WISep 21, 1974 · N8753Y · Destroyed NTSB CHI75DEP26Accident · Minor injuriesClosedStinson 108-3 · Kenosha, WISep 21, 1974 · N899C · Substantial damage NTSB CHI75FEP23Accident · Serious injuriesClosedCessna 150E · Milwaukee, WISep 14, 1974 · N4069U · Substantial damage NTSB CHI75FEP22Accident · 1 fatalClosedCessna 182H · West Bend, WISep 13, 1974 · N8533S · Substantial damage NTSB CHI75DEP24Accident · No injuriesClosedBoeing A75 · Lone Rock, WISep 8, 1974 · N55898 · Substantial damage