# NTSB investigations, 2024: 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 ERA24FA283](https://openairdocs.org/ntsb/ERA24FA283.md): Piper PA46 · Trout Creek, NY · Accident · 5 fatal · Class 3 · Field · Final report · Jun 30, 2024 · N85PG · Destroyed
  > The pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…
- [NTSB CEN24FA243](https://openairdocs.org/ntsb/CEN24FA243.md): Waco YKC · Selden, KS · Accident · 2 fatal · Class 3 · Field · Final report · Jun 30, 2024 · N14137 · Substantial damage
  > The pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.
- [NTSB WPR24FA202](https://openairdocs.org/ntsb/WPR24FA202.md): Air Tractor AT-802A · Capitan, NM · Accident · 1 fatal · Class 3 · Field · Final report · Jun 21, 2024 · N331BS · Destroyed
  > The pilot’s decision to continue the visual flight rules flight through an apparent visual corridor that rapidly narrowed due to rising terrain and mountain obscuration, resulting in momentary instrument meteorological conditions and the pilot’s subsequent…
- [NTSB ERA24LA227](https://openairdocs.org/ntsb/ERA24LA227.md): Brallier Scott Glasair I · Gulf of Mexico, FL · Accident · 1 fatal · Class 3 · Limited · Final report · May 26, 2024 · N446KW · Destroyed
  > The non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…
- [NTSB ERA24FA120](https://openairdocs.org/ntsb/ERA24FA120.md): Piper PA32 · Jackson, OH · Accident · 3 fatal · Class 3 · Field · Final report · Feb 24, 2024 · N8963N · Destroyed
  > The non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.
- [NTSB ERA24FA096](https://openairdocs.org/ntsb/ERA24FA096.md): Cessna 172 · Weston, FL · Accident · 2 fatal · Class 3 · Field · Final report · Jan 23, 2024 · N737VC · Substantial damage
  > The pilots’ spatial disorientation in dark night visual meteorological conditions, which resulted in their failure to maintain altitude and a subsequent descent and impact with a swamp.

## 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 year(c."eventDate") = 2024
  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?year=2024

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