Skip to content

NTSB investigations, WI

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI77FEP18Accident · Serious injuriesClosedNavion L-17 · Readstown, WIFeb 11, 1977 · N91741 · Destroyed NTSB CHI77FA026Accident · 1 fatalClosedBeech 58 · Necedah, WIFeb 3, 1977 · N177HC · Destroyed NTSB CHI77DER02Accident · No injuriesClosedCessna 172F · Glenwood City, WIFeb 3, 1977 · N8121U · Substantial damage NTSB CHI77DEP15Accident · No injuriesClosedPiper PA-28 · Pewaukee, WIJan 30, 1977 · N7504W · Substantial damage NTSB CHI77DER01Accident · No injuriesClosedCessna 170B · Rice Lake, WIJan 23, 1977 · N1782D · Substantial damage NTSB CHI77FEP14Accident · Minor injuriesClosedPiper PA-23 · Lone Rock, WIJan 21, 1977 · N1275P · Destroyed NTSB CHI77FEP16Accident · No injuriesClosedCessna 150 · Mosinee, WIJan 9, 1977 · N63346 · Substantial damage NTSB CHI77FEP12Accident · Serious injuriesClosedPiper PA-30A · Madison, WIDec 27, 1976 · N7184Y · Destroyed NTSB CHI77FEP13Accident · No injuriesClosedPiper PA-28 · Cable, WIDec 24, 1976 · N210KB · Substantial damage NTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WIDec 21, 1976 · N5835Z · Substantial damage NTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WIDec 15, 1976 · N2973E · Substantial damage NTSB CHI77FEP10Accident · Serious injuriesClosedBeech C55 · Eau Claire, WIDec 9, 1976 · N551U · Substantial damage NTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WIDec 4, 1976 · N3526J · Destroyed NTSB CHI77FEP09Accident · No injuriesClosedCessna 310 · Janesville, WIDec 2, 1976 · N188GS · Substantial damage NTSB CHI77FEP07Accident · No injuriesClosedPiper PA-32R · Ashippun, WINov 27, 1976 · N6273J · Substantial damage NTSB CHI77FEP08Accident · No injuriesClosedStinson 108-1 · Burlington, WINov 25, 1976 · N97849 · Substantial damage NTSB CHI77FEP06Accident · No injuriesClosedBeech V35R · Cottage Grove, WINov 20, 1976 · N3016V · Substantial damage NTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINov 20, 1976 · N2168V · Substantial damage NTSB CHI77DEP03Accident · Minor injuriesClosedCessna 172 · Middleton, WINov 10, 1976 · N1582Y · Substantial damage NTSB CHI77FEP02Accident · No injuriesClosedCessna 210T · Eau Claire, WIOct 21, 1976 · N3006R · Substantial damage NTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WIOct 20, 1976 · N704PN · Destroyed NTSB CHI77DEP01Accident · No injuriesClosedMooney M20 · Franklin, WIOct 3, 1976 · N6500B · Substantial damage NTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WISep 22, 1976 · N11106 · Destroyed NTSB CHI76DEP50Accident · No injuriesClosedPiper PA-28 · Ladysmith, WISep 13, 1976 · N6113J · Substantial damage NTSB CHI76DEP48Accident · No injuriesClosedCessna 210 · Big Falls, WISep 11, 1976 · N9450T · Substantial damage NTSB CHI76AC089Accident · 2 fatalClosedCessna 150L · Stevens Point, WISep 5, 1976 · N6986G · Substantial damage NTSB CHI76DEP49Accident · No injuriesClosedBeech B24R · Walworth, WISep 4, 1976 · N2518W · Substantial damage NTSB CHI76DEP47Accident · Minor injuriesClosedBellanca 8GCBC · West Bend, WISep 4, 1976 · N88089 · Substantial damage NTSB CHI76FEP45Accident · Serious injuriesClosedCessna 210 · Hales Corner, WIAug 28, 1976 · N3911Y · Destroyed NTSB CHI76DEP46Accident · Serious injuriesClosedCessna 172 · Dodgeville, WIAug 28, 1976 · N9626V · Substantial damage NTSB CHI76DEP44Accident · No injuriesClosedPiper PA-24 · La Crosse, WIAug 18, 1976 · N9390P · Substantial damage NTSB CHI76AC086Accident · 2 fatalClosedCessna 207 · East Troy, WIAug 17, 1976 · N91061 · Destroyed NTSB CHI76FEP43Accident · No injuriesClosedPiper PA-28R · Withee, WIAug 13, 1976 · N4375X · Substantial damage NTSB CHI76FEP42Accident · Minor injuriesClosedMooney M20E · Grafton, WIAug 13, 1976 · N5753Q · Substantial damage NTSB CHI76AC085Accident · 1 fatalClosedPiper PA-18 · Tomahawk, WIAug 9, 1976 · N3697Z · Destroyed NTSB CHI76AC083Accident · 1 fatalClosedPiper PA-28R · Oshkosh, WIAug 7, 1976 · N55765 · Destroyed NTSB CHI77DEP04Accident · No injuriesClosedCessna 310B · Bristol, WIJul 25, 1976 · N5396A · Substantial damage NTSB CHI76FEP38Accident · Minor injuriesClosedHughes 269A · Abbotsford, WIJul 25, 1976 · N8929F · Substantial damage NTSB CHI76FEP39Accident · Minor injuriesClosedPiper PA-28 · Sturtevant, WIJul 24, 1976 · N44553 · Substantial damage NTSB CHI76DEP41Accident · No injuriesClosedBoeing A75N1 · Hartford, WIJul 24, 1976 · N73878 · Substantial damage NTSB CHI76FEP40Accident · No injuriesClosedCessna 180J · Rhinelander, WIJul 22, 1976 · N9906N · Substantial damage NTSB CHI76FEP37Accident · No injuriesClosedSnow 600S2C · Plainfield, WIJul 21, 1976 · N1629S · Destroyed NTSB CHI76FEP35Accident · Serious injuriesClosedCessna 210 · Schofield, WIJul 13, 1976 · N9416T · Destroyed NTSB CHI76DEP36Accident · No injuriesClosedPiper PA-28 · Ojibwa, WIJul 5, 1976 · N44604 · Substantial damage NTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WIJul 3, 1976 · N30714 · Substantial damage NTSB CHI76FEP33Accident · No injuriesClosedCessna 180A · Milwaukee, WIJun 6, 1976 · N7769A · Substantial damage NTSB CHI76FEP31Accident · Serious injuriesClosedLuscombe 8A · West Bend, WIMay 24, 1976 · N1037K · Destroyed NTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WIMay 9, 1976 · N2931S · Substantial damage NTSB CHI76AC059Accident · 1 fatalClosedBoeing A75N1 · Lake Geneva, WIMay 4, 1976 · N56945 · Destroyed NTSB CHI76FEP29Accident · Minor injuriesClosedCessna 182K · Lake Geneva, WIApr 27, 1976 · N2898R · Substantial damage