# NTSB investigations, NE: 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 CEN23FA220](https://openairdocs.org/ntsb/CEN23FA220.md): Vans RV7 · Gibbon, NE · Accident · 1 fatal · Class 3 · Field · Final report · Jun 2, 2023 · N977RV · Destroyed
  > The pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.
- [NTSB WPR22FA266](https://openairdocs.org/ntsb/WPR22FA266.md): Holland Mike RV9A · Tryon, NE · Accident · 2 fatal · Class 3 · Field · Final report · Jul 25, 2022 · N192MH · Destroyed
  > The non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…
- [NTSB CEN21FA150](https://openairdocs.org/ntsb/CEN21FA150.md): Aviat A-1B · Berwyn, NE · Accident · 1 fatal · Class 3 · Field · Final report · Mar 6, 2021 · N166WW · Destroyed
  > A loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.
- [NTSB CEN17FA362](https://openairdocs.org/ntsb/CEN17FA362.md): Mitsubishi MU 2B-40 · Ainsworth, NE · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2017 · N73MA · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation.
- [NTSB CEN10CA539](https://openairdocs.org/ntsb/CEN10CA539.md): Cessna A185F · Rushville, NE · Accident · No injuries · Data collection · Final report · Sep 13, 2010 · N714AL · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.
- [NTSB DEN08FA100](https://openairdocs.org/ntsb/DEN08FA100.md): Extra Flugzeugbau EA 300/L · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Jun 5, 2008 · N12XT · Destroyed
  > The pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…

## 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" = 'NE' 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=NE

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