# Fatal NTSB investigations, WI: Miscellaneous/other

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 CHI02FA093](https://openairdocs.org/ntsb/CHI02FA093.md): Cessna 208B · Alma, WI · Accident · 1 fatal · Field investigation · Final report · Mar 15, 2002 · N228PA · Substantial damage
  > The pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…
- [NTSB CHI98FA349](https://openairdocs.org/ntsb/CHI98FA349.md): Beech 58 · Oakdale, WI · Accident · 3 fatal · Field investigation · Final report · Sep 16, 1998 · N4574Q · Destroyed
  > The installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.
- [NTSB CHI87LA086](https://openairdocs.org/ntsb/CHI87LA086.md): Cessna 172RG · Camp Douglas, WI · Accident · 1 fatal · Limited investigation · Final report · Feb 20, 1987 · N4601V · Substantial damage
  > The passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…
- [NTSB CHI86FEP09](https://openairdocs.org/ntsb/CHI86FEP09.md): Piper PA-32R-300 · Wisconsin Rapid, WI · Accident · 1 fatal · Final report · Sep 20, 1986 · N4909F · Destroyed
  > ATC had cleared the aircraft for an approach to an airport with several nonprecision instrument approaches and to maintain an altitude until established on a segment of an approach to that airport. Shortly after that time witnesses located 4.5 miles northwest…

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&occurrence=430&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
