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 CHI71IC024Incident · No injuriesClosedBoeing 727 · Milwaukee, WIOct 1, 1970 · N7424U · No damage NTSB CHI71DDJ18Accident · No injuriesClosedCessna 210 · Eleva, WISep 25, 1970 · N7484E · Substantial damage NTSB CHI71DDJ26Accident · No injuriesClosedStinson V-77 · Neenah, WISep 22, 1970 · N69856 · Substantial damage NTSB CHI72DDJ17Accident · Minor injuriesClosedStinson 108-3 · Bruce, WISep 20, 1970 · N960C · Substantial damage NTSB CHI71AC020Accident · No injuriesClosedBeech E18S · Lyndon Sta, WISep 15, 1970 · N387W · Substantial damage NTSB CHI71DDJ16Accident · No injuriesClosedCessna 177 · Black Rvr Fls, WISep 12, 1970 · N2870X · Substantial damage NTSB CHI71FDJ15Accident · No injuriesClosedCessna 150 · East Troy, WISep 9, 1970 · N7900E · Substantial damage NTSB CHI71DDJ12Accident · Serious injuriesClosedBeech C-45H · Lakewood, WISep 7, 1970 · N9961Z · Destroyed NTSB CHI71AC018Accident · 4 fatalClosedBeech J35 · Plain, WISep 6, 1970 · N622T · Destroyed NTSB CHI71DDJ14Accident · No injuriesClosedPiper PA-28 · Delavan, WISep 5, 1970 · N7864N · Substantial damage NTSB CHI71FDM03Accident · No injuriesClosedBeech A35 · L.Nebagamon, WIAug 25, 1970 · N8509A · Substantial damage NTSB CHI71DDJ11Accident · No injuriesClosedBell 47D1 · Manitowish, WIAug 21, 1970 · N4252A · Substantial damage NTSB CHI71FDJ13Accident · No injuriesClosedLuscombe 8E · Cottage Grove, WIAug 19, 1970 · N39028 · Substantial damage NTSB CHI71FDJ10Accident · No injuriesClosedCessna 172C · Madison, WIAug 12, 1970 · N1582Y · Substantial damage NTSB CHI71AC012Accident · Serious injuriesClosedCessna 402 · Watertown, WIAug 8, 1970 · N8139F · Destroyed NTSB CHI71FDJ09Accident · No injuriesClosedHughes 269B · Green Bay, WIAug 5, 1970 · N9308F · Destroyed NTSB CHI71FDJ06Accident · Minor injuriesClosedGlobe GC-1B · Franklin, WIAug 2, 1970 · N11HR · Substantial damage NTSB CHI71AC010Accident · No injuriesClosedBeech 95-A55 · Green Bay, WIJul 28, 1970 · N9618Y · Substantial damage NTSB CHI71FDJ08Accident · Serious injuriesClosedTaylorcraft BC12-D · Land O Lakes, WIJul 25, 1970 · N43009 · Substantial damage NTSB CHI71FDJ07Accident · Serious injuriesClosedBeech E18S · Delavan, WIJul 25, 1970 · N3333C · Destroyed NTSB CHI71DDM01Accident · No injuriesClosedCessna 150C · River Falls, WIJul 23, 1970 · N1907Z · Substantial damage NTSB CHI71FDJ05Accident · Minor injuriesClosedPiper PA-28 · Green Bay, WIJul 21, 1970 · N6667J · Substantial damage NTSB CHI71FDM02Accident · No injuriesClosedCessna 172G · Mondovi, WIJul 20, 1970 · N3616L · Substantial damage NTSB CHI71AC003Accident · 4 fatalClosedCessna 177 · Wild Rose, WIJul 12, 1970 · N2277Y · Destroyed NTSB CHI71FDJ03Accident · Minor injuriesClosedBeech C-18 · Waukesha, WIJul 10, 1970 · N2391C · Substantial damage NTSB CHI71DDJ04Accident · No injuriesClosedCessna 150 · Platteville, WIJul 10, 1970 · N3679J · Substantial damage NTSB CHI71DDJ02Accident · Minor injuriesClosedCessna 180F · Friendship, WIJul 3, 1970 · N2157Z · Substantial damage NTSB CHI71FDJ01Accident · Serious injuriesClosedMooney M20C · Union Grove, WIJul 2, 1970 · N9384V · Destroyed NTSB CHI70DDJ29Accident · No injuriesClosedBeech 19A · Appleton, WIJun 29, 1970 · N6973Q · Substantial damage NTSB CHI70DDJ26Accident · No injuriesClosedCessna 180 · Lone Rock, WIJun 28, 1970 · N4930A · Substantial damage NTSB CHI70FDJ27Accident · No injuriesClosedCessna 140 · Lyndon Stn, WIJun 27, 1970 · N89231 · Substantial damage NTSB CHI70FDM08Accident · Minor injuriesClosedAeronca 11CC · Cumberland, WIJun 23, 1970 · N4121E · Substantial damage NTSB CHI70DDJ25Accident · No injuriesClosedCessna 182 · Milwaukee, WIJun 23, 1970 · N9958B · Substantial damage NTSB CHI70AC091Accident · No injuriesClosedCessna 150G · Burlington, WIJun 18, 1970 · N2213J · 2 aircraft · Minor damage NTSB CHI70FDM07Accident · No injuriesClosedPiper PA-28 · Minong, WIJun 17, 1970 · N8659W · Substantial damage NTSB CHI70FDJ24Accident · No injuriesClosedPiper PA-28 · Watertown, WIJun 17, 1970 · N6531J · Substantial damage NTSB CHI70DDJ28Accident · No injuriesClosedLuscombe 8E · Wayside, WIJun 16, 1970 · N2438K · Substantial damage NTSB CHI70FDJ23Accident · Serious injuriesClosedChampion 7ECA · Appleton, WIJun 13, 1970 · N11054 · Substantial damage NTSB CHI70FDJ30Accident · No injuriesClosedCessna 172 · Baileys Harbr, WIJun 11, 1970 · N8337L · Substantial damage NTSB CHI70DDM05Accident · Minor injuriesClosedCessna 150 · Baldwin, WIJun 7, 1970 · N8843S · Substantial damage NTSB CHI70DDJ22Accident · No injuriesClosedPiper PA-28R · Washington Is, WIJun 6, 1970 · N3057R · Substantial damage NTSB CHI70DDM06Accident · No injuriesClosedCessna 177 · Superior, WIJun 4, 1970 · N3134T · Substantial damage NTSB CHI70FDJ21Accident · No injuriesClosedPiper PA-22 · Mount Horeb, WIJun 3, 1970 · N8129D · Substantial damage NTSB CHI70FDM03Accident · Minor injuriesClosedChampion 7ECA · Webster, WIMay 30, 1970 · N11031 · Substantial damage NTSB CHI70FDJ20Accident · No injuriesClosedTailwind ACB-2 · Milwaukee, WIMay 26, 1970 · N55Y · Substantial damage NTSB CHI70AC082Accident · 3 fatalClosedNavion A · Evansville, WIMay 23, 1970 · N5105K · Destroyed NTSB CHI70FDJ19Accident · No injuriesClosedCessna 180 · Hatley, WIMay 22, 1970 · N181WS · Substantial damage NTSB CHI70DDJ18Accident · No injuriesClosedCessna 150H · Dodgeville, WIMay 21, 1970 · N6620S · Substantial damage NTSB CHI70AC080Accident · 1 fatalClosedTaylorcraft BC-12D · Mauston, WIMay 16, 1970 · N96260 · Destroyed NTSB CHI70FDJ17Accident · Serious injuriesClosedErco 415-C · Evansville, WIMay 6, 1970 · N2362H · Destroyed