# NTSB investigations: Perception/orientation/illusion, general

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 DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB GAA16CA518](https://openairdocs.org/ntsb/GAA16CA518.md): Beech C24 · Andrews, OR · Accident · No injuries · Data collection · Final report · Sep 28, 2016 · N4690M · Substantial damage
  > The pilot’s decision to land off airport at night and his lack of positional awareness, which resulted in his landing at the wrong location and impacting a fence.
- [NTSB ERA15FA254](https://openairdocs.org/ntsb/ERA15FA254.md): Beech A36 · Plainville, MA · Accident · 3 fatal · Field investigation · Final report · Jun 28, 2015 · N5626D · Destroyed
  > The total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.
- [NTSB ERA14LA212](https://openairdocs.org/ntsb/ERA14LA212.md): Champion 7ECA · Taylorsville, NC · Accident · 1 fatal · Limited investigation · Final report · Apr 26, 2014 · N9122E · Substantial damage
  > The pilot’s improper approach, which resulted in a long landing right of the runway centerline and the airplane’s subsequent collision with a riding mower that would have been difficult for the pilot to see due to its color and the nose-high attitude of the…
- [NTSB ANC13LA066](https://openairdocs.org/ntsb/ANC13LA066.md): Cessna T207A · King Salmon, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 2013 · N499K · Substantial damage
  > The pilot’s inadequate visual lookout while departing from a multiple-use waterway, which resulted in a collision with a drifting boat. Contributing to the accident were the lack of visual conspicuity of the boat and the limited amount of time the boat…
- [NTSB WPR13FA119](https://openairdocs.org/ntsb/WPR13FA119.md): Bell 206B · Acton, CA · Accident · 3 fatal · Field investigation · Final report · Feb 10, 2013 · N59518 · Substantial damage
  > The pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…
- [NTSB ERA09CA216](https://openairdocs.org/ntsb/ERA09CA216.md): Cirrus Design SR22 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Mar 18, 2009 · N748CD · Substantial damage
  > The failure of the pilot to maintain clearance with a parked airplane.
- [NTSB WPR09LA125](https://openairdocs.org/ntsb/WPR09LA125.md): Eurocopter AS 350 B2 · Cave Creek, AZ · Accident · No injuries · Limited investigation · Final report · Feb 23, 2009 · N353P · Substantial damage
  > The pilot's misjudged landing flare. Contributing to the accident was the brownout condition created by the dust cloud that interfered with the pilot's perception of proximity to the ground, and the glare interference from the parked fire vehicles headlights…

## 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02022000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02022000/cases

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