Skip to content

NTSB investigations, WI

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WISep 26, 1980 · N7627Z · Substantial damage NTSB CHI80FEP56Accident · Serious injuriesClosedPitts S-1S · Burlington, WISep 24, 1980 · N17BE · Substantial damage NTSB CHI80DER68Accident · No injuriesClosedCessna 150 · Osceola, WISep 22, 1980 · N8582J · Substantial damage NTSB CHI80DEP57Accident · No injuriesClosedCessna 170A · Iola, WISep 21, 1980 · N401P · Substantial damage NTSB CHI80DEP59Accident · No injuriesClosedGrum-Amer AA-1B · Wilmot, WISep 20, 1980 · N89816 · Substantial damage NTSB CHI80FEP55Accident · 1 fatalClosedBensen B-8M · Franksville, WISep 14, 1980 · N37512 · Substantial damage NTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WISep 13, 1980 · N7801D · Substantial damage NTSB CHI80FEP53Accident · Serious injuriesClosedBell 206 · Grafton, WISep 8, 1980 · N256DE · Substantial damage NTSB CHI80FEP52Accident · No injuriesClosedCessna 180 · Bevent, WISep 2, 1980 · N180FS · Substantial damage NTSB CHI80FEP60Accident · No injuriesClosedPiper PA-28 · Cornucopia, WISep 1, 1980 · N33444 · Substantial damage NTSB CHI80FA066Accident · 1 fatalClosedPiper PA-28 · Antigo, WIAug 29, 1980 · N1807J · Destroyed NTSB CHI80FEP49Accident · Minor injuriesClosedVarga 2150A · Fort Atkinson, WIAug 19, 1980 · N5083V · Substantial damage NTSB CHI80FEP51Accident · Serious injuriesClosedPitts S-1C · Fond Du Lac, WIAug 15, 1980 · N2271 · Substantial damage NTSB CHI80DEP47Accident · No injuriesClosedPiper PA-28 · Chippewa Falls, WIAug 15, 1980 · N2264M · Substantial damage NTSB CHI80FEP48Accident · No injuriesClosedBeech A23-19 · Winneconne, WIAug 12, 1980 · N4737J · Substantial damage NTSB CHI80DEP50Accident · No injuriesClosedPiper PA-32 · Dodgeville, WIAug 9, 1980 · N3954W · Substantial damage NTSB CHI80FEP44Accident · Minor injuriesClosedPiper PA-28 · Collins, WIAug 7, 1980 · N6796W · Substantial damage NTSB CHI80FEP43Accident · No injuriesClosedPiper PA-28R · Green Bay, WIAug 7, 1980 · N7695J · Substantial damage NTSB CHI80DEP42Accident · No injuriesClosedSikorsky CH-19E · Plover, WIAug 3, 1980 · N94475 · Substantial damage NTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WIAug 2, 1980 · N45802 · Substantial damage NTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WIAug 1, 1980 · N7EJ · Destroyed NTSB CHI80DEP41Accident · No injuriesClosedBlanik L-13 · Middleton, WIJul 16, 1980 · N90889 · Substantial damage NTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WIJul 13, 1980 · N2761 · Substantial damage NTSB CHI80FEP38Accident · Minor injuriesClosedCessna 177RG · New Lisbon, WIJul 7, 1980 · N34365 · Substantial damage NTSB CHI80FEP39Accident · No injuriesClosedCessna 182K · Wilmot, WIJul 3, 1980 · N3013Q · Substantial damage NTSB CHI80DEP36Accident · No injuriesClosedBell 47G-3B · Plainfield, WIJun 11, 1980 · N73995 · Substantial damage NTSB CHI80DEP35Accident · No injuriesClosedCessna 172D · Delavan, WIJun 8, 1980 · N2413Y · Substantial damage NTSB CHI80FER45Accident · No injuriesClosedBeech 23 · Deerpark, WIJun 2, 1980 · N8738M · Substantial damage NTSB CHI80DEP34Accident · No injuriesClosedCessna 152 · Watertown, WIMay 27, 1980 · N4809A · Substantial damage NTSB CHI80FEP31Accident · Serious injuriesClosedTomcat MARK5A · Stockbridge, WIMay 23, 1980 · N19JM · Substantial damage NTSB CHI80FA042Accident · 2 fatalClosedGrum-Amer AA-1C · Portage, WIMay 23, 1980 · N9524U · Destroyed NTSB CHI80DEP32Accident · No injuriesClosedStearman A75-N1 · City Point, WIMay 23, 1980 · N63111 · Substantial damage NTSB CHI80FEP29Accident · No injuriesClosedCassutt 111M · Stevens Pt, WIMay 21, 1980 · N5JJ · Substantial damage NTSB CHI80DEP33Accident · No injuriesClosedPiper PA-28 · Bristol, WIMay 17, 1980 · N4327T · Substantial damage NTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WIMay 17, 1980 · N73362 · Substantial damage NTSB CHI80DEP37Accident · No injuriesClosedCessna 152 · Platteville, WIMay 12, 1980 · N25990 · Substantial damage NTSB CHI80DEP28Accident · No injuriesClosedCessna 152 · Tilden, WIMay 4, 1980 · N757SV · Substantial damage NTSB CHI80DEP27Accident · Minor injuriesClosedBensen B-8M · Manitowoc, WIApr 27, 1980 · N2264A · Substantial damage NTSB CHI80DEP26Accident · Serious injuriesClosedCessna 172F · Stone Lake, WIApr 22, 1980 · N5583R · Substantial damage NTSB CHI80DEP23Accident · No injuriesClosedPiper PA-12 · Mount Vernon, WIApr 22, 1980 · N3181M · Substantial damage NTSB CHI80DEP24Accident · No injuriesClosedCessna 172K · Waunakee, WIApr 21, 1980 · N7301G · Substantial damage NTSB CHI80DEP25Accident · Minor injuriesClosedGrumman AA58 · Dodgeville, WIApr 19, 1980 · N4519K · Substantial damage NTSB CHI80DEP22Accident · No injuriesClosedCessna 177 · Oshkosh, WIApr 15, 1980 · N30231 · Substantial damage NTSB CHI80DEP21Accident · No injuriesClosedCessna 172 · Wilmot, WIApr 4, 1980 · N84633 · Substantial damage NTSB CHI80DEP20Accident · Minor injuriesClosedVertol 42A · Neosho, WIMar 21, 1980 · N96244 · Substantial damage NTSB CHI80DEP19Accident · No injuriesClosedPiper PA-28 · Waukesha, WIMar 8, 1980 · N47952 · Substantial damage NTSB CHI80FEP18Accident · Serious injuriesClosedBeech P35 · Dodgeville, WIFeb 18, 1980 · N9690Y · Substantial damage NTSB CHI80DEP16Accident · No injuriesClosedCessna 150 · Eau Claire, WIFeb 9, 1980 · N6747F · Substantial damage NTSB CHI80FEP17Accident · Minor injuriesClosedCessna 172 · Bruce, WIFeb 6, 1980 · N1167V · Substantial damage NTSB CHI80FEP15Accident · No injuriesClosedBellanca 17-30 · Darlington, WIFeb 3, 1980 · N7369V · Substantial damage