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 CHI70DDJ16Accident · No injuriesClosedCessna 182 · Juneau, WIMay 1, 1970 · N3367Y · Substantial damage NTSB CHI70AC075Accident · 2 fatalClosedCessna 150J · Fond Du Lac, WIApr 28, 1970 · N5539G · Destroyed NTSB CHI70FDJ15Accident · No injuriesClosedBrantly B2B · Wis Dells, WIApr 26, 1970 · N2264U · Substantial damage NTSB CHI70DDM01Accident · No injuriesClosedCessna 180 · Grantsburg, WIApr 25, 1970 · N2726X · Substantial damage NTSB CHI70DDJ14Accident · No injuriesClosedLuscombe 8A · Sheboygan Fls, WIMar 28, 1970 · N71170 · Substantial damage NTSB CHI70FDJ12Accident · No injuriesClosedCessna 182 · Stevens Point, WIMar 27, 1970 · N6498A · Substantial damage NTSB CHI70DDJ13Accident · No injuriesClosedLuscombe 8E · Wausau, WIMar 26, 1970 · N2040K · Substantial damage NTSB CHI70FDJ11Accident · Minor injuriesClosedMooney M20E · Lyndon Stn, WIMar 7, 1970 · N2680W · Substantial damage NTSB CHI70DDJ10Accident · No injuriesClosedPiper PA-28 · Burlington, WIFeb 21, 1970 · N8279N · Substantial damage NTSB CHI70FDJ06Accident · Minor injuriesClosedBell 47G-2 · Oshkosh, WIFeb 1, 1970 · N5158B · Substantial damage NTSB CHI70DDJ07Accident · No injuriesClosedCessna 150 · Pewaukee, WIFeb 1, 1970 · N8662S · Substantial damage NTSB CHI70DDJ08Accident · No injuriesClosedPiper PA-32 · Waukesha, WIJan 31, 1970 · N4265R · Substantial damage NTSB CHI70DDJ05Accident · No injuriesClosedCessna 150 · Waukesha, WIJan 18, 1970 · N7959E · Substantial damage NTSB CHI70DDJ04Accident · No injuriesClosedLuscombe 8F · Waupun, WIJan 11, 1970 · N3535G · Substantial damage NTSB CHI70DDJ03Accident · No injuriesClosedCessna 170A · Prairie Du Sc, WIJan 3, 1970 · N5772C · Substantial damage NTSB CHI70D0369Accident · No injuriesClosedCessna 150 · Orfordville, WIDec 30, 1969 · N6236R · Substantial damage NTSB CHI70I0038Incident · No injuriesClosedBeech 95 · Stevens Point, WINov 26, 1969 · N654Q · Minor damage NTSB CHI70F0338Accident · Serious injuriesClosedTaylorcraft BC12-D · Blck Rvr Fals, WINov 25, 1969 · N95999 · Substantial damage NTSB CHI70F0340Accident · No injuriesClosedCessna 150J · Lancaster, WINov 22, 1969 · N60713 · Substantial damage NTSB CHI70F0347Accident · No injuriesClosedPiper PA-28 · Madison, WINov 16, 1969 · N6092W · Substantial damage NTSB CHI70A0030Accident · 2 fatalClosedMooney M20E · Barron, WINov 8, 1969 · N1293X · Destroyed NTSB CHI70A0027Accident · 7 fatalClosedLear Jet 23A · Racine, WINov 6, 1969 · N1021B · Destroyed NTSB CHI70A0026Accident · 2 fatalClosedCessna 182B · Watertown, WINov 5, 1969 · N2795G · Destroyed NTSB CHI70A0025Accident · No injuriesClosedPiper PA-32 · New Berlin, WINov 4, 1969 · N3276W · Substantial damage NTSB CHI70A0023Accident · 1 fatalClosedBeech D18S · Madison, WINov 1, 1969 · N106H · Destroyed NTSB CHI70D0330Accident · No injuriesClosedCessna 150 · Platteville, WIOct 25, 1969 · N3227J · Substantial damage NTSB CHI70D0332Accident · No injuriesClosedPiper PA-28 · Woodruff, WIOct 18, 1969 · N95157 · Substantial damage NTSB MKC70A0018Accident · No injuriesClosedBeech E18S · Ashland, WIOct 12, 1969 · N3785B · Substantial damage NTSB CHI70A0021Accident · 2 fatalClosedCessna 182M · Mazomanie, WIOct 11, 1969 · N70696 · Destroyed NTSB CHI70F0341Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 9, 1969 · N6526S · Substantial damage NTSB CHI70D0334Accident · No injuriesClosedPiper PA-28 · Sturtevant, WIOct 7, 1969 · N1863J · Substantial damage NTSB CHI70F0310Accident · Minor injuriesClosedCessna 180 · Reeseville, WIOct 5, 1969 · N3866C · Substantial damage NTSB CHI70F0276Accident · No injuriesClosedCessna 150 · River Falls, WIOct 5, 1969 · N7993E · Substantial damage NTSB CHI70A0019Accident · 6 fatalClosedPiper PA-32 · Bruce, WIOct 3, 1969 · N4178R · Destroyed NTSB CHI70D0335Accident · No injuriesClosedMooney M20A · Milwaukee, WIOct 2, 1969 · N6071X · Substantial damage NTSB CHI70F0282Accident · Minor injuriesClosedAeronca 11AC · Neilsville, WISep 27, 1969 · N9239E · Destroyed NTSB CHI70A0018Accident · 1 fatalClosedNavion A · Milwaukee, WISep 27, 1969 · N4393K · Destroyed NTSB CHI70F0342Accident · Serious injuriesClosedPiper J3C-65 · Niagara, WISep 23, 1969 · N42046 · Destroyed NTSB CHI70F0274Accident · No injuriesClosedPiper PA-24 · Middleton, WISep 17, 1969 · N8149P · Substantial damage NTSB CHI70A0015Accident · 3 fatalClosedPiper PA-28 · North Lake, WISep 4, 1969 · N4898L · Destroyed NTSB CHI70F0200Accident · No injuriesClosedLuscombe 8A · So Superior, WIAug 31, 1969 · N39207 · Substantial damage NTSB CHI70F0333Accident · Minor injuriesClosedPiper PA-24 · Sextonville, WIAug 30, 1969 · N7797P · Substantial damage NTSB CHI70D0278Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 30, 1969 · N46556 · Substantial damage NTSB CHI70D0283Accident · No injuriesClosedCessna 310 · Tomah, WIAug 27, 1969 · N5355A · Substantial damage NTSB CHI70F0236Accident · No injuriesClosedCessna 150 · Kansasville, WIAug 26, 1969 · N3906J · Substantial damage NTSB CHI70F0319Accident · No injuriesClosedPiper PA-25 · Peshtigo, WIAug 25, 1969 · N7796Z · Substantial damage NTSB CHI70D0298Accident · No injuriesClosedCessna 140 · Chilton, WIAug 24, 1969 · N1999V · Substantial damage NTSB CHI70F0348Accident · No injuriesClosedGlobe GC-1B · Delavan, WIAug 23, 1969 · N78137 · Substantial damage NTSB CHI70F0252Accident · Minor injuriesClosedBeech B35 · Birchwood, WIAug 20, 1969 · N5200C · Substantial damage NTSB CHI70D0204Accident · No injuriesClosedBeech A-23 · Neenah, WIAug 17, 1969 · N1423L · Substantial damage