# NTSB investigations: Personality/attitude, 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 WPR19MA177](https://openairdocs.org/ntsb/WPR19MA177.md): Beech 65-A90 · Mokuleia, HI · Accident · 11 fatal · Class 2 · Major · Final report · Jun 22, 2019 · N256TA · Destroyed
  > The pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…
- [NTSB WPR18FA053](https://openairdocs.org/ntsb/WPR18FA053.md): Browning Gregory S Zodiac 601XL · Thompson's Station, TN · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N929GB · Substantial damage
  > The sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ANC14LA046](https://openairdocs.org/ntsb/ANC14LA046.md): Dehavilland DHC 2 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2014 · N115CX · Minor damage
  > The pilot’s improper decision to operate the airplane at low altitude and deliberately in close proximity to the boat operators, which resulted in a collision with a boat operator.

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

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