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 CHI68D0030Accident · No injuriesClosedLuscombe 8E · Lake Mills, WIJun 3, 1967 · N2550K · Substantial damage NTSB CHI68D0047Accident · No injuriesClosedCessna 170 · Janesville, WIJun 2, 1967 · N4014V · Destroyed NTSB CHI68D0043Accident · No injuriesClosedMooney M20C · Tomah, WIJun 1, 1967 · N9207M · Substantial damage NTSB MKC68D0021Accident · No injuriesClosedLuscombe 8A · Siren, WIMay 21, 1967 · N1381K · Substantial damage NTSB CHI67F0674Accident · No injuriesClosedPiper PA-30 · Waukesha, WIMay 18, 1967 · N7925Y · Substantial damage NTSB CHI67F0642Accident · No injuriesClosedCessna 310 · Madison, WIMay 13, 1967 · N3692D · Substantial damage NTSB CHI67D0661Accident · No injuriesClosedPiper PA-28 · Pewaukee, WIMay 12, 1967 · N6313W · Substantial damage NTSB CHI68D0120Accident · No injuriesClosedLake LA-4 · Milwaukee, WIMay 10, 1967 · N2015L · Substantial damage NTSB CHI67D0668Accident · No injuriesClosedCessna 180 · Sextonville, WIMay 7, 1967 · N3866C · Substantial damage NTSB CHI67D0660Accident · No injuriesClosedCessna 150 · Waukesha, WIMay 7, 1967 · N3589L · Substantial damage NTSB MKC67F0617Accident · No injuriesClosedCessna 150G · Wonewak, WIApr 25, 1967 · N4685X · Substantial damage NTSB CHI67F0666Accident · No injuriesClosedPiper PA-25 · Union Grove, WIApr 23, 1967 · N6367Z · Substantial damage NTSB CHI67D0659Accident · No injuriesClosedBeech E18S · Fond Du Lac, WIApr 23, 1967 · N8211 · Substantial damage NTSB CHI68D0042Accident · No injuriesClosedCessna 140 · Manitowoc, WIApr 20, 1967 · N2169V · Substantial damage NTSB CHI67A0118Accident · No injuriesClosedConvair 440 · Milwaukee, WIApr 15, 1967 · N4821C · Substantial damage NTSB CHI67F0653Accident · Minor injuriesClosedBeech 65-A80 · Rhinelander, WIApr 13, 1967 · N314Q · Substantial damage NTSB CHI67F0565Accident · No injuriesClosedLuscombe 8A · Superior, WIApr 9, 1967 · N25394 · Substantial damage NTSB CHI67D0667Accident · No injuriesClosedN.American P-51D · Hartford, WIApr 4, 1967 · N6165U · Substantial damage NTSB CHI68F0194Accident · No injuriesClosedChampion 7FC · Sturtevant, WIMar 30, 1967 · N8583E · Substantial damage NTSB CHI67F0603Accident · Minor injuriesClosedCessna 172F · Burlington, WIMar 18, 1967 · N5436R · Substantial damage NTSB CHI67D0524Accident · No injuriesClosedPiper PA-22 · Eleva, WIMar 14, 1967 · N5315Z · Substantial damage NTSB CHI67D0561Accident · No injuriesClosedBeech 23 · Milwaukee, WIMar 8, 1967 · N2331L · No damage NTSB CHI67D0594Accident · No injuriesClosedCessna 182J · Pewaukee, WIMar 7, 1967 · N3076F · Substantial damage NTSB CHI67F0505Accident · No injuriesClosedBeech 95-B55 · Waukesha, WIMar 6, 1967 · N2030W · Substantial damage NTSB CHI67D0598Accident · No injuriesClosedPiper PA-24 · Eagle River, WIMar 4, 1967 · N5289P · Substantial damage NTSB CHI67A0101Accident · No injuriesClosedBeech C-45H · Janesville, WIMar 3, 1967 · N9966Z · Substantial damage NTSB MKC67D0479Accident · No injuriesClosedChampion 7GCBC · Osceola, WIFeb 27, 1967 · N5189T · Substantial damage NTSB CHI67D0502Accident · No injuriesClosedPiper PA-28 · Sturtevant, WIFeb 26, 1967 · N9140W · Substantial damage NTSB CHI67D0501Accident · No injuriesClosedCessna 172 · Oshkosh, WIFeb 21, 1967 · N1370F · Substantial damage NTSB CHI67D0498Accident · No injuriesClosedCessna 182 · Shawano, WIFeb 14, 1967 · N2786G · Substantial damage NTSB CHI67A0096Accident · No injuriesClosedPiper PA-23 · Mt.Hope, WIFeb 12, 1967 · N4240P · Substantial damage NTSB CHI67F0472Accident · No injuriesClosedPiper PA-24 · Eau Claire, WIFeb 7, 1967 · N6538P · Substantial damage NTSB CHI67D0592Accident · No injuriesClosedPiper PA-24 · Milwaukee, WIFeb 6, 1967 · N7782P · Substantial damage NTSB CHI67D0491Accident · No injuriesClosedBeech 95 · Marshfield, WIJan 31, 1967 · N2734Y · Substantial damage NTSB CHI67D0499Accident · No injuriesClosedCessna 172 · Watertown, WIJan 20, 1967 · N8136B · Substantial damage NTSB CHI67D0500Accident · No injuriesClosedPiper PA-28 · Oshkosh, WIJan 15, 1967 · N7835W · Substantial damage NTSB CHI67A0086Accident · 1 fatalClosedGlobe GC-1B · Sheboygan, WIJan 11, 1967 · N3738K · Destroyed NTSB CHI67D0489Accident · No injuriesClosedPiper PA-28 · Black Riv Fls, WIJan 3, 1967 · N4539R · Substantial damage NTSB CHI67D0455Accident · No injuriesClosedBeech A23-24 · Winneconne, WIDec 24, 1966 · N7987L · Substantial damage NTSB CHI67D0436Accident · No injuriesClosedAeronca 15AC · Pt.Washington, WIDec 18, 1966 · N1401H · Substantial damage NTSB CHI67D0429Accident · No injuriesClosedPiper PA-23 · Madison, WIDec 15, 1966 · N3139P · Substantial damage NTSB CHI67F0434Accident · No injuriesClosedCessna 210-5 · Waupun, WIDec 6, 1966 · N8047Z · Substantial damage NTSB CHI67D0389Accident · No injuriesClosedPiper PA-28 · Superior, WIDec 3, 1966 · N7721W · Substantial damage NTSB CHI67A0067Accident · 4 fatalClosedPiper PA-28 · Madison, WINov 22, 1966 · N7901W · Destroyed NTSB MKC67D0311Accident · No injuriesClosedAeronca 7AC · Prairie Farm, WINov 20, 1966 · N85569 · Substantial damage NTSB CHI67F0354Accident · No injuriesClosedCessna 170B · Pewaukee, WINov 20, 1966 · N3120B · Substantial damage NTSB CHI67F0430Accident · Minor injuriesClosedBeech C35 · Waukesha, WINov 12, 1966 · N5979C · Substantial damage NTSB CHI67F0306Accident · No injuriesClosedPiper PA12 · Woodruff, WINov 6, 1966 · N2824M · Substantial damage NTSB CHI67D0349Accident · No injuriesClosedPiper PA-24 · Delavan, WIOct 31, 1966 · N8952P · Substantial damage NTSB CHI67D0341Accident · No injuriesClosedPiper PA-23 · Racine, WIOct 30, 1966 · N2150P · Substantial damage