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 CHI79FEP51Accident · Serious injuriesClosedCessna 182P · Neillsville, WIJul 3, 1979 · N22FW · Substantial damage NTSB CHI79FA056Accident · 1 fatalClosedPiper PA-28 · Taylor, WIJul 3, 1979 · N8341C · Destroyed NTSB CHI79DER04Accident · No injuriesClosedBeech E33C · Star Prairie, WIJul 3, 1979 · N277F · Substantial damage NTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WIJul 1, 1979 · N1972J · Destroyed NTSB CHI79DEP55Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WIJul 1, 1979 · N6981C · Substantial damage NTSB CHI79FER03Accident · Minor injuriesClosedCessna 182B · Osceola, WIJun 30, 1979 · N7228E · Substantial damage NTSB CHI79DEP54Accident · No injuriesClosedCessna 180 · Middleton, WIJun 27, 1979 · N169N · Substantial damage NTSB CHI79FA053Accident · 1 fatalClosedAeronca 11AC · Chippewa Falls, WIJun 25, 1979 · N9408E · Destroyed NTSB CHI79DEP56Accident · No injuriesClosedCessna 152 · Pewaukee, WIJun 25, 1979 · N66602 · Substantial damage NTSB CHI79FEP48Accident · Minor injuriesClosedBeech V35 · Beloit, WIJun 8, 1979 · N2069W · Substantial damage NTSB CHI79DEP50Accident · Minor injuriesClosedCessna 172H · Boulder Jct, WIJun 7, 1979 · N80921 · Substantial damage NTSB CHI79FEP47Accident · No injuriesClosedPiper PA-32R · Burlington, WIJun 6, 1979 · N1134Q · 2 aircraft · Substantial damage NTSB CHI79DEP49Accident · No injuriesClosedCessna 182 · Wilmot, WIJun 3, 1979 · N4662K · Substantial damage NTSB CHI79FEP46Accident · Serious injuriesClosedPiccard AX-6 · Middleton, WIMay 20, 1979 · N87DP · No damage NTSB CHI79FEP27Accident · No injuriesClosedPiper PA-32 · Dodgeville, WIMay 17, 1979 · N6256J · Substantial damage NTSB CHI79FEP45Accident · Serious injuriesClosedEaa Biplane P2 · Cottage Grove, WIMay 8, 1979 · N14Z · Destroyed NTSB CHI79FEP44Accident · Serious injuriesClosedCessna T210N · St. Francis, WIApr 24, 1979 · N6485N · Substantial damage NTSB CHI79FEP38Accident · Serious injuriesClosedPiper PA-23 · Park Falls, WIApr 22, 1979 · N4073P · Destroyed NTSB CHI79FA047Accident · No injuriesClosedDouglas DC-9 · Mosinee, WIApr 21, 1979 · N941N · Substantial damage NTSB CHI79FA046Accident · 6 fatalClosedCessna 210 · Cable, WIApr 17, 1979 · N5157Q · Destroyed NTSB CHI79FEP42Accident · No injuriesClosedAnderson Tent 2 · Burlington, WIApr 16, 1979 · N41MA · Substantial damage NTSB CHI79FEP43Accident · No injuriesClosedPiper PA-32R · Iola, WIApr 13, 1979 · N9585C · Substantial damage NTSB CHI79FEP41Accident · No injuriesClosedAerofab LA4200 · Coloma, WIApr 10, 1979 · N65702 · Substantial damage NTSB CHI79FEP40Accident · No injuriesClosedCessna 150M · Appleton, WIApr 7, 1979 · N9365U · Substantial damage NTSB CHI79FEP39Accident · No injuriesClosedBellanca 7GCBC · Bristol, WIApr 1, 1979 · N5507K · Substantial damage NTSB CHI79DEP37Accident · No injuriesClosedCessna 150 · Watertown, WIMar 17, 1979 · N63586 · Substantial damage NTSB CHI79DEP36Accident · No injuriesClosedCessna 172 · Milwaukee, WIMar 14, 1979 · N739HC · Minor damage NTSB CHI79FDP35Accident · No injuriesClosedBeech G18S · Clintonville, WIMar 9, 1979 · N847U · Substantial damage NTSB CHI79DEP32Accident · No injuriesClosedCessna 152 · Eau Claire, WIFeb 26, 1979 · N89048 · Substantial damage NTSB CHI79DEP34Accident · No injuriesClosedCessna 180 · Waunakee, WIFeb 24, 1979 · N9916 · Substantial damage NTSB CHI79DEP33Accident · No injuriesClosedCessna 150K · Platteville, WIFeb 19, 1979 · N6206G · Substantial damage NTSB CHI79DEP31Accident · Minor injuriesClosedGrumman AA1-A · Wausau, WIFeb 19, 1979 · N72562 · Substantial damage NTSB CHI79DEP30Accident · No injuriesClosedCessna 152 · Hartford, WIFeb 19, 1979 · N757PG · Substantial damage NTSB CHI79DEP28Accident · No injuriesClosedBeech BE-19 · Milwaukee, WIFeb 10, 1979 · N1990L · Substantial damage NTSB CHI79FEP24Accident · No injuriesClosedPiper PA-32 · Milwaukee, WIJan 29, 1979 · N4823S · Substantial damage NTSB CHI79FA027Accident · 1 fatalClosedBeech 58P · Waukesha, WIJan 27, 1979 · N9ZZ · Destroyed NTSB CHI79DEP26Accident · No injuriesClosedBeech A23 · Stevens Pt, WIJan 27, 1979 · N3570R · Substantial damage NTSB CHI79FEP25Accident · No injuriesClosedCessna 177RG · Mount Horeb, WIJan 26, 1979 · N8071G · Substantial damage NTSB CHI79DER02Accident · No injuriesClosedBeechcraft B58 · Amery, WIJan 16, 1979 · N4101S · Substantial damage NTSB CHI79FEP23Accident · No injuriesClosedSwearingen SA-226 · Wisconsin Rpds, WIJan 15, 1979 · N160MA · Substantial damage NTSB CHI79FEP22Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIJan 14, 1979 · N6695A · Substantial damage NTSB CHI79FEP21Accident · No injuriesClosedCessna 340 · Milwaukee, WIJan 3, 1979 · N888HB · Substantial damage NTSB CHI79FEP20Accident · No injuriesClosedCessna 207 · Lyndon Station, WIDec 29, 1978 · N1688U · Substantial damage NTSB CHI79FEP13Accident · No injuriesClosedCessna 150 · Sussex, WIDec 28, 1978 · N60422 · Substantial damage NTSB CHI79DEP17Accident · No injuriesClosedPiper PA-24 · Eau Claire, WIDec 28, 1978 · N6175P · Substantial damage NTSB CHI79DEP19Accident · No injuriesClosedGrumman AA-1C · Madison, WIDec 26, 1978 · N9649U · Substantial damage NTSB CHI79FEP16Accident · No injuriesClosedCessna 172K · Dodgeville, WIDec 22, 1978 · N78428 · Substantial damage NTSB CHI79DEP15Accident · No injuriesClosedPiper PA-28R · Waupun, WIDec 17, 1978 · N7607J · Substantial damage NTSB CHI79DEP14Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 17, 1978 · N6858A · Substantial damage NTSB CHI79DEP12Accident · No injuriesClosedCessna 210 · Land O'Lakes, WIDec 13, 1978 · N8110G · Substantial damage