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 CHI69D0486Accident · No injuriesClosedStinson 108-2 · Superior, WIFeb 13, 1969 · N962D · Substantial damage NTSB CHI69D0588Accident · No injuriesClosedBeech 95-B55 · Crivitz, WIFeb 9, 1969 · N7739K · Substantial damage NTSB CHI69D0573Accident · No injuriesClosedLuscombe 8A · West Bend, WIFeb 9, 1969 · N72041 · Substantial damage NTSB CHI69A0070Accident · No injuriesClosedBeech E18S · La Crosse, WIFeb 5, 1969 · N68V · Substantial damage NTSB CHI69F0444Accident · No injuriesClosedCessna 150E · Pewaukee, WIJan 20, 1969 · N6221T · Substantial damage NTSB CHI69D0540Accident · Minor injuriesClosedCessna 172 · Wautoma, WIJan 20, 1969 · N5749T · Substantial damage NTSB CHI69F0481Accident · No injuriesClosedCessna 150 · Beloit, WIJan 18, 1969 · N50322 · Destroyed NTSB CHI69D0430Accident · No injuriesClosedCessna 172 · Monroe, WIJan 2, 1969 · N8207B · Substantial damage NTSB CHI69F0501Accident · Serious injuriesClosedTaylorcraft DCO-65 · Hortonville, WIDec 29, 1968 · N53514 · Destroyed NTSB MKC69F0303Accident · No injuriesClosedPiper PA-32 · Baldwin, WIDec 23, 1968 · N4150R · Substantial damage NTSB CHI69D0392Accident · No injuriesClosedCessna 310F · Appleton, WIDec 6, 1968 · N5814X · Substantial damage NTSB CHI69D0531Accident · No injuriesClosedCessna 172 · Ridgeland, WINov 29, 1968 · N3910S · Substantial damage NTSB CHI69D0417Accident · No injuriesClosedCessna 195A · Madison, WINov 26, 1968 · N2187C · Substantial damage NTSB CHI69F0409Accident · Minor injuriesClosedPiper PA-28 · Sturtevant, WINov 24, 1968 · N4217T · Substantial damage NTSB CHI69A0053Accident · 3 fatalClosedMooney M20C · Rhinelander, WINov 17, 1968 · N1352W · Destroyed NTSB CHI69D0411Accident · No injuriesClosedPiper PA-28 · Appleton, WINov 16, 1968 · N9675J · Substantial damage NTSB CHI69D0371Accident · No injuriesClosedCessna 182 · West Salem, WINov 9, 1968 · N2843R · Substantial damage NTSB CHI69A0048Accident · No injuriesClosedBeech C-45G · Wausaukee, WINov 9, 1968 · N2847G · Substantial damage NTSB CHI69D0331Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 31, 1968 · N6422F · Substantial damage NTSB CHI69F0317Accident · Minor injuriesClosedCessna 172D · Shawano, WIOct 13, 1968 · N2522Y · Destroyed NTSB CHI69A0040Accident · 4 fatalClosedCessna 172 · Platteville, WIOct 13, 1968 · N8624B · Destroyed NTSB CHI69D0318Accident · No injuriesClosedCessna 120 · Richland Ctr, WIOct 12, 1968 · N2874N · Substantial damage NTSB CHI69D0310Accident · No injuriesClosedCessna 150 · Clintonville, WIOct 1, 1968 · N7235S · Substantial damage NTSB CHI69D0301Accident · Minor injuriesClosedCessna 182C · Waunakee, WISep 22, 1968 · N8585T · Substantial damage NTSB CHI69D0308Accident · No injuriesClosedPiper PA-28 · Albion, WISep 21, 1968 · N6114W · Substantial damage NTSB CHI69D0238Accident · No injuriesClosedChampion 7ECA · Grantsburg, WISep 14, 1968 · N11031 · Substantial damage NTSB CHI69F0233Accident · Minor injuriesClosedStinson 108-2 · Baraboo, WISep 7, 1968 · N333C · Substantial damage NTSB CHI69F0253Accident · 1 fatalClosedAeronca 0-58A · Richland Ctr, WISep 1, 1968 · N47262 · Destroyed NTSB CHI69D0300Accident · No injuriesClosedCessna 150 · Black Rvr Fls, WIAug 30, 1968 · N3679J · Substantial damage NTSB CHI69D0270Accident · No injuriesClosedPiper PA-22 · Hales Corners, WIAug 18, 1968 · N2175A · Substantial damage NTSB CHI69D0208Accident · No injuriesClosedPiper PA-28 · Washington Is, WIAug 13, 1968 · N9809W · Substantial damage NTSB CHI69F0269Accident · No injuriesClosedPiper PA-28 · Juneau, WIAug 11, 1968 · N5858W · Substantial damage NTSB CHI69F0150Accident · No injuriesClosedErco 415-CD · Rio, WIAug 11, 1968 · N3920H · Destroyed NTSB CHI69D0294Accident · Minor injuriesClosedPiper PA-22 · Platteville, WIAug 9, 1968 · N4990Z · Substantial damage NTSB CHI69D0190Accident · No injuriesClosedPiper PA-18A · Hancock, WIAug 7, 1968 · N3708A · Substantial damage NTSB CHI69D0179Accident · No injuriesClosedPiper PA-22 · Sister Bay, WIAug 7, 1968 · N3917P · Substantial damage NTSB SEA69A0010Accident · Serious injuriesClosedDouglas DC-8 · New Richmond, WIAug 6, 1968 · N8010U · Substantial damage NTSB DCA69A0001Accident · 3 fatalClosedConvair 580 · Milwaukee, WIAug 4, 1968 · N4634S · 2 aircraft · Substantial damage NTSB CHI69D0167Accident · Minor injuriesClosedCessna 150 · Franklin, WIJul 31, 1968 · N3906J · Destroyed NTSB CHI69D0172Accident · No injuriesClosedCessna 210 · Lake Geneva, WIJul 30, 1968 · N2341F · Substantial damage NTSB CHI69D0218Accident · No injuriesClosedEnstrom F-28A · Port Washngtn, WIJul 27, 1968 · N4462 · Destroyed NTSB CHI69D0393Accident · No injuriesClosedCessna 172 · Bellville, WIJul 23, 1968 · N8740U · Substantial damage NTSB CHI69D0171Accident · No injuriesClosedMooney M20 · Lyndon Sta, WIJul 21, 1968 · N5293B · Substantial damage NTSB CHI69D0291Accident · No injuriesClosedCessna 150 · Woodruff, WIJul 19, 1968 · N6127T · Substantial damage NTSB CHI69D0191Accident · No injuriesClosedAero Comdr 100 · Mattoon, WIJul 17, 1968 · N3884X · Substantial damage NTSB CHI69D0189Accident · Minor injuriesClosedPiper PA-28 · Wonewoc, WIJul 14, 1968 · N6343R · Substantial damage NTSB CHI69D0113Accident · No injuriesClosedLuscombe 8A · Green Bay, WIJul 12, 1968 · N21996 · Substantial damage NTSB CHI69D0109Accident · No injuriesClosedPiper PA-28 · Sparta, WIJul 12, 1968 · N6613W · Substantial damage NTSB CHI69D0129Accident · No injuriesClosedPiper PA-22 · Neenah, WIJul 7, 1968 · N2244A · Substantial damage NTSB CHI69F0051Accident · No injuriesClosedMooney M20D · Boscobel, WIJul 6, 1968 · N6913U · Substantial damage