# NTSB investigations: Personality

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 CEN25LA049](https://openairdocs.org/ntsb/CEN25LA049.md): Piper PA-28-140 · Camdenton, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 24, 2024 · N6575W · Substantial damage
  > The pilot’s poor flight planning which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA23FA048](https://openairdocs.org/ntsb/ERA23FA048.md): Beech A36 · Harlan, KY · Accident · 1 fatal · Class 3 · Field · Final report · Nov 3, 2022 · N84R · Destroyed
  > The pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…
- [NTSB ERA19FA234](https://openairdocs.org/ntsb/ERA19FA234.md): Cirrus SR22 · Americus, GA · Accident · 2 fatal · Class 2 · Field · Final report · Jul 24, 2019 · N921CD · Destroyed
  > The pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…
- [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 CEN18FA011](https://openairdocs.org/ntsb/CEN18FA011.md): Cessna 172M · Ramsey, MN · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N7CF · Destroyed
  > The pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…
- [NTSB ERA17FA073](https://openairdocs.org/ntsb/ERA17FA073.md): Cessna 182 · Gatlinburg, TN · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2016 · N1839X · Destroyed
  > The non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.
- [NTSB CEN16FA370](https://openairdocs.org/ntsb/CEN16FA370.md): Piper PA 11 · Arcanum, OH · Accident · 2 fatal · Field investigation · Final report · Sep 14, 2016 · N4910M · Substantial damage
  > The student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.
- [NTSB ERA15FA359](https://openairdocs.org/ntsb/ERA15FA359.md): Boatright Waylon RV10 · Alma, GA · Accident · 5 fatal · Field investigation · Final report · Sep 16, 2015 · N122WK · Destroyed
  > The noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…

## 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", '02021030'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02021030/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.
