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 CHI78FEP37Accident · No injuriesClosedDehavilland DHC-2 · Chippewa Falls, WIMay 28, 1978 · N5163G · Substantial damage NTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WIMay 28, 1978 · N9376U · Destroyed NTSB CHI78FA041Accident · 4 fatalClosedCessna T210M · Bloomer, WIMay 27, 1978 · N761GV · Destroyed NTSB CHI78FEP36Accident · Serious injuriesClosedPiper PA-28 · Portage, WIMay 22, 1978 · N9436J · Substantial damage NTSB CHI78DEP35Accident · Minor injuriesClosedMustang II · Lancaster, WIMay 21, 1978 · N4790 · Substantial damage NTSB CHI78DEP34Accident · Minor injuriesClosedHughes 269 · B1rchwood, WIMay 21, 1978 · N7449F · Substantial damage NTSB CHI78DEP32Accident · Minor injuriesClosedCessna 150 · Baileys Harbor, WIMay 16, 1978 · N60536 · Substantial damage NTSB CHI78DEP33Accident · No injuriesClosedCessna 185 · Clyman, WIMay 10, 1978 · N7591H · Substantial damage NTSB CHI78DER04Accident · No injuriesClosedCessna 150L · Grantsburg, WIApr 30, 1978 · N150L · Substantial damage NTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WIApr 29, 1978 · N8969B · Substantial damage NTSB CHI78DEP31Accident · No injuriesClosedCessna 172 · Middleton, WIApr 13, 1978 · N73362 · Substantial damage NTSB CHI78FEP29Accident · No injuriesClosedPiper PA-36 · Neenah, WIMar 22, 1978 · N9992P · Substantial damage NTSB CHI78DEP27Accident · No injuriesClosedCessna 150 · Black River, WIMar 22, 1978 · N18162 · Substantial damage NTSB CHI78FEP28Accident · No injuriesClosedCessna 177RG · Dodgeville, WIMar 21, 1978 · N2011Q · Substantial damage NTSB CHI78DEP25Accident · No injuriesClosedCessna 152 · Milwaukee, WIMar 12, 1978 · N24337 · Substantial damage NTSB CHI78DEP26Accident · No injuriesClosedCessna 150 · Delavan, WIMar 11, 1978 · N3639J · Substantial damage NTSB CHI78FEP23Accident · No injuriesClosedGrumman AA1-B · Waukesha, WIMar 6, 1978 · N8871L · Substantial damage NTSB CHI78FEP24Accident · No injuriesClosedPiper PA-28 · Lacrosse, WIMar 4, 1978 · N4547F · Substantial damage NTSB CHI78FEP22Accident · No injuriesClosedCessna 182E · East Troy, WIMar 4, 1978 · N2860Y · Substantial damage NTSB CHI78FEP19Accident · No injuriesClosedTaylorcraft BL-65 · Hartford, WIFeb 25, 1978 · N29504 · Substantial damage NTSB CHI78DEP18Accident · No injuriesClosedCessna 150F · Necedah, WIFeb 20, 1978 · N8617G · Substantial damage NTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WIFeb 17, 1978 · N2760L · Substantial damage NTSB CHI78FEP20Accident · Minor injuriesClosedPiper PA-28R · Pewaukee, WIFeb 16, 1978 · N1394T · Substantial damage NTSB CHI78DEP16Accident · No injuriesClosedCessna 150 · Kenosha, WIFeb 9, 1978 · N10428 · Substantial damage NTSB CHI78FEP14Accident · Minor injuriesClosedBell 47-J · Wilmot, WIFeb 5, 1978 · N6780D · Substantial damage NTSB CHI78DEP12Accident · No injuriesClosedCessna 150L · Sun Prairie, WIJan 31, 1978 · N10735 · Substantial damage NTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WIJan 29, 1978 · N51042 · Substantial damage NTSB CHI78FEP13Accident · No injuriesClosedPiper PA-32 · Watertown, WIJan 28, 1978 · N7726J · Substantial damage NTSB CHI78FEP11Accident · No injuriesClosedCessna 172L · Waukesha, WIJan 15, 1978 · N7699G · Substantial damage NTSB CHI78DER03Accident · No injuriesClosedCessna 150 · Superior, WIJan 10, 1978 · N6039K · Substantial damage NTSB CHI78DER02Accident · No injuriesClosedPiper PA-28 · Amery, WIJan 9, 1978 · N8005W · Substantial damage NTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WIJan 2, 1978 · N8215C · Destroyed NTSB CHI78FEP07Accident · No injuriesClosedCessna 177 · Madison, WIDec 26, 1977 · N2011Q · Substantial damage NTSB CHI78FEP10Accident · No injuriesClosedCessna 402 · Milwaukee, WIDec 13, 1977 · N15096 · Substantial damage NTSB CHI78FA008Accident · 1 fatalClosedCessna 310P · Eagle River, WINov 7, 1977 · N5861M · Destroyed NTSB CHI78FA007Accident · 1 fatalClosedCessna 310Q · Watertown, WINov 6, 1977 · N7701Q · Destroyed NTSB CHI78FEP09Accident · Serious injuriesClosedPiper PA-31 · Manitowoc, WINov 3, 1977 · N9273Y · Destroyed NTSB CHI78FER01Accident · No injuriesClosedBeech D18S · Osceola, WIOct 30, 1977 · N273C · Substantial damage NTSB CHI78FEP08Accident · No injuriesClosedGrum Amer AA1B · Racine, WIOct 28, 1977 · N888IL · Substantial damage NTSB CHI78FEP06Accident · No injuriesClosedBeech C23 · Milwaukee, WIOct 25, 1977 · N2252L · Substantial damage NTSB CHI78FEP05Accident · No injuriesClosedPiper PA-24 · Green Bay, WIOct 19, 1977 · N5837P · Substantial damage NTSB CHI78FEP04Accident · Minor injuriesClosedCessna 172M · Elkhorn, WIOct 17, 1977 · N20011 · Destroyed NTSB CHI78DEP03Accident · No injuriesClosedHawk DSK-1 · Mosinee, WIOct 16, 1977 · N9FK · Substantial damage NTSB CHI78DEP02Accident · Serious injuriesClosedSemco Chlngr · Mauston, WIOct 16, 1977 · N14550 · No damage NTSB CHI78FEP01Accident · Minor injuriesClosedHughes 269C · Cottage Grove, WIOct 6, 1977 · N7436F · Substantial damage NTSB CHI77DEP64Accident · No injuriesClosedCessna 337 · Wilmot, WISep 28, 1977 · N6304F · Substantial damage NTSB CHI77FEP61Accident · No injuriesClosedCessna 172L · West Bend, WISep 18, 1977 · N1TA · Substantial damage NTSB CHI77DEP62Accident · No injuriesClosedPiper PA-28 · Middleton, WISep 18, 1977 · N15953 · Substantial damage NTSB CHI77FEP63Accident · Serious injuriesClosedCessna 150L · Winneconne, WISep 14, 1977 · N19257 · Substantial damage NTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WISep 11, 1977 · N5719X · Destroyed