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 CHI74DEP37Accident · No injuriesClosedPiper PA-28 · Lacrosse, WIMar 23, 1974 · N15255 · Substantial damage NTSB CHI74FEP36Accident · Serious injuriesClosedPiper PA-28 · Waukesha, WIMar 22, 1974 · N55531 · Destroyed NTSB CHI74FEP39Accident · No injuriesClosedCessna 337P · Milwaukee, WIMar 14, 1974 · N2CT · Substantial damage NTSB CHI74DEP32Accident · Minor injuriesClosedBeech N35 · Medford, WIFeb 26, 1974 · N1297Z · Substantial damage NTSB CHI74DEP33Accident · No injuriesClosedCessna 172 · Burlington, WIFeb 24, 1974 · N1144M · Substantial damage NTSB CHI74DEP35Accident · No injuriesClosedPiper PA-32 · Racine, WIFeb 17, 1974 · N3303W · Substantial damage NTSB CHI74DEP34Accident · No injuriesClosedBensen B8MV · Wind Lake, WIFeb 17, 1974 · N2473 · Substantial damage NTSB CHI74DEP31Accident · No injuriesClosedBellanca 17-30A · Burlington, WIFeb 11, 1974 · N39822 · Substantial damage NTSB CHI74DEP30Accident · No injuriesClosedCessna 172 · Stevens Point, WIFeb 3, 1974 · N79409 · Substantial damage NTSB CHI74FEP29Accident · No injuriesClosedCessna 210 · Milwaukee, WIJan 29, 1974 · N9602T · Substantial damage NTSB CHI74FEP28Accident · No injuriesClosedAero Comdr 680F · Milwaukee, WIJan 29, 1974 · N77WC · Substantial damage NTSB CHI74FEP26Accident · Minor injuriesClosedCessna U206E · Cable, WIJan 15, 1974 · N9425G · Substantial damage NTSB CHI74DEP27Accident · No injuriesClosedCessna 172 · Kenosha, WIDec 29, 1973 · N7120G · Substantial damage NTSB CHI74DEP25Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 29, 1973 · N3907Q · Substantial damage NTSB CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB CHI74AC040Accident · No injuriesClosedBoeing 727 · Madison, WIDec 9, 1973 · N259US · Substantial damage NTSB CHI74DEP23Accident · Minor injuriesClosedAeronca 11AC · Neshkoro, WIDec 1, 1973 · N9353E · Substantial damage NTSB CHI74AC043Accident · 4 fatalClosedPiper PA-28 · Delavan, WINov 23, 1973 · N16327 · Destroyed NTSB CHI74DEP22Accident · Minor injuriesClosedCessna 172G · Elkhorn, WINov 22, 1973 · N1346F · Substantial damage NTSB CHI74DEP21Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WINov 22, 1973 · N1783T · Substantial damage NTSB CHI74FEP20Accident · No injuriesClosedHelio Acft H-391B · Eau Claire, WIOct 17, 1973 · N8750R · Substantial damage NTSB CHI74FEP19Accident · No injuriesClosedCessna 175A · Milwaukee, WIOct 14, 1973 · N7017E · Substantial damage NTSB CHI74DER03Accident · No injuriesClosedCessna 150L · Durand, WIOct 14, 1973 · N17295 · Substantial damage NTSB CHI74AC033Accident · 1 fatalClosedBeech D35 · Aurora, WIOct 9, 1973 · N2964B · Destroyed NTSB CHI74FEP18Accident · No injuriesClosedBeech V35G · Manitowish W, WIOct 6, 1973 · N4647D · Substantial damage NTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WISep 22, 1973 · N6838B · Substantial damage NTSB CHI74AC025Accident · 4 fatalClosedCessna 411 · Delavan, WISep 21, 1973 · N3243R · Destroyed NTSB CHI74AC024Accident · 6 fatalClosedPiper PA-30 · Florence, WISep 21, 1973 · N7878Y · Destroyed NTSB CHI74FEP15Accident · Minor injuriesClosedErco 415C · Portage, WISep 20, 1973 · N2244H · Substantial damage NTSB CHI74FEP07Accident · Serious injuriesClosedCessna 150D · Crandon, WISep 8, 1973 · N4537U · Substantial damage NTSB CHI74DEP16Accident · No injuriesClosedPiper PA-28 · Elkhorn, WISep 2, 1973 · N3498K · Substantial damage NTSB CHI74DEP13Accident · Minor injuriesClosedBolkow 150FF · Bristol, WIAug 20, 1973 · N209AJ · Substantial damage NTSB CHI74DEP14Accident · Minor injuriesClosedCessna 177 · Shawano, WIAug 15, 1973 · N2957X · Substantial damage NTSB CHI74FEP11Accident · Minor injuriesClosedCessna 170B · Kenosha, WIAug 12, 1973 · N4670C · Substantial damage NTSB CHI74DEP12Accident · Minor injuriesClosedPiper J-3 · Neena, WIAug 12, 1973 · N98200 · Substantial damage NTSB CHI74FEP09Accident · Minor injuriesClosedCessna 120 · Okauchee, WIAug 11, 1973 · N76245 · Substantial damage NTSB CHI74FEP10Accident · Serious injuriesClosedCessna 172 · Cadott, WIAug 10, 1973 · N8595U · Destroyed NTSB CHI74FEP08Accident · Minor injuriesClosedBeech D50 · Walworth, WIAug 9, 1973 · N4977B · Destroyed NTSB CHI74FEP06Accident · Minor injuriesClosedBeech C23 · Milwaukee, WIAug 7, 1973 · N2102W · 2 aircraft · Substantial damage NTSB CHI74FEP04Accident · Serious injuriesClosedStits SA3B · Oshkosh, WIAug 3, 1973 · N3849 · Substantial damage NTSB CHI74FEP03Accident · No injuriesClosedBede BD-5J · Oshkosh, WIAug 1, 1973 · N5BD · Substantial damage NTSB CHI74FEP05Accident · Serious injuriesClosedPiper PA-28 · Wautoma, WIJul 28, 1973 · N1658J · Substantial damage NTSB CHI74DEP02Accident · Minor injuriesClosedCessna 150L · Stoughton, WIJul 25, 1973 · N1328Q · Destroyed NTSB CHI74FER01Accident · Minor injuriesClosedBeech 23 · Menomonie, WIJul 24, 1973 · N2349L · Substantial damage NTSB CHI74FEP01Accident · Serious injuriesClosedCessna 172M · Mantowish Wta, WIJul 4, 1973 · N20281 · Destroyed NTSB CHI74AC002Accident · 1 fatalClosedCessna 170A · Superior, WIJul 2, 1973 · N9745A · Destroyed NTSB CHI73DEP69Accident · No injuriesClosedCessna 140A · Milwaukee, WIJun 29, 1973 · N1116D · Substantial damage NTSB CHI73DEP68Accident · Minor injuriesClosedPiper PA-24 · Tigerton, WIJun 26, 1973 · N9287P · Destroyed NTSB CHI73FEP67Accident · No injuriesClosedFairchild F-24 · Portage, WIJun 24, 1973 · N77697 · Substantial damage NTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WIJun 24, 1973 · N7840S · Substantial damage