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 CHI67F0007Accident · Minor injuriesClosedStinson 108-1 · Kenoska, WIJun 1, 1966 · N9055K · Substantial damage NTSB CHI67D0014Accident · No injuriesClosedPiper PA22 · Janesville, WIMay 30, 1966 · N5156Z · Substantial damage NTSB CHI67D0021Accident · No injuriesClosedAlon A-2 · Menomonee Fls, WIMay 28, 1966 · N6359V · Substantial damage NTSB CHI66F0778Accident · Minor injuriesClosedBeech 35 · Bangor, WIMay 27, 1966 · N419B · Substantial damage NTSB CHI66D0777Accident · Minor injuriesClosedCessna 172 · Middleton, WIMay 26, 1966 · N8795B · Substantial damage NTSB CHI66F0745Accident · No injuriesClosedBeech A23A · Cable, WIMay 24, 1966 · N2360W · Substantial damage NTSB CHI66F0735Accident · No injuriesClosedCessna 150 · Milwauke, WIMay 19, 1966 · N6765F · Substantial damage NTSB CHI66F0748Accident · Minor injuriesClosedCessna 150 · Waubecka, WIMay 17, 1966 · N8540G · Destroyed NTSB CHI66F0744Accident · Serious injuriesClosedCessna 170 · Franklin, WIMay 17, 1966 · N4209V · Substantial damage NTSB CHI66F0747Accident · No injuriesClosedBellanca 14-13 · Tony, WIMay 7, 1966 · N86771 · Substantial damage NTSB CHI66F0716Accident · Minor injuriesClosedCessna 172 · Port Washngtn, WIApr 19, 1966 · N6835X · Destroyed NTSB CHI66F0666Accident · No injuriesClosedCessna 140 · Milwaukee, WIApr 16, 1966 · N89523 · Substantial damage NTSB CHI66F0685Accident · No injuriesClosedCessna 172E · Beaver Dam, WIApr 10, 1966 · N5361T · Substantial damage NTSB CHI66D0658Accident · No injuriesClosedPiper PA-28 · Shullsburg, WIMar 25, 1966 · N4571R · Substantial damage NTSB CHI66A0076Accident · Serious injuriesClosedBell 47G3B1 · Oshkosh, WIMar 19, 1966 · N73963 · Substantial damage NTSB CHI66D0682Accident · No injuriesClosedCessna 182 · Watertown, WIMar 17, 1966 · N5532B · Substantial damage NTSB CHI66D0681Accident · No injuriesClosedBeech G35 · Waukesha, WIMar 16, 1966 · N171B · Substantial damage NTSB CHI66F0680Accident · No injuriesClosedChampion 7KC · Middleton, WIMar 9, 1966 · N8977R · Substantial damage NTSB CHI66F0595Accident · No injuriesClosedCessna 150 · Milwaukee, WIFeb 16, 1966 · N8704S · Substantial damage NTSB CHI66F0592Accident · Serious injuriesClosedCessna 150 · Milwaukee, WIFeb 15, 1966 · N6042T · Substantial damage NTSB CHI66F0584Accident · Serious injuriesClosedErco 415-C · Baraboo, WIFeb 13, 1966 · N99772 · Destroyed NTSB CHI66D0602Accident · No injuriesClosedCessna 182 · Middleton, WIFeb 12, 1966 · N4907D · Substantial damage NTSB CHI66F0550Accident · Minor injuriesClosedCessna 140 · Pelican Lake, WIJan 31, 1966 · N76910 · Substantial damage NTSB CHI66D0593Accident · No injuriesClosedPiper PA-22 · Janesville, WIJan 30, 1966 · N5815Z · Substantial damage NTSB CHI66D0577Accident · No injuriesClosedCessna 170B · Depere, WIJan 29, 1966 · N8084A · Substantial damage NTSB CHI66F0530Accident · No injuriesClosedCessna 182H · Boscobel, WIJan 9, 1966 · N1986X · Substantial damage NTSB CHI66F0475Accident · No injuriesClosedErcoupe 415-C · Stevens Pt, WIDec 16, 1965 · N94196 · Substantial damage NTSB CHI66F0521Accident · Serious injuriesClosedCessna 172D · Walworth, WIDec 10, 1965 · N2085Y · Destroyed NTSB CHI66F0497Accident · No injuriesClosedCulver LCA · Superior, WINov 30, 1965 · N20988 · Substantial damage NTSB CHI66F0505Accident · Minor injuriesClosedTaylorcraft DCO-65 · Waupaca, WINov 26, 1965 · N53514 · Substantial damage NTSB CHI66F0467Accident · No injuriesClosedPiper PA-24 · Eau Claire, WINov 13, 1965 · N5352P · Substantial damage NTSB CHI66D0436Accident · Minor injuriesClosedStinson 108-3 · Portage, WIOct 24, 1965 · N1000M · Substantial damage NTSB CHI66F0480Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIOct 17, 1965 · N7326W · 2 aircraft · Substantial damage NTSB CHI66A0038Accident · 2 fatalClosedCessna 310F · Minocqua, WIOct 17, 1965 · N188RT · Destroyed NTSB CHI66A0033Accident · 1 fatalClosedBeech 35 · Delton, WIOct 8, 1965 · N3847N · Destroyed NTSB CHI66D0463Accident · No injuriesClosedChampion 7FC · Coon Valley, WIOct 2, 1965 · N7534B · Substantial damage NTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WISep 22, 1965 · N6287E · Substantial damage NTSB CHI66D0460Accident · No injuriesClosedPiper PA-28 · Cashton, WISep 19, 1965 · N7742W · Substantial damage NTSB CHI66A0028Accident · 1 fatalClosedAeronca 7AC · Whitewater, WISep 17, 1965 · N2334E · Destroyed NTSB CHI66A0026Accident · No injuriesClosedDouglas DC-3 · Stevens Pt., WISep 14, 1965 · N28341 · Substantial damage NTSB CHI66D0442Accident · No injuriesClosedCessna 210 · Delavan, WISep 11, 1965 · N9492T · Substantial damage NTSB CHI66A0022Accident · 2 fatalClosedCessna 182 · Burlington, WIAug 25, 1965 · N2402G · Destroyed NTSB CHI66F0178Accident · No injuriesClosedCessna 140 · Milwaukee, WIAug 23, 1965 · N76465 · Substantial damage NTSB CHI66D0493Accident · No injuriesClosedPiper PA-24 · Crivitz, WIAug 20, 1965 · N5630P · Substantial damage NTSB CHI66A0019Accident · 1 fatalClosedMooney M-20C · Beloit, WIAug 20, 1965 · N6701U · Destroyed NTSB CHI66F0300Accident · Serious injuriesClosedNardi FN333 · Three Lakes, WIAug 19, 1965 · N624 · Destroyed NTSB CHI66D0362Accident · No injuriesClosedBeechcraft F35 · Seymour, WIAug 18, 1965 · N3386C · Substantial damage NTSB CHI66F0424Accident · Serious injuriesClosedPiper J-3 · De Pere, WIAug 17, 1965 · N23413 · Substantial damage NTSB CHI66D0411Accident · No injuriesClosedBeechcraft F35 · Baraboo, WIAug 16, 1965 · N3844B · Substantial damage NTSB CHI66F0216Accident · Minor injuriesClosedPiper PA-28 · Delavan, WIAug 13, 1965 · N7280W · Substantial damage