# NTSB investigations, 2018, GA: Miscellaneous/other

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 GAA19CA088](https://openairdocs.org/ntsb/GAA19CA088.md): Piper PA28 · Cornelia, GA · Accident · No injuries · Data collection · Final report · Dec 5, 2018 · N839AL · Substantial damage
  > The flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.
- [NTSB ERA19LA057](https://openairdocs.org/ntsb/ERA19LA057.md): Cirrus SR22 · Kennesaw, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 2018 · N597CP · Substantial damage
  > The total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.
- [NTSB GAA18CA458](https://openairdocs.org/ntsb/GAA18CA458.md): Allen W Inks Virus SW · Clayton, GA · Accident · No injuries · Data collection · Final report · Jul 30, 2018 · N608US · Substantial damage
  > The pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.
- [NTSB ERA18LA176](https://openairdocs.org/ntsb/ERA18LA176.md): Cessna 337 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · May 29, 2018 · N86507 · Substantial damage
  > An area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.
- [NTSB GAA18CA273](https://openairdocs.org/ntsb/GAA18CA273.md): Christopher Lord ELA Eclipse 10 · Calhoun, GA · Accident · Minor injuries · Data collection · Final report · May 5, 2018 · N533EA · Substantial damage
  > The student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.

## 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") = 2018
  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" = '900' 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/900/sequence?state=GA&year=2018

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