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 CHI76FEP28Accident · No injuriesClosedPiper PA-28R · Pulaski, WIApr 20, 1976 · N4508J · Substantial damage NTSB CHI76DEP27Accident · No injuriesClosedCessna 170A · Hartford, WIApr 3, 1976 · N1332D · Substantial damage NTSB CHI76AC052Accident · 1 fatalClosedBeech E18S · Burlington, WIMar 1, 1976 · N386 · Destroyed NTSB CHI76DER07Accident · No injuriesClosedCessna 150 · Amery, WIFeb 26, 1976 · N3596L · Substantial damage NTSB CHI76DEP26Accident · No injuriesClosedPiper PA-18 · Milwaukee, WIFeb 23, 1976 · N326T · Substantial damage NTSB CHI76AC050Accident · 1 fatalClosedPiper PA-32 · Cable, WIFeb 20, 1976 · N3947W · Destroyed NTSB CHI76DEP24Accident · No injuriesClosedPiper PA-20 · Baraboo, WIFeb 8, 1976 · N7354K · Substantial damage NTSB CHI76DEP25Accident · No injuriesClosedCessna 182 · Milwaukee, WIFeb 6, 1976 · N3142R · Substantial damage NTSB CHI76DEP23Accident · Minor injuriesClosedTaylorcraft BC12-D · Chambers Isle, WIJan 25, 1976 · N95927 · Substantial damage NTSB CHI76DEP21Accident · No injuriesClosedCessna 140 · Kenosha, WIJan 18, 1976 · N701F · Substantial damage NTSB CHI76DEP22Accident · No injuriesClosedPiper PA-22 · Rhinelander, WIJan 15, 1976 · N3347A · Substantial damage NTSB CHI76AC044Accident · 1 fatalClosedPiper PA-28 · Beloit, WIJan 11, 1976 · N55577 · Destroyed NTSB CHI76DER06Accident · No injuriesClosedAero Comdr 100 · Superior, WIDec 9, 1975 · N3877X · Substantial damage NTSB CHI76DEP20Accident · No injuriesClosedPiper PA-28 · Lancaster, WIDec 9, 1975 · N98107 · Substantial damage NTSB CHI76FEP19Accident · Serious injuriesClosedCessna 172A · Madison, WINov 22, 1975 · N7727T · Destroyed NTSB CHI76FER05Accident · No injuriesClosedCessna 150G · Rice Lake, WINov 15, 1975 · N3940J · Substantial damage NTSB CHI76FEP18Accident · Serious injuriesClosedBeech 95-B55 · Crandon, WINov 7, 1975 · N181Q · Substantial damage NTSB CHI76FEP16Accident · No injuriesClosedCessna 150H · Lake Geneva, WIOct 12, 1975 · N50127 · Substantial damage NTSB CHI76DEP15Accident · No injuriesClosedGrum Amer AA-5 · Necedah, WISep 14, 1975 · N5484L · Substantial damage NTSB CHI76AC023Accident · 2 fatalClosedPiper PA-22 · Cataract, WISep 7, 1975 · N3279B · Destroyed NTSB CHI76DEP14Accident · No injuriesClosedCessna 182 · Ft Atkinson, WIAug 30, 1975 · N71248 · Substantial damage NTSB CHI76DER04Accident · No injuriesClosedBensen B-8M · New Richmond, WIAug 28, 1975 · N8322 · Substantial damage NTSB CHI76FER03Accident · Serious injuriesClosedPiper PA-22 · Siren, WIAug 11, 1975 · N1409C · Destroyed NTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WIAug 11, 1975 · N55891 · Destroyed NTSB CHI76FEP09Accident · No injuriesClosedBreezy R201 · Oshkosh, WIAug 2, 1975 · N5AF · Substantial damage NTSB CHI76AC008Accident · 1 fatalClosedCessna 170B · Iron Ridge, WIAug 2, 1975 · N3468C · Destroyed NTSB CHI76DEP11Accident · Serious injuriesClosedPiper PA-28 · Mt Horeb, WIAug 1, 1975 · N15581 · Substantial damage NTSB CHI76FER02Accident · No injuriesClosedPiper PA-18 · Cumberland, WIJul 28, 1975 · N5404Y · Substantial damage NTSB CHI76DEP12Accident · No injuriesClosedCessna 188 · Gillman, WIJul 28, 1975 · N8135V · Substantial damage NTSB CHI76DEP08Accident · No injuriesClosedAeronca 11AC · Holmen, WIJul 28, 1975 · N9692E · Substantial damage NTSB CHI76FEP07Accident · 1 fatalClosedNieuport 17 · Milwaukee, WIJul 27, 1975 · N3603 · Destroyed NTSB CHI76FER01Accident · Minor injuriesClosedPiper PA-25 · Balsam Lake, WIJul 26, 1975 · N4799Y · Substantial damage NTSB CHI75FEP65Accident · No injuriesClosedBeech E18S · Burlington, WIJul 25, 1975 · N402FW · Substantial damage NTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WIJul 22, 1975 · N55898 · Substantial damage NTSB CHI76DEP10Accident · Minor injuriesClosedGrum Amer AA1-A · Portage, WIJul 20, 1975 · N9251L · Substantial damage NTSB CHI76FEP05Accident · Serious injuriesClosedBeech S3S · Franklin, WIJul 19, 1975 · N1478V · Substantial damage NTSB CHI76AC003Accident · 4 fatalClosedGrum Amer AA-5 · Hammond, WIJul 19, 1975 · N5875L · Destroyed NTSB CHI76DEP03Accident · No injuriesClosedPiper PA-25 · Bancroft, WIJul 15, 1975 · N4659Y · Substantial damage NTSB CHI76FEP02Accident · No injuriesClosedNavion N1A · Hales Corners, WIJul 6, 1975 · N5108K · Substantial damage NTSB CHI76DEP04Accident · No injuriesClosedCessna 182 · West Bend, WIJul 6, 1975 · N3707U · Substantial damage NTSB CHI76FEP01Accident · Serious injuriesClosedLuscombe 8A · Montello, WIJul 4, 1975 · N77887 · Substantial damage NTSB CHI75DEP71Accident · No injuriesClosedStinson 108-1 · Montello, WIJun 27, 1975 · N8784K · Substantial damage NTSB CHI75FEP69Accident · No injuriesClosedCessna 182H · Gratiot, WIJun 22, 1975 · N8454S · Substantial damage NTSB CHI75DEP72Accident · No injuriesClosedPiper PA-24 · Sturgeon Bay, WIJun 20, 1975 · N5837P · Substantial damage NTSB CHI75FEP70Accident · No injuriesClosedCessna 170B · Medford, WIJun 19, 1975 · N2352D · Substantial damage NTSB CHI75FEP46Accident · Minor injuriesClosedLuscombe 8A · Burlington, WIJun 14, 1975 · N45974 · Substantial damage NTSB CHI75FEP68Accident · Serious injuriesClosedGrum Amer AA1 · Delavan, WIJun 12, 1975 · N6543L · Substantial damage NTSB CHI75FER07Accident · Serious injuriesClosedBeech A23 · Baldwin, WIJun 7, 1975 · N4769J · Destroyed NTSB CHI75FEP66Accident · No injuriesClosedPiper PA-22 · Pewaukee, WIJun 6, 1975 · N7043D · Substantial damage NTSB CHI75FEP64Accident · Minor injuriesClosedBeech A36 · Wausaw, WIMay 31, 1975 · N9076Q · Destroyed