# Final NTSB investigations, WI: VFR encounter with IMC

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 CEN22FA013](https://openairdocs.org/ntsb/CEN22FA013.md): New Glasair Glastar · Waukesha, WI · Accident · 2 fatal · Class 3 · Field · Final report · Oct 12, 2021 · N628RS · Destroyed
  > The noninstrument-rated pilot’s decision to depart and continue flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN21FA297](https://openairdocs.org/ntsb/CEN21FA297.md): Earthstar Gull 2000 · Curtiss, WI · Accident · 1 fatal · Class 3 · Field · Final report · Jun 30, 2021 · N1712L · Substantial damage
  > The non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…
- [NTSB CEN11FA240](https://openairdocs.org/ntsb/CEN11FA240.md): Cessna 150D · Baraboo, WI · Accident · 2 fatal · Field investigation · Final report · Mar 20, 2011 · N4178U · Substantial damage
  > The student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.
- [NTSB CEN09FA340](https://openairdocs.org/ntsb/CEN09FA340.md): Gulfstream American AA-5B · Humbird, WI · Accident · 2 fatal · Field investigation · Final report · Jun 7, 2009 · N448DM · Substantial damage
  > The pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CHI08FA293](https://openairdocs.org/ntsb/CHI08FA293.md): Robinson R44 II · Kenosha, WI · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2008 · N999ZD · Destroyed
  > The pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '401')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/401/cases?state=WI&status=final

---
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.
