# NTSB investigations, GA: Personality/attitude

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 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 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…
- [NTSB ERA14LA316](https://openairdocs.org/ntsb/ERA14LA316.md): Czech Sport Piper Sport · Peachtree City, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N957MD · Substantial damage
  > The pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…
- [NTSB ERA12LA401](https://openairdocs.org/ntsb/ERA12LA401.md): Beech 400A · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2012 · N826JH · Substantial damage
  > The flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…

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

This list as a web page: https://openairdocs.org/ntsb-findings/020210/cases?state=GA

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
