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 CHI72DEP38Accident · No injuriesClosedCessna 182K · Green Bay, WIApr 6, 1972 · N3135Q · Substantial damage NTSB CHI72FEP35Accident · Serious injuriesClosedMustang M-1 · Appleton, WIMar 26, 1972 · N5RK · Destroyed NTSB CHI72DEP36Accident · No injuriesClosedPiper PA-28 · Ashland, WIMar 23, 1972 · N7290F · Substantial damage NTSB CHI72DEP33Accident · No injuriesClosedCessna 177 · Racine, WIMar 11, 1972 · N3134T · Substantial damage NTSB CHI72FEP32Accident · Minor injuriesClosedCessna 172G · Thorp, WIMar 10, 1972 · N3664L · Substantial damage NTSB CHI72DEP34Accident · No injuriesClosedCessna 172G · Burlington, WIMar 7, 1972 · N3623L · Substantial damage NTSB CHI72IC063Incident · No injuriesClosedBeech 95-B55 · Milwaukee, WIFeb 5, 1972 · N48034 · Minor damage NTSB CHI72FEP31Accident · Minor injuriesClosedMooney M20C · Franksville, WIJan 23, 1972 · N6449U · Substantial damage NTSB CHI72FEP30Accident · 1 fatalClosedCessna 337 · Woodruff, WIJan 20, 1972 · N2140 · Destroyed NTSB CHI72AC060Accident · No injuriesClosedBeech D18S · Madison, WIJan 20, 1972 · N80390 · Substantial damage NTSB CHI72DEP29Accident · No injuriesClosedCessna 150D · Viroqua, WIJan 18, 1972 · N4178U · Substantial damage NTSB CHI72FEP27Accident · No injuriesClosedCessna 172A · Fall Creek, WIJan 9, 1972 · N7406T · Substantial damage NTSB CHI72FEP25Accident · No injuriesClosedCessna 172 · Delavan, WIJan 9, 1972 · N5875A · Substantial damage NTSB CHI72DEP28Accident · No injuriesClosedPiper PA-28 · Waukesha, WIDec 31, 1971 · N2371T · Substantial damage NTSB CHI72FEP24Accident · No injuriesClosedMitsubishi MU2B20 · East Troy, WIDec 11, 1971 · N304L · Substantial damage NTSB CHI72FEP23Accident · Minor injuriesClosedPiper PA-32 · Waukesha, WIDec 5, 1971 · N3449W · Destroyed NTSB CHI72AC048Accident · 1 fatalClosedCessna 172H · Granton, WIDec 5, 1971 · N3288L · Destroyed NTSB CHI72DEP26Accident · No injuriesClosedLuscombe 8A · Wilmot, WINov 24, 1971 · N45676 · Substantial damage NTSB CHI72AC045Accident · No injuriesClosedBoeing 727 · Milwaukee, WINov 17, 1971 · N7077U · Substantial damage NTSB CHI72FEP21Accident · Serious injuriesClosedLuscombe 8A · Stevens Pt., WINov 10, 1971 · N45431 · Substantial damage NTSB CHI72DEP22Accident · No injuriesClosedCessna 150 · Kenosha, WINov 2, 1971 · N8229F · Substantial damage NTSB CHI72DEP20Accident · No injuriesClosedMooney M20C · Dodgeville, WIOct 28, 1971 · N5953Q · Substantial damage NTSB CHI72FEP18Accident · No injuriesClosedGlobe GC-1B · Sheboygan, WIOct 5, 1971 · N80606 · Substantial damage NTSB CHI72DEP19Accident · No injuriesClosedDoers B8M · Tichigan, WIOct 2, 1971 · N7195 · Substantial damage NTSB CHI72AC031Accident · 2 fatalClosedCessna 150F · Tomahawk, WIOct 1, 1971 · N7801F · Destroyed NTSB CHI72FEP16Incident · No injuriesClosedPiper PA-28 · Dodgeville, WISep 29, 1971 · N7251W · Minor damage NTSB CHI72DEP17Accident · No injuriesClosedMooney M20 · Hayward, WISep 28, 1971 · N5247B · Substantial damage NTSB CHI72AC027Accident · 6 fatalClosedBeech 95-B55 · Milwaukee, WISep 25, 1971 · N8627Q · Destroyed NTSB CHI72FEP13Accident · No injuriesClosedCessna 175 · Dodgeville, WISep 11, 1971 · N6655E · Substantial damage NTSB CHI72DER02Accident · No injuriesClosedCassutt 3M · Durand, WISep 11, 1971 · N8156 · Substantial damage NTSB CHI72DEP15Accident · No injuriesClosedLuscombe 8A · Lyons, WISep 11, 1971 · N1323B · Substantial damage NTSB CHI72DEP11Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WIAug 27, 1971 · N1765T · Substantial damage NTSB CHI72FEP14Accident · Minor injuriesClosedPiper PA-28 · Wauwatosa Br, WIAug 22, 1971 · N7269J · Substantial damage NTSB CHI72DEP12Accident · Minor injuriesClosedCessna 150 · Gays Mills, WIAug 15, 1971 · N6872F · Substantial damage NTSB CHI72FEP09Accident · No injuriesClosedMooney M20C · La Crosse, WIAug 14, 1971 · N6837N · Substantial damage NTSB CHI72FEP08Accident · No injuriesClosedCessna 177 · Delavan, WIAug 8, 1971 · N3269T · Substantial damage NTSB CHI72FEP07Accident · Serious injuriesClosedGrumman G-32A · Pickett, WIAug 7, 1971 · N7F · Substantial damage NTSB CHI72FEP06Accident · Minor injuriesClosedDavis V-3 · Wauwatosa, WIAug 5, 1971 · NC630 · Substantial damage NTSB CHI72AC012Accident · No injuriesClosedBeech 99 · Ashland, WIAug 5, 1971 · N7099N · Substantial damage NTSB CHI72DEP10Accident · Minor injuriesClosedPiper J-3 · East Troy, WIAug 1, 1971 · N3676K · Substantial damage NTSB CHI72FER01Accident · Minor injuriesClosedPiper PA-28 · Trego, WIJul 31, 1971 · N5657U · Substantial damage NTSB CHI72FEP04Accident · No injuriesClosedBeech A23-24 · Waupaca, WIJul 25, 1971 · N4773J · Substantial damage NTSB CHI72FEP05Accident · Minor injuriesClosedCessna 182J · Wausau, WIJul 23, 1971 · N3337F · Substantial damage NTSB CHI72DEP03Accident · No injuriesClosedPiper PA-22 · Washingtn Isl, WIJul 22, 1971 · N7821D · Destroyed NTSB CHI72DEP02Accident · No injuriesClosedBoeing B75N1 · Blck Rvr Flls, WIJul 11, 1971 · N69808 · Substantial damage NTSB CHI72FEP01Accident · Serious injuriesClosedAeronca 7AC · Antigo, WIJul 9, 1971 · N84263 · Substantial damage NTSB CHI72AC001Accident · 2 fatalClosedTed Smith 601 · Woodruff, WIJul 2, 1971 · N566Y · Destroyed NTSB CHI71FEP54Accident · No injuriesClosedPietenpol GN-1 · Menomonee Fls, WIJun 19, 1971 · N4705G · Substantial damage NTSB CHI71FEP53Accident · 1 fatalClosedPiper PA-18 · Ripon, WIJun 13, 1971 · N2366P · Destroyed NTSB CHI71FEP55Accident · No injuriesClosedRearwin 8135 · Reedsburg, WIJun 6, 1971 · N25451 · Substantial damage