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 CHI73DEP22Accident · No injuriesClosedCessna 150 · Elkhorn, WISep 17, 1972 · N8778G · Substantial damage NTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WISep 14, 1972 · N2348L · Destroyed NTSB CHI73FEP10Accident · Serious injuriesClosedPiper PA-25 · Suring, WISep 12, 1972 · N4598Y · Substantial damage NTSB CHI73DEP27Accident · No injuriesClosedGrumman G-164 · Antigo, WISep 11, 1972 · N73W · Substantial damage NTSB CHI73FER04Accident · No injuriesClosedPitts SPL S1C · Osceola, WISep 4, 1972 · N51AC · Substantial damage NTSB CHI73DEP21Accident · No injuriesClosedCessna 172 · Lake Geneva, WISep 4, 1972 · N172KA · Substantial damage NTSB CHI73FEP29Accident · No injuriesClosedCessna 177 · Sullivan, WISep 3, 1972 · N3281T · Destroyed NTSB CHI73DEP19Accident · No injuriesClosedPiper PA-28 · Endeavor, WISep 3, 1972 · N6218W · Substantial damage NTSB CHI73FEP17Accident · No injuriesClosedCessna 150K · Janesville, WIAug 25, 1972 · N6466G · 2 aircraft · Substantial damage NTSB CHI73FER03Accident · Minor injuriesClosedAlon A-2 · Elk Mound, WIAug 17, 1972 · N6525Q · Substantial damage NTSB CHI73DEP24Accident · No injuriesClosedCessna 150 · Palmyra, WIAug 14, 1972 · N1710Q · Substantial damage NTSB CHI73DEP18Accident · No injuriesClosedCessna 140 · New Glarus, WIAug 14, 1972 · N9461A · Substantial damage NTSB CHI73DEP13Accident · No injuriesClosedCessna 310Q · Necedah, WIAug 14, 1972 · N7588Q · Substantial damage NTSB CHI73FEP12Accident · No injuriesClosedCessna 175 · Kansasville, WIAug 13, 1972 · N9320B · Substantial damage NTSB CHI73FEP14Accident · Serious injuriesClosedChampion 7GCBC · Baraboo, WIAug 8, 1972 · N577RF · Destroyed NTSB CHI73FEP08Accident · Minor injuriesClosedMooney M20E · Waukesha, WIAug 4, 1972 · N6967U · Substantial damage NTSB CHI73FEP07Accident · No injuriesClosedBeech D17R · Milwaukee, WIAug 4, 1972 · N35E · Substantial damage NTSB CHI73FER02Accident · Serious injuriesClosedTaylorcraft BL-65 · Rice Lake, WIAug 1, 1972 · N29570 · Substantial damage NTSB CHI73FEP16Accident · No injuriesClosedTravel Air 4000 · Redgranite, WIAug 1, 1972 · N241 · Substantial damage NTSB CHI73FEP05Accident · Serious injuriesClosedGanagobie 3 · Oshkosh, WIAug 1, 1972 · N1949 · Substantial damage NTSB CHI73DER01Accident · No injuriesClosedCessna 150G · New Richmond, WIJul 31, 1972 · N3998J · Substantial damage NTSB CHI73DEP15Accident · No injuriesClosedPiper PA-28 · Rio, WIJul 28, 1972 · N5450W · Substantial damage NTSB CHI73FEP09Accident · 1 fatalClosedCessna 150F · Lakewood, WIJul 22, 1972 · N7109F · Substantial damage NTSB CHI73FEP06Incident · No injuriesClosedSiai-Marche 20522R · Juneau, WIJul 22, 1972 · N732W · Minor damage NTSB CHI73FEP11Accident · No injuriesClosedCessna 172G · North Freedom, WIJul 21, 1972 · N5885R · Substantial damage NTSB CHI73FEP04Accident · No injuriesClosedCessna 150G · Genoa City, WIJul 21, 1972 · N3794J · Substantial damage NTSB CHI73FEP03Accident · Serious injuriesClosedPiper PA-22 · Arkdale, WIJul 16, 1972 · N5622Z · Destroyed NTSB CHI73FEP02Accident · No injuriesClosedCessna 172F · Lake Geneva, WIJul 14, 1972 · N8236U · Substantial damage NTSB CHI73FEP01Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIJul 4, 1972 · N4472T · Substantial damage NTSB CHI73AC002Accident · 3 fatalClosedCessna 172K · Hales Corners, WIJul 4, 1972 · N79022 · Destroyed NTSB DCA72AZ012Accident · 13 fatalClosedDehavilland DHC-6 · Appleton, WIJun 29, 1972 · N4043B · 2 aircraft · Destroyed NTSB CHI72FEP51Accident · Minor injuriesClosedPiper J3C-65 · Fond Du Lac, WIJun 27, 1972 · N40609 · Substantial damage NTSB CHI72FEP50Accident · Serious injuriesClosedBensen B8M · Waterford, WIJun 27, 1972 · N7195 · Substantial damage NTSB CHI72DEP52Accident · No injuriesClosedCessna 172 · Sturtevant, WIJun 19, 1972 · N7514X · Substantial damage NTSB CHI72FER04Accident · Minor injuriesClosedPiper J3C · Menomonie, WIJun 13, 1972 · N3607K · Substantial damage NTSB CHI72FEP48Accident · No injuriesClosedCessna 180 · Menomonee Fls, WIJun 10, 1972 · N3129D · Substantial damage NTSB CHI72FEP49Accident · Minor injuriesClosedScooter RH-1 · Neenah, WIJun 7, 1972 · N3505 · Substantial damage NTSB CHI72FEP46Accident · No injuriesClosedLake LA-4 · Waukesha, WIJun 6, 1972 · N5034L · Substantial damage NTSB CHI72DEP47Accident · No injuriesClosedChampion 7ECA · Dousman, WIJun 6, 1972 · N11852 · Substantial damage NTSB CHI72ACO96Accident · 1 fatalClosedCessna 207 · Cochrane, WIJun 2, 1972 · N91005 · Destroyed NTSB CHI72FEP43Accident · No injuriesClosedCessna 140 · Lafarge, WIMay 18, 1972 · N2353N · Substantial damage NTSB CHI72FEP42Accident · No injuriesClosedCessna 182P · Bloomer, WIMay 17, 1972 · N7412Q · Substantial damage NTSB CHI72FEP45Accident · 1 fatalClosedBensen B-8 · Wiscnsin Rpds, WIMay 16, 1972 · N2362 · Destroyed NTSB CHI72DEP39Accident · No injuriesClosedPiper PA-28 · Portage, WIMay 7, 1972 · N6218W · Substantial damage NTSB CHI73AC085Accident · 5 fatalClosedBeech 65-A90 · Racine, WIMay 1, 1972 · N295X · Destroyed NTSB CHI72DEP41Accident · No injuriesClosedMooney M20C · Weston, WIApr 30, 1972 · N6821N · Substantial damage NTSB CHI72FER03Accident · No injuriesClosedBeech 35-C33 · Star Prairie, WIApr 27, 1972 · N3724Q · Substantial damage NTSB CHI72DEP40Accident · No injuriesClosedCessna 210 · Withee, WIApr 20, 1972 · N3935Y · Substantial damage NTSB CHI72FEP37Accident · No injuriesClosedPiper PA-20 · Twin Lakes, WIApr 15, 1972 · N6978K · Substantial damage NTSB CHI72AC083Accident · 1 fatalClosedShort Bros SC-7-3 · Lacrosse, WIApr 14, 1972 · N725R · Destroyed