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 CHI69D0125Accident · Minor injuriesClosedBell 47G-2 · Wis.Dells, WIJul 6, 1968 · N2866B · Substantial damage NTSB CHI69A0005Accident · 2 fatalClosedLuscombe 8E · Union Grove, WIJul 6, 1968 · N1181B · Destroyed NTSB CHI69I0003Incident · No injuriesClosedDouglas DC-3A · Oshkosh, WIJul 4, 1968 · N4007C · Minor damage NTSB CHI69D0126Accident · No injuriesClosedCessna 150F · Neenah, WIJun 29, 1968 · N6970F · Substantial damage NTSB CHI68A0107Accident · 1 fatalClosedBell 47J-2 · Rice Lake, WIJun 14, 1968 · N73258 · Destroyed NTSB CHI69D0025Accident · No injuriesClosedPiper PA-24 · Merrill, WIJun 11, 1968 · N7061P · Substantial damage NTSB CHI68A0103Accident · 3 fatalClosedCessna 172 · Mount Horeb, WIJun 8, 1968 · N3837S · Destroyed NTSB CHI69D0108Accident · No injuriesClosedPiper PA-22 · Sherry, WIJun 4, 1968 · N2843Z · Substantial damage NTSB CHI69D0119Accident · No injuriesClosedTaylorcraft BC12-D · Reedsburg, WIJun 2, 1968 · N96105 · Substantial damage NTSB CHI69D0015Accident · No injuriesClosedStinson 108-2 · Burkhardt, WIMay 31, 1968 · N9472K · Substantial damage NTSB CHI69D0029Accident · No injuriesClosedMooney M20A · Kenosha, WIMay 22, 1968 · N8390E · Substantial damage NTSB CHI68A0096Accident · 1 fatalClosedBeech D18 · Marshfield, WIMay 15, 1968 · N1977D · Destroyed NTSB CHI69D0040Accident · No injuriesClosedBeech T-34A · Milwaukee, WIMay 14, 1968 · N2969C · Substantial damage NTSB CHI69D0037Accident · No injuriesClosedBeech C35 · Delavan, WIMay 12, 1968 · N1920D · Substantial damage NTSB CHI69D0012Accident · Minor injuriesClosedCessna 172 · Walworth, WIMay 12, 1968 · N8356X · Destroyed NTSB CHI68F0753Accident · No injuriesClosedEnstrom F-28 · Milwaukee, WIMay 10, 1968 · N4462 · Substantial damage NTSB CHI68D0752Accident · No injuriesClosedPiper PA-22 · Stoughton, WIMay 8, 1968 · N6159D · Substantial damage NTSB CHI68D0754Accident · No injuriesClosedCessna 337B · Genoa City, WIMay 7, 1968 · N54385 · Substantial damage NTSB CHI68D0724Accident · No injuriesClosedPiper PA-24 · Milwaukee, WIApr 28, 1968 · N5078P · Substantial damage NTSB MKC68F0580Accident · Serious injuriesClosedStinson 108-2 · Menomonie, WIApr 27, 1968 · N973D · Destroyed NTSB CHI69D0021Accident · Minor injuriesClosedPiper PA-28 · Juneau, WIApr 21, 1968 · N4283J · Substantial damage NTSB CHI68A0094Accident · 2 fatalClosedAeronca 7AC · Ladysmith, WIApr 21, 1968 · N85137 · Destroyed NTSB CHI68A0090Accident · 1 fatalClosedCessna 170B · Waukesha, WIApr 17, 1968 · N4304B · Destroyed NTSB CHI68D0696Incident · No injuriesClosedCessna 185C · Grafton, WIApr 16, 1968 · N2674Z · Substantial damage NTSB CHI69F0271Accident · No injuriesClosedCessna 337 · Milwaukee, WIApr 11, 1968 · N2363S · Substantial damage NTSB CHI68D0664Accident · No injuriesClosedCessna 150 · Pulaski, WIMar 21, 1968 · N2213J · Substantial damage NTSB CHI68A0080Accident · 1 fatalClosedAeronca 7AC · Franklin, WIMar 7, 1968 · N85100 · Destroyed NTSB CHI68F0692Accident · No injuriesClosedMooney M20F · Oshkosh, WIMar 5, 1968 · N2907L · Substantial damage NTSB CHI68D0360Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 24, 1968 · N3820P · Substantial damage NTSB CHI68F0618Accident · No injuriesClosedPiper PA-24 · West Bend, WIFeb 13, 1968 · N7523P · Substantial damage NTSB CHI68F0586Accident · No injuriesClosedCessna 210B · Sauk City, WIFeb 5, 1968 · N9627X · Substantial damage NTSB CHI68D0584Accident · Minor injuriesClosedBeech A23 · Milwaukee, WIFeb 5, 1968 · N4733J · Destroyed NTSB CHI68F0612Accident · Minor injuriesClosedCessna 177 · Walworth, WIFeb 4, 1968 · N3361T · Substantial damage NTSB CHI68F0583Accident · No injuriesClosedCessna 177 · Middleton, WIFeb 3, 1968 · N2893X · Substantial damage NTSB CHI68D0580Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 3, 1968 · N4990Z · Substantial damage NTSB CHI68D0579Accident · No injuriesClosedCessna 172 · Brussels, WIJan 30, 1968 · N5520T · Substantial damage NTSB CHI68A0063Accident · 1 fatalClosedPiper J3C-65 · Beloit, WIJan 21, 1968 · N33495 · Destroyed NTSB CHI68F0594Accident · No injuriesClosedPiper PA-24 · West Bend, WIJan 18, 1968 · N8042P · Substantial damage NTSB CHI68D0544Accident · No injuriesClosedCessna 150 · Superior, WIJan 13, 1968 · N2707S · Substantial damage NTSB CHI68D0543Accident · No injuriesClosedPiper PA-28 · New Richmond, WIDec 31, 1967 · N7642W · Substantial damage NTSB CHI68D0523Accident · No injuriesClosedCessna 140 · Fitchburg, WIDec 24, 1967 · N1914N · Substantial damage NTSB CHI68D0524Accident · No injuriesClosedCessna 150 · Hales Corners, WIDec 23, 1967 · N6431T · Substantial damage NTSB CHI68F0495Accident · No injuriesClosedCessna 310C · Prairie D Sac, WIDec 14, 1967 · N1796H · Destroyed NTSB CHI68A0053Accident · 7 fatalClosedBeech H18 · Madison, WIDec 10, 1967 · N390R · Destroyed NTSB CHI68F0598Accident · Serious injuriesClosedPiper PA-32 · Wauwatosa, WIDec 8, 1967 · N3437W · Substantial damage NTSB CHI68D0481Accident · No injuriesClosedCessna 310F · Waukesha, WIDec 4, 1967 · N6720X · Substantial damage NTSB CHI68D0548Accident · No injuriesClosedCessna 150 · Germantown, WINov 25, 1967 · N3007J · Substantial damage NTSB CHI68D0480Accident · No injuriesClosedPiper J-3 · Randolph, WINov 25, 1967 · N1276V · Substantial damage NTSB CHI68A0049Accident · 3 fatalClosedMooney M20C · Cable, WINov 23, 1967 · N1383W · Destroyed NTSB CHI68A0041Accident · 1 fatalClosedBeech C-45H · Aurora, WIOct 29, 1967 · N956C · Destroyed