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 CHI75FEP19Accident · 1 fatalClosedBoeing A75N1 · Plover, WISep 1, 1974 · N60334 · Destroyed NTSB CHI75FEP20Accident · Serious injuriesClosedStinson SR-8C · Shawand, WIAug 29, 1974 · N956AL · Substantial damage NTSB CHI75DER03Accident · No injuriesClosedPiper PA-12 · Amery, WIAug 25, 1974 · N221U · Substantial damage NTSB CHI75DEP18Accident · Minor injuriesClosedCessna 182P · Delavan, WIAug 21, 1974 · N52715 · Destroyed NTSB CHI75AC019Accident · 1 fatalClosedAeronca 7AC · Bloomer, WIAug 19, 1974 · N82532 · Destroyed NTSB CHI75FEP21Accident · Serious injuriesClosedFairchild M-62A · Oostburg, WIAug 18, 1974 · N192P · Destroyed NTSB CHI75AC017Accident · 1 fatalClosedAmer Avco AA-1A · New Richmond, WIAug 18, 1974 · N9262L · Destroyed NTSB CHI75DEP16Accident · No injuriesClosedBoeing A75N1 · Friendship, WIAug 17, 1974 · N61836 · Destroyed NTSB CHI75FEP11Accident · 2 fatalClosedThorpe T-18 · Oshkosh, WIAug 6, 1974 · N193N · Destroyed NTSB CHI74FEP13Accident · No injuriesClosedBell 47D1 · Centerville, WIAug 6, 1974 · N3655F · Substantial damage NTSB CHI75FEP15Accident · No injuriesClosedCessna 182A · Appleton, WIAug 5, 1974 · N2010G · Substantial damage NTSB CHI75FEP12Accident · Minor injuriesClosedWalts Wings S1 · Hartford, WIAug 5, 1974 · N7748 · Substantial damage NTSB CHI75FER02Accident · No injuriesClosedN. American P-51 · River Falls, WIAug 4, 1974 · N6519D · Substantial damage NTSB CHI75DEP17Accident · No injuriesClosedPiper PA-30 · Madison, WIAug 4, 1974 · N7690Y · Substantial damage NTSB CHI75FER01Accident · Minor injuriesClosedVollmer Sprts · Webster, WIAug 3, 1974 · N4646T · Substantial damage NTSB CHI75FEP08Accident · 1 fatalClosed3 Roadable Bryan · Oshkosh, WIAug 2, 1974 · N2714C · Destroyed NTSB CHI75DEP14Accident · No injuriesClosedCessna 140 · Shawano, WIAug 2, 1974 · N77253 · Substantial damage NTSB CHI75FEP07Accident · Serious injuriesClosedBeech 23 · Dodgeville, WIAug 1, 1974 · N2397Z · Substantial damage NTSB CHI75FEP04Accident · Minor injuriesClosedPiper PA-18 · Hazelhurst, WIJul 29, 1974 · N7092D · Substantial damage NTSB CHI75FEP09Accident · No injuriesClosedPitts S1S · Fon Du Lac, WIJul 28, 1974 · N66JS · Substantial damage NTSB CHI75FEP10Accident · No injuriesClosedAcro Duster SA-700 · Fond Du Lac, WIJul 27, 1974 · N181J · Substantial damage NTSB CHI75FEP06Accident · No injuriesClosedPiper PA-28 · Beloit, WIJul 27, 1974 · N56978 · Destroyed NTSB CHI75FEP05Accident · Minor injuriesClosedCessna 180 · Three Lakes, WIJul 23, 1974 · N3460Y · Substantial damage NTSB CHI75DEP03Accident · No injuriesClosedCessna A188 · Nekoosa, WIJul 22, 1974 · N3545Q · Destroyed NTSB CHI75DEP02Accident · No injuriesClosedCessna 172 · Summit Lake, WIJul 21, 1974 · N4225Q · Substantial damage NTSB CHI75DEP44Accident · No injuriesClosedPiper PA-28R · Darlington, WIJul 20, 1974 · N2712R · Substantial damage NTSB CHI75AC008Accident · 3 fatalClosedCessna 310L · Land O' Lakes, WIJul 17, 1974 · N69939 · Destroyed NTSB CHI75AC003Accident · No injuriesClosedCessna 310C · Middleton, WIJul 9, 1974 · N1799H · Substantial damage NTSB CHI74DEP01Accident · No injuriesClosedPiper PA-22 · Menomonee Fls, WIJul 9, 1974 · N57260 · Substantial damage NTSB CHI74FER05Accident · No injuriesClosedCessna 170A · Horse Creek, WIJun 30, 1974 · N9546A · Substantial damage NTSB CHI74FEP50Accident · Minor injuriesClosedPiper PA-24 · Madison, WIJun 22, 1974 · N6847P · Substantial damage NTSB CHI74FEP52Accident · Minor injuriesClosedCessna 210 · Watertown, WIJun 15, 1974 · N6545X · Substantial damage NTSB CHI74DER04Accident · Minor injuriesClosedPiper PA-28 · Superior, WIJun 15, 1974 · N56303 · Substantial damage NTSB CHI74FEP49Accident · No injuriesClosedBoeing A75N1 · Lone Rock, WIJun 13, 1974 · N111Q · Substantial damage NTSB CHI74FEP48Accident · No injuriesClosedPiper PA-32 · Friendship, WIJun 4, 1974 · N4191R · Substantial damage NTSB CHI74DEP47Accident · No injuriesClosedSteffens C-II · Columbus, WIMay 26, 1974 · N8981 · Substantial damage NTSB CHI74DEP46Accident · No injuriesClosedAeronca 15AC · St Germain, WIMay 26, 1974 · N1083H · Substantial damage NTSB CHI74DEP51Accident · No injuriesClosedHoward DGA15P · Franklin, WIMay 19, 1974 · N9887H · Substantial damage NTSB CHI74AC092Accident · 3 fatalClosedPiper PA-22 · Oshkosh, WIMay 17, 1974 · N1664A · Substantial damage NTSB CHI74DEP45Accident · No injuriesClosedAmer Avco AA1-A · Brodhead, WIApr 27, 1974 · N9394L · Substantial damage NTSB CHI74AC085Accident · 1 fatalClosedCessna 120 · Verona, WIApr 27, 1974 · N76072 · Destroyed NTSB CHI74DEP43Accident · No injuriesClosedCessna 170A · Gratiot, WIApr 21, 1974 · N5781C · Substantial damage NTSB CHI74FEP44Accident · 1 fatalClosedBeech T34B · Wautoma, WIApr 19, 1974 · N8661E · Destroyed NTSB CHI74DEP42Accident · No injuriesClosedPiper PA-28 · Pewaukee, WIApr 16, 1974 · N6313W · Substantial damage NTSB CHI74FEP41Accident · No injuriesClosedAmer Avco AA-1B · Waunakee, WIApr 15, 1974 · N9621L · Substantial damage NTSB CHI74AC083Accident · 1 fatalClosedBellanca 7ACA · Rhinelander, WIApr 9, 1974 · N68530 · Substantial damage NTSB CHI74FEP40Accident · No injuriesClosedCessna 310Q · Park Falls, WIApr 1, 1974 · N69684 · Substantial damage NTSB CHI74AC079Accident · 1 fatalClosedCessna 150F · Glen Flora, WIMar 28, 1974 · N8654G · Destroyed NTSB CHI74DEP38Accident · No injuriesClosedPiper PA-28 · Sheboygn Fall, WIMar 24, 1974 · N40903 · Substantial damage NTSB CHI74AC078Accident · 1 fatalClosedEnstrom F-28A · Superior, WIMar 24, 1974 · N9592 · Substantial damage