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 CHI66F0168Accident · Serious injuriesClosedComonwealth 185 · Baraboo, WIAug 13, 1965 · N92834 · Destroyed NTSB CHI66I0016Incident · No injuriesClosedBoeing B-720 · Milwaukee, WIAug 11, 1965 · N466US · Minor damage NTSB CHI66F0423Accident · No injuriesClosedCessna 310B · Milwaukee, WIAug 10, 1965 · N493JE · Substantial damage NTSB CHI66A0015Accident · 4 fatalClosedBeech B35 · Boulder Jct, WIAug 7, 1965 · N5091C · Destroyed NTSB CHI66A0011Accident · 1 fatalClosedAircoupe A-2 · Langlade, WIJul 30, 1965 · N5480E · Destroyed NTSB CHI65D0151Accident · No injuriesClosedBeechcraft H35 · Madison, WIJul 28, 1965 · N5475D · Substantial damage NTSB CHI66F0189Accident · No injuriesClosedBeechcraft A-35 · Green Bay, WIJul 24, 1965 · N8681A · Substantial damage NTSB CHI66F0152Accident · Minor injuriesClosedStinson 108-2 · Beaver Dam, WIJul 24, 1965 · N286C · Destroyed NTSB CHI66A0009Accident · 1 fatalClosedCessna 150C · Wausau, WIJul 18, 1965 · N7936Z · Destroyed NTSB CHI66F0170Accident · No injuriesClosedCessna 195 · Oshkosh, WIJul 15, 1965 · N4381V · Substantial damage NTSB CHI66F0428Accident · Minor injuriesClosedFairchild M-62A3 · Pulaski, WIJul 13, 1965 · N64551 · Substantial damage NTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damage NTSB CHI66F0166Accident · No injuriesClosedStinson 108 · Lac Duflambeu, WIJul 8, 1965 · N6865M · Substantial damage NTSB CHI66F0364Accident · No injuriesClosedPiper PA-12 · Dallas, WIJul 4, 1965 · N4227M · Substantial damage NTSB CHI66A0002Accident · 1 fatalClosedPiper PA-16 · Lake Delton, WIJul 4, 1965 · N6866K · Destroyed NTSB CHI66A0001Accident · 2 fatalClosedTaylorcraft BC-12D · Mineral Point, WIJul 3, 1965 · N96648 · Destroyed NTSB CHI66F0047Accident · Minor injuriesClosedNo American SNJ-5 · Hales Corner, WIJun 28, 1965 · N3262G · Substantial damage NTSB CHI66F0141Accident · Serious injuriesClosedComonwealth 7000 · Sparta, WIJun 26, 1965 · N20734 · Substantial damage NTSB CHI66F0471Accident · No injuriesClosedBeechcraft H35 · Delavan, WIJun 24, 1965 · N5493D · Substantial damage NTSB CHI66F0113Accident · Minor injuriesClosedStinson 108-2 · Kenosha, WIJun 24, 1965 · N9519K · Destroyed NTSB CHI66D0348Accident · No injuriesClosedPiper PA-24 · Wausau, WIJun 24, 1965 · N6188P · Destroyed NTSB CHI66F0163Accident · No injuriesClosedNavion B · Portage, WIJun 23, 1965 · N5436K · Substantial damage NTSB CHI66F0142Accident · No injuriesClosedLuscombe 8F · Milwaukee, WIJun 21, 1965 · N2036K · Substantial damage NTSB CHI66D0162Accident · No injuriesClosedPiper PA-22 · Lake Geneva, WIJun 20, 1965 · N4568A · Substantial damage NTSB CHI65A0106Accident · No injuriesClosedHughes 269B · Gile, WIJun 20, 1965 · N9355F · Substantial damage NTSB CHI66D0112Accident · No injuriesClosedAeronca 15AC · Wisconsin Dls, WIJun 19, 1965 · N1314H · Substantial damage NTSB CHI66D0153Accident · No injuriesClosedCessna 182 · Franklin, WIJun 9, 1965 · N5568B · Substantial damage NTSB CHI66D0049Accident · No injuriesClosedPiper PA-22 · Milwaukee, WIJun 6, 1965 · N4677Z · Substantial damage NTSB CHI65F0198Accident · No injuriesClosedCessna 182G · Cornell, WIMay 12, 1965 · N2352R · Substantial damage NTSB CHI65F0159Accident · No injuriesClosedCessna 182A · Phillips, WIApr 22, 1965 · N5172D · Substantial damage NTSB CHI66F0104Accident · No injuriesClosedCessna 195-A · Madison, WIApr 13, 1965 · N41X · Substantial damage NTSB CHI65F0142Accident · No injuriesClosedNo American F-51D · Maidson, WIApr 11, 1965 · N12065 · Substantial damage NTSB CHI65A0090Accident · 2 fatalClosedAeronca 7AC · East Troy, WIApr 10, 1965 · N84981 · Destroyed NTSB MKC65F0094Accident · No injuriesClosedCessna 150D · Kenosha, WIApr 2, 1965 · N6020T · Substantial damage NTSB CHI65F0172Accident · No injuriesClosedPiper PA-22 · Eau Claire, WIApr 2, 1965 · N5272Z · Substantial damage NTSB CHI65A0082Accident · 1 fatalClosedMooney M20E · Orfordville, WIMar 21, 1965 · N7143U · Destroyed NTSB CHI65F0195Accident · No injuriesClosedCessna 140A · Shell Lake, WIMar 12, 1965 · N5642C · Substantial damage NTSB CHI66F0028Accident · No injuriesClosedPiper PA-20 · Cable, WIMar 6, 1965 · N1145C · 2 aircraft · Substantial damage NTSB CHI65F0041Accident · No injuriesClosedAeronca 7HC · Watertown, WIFeb 27, 1965 · N9818Y · Substantial damage NTSB CHI65D0081Accident · No injuriesClosedLuscombe 8A · Janesville, WIFeb 26, 1965 · N37024 · Substantial damage NTSB CHI65F0111Accident · No injuriesClosedPiper PA-28 · Middleton, WIFeb 20, 1965 · N5015W · Substantial damage NTSB CHI65F0069Accident · No injuriesClosedMooney M20A · Portage, WIFeb 13, 1965 · N5261B · Substantial damage NTSB CHI65F0040Accident · No injuriesClosedCessna 172D · Madison, WIFeb 13, 1965 · N2327U · Substantial damage NTSB CHI65F0032Accident · No injuriesClosedCessna 170B · Wausau, WIFeb 10, 1965 · N4550C · Substantial damage NTSB MKC65D0039Accident · No injuriesClosedCessna 172 · E Farmington, WIJan 31, 1965 · N8401U · Substantial damage NTSB CHI65F0080Accident · No injuriesClosedCessna 180 · Oconomowoc, WIJan 31, 1965 · N9415C · Substantial damage NTSB CHI65D0025Accident · No injuriesClosedCessna 150 · New Holstein, WIJan 31, 1965 · N7910E · Substantial damage NTSB CHI65F0033Accident · No injuriesClosedPiper PA-22 · Milwaukee, WIJan 30, 1965 · N9533D · Substantial damage NTSB UNK65X1343Accident · Serious injuriesClosedPiper PA-18 · Tustin, WIJan 24, 1965 · N1021A · Destroyed NTSB CHI65D0005Accident · Minor injuriesClosedCessna 170A · Stanley, WIJan 2, 1965 · N9503A · Substantial damage