# NTSB investigations, GA: Object/animal/substance, 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 ERA17CA047](https://openairdocs.org/ntsb/ERA17CA047.md): Hawker Beechcraft G58 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Nov 1, 2016 · N525 · Substantial damage
  > The pilot’s failure to maintain the proper airspeed during final approach and his subsequent loss of directional control during landing, which resulted in a runway excursion.
- [NTSB GAA16CA254](https://openairdocs.org/ntsb/GAA16CA254.md): Beech A36 · Griffin, GA · Accident · No injuries · Data collection · Final report · May 22, 2016 · N36SR · Substantial damage
  > The pilot's decision to land with a tailwind, resulting in a runway overrun and collision with a highway road embankment.
- [NTSB ERA16LA172](https://openairdocs.org/ntsb/ERA16LA172.md): Champion 7BCM · Tyrone, GA · Accident · No injuries · Limited investigation · Final report · Apr 30, 2016 · N7620B · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA15LA052](https://openairdocs.org/ntsb/ERA15LA052.md): Dehavilland Tiger Moth DH 82A · Williamson, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2014 · N28681 · Destroyed
  > The pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.
- [NTSB ERA09CA216](https://openairdocs.org/ntsb/ERA09CA216.md): Cirrus Design SR22 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Mar 18, 2009 · N748CD · Substantial damage
  > The failure of the pilot to maintain clearance with a parked airplane.
- [NTSB ERA09CA149](https://openairdocs.org/ntsb/ERA09CA149.md): D-Fly UL Stork · Jackson, GA · Accident · No injuries · Data collection · Final report · Jan 31, 2009 · N620KJ · Substantial damage
  > The pilot's inadvertent activation of an engine cutoff switch during cruise flight.

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

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