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 CHI71FER09Accident · Minor injuriesClosedErco 415-C · Superior, WIMay 29, 1971 · N93989 · Destroyed NTSB CHI71DER08Accident · No injuriesClosedCessna 150 · Cochrane, WIMay 29, 1971 · N50543 · Substantial damage NTSB CHI71DEP52Accident · No injuriesClosedPiper PA-25 · Random Lake, WIMay 28, 1971 · N4421Y · Substantial damage NTSB CHI71FEP51Accident · No injuriesClosedPiper PA-28 · Janesville, WIMay 16, 1971 · N5510W · Substantial damage NTSB CHI71DER07Accident · No injuriesClosedPiper J3C · Star Prairie, WIMay 13, 1971 · N92094 · Substantial damage NTSB CHI71DEP50Accident · Minor injuriesClosedCessna 337 · Land O Lakes, WIMay 7, 1971 · N2201X · Substantial damage NTSB CHI71FDM06Accident · No injuriesClosedPiper PA-28 · Cochrane, WIApr 22, 1971 · N5979W · Substantial damage NTSB CHI71DDJ48Accident · No injuriesClosedCessna 337A · Delavan, WIApr 9, 1971 · N5327S · Substantial damage NTSB CHI71AC073Accident · 2 fatalClosedAmer Avco AA-1 · Mazomanie, WIApr 6, 1971 · N5963L · Destroyed NTSB CHI71DDJ47Accident · No injuriesClosedStinson 108-1 · Milwaukee, WIApr 4, 1971 · N9155K · Substantial damage NTSB CHI71DEP49Accident · No injuriesClosedCessna 150 · Appleton, WIMar 30, 1971 · N60049 · Substantial damage NTSB CHI71FDJ46Accident · Minor injuriesClosedCessna 150F · Racine, WIMar 23, 1971 · N8927S · Substantial damage NTSB CHI71AC066Accident · No injuriesClosedCessna 207 · Richland Cen, WIMar 23, 1971 · N91005 · Substantial damage NTSB CHI71FDM05Accident · No injuriesClosedCessna 150 · Superior, WIMar 17, 1971 · N6249R · 2 aircraft · Substantial damage NTSB CHI71FDJ44Accident · Minor injuriesClosedCessna 182B · Kenosha, WIMar 16, 1971 · N2291G · Substantial damage NTSB CHI71AC062Accident · No injuriesClosedCessna 172K · Sussex, WIMar 9, 1971 · N46654 · 2 aircraft · Substantial damage NTSB CHI71FDJ45Accident · No injuriesClosedPiper PA-23 · Watertown, WIMar 4, 1971 · N5554Y · Substantial damage NTSB CHI71AC060Accident · 1 fatalClosedCessna 411 · Germantown, WIFeb 26, 1971 · N3283R · Destroyed NTSB CHI71DDJ35Accident · Minor injuriesClosedCessna 172G · Hales Corners, WIFeb 15, 1971 · N4631L · Substantial damage NTSB CHI71DDJ43Accident · Minor injuriesClosedCessna A150K · Appleton, WIFeb 9, 1971 · N8336M · Substantial damage NTSB CHI71DDJ42Accident · No injuriesClosedCessna 120 · Lake Geneva, WIFeb 7, 1971 · N72441 · Substantial damage NTSB CHI71FDJ40Accident · No injuriesClosedPiper PA-28R · Milwaukee, WIFeb 2, 1971 · N4970S · Substantial damage NTSB CHI71DDJ41Accident · No injuriesClosedPiper PA-28 · Sheboygan, WIJan 27, 1971 · N3970K · Substantial damage NTSB CHI71DDJ39Accident · No injuriesClosedCessna 182 · Lone Rock, WIJan 25, 1971 · N8994X · Substantial damage NTSB CHI71DDJ38Accident · No injuriesClosedAero Comdr 100 · New Holstein, WIJan 21, 1971 · N3623X · Substantial damage NTSB CHI71DDJ37Accident · No injuriesClosedPiper PA-22 · Platteville, WIJan 20, 1971 · N4990Z · Substantial damage NTSB CHI71AC053Accident · 1 fatalClosedPiper PA-22 · Dyckesville, WIJan 16, 1971 · N4651Z · Destroyed NTSB CHI71FDJ36Accident · No injuriesClosedCessna 411 · Milwaukee, WIJan 13, 1971 · N610GC · Substantial damage NTSB CHI71AC044Accident · 3 fatalClosedCessna 402 · Waukesha, WIDec 19, 1970 · N4045Q · 2 aircraft · Destroyed NTSB CHI71IC051Incident · No injuriesClosedBoeing 707 · Janesville, WIDec 18, 1970 · N386US · No damage NTSB CHI71DDJ33Accident · No injuriesClosedAero Comdr 560A · Milwaukee, WIDec 18, 1970 · N2759B · Substantial damage NTSB CHI71DDJ34Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WIDec 15, 1970 · N7347J · Substantial damage NTSB CHI71FDJ32Accident · Serious injuriesClosedCessna 150 · Strum, WIDec 12, 1970 · N6770G · Destroyed NTSB CHI71FDJ30Accident · Serious injuriesClosedCessna 172 · Milwaukee, WIDec 5, 1970 · N8071L · Substantial damage NTSB CHI71DDJ79Accident · No injuriesClosedCessna 172 · Milwaukee, WIDec 5, 1970 · N46024 · Substantial damage NTSB CHI71DDJ31Accident · No injuriesClosedCessna 172 · Juneau, WIDec 5, 1970 · N5686T · Substantial damage NTSB CHI71DDJ28Accident · No injuriesClosedCessna 172 · Reedsburg, WIDec 5, 1970 · N8164U · Substantial damage NTSB CHI7IIC037Incident · No injuriesClosedBeech B99 · Marshfield, WIDec 3, 1970 · N8899M · Minor damage NTSB CHI71AC034Accident · 4 fatalClosedPiper PA-24 · Weston, WINov 18, 1970 · N7880P · Destroyed NTSB CHI71AC031Accident · Serious injuriesClosedDehavilland DHC-6 · Lacrosse, WINov 9, 1970 · N956SM · Destroyed NTSB CHI71FDJ24Accident · Minor injuriesClosedCessna 195 · Franklin, WINov 8, 1970 · N3878V · Substantial damage NTSB CHI71DDJ27Accident · No injuriesClosedBensen B8M · Waterford, WINov 7, 1970 · N2434 · Substantial damage NTSB CHI71DDJ21Accident · Minor injuriesClosedCessna 180A · Tony, WINov 6, 1970 · N5395D · Substantial damage NTSB CHI71FDM04Accident · No injuriesClosedPiper PA-28 · Chetek, WINov 1, 1970 · N4363J · Substantial damage NTSB CHI71AC026Accident · 3 fatalClosedCessna 310D · Watertown, WIOct 20, 1970 · N6765T · Destroyed NTSB CHI71FDJ23Accident · 2 fatalClosedConvair PBY-5A · Rhinelander, WIOct 15, 1970 · N610FF · Destroyed NTSB CHI71FDJ22Accident · No injuriesClosedCessna 182 · Middleton, WIOct 15, 1970 · N3018Y · 2 aircraft · Substantial damage NTSB CHI71DDJ25Accident · No injuriesClosedPiper PA-22 · Niagara, WIOct 6, 1970 · N5815Z · Substantial damage NTSB CHI71DDJ20Accident · No injuriesClosedCessna 172E · Madison, WIOct 6, 1970 · N5785T · Substantial damage NTSB CHI71FDJ19Accident · Serious injuriesClosedCessna 150J · Eau Claire, WIOct 5, 1970 · N61357 · Destroyed