# NTSB investigations, IL: Loss of visual reference

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 CEN20CA182](https://openairdocs.org/ntsb/CEN20CA182.md): Cessna 120 · Chatham, IL · Accident · No injuries · Class 4 · Data collection · Final report · May 15, 2020 · N120MZ · Substantial damage
  > The pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.
- [NTSB GAA18CA069](https://openairdocs.org/ntsb/GAA18CA069.md): Weaver David A Pulsar 912XP · Plato Center, IL · Accident · No injuries · Data collection · Final report · Dec 2, 2017 · N912GR · Substantial damage
  > The pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.
- [NTSB CEN14LA316](https://openairdocs.org/ntsb/CEN14LA316.md): Grazhopper Trike · Ottawa, IL · Accident · 1 fatal · Limited investigation · Final report · Jun 24, 2014 · UNREG · Substantial damage
  > The noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…
- [NTSB CEN13FA096](https://openairdocs.org/ntsb/CEN13FA096.md): MBB BK 117 A-3 · Compton, IL · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2012 · N911BK · Substantial damage
  > The inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.
- [NTSB CEN09CA500](https://openairdocs.org/ntsb/CEN09CA500.md): Cessna P210N · Wheeling, IL · Accident · No injuries · Data collection · Final report · Jul 29, 2009 · N4648A · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during landing.

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

This list as a web page: https://openairdocs.org/ntsb-events/402/sequence?state=IL

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