# NTSB investigations, 2020, GA: Nose over/nose down

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 ERA21LA038](https://openairdocs.org/ntsb/ERA21LA038.md): Piper PA22 · Warner Robins, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 1, 2020 · N3225B · Substantial damage
  > The pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.
- [NTSB ERA21LA007](https://openairdocs.org/ntsb/ERA21LA007.md): Champion 8KCAB · Ellijay, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 5, 2020 · N787AC · Substantial damage
  > The pilot's improper landing flare which resulted in a bounced landing and a subsequent noseover.
- [NTSB ERA20LA311](https://openairdocs.org/ntsb/ERA20LA311.md): Zenith CH650LS · Villa Rica, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 5, 2020 · N232PA · Substantial damage
  > A loss of directional control during the landing roll.
- [NTSB ERA20CA200](https://openairdocs.org/ntsb/ERA20CA200.md): Vans RV8 · Hampton, GA · Accident · No injuries · Class 4 · Data collection · Final report · May 21, 2020 · N665HM · Substantial damage
  > A right main landing gear break malfunction during landing. Contributing to the accident was a worn right main landing gear caliper pin and pressure plate hole.
- [NTSB ERA20CA131](https://openairdocs.org/ntsb/ERA20CA131.md): American Legand AL18 · Social Circle, GA · Accident · No injuries · Data collection · Final report · Mar 10, 2020 · N23TN · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.
- [NTSB ERA20LA071](https://openairdocs.org/ntsb/ERA20LA071.md): Hughes OH 6A · Preston, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 8, 2020 · N6186U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.

## 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") = 2020
  AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' 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/096/sequence?state=GA&year=2020

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