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 CHI67D0347Accident · Minor injuriesClosedChampion 7FC · Elcho, WIOct 25, 1966 · N9862Y · Substantial damage NTSB CHI67A0055Accident · 2 fatalClosedTaylorcraft BC12-D · Burlington, WIOct 23, 1966 · N39294 · Destroyed NTSB CHI67F0327Accident · No injuriesClosedPiper PA-28 · Delafield, WIOct 22, 1966 · N5582W · Substantial damage NTSB CHI67D0293Accident · No injuriesClosedNavion A · Stevens Point, WIOct 12, 1966 · N4002K · Substantial damage NTSB CHI67D0292Accident · No injuriesClosedChampion 7FC · Hales Corners, WIOct 9, 1966 · N9017B · Substantial damage NTSB CHI67D0286Accident · No injuriesClosedCessna 172 · Waukesha, WIOct 4, 1966 · N3896L · Substantial damage NTSB CHI67D0285Accident · No injuriesClosedPiper PA-24 · Sheboygan Fls, WIOct 3, 1966 · N8337P · Substantial damage NTSB CHI67F0254Accident · No injuriesClosedStinson 108-1 · Solon Springs, WIOct 2, 1966 · N40110 · Substantial damage NTSB CHI67D0352Accident · No injuriesClosedCessna 150 · La Farge, WIOct 1, 1966 · N7725F · Substantial damage NTSB CHI67D0313Accident · No injuriesClosedAeronca 11BC · Kaukauna, WISep 23, 1966 · N3948E · Substantial damage NTSB CHI67F0337Accident · No injuriesClosedChampion 7GCAA · Salem, WISep 17, 1966 · N9626S · Substantial damage NTSB CHI67F0223Accident · No injuriesClosedCessna 310K · Delevan, WISep 16, 1966 · N3801X · Substantial damage NTSB CHI67D0195Accident · No injuriesClosedCessna 150A · Stevens Point, WISep 12, 1966 · N7217X · Substantial damage NTSB CHI67F0190Accident · No injuriesClosedTaylorcraft DCO-65 · Cottage Grove, WISep 11, 1966 · N50702 · Substantial damage NTSB CHI67F0189Accident · No injuriesClosedBeech D18S · Janesville, WISep 8, 1966 · N156NA · Substantial damage NTSB CHI67F0191Accident · Minor injuriesClosedAeronca 15AC · Superior, WISep 6, 1966 · N1156H · Substantial damage NTSB CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB CHI67F0268Accident · Minor injuriesClosedMooney M20C · Crivitz, WIAug 28, 1966 · N2799W · Destroyed NTSB CHI67F0173Accident · No injuriesClosedCessna 205 · Oak Creek, WIAug 27, 1966 · N8150Z · Substantial damage NTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 25, 1966 · N6428E · Substantial damage NTSB CHI67F0181Accident · Minor injuriesClosedCessna 170A · Walworth, WIAug 21, 1966 · N9217A · Substantial damage NTSB CHI67A0025Accident · 1 fatalClosedBeech 23 · Tomah, WIAug 21, 1966 · N2307J · Destroyed NTSB CHI67D0157Accident · No injuriesClosedCessna 185 · Land O Lakes, WIAug 16, 1966 · N4019Y · Substantial damage NTSB CHI67F0175Accident · Serious injuriesClosedPiper PA-18 · Mt.Hope, WIAug 11, 1966 · N3496Z · Destroyed NTSB CHI67F0162Accident · Serious injuriesClosedAeronca 15AC · Minocqua, WIAug 6, 1966 · N1377H · Destroyed NTSB CHI67D0110Accident · No injuriesClosedCessna 310B · Milwaukee, WIAug 1, 1966 · N5396A · Substantial damage NTSB CHI67F0122Accident · No injuriesClosedCessna 170B · Brookfield, WIJul 29, 1966 · N3194B · Substantial damage NTSB CHI67D0107Accident · Minor injuriesClosedPiper PA-22 · Osseo, WIJul 29, 1966 · N8803C · Substantial damage NTSB CHI67A0016Accident · 1 fatalClosedCessna 150 · Racine, WIJul 27, 1966 · N3005J · Destroyed NTSB CHI67F0127Accident · No injuriesClosedCessna 310H · Racine, WIJul 25, 1966 · N222YW · Substantial damage NTSB CHI67F0100Accident · No injuriesClosedPiper PA-28 · De Pere, WIJul 12, 1966 · N6772W · Substantial damage NTSB CHI67D0120Accident · Minor injuriesClosedPiper PA-22 · Whitewater, WIJul 10, 1966 · N8494D · Destroyed NTSB CHI67D0125Accident · Serious injuriesClosedBeech 35 · West Bend, WIJul 8, 1966 · N4465V · Substantial damage NTSB CHI67F0141Accident · Serious injuriesClosedBeech A23 · Baraboo, WIJul 5, 1966 · N1449L · Substantial damage NTSB MKC67F0118Accident · Serious injuriesClosedPitts Specl · Rice Lake, WIJul 3, 1966 · N7513U · Destroyed NTSB CHI67D0085Accident · No injuriesClosedPiper PA-28 · Viola, WIJul 3, 1966 · N5234W · Substantial damage NTSB CHI67D0035Accident · Minor injuriesClosedLuscombe 8A · Montello, WIJul 2, 1966 · N71350 · Destroyed NTSB CHI67F0087Accident · No injuriesClosedNavion B · Marshall, WIJun 28, 1966 · N29P · Substantial damage NTSB CHI67F0030Accident · No injuriesClosedPiper PA24 · Delavan, WIJun 27, 1966 · N8217P · Substantial damage NTSB CHI67F0039Accident · No injuriesClosedPiper PA-25 · Jefferson, WIJun 25, 1966 · N6269Z · Substantial damage NTSB CHI67D0080Accident · No injuriesClosedCessna 172 · Richland Cntr, WIJun 24, 1966 · N6202E · Destroyed NTSB CHI66D0779Accident · No injuriesClosedPiper PA28 · Milwaukee, WIJun 20, 1966 · N6313W · Substantial damage NTSB CHI67D0121Accident · No injuriesClosedLuscombe 8A · Mukwonago, WIJun 19, 1966 · N71157 · Substantial damage NTSB CHI66F0012Accident · Serious injuriesClosedSchweizer SGU222 · Bay City, WIJun 18, 1966 · N10399 · Destroyed NTSB MKC67D0026Accident · No injuriesClosedPiper J4A-S · Superior, WIJun 12, 1966 · N29097 · Substantial damage NTSB CHI67D0029Accident · No injuriesClosedCessna 140 · Madison, WIJun 10, 1966 · N72919 · Substantial damage NTSB CHI66D0790Accident · No injuriesClosedMooney M20E · Woodruff, WIJun 7, 1966 · N5632Q · Substantial damage NTSB CHI67F0017Accident · Serious injuriesClosedPiper PA-24 · Chetek, WIJun 5, 1966 · N7709P · Destroyed NTSB CHI66F0758Accident · No injuriesClosedAeronca 7FC · Palmyra, WIJun 4, 1966 · N7683E · Substantial damage NTSB CHI67F0022Accident · Minor injuriesClosedPiper PA-22 · Middleton, WIJun 2, 1966 · N9964D · Substantial damage