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 CHI73DEP65Accident · Minor injuriesClosedPiper PA-22 · Kenosha, WIJun 15, 1973 · N7316D · Substantial damage NTSB CHI73FER09Accident · 1 fatalClosedMoonraker 100 · Prescott, WIJun 13, 1973 · N8669E · Destroyed NTSB CHI73FER08Accident · Serious injuriesClosedTaylorcraft BC12-D · Menomonie, WIJun 13, 1973 · N96584 · Substantial damage NTSB CHI73FEP64Accident · No injuriesClosedCessna 310Q · Viroqwa, WIJun 12, 1973 · N6292Q · Substantial damage NTSB CHI73DEP63Accident · No injuriesClosedPiper PA-25 · Portage, WIJun 4, 1973 · N7796Z · Substantial damage NTSB CHI73FEP62Accident · No injuriesClosedPiper PA-28 · Elkhorn, WIMay 30, 1973 · N3498K · Substantial damage NTSB CHI73FEP61Accident · 1 fatalClosedCassutt 111M · Bloomer, WIMay 28, 1973 · N143L · Destroyed NTSB CHI73AC092Accident · 1 fatalClosedCessna 172L · Crivitz, WIMay 26, 1973 · N7656G · Destroyed NTSB CHI73FEP60Accident · Serious injuriesClosedPiper PA-24 · Madison, WIMay 24, 1973 · N7068D · Substantial damage NTSB CHI73FEP59Accident · No injuriesClosedLuscombe 8A · Middleton, WIMay 20, 1973 · N71318 · Substantial damage NTSB CHI73FEP58Accident · No injuriesClosedCessna 182M · Burlington, WIMay 20, 1973 · N91835 · Substantial damage NTSB CHI73DEP57Accident · No injuriesClosedCessna 172G · Wilmot, WIMay 17, 1973 · N5767R · Substantial damage NTSB CHI73FEP55Accident · No injuriesClosedCessna 310C · Burlington, WIMay 9, 1973 · N55KM · Substantial damage NTSB CHI73FEP54Accident · No injuriesClosedTaylorcraft BC1265 · Waunakee, WIMay 5, 1973 · N36466 · Substantial damage NTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damage NTSB CHI73FEP50Accident · Serious injuriesClosedBeech 35-A33 · West Bend, WIApr 30, 1973 · N563T · Substantial damage NTSB CHI73DEP56Accident · Minor injuriesClosedCessna 177 · Rhinelander, WIApr 30, 1973 · N3174T · Destroyed NTSB CHI73FEP52Accident · No injuriesClosedMaule M-4 · Batavia, WIApr 29, 1973 · N4622T · Substantial damage NTSB CHI73FEP51Accident · No injuriesClosedPiper PA-28 · Sturtevant, WIApr 28, 1973 · N5024T · Substantial damage NTSB CHI73DER07Accident · No injuriesClosedPiper PA-28 · Boyceville, WIApr 26, 1973 · N8440R · Substantial damage NTSB CHI73AC085Accident · 1 fatalClosedAeronca 7AC · Rice Lake, WIApr 25, 1973 · N85010 · Destroyed NTSB CHI73DEP53Accident · No injuriesClosedCessna 150 · Tony, WIApr 24, 1973 · N8654G · Substantial damage NTSB CHI73DEP49Accident · No injuriesClosedCessna 172 · Bristol, WIApr 14, 1973 · N2692U · Substantial damage NTSB CHI73DEP48Accident · No injuriesClosedCessna 150K · Rhinelander, WIApr 13, 1973 · N6243G · Substantial damage NTSB CHI73FEP47Accident · Serious injuriesClosedPiper PA-28 · Independence, WIApr 6, 1973 · N4451J · Destroyed NTSB CHI73DEP46Accident · No injuriesClosedPiper PA-22 · Phillips, WIMar 30, 1973 · N7814D · Substantial damage NTSB CHI73DEP45Accident · No injuriesClosedPiper PA-28 · Middleton, WIMar 30, 1973 · N686FL · Substantial damage NTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WIMar 29, 1973 · N2418J · Destroyed NTSB CHI73DEP44Accident · No injuriesClosedPiper PA-22 · Middleton, WIMar 26, 1973 · N2849P · Substantial damage NTSB CHI73DER06Accident · Serious injuriesClosedCessna 177 · Baldwin, WIMar 25, 1973 · N2352Y · Destroyed NTSB CHI73AC071Accident · 4 fatalClosedCessna 421B · Brookfield, WIFeb 19, 1973 · N1536T · Destroyed NTSB CHI73AC070Accident · 2 fatalClosedBeech B35 · Sheboygan, WIFeb 17, 1973 · N5209C · Destroyed NTSB CHI73FEP38Accident · Serious injuriesClosedCassutt Sport · Waukesha, WIFeb 11, 1973 · N219 · Substantial damage NTSB CHI73DEP40Accident · Minor injuriesClosedChampion 7ECA · Stevens Point, WIFeb 10, 1973 · N9576S · Substantial damage NTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WIFeb 8, 1973 · N6520U · Substantial damage NTSB CHI73DER05Accident · No injuriesClosedCessna 182 · River Falls, WIFeb 3, 1973 · N2100R · Substantial damage NTSB CHI73DEP36Accident · No injuriesClosedCessna 182M · Waukesha, WIJan 28, 1973 · N70938 · Substantial damage NTSB CHI73FEP35Accident · No injuriesClosedPiper PA-32 · Racine, WIJan 12, 1973 · N4191R · Substantial damage NTSB CHI73DEP37Accident · No injuriesClosedPiper PA-28 · Shawano, WIJan 7, 1973 · N8700N · Substantial damage NTSB CHI73DEP34Accident · No injuriesClosedCessna 310 · Lake Geneva, WIDec 15, 1972 · N6886T · Substantial damage NTSB CHI73FEP33Accident · No injuriesClosedCessna 172C · New Holstein, WIDec 14, 1972 · N1535Y · Substantial damage NTSB CHI73FEP32Accident · No injuriesClosedBeech B23 · Prentice, WINov 15, 1972 · N9139T · Substantial damage NTSB CHI73FEP31Accident · Minor injuriesClosedCessna 172L · Antigo, WINov 8, 1972 · N7662G · Substantial damage NTSB CHI73FEP30Accident · Minor injuriesClosedCessna 120 · Hartford, WINov 5, 1972 · N2425N · Substantial damage NTSB CHI73FEP28Accident · Minor injuriesClosedCessna 172D · Franklin, WINov 4, 1972 · N2841U · Substantial damage NTSB CHI73AC045Accident · 2 fatalClosedPiper PA-22 · Wisconsn Rpds, WINov 1, 1972 · N5728Z · Destroyed NTSB CHI73DEP26Accident · No injuriesClosedCessna 172 · Michicot, WIOct 8, 1972 · N6259E · Substantial damage NTSB CHI73FEP73Accident · No injuriesClosedPiper PA-24 · Burlington, WIOct 4, 1972 · N6459P · Substantial damage NTSB CHI73DEP25Accident · No injuriesClosedLuscombe 8A · Waunakee, WISep 22, 1972 · N71318 · Substantial damage NTSB CHI73FEP20Accident · No injuriesClosedNaval Fcty N3N-3 · Cross Plains, WISep 19, 1972 · N6358T · Substantial damage