# Major NTSB investigations, WI

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CHI07MA160](https://openairdocs.org/ntsb/CHI07MA160.md): Cessna 550 · Milwaukee, WI · Accident · 6 fatal · Class 1 · Major · Final report · Jun 4, 2007 · N550BP · Destroyed
  > The National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…
- [NTSB CHI90MA244](https://openairdocs.org/ntsb/CHI90MA244.md): Bell 206B · Elkhorn, WI · Accident · 5 fatal · Major investigation · Final report · Aug 27, 1990 · N16933 · Destroyed
  > Improper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…
- [NTSB CHI88MA026](https://openairdocs.org/ntsb/CHI88MA026.md): Beech 200 · Jefferson, WI · Accident · 8 fatal · Major investigation · Final report · Nov 16, 1987 · N334DP · Destroyed
  > While cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…
- [NTSB DCA85AA036](https://openairdocs.org/ntsb/DCA85AA036.md): Douglas DC-9-14 · Milwaukee, WI · Accident · 31 fatal · Final report · Sep 6, 1985 · N100ME · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…
- [NTSB CHI70A0027](https://openairdocs.org/ntsb/CHI70A0027.md): Lear Jet 23A · Racine, WI · Accident · 7 fatal · Closed · Nov 6, 1969 · N1021B · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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'
  AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&state=WI

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.