# NTSB investigations, OR: 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 WPR24FA057](https://openairdocs.org/ntsb/WPR24FA057.md): Cessna 172G · Independence, OR · Accident · 3 fatal · Class 3 · Field · Final report · Dec 17, 2023 · N3992L · Destroyed
  > The pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.
- [NTSB WPR18FA001](https://openairdocs.org/ntsb/WPR18FA001.md): Cirrus Design SR22 · Klamath Falls, OR · Accident · 2 fatal · Field investigation · Final report · Oct 1, 2017 · N6083D · Destroyed
  > The noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…
- [NTSB GAA16CA422](https://openairdocs.org/ntsb/GAA16CA422.md): Cessna 195 · Hillsborough, OR · Accident · No injuries · Data collection · Final report · Aug 6, 2016 · N4026A · Substantial damage
  > The pilot's failure to attain a proper touchdown point and loss of directional control and her subsequent excessive brake application, which resulted in a nose-over.
- [NTSB WPR14FA244](https://openairdocs.org/ntsb/WPR14FA244.md): Grumman American Avn. AA 5B · Florence, OR · Accident · 2 fatal · Field investigation · Final report · Jun 15, 2014 · N28718 · Destroyed
  > The noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.
- [NTSB WPR11FA395](https://openairdocs.org/ntsb/WPR11FA395.md): Maule M-7-235C · Brookings, OR · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2011 · N199BF · Substantial damage
  > The pilot’s improper decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in a collision with trees while on approach for landing.
- [NTSB WPR09FA391](https://openairdocs.org/ntsb/WPR09FA391.md): Navion Navion A · Adrian, OR · Accident · 3 fatal · Field investigation · Final report · Aug 7, 2009 · N4898K · Substantial damage
  > The pilot’s failure to maintain aircraft control while in cruise flight due to spatial disorientation, which resulted in an exceedence of the design stress limits of the aircraft and led to an in-flight structural failure.

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

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