# NTSB investigations, GA: Aircraft inspection event

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 ERA24LA158](https://openairdocs.org/ntsb/ERA24LA158.md): Jmmt Vans RV9A · Jasper, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 29, 2024 · N387E · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined due to impact-related damage.
- [NTSB ERA24LA006](https://openairdocs.org/ntsb/ERA24LA006.md): Piper PA28 · Jonesboro, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 11, 2023 · N55162 · Substantial damage
  > Both pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA20LA035](https://openairdocs.org/ntsb/ERA20LA035.md): Beech 55 · Griffin, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 9, 2019 · N686DR · Substantial damage
  > The pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.
- [NTSB ERA10LA351](https://openairdocs.org/ntsb/ERA10LA351.md): Champion 7ECA · Thomasville, GA · Accident · No injuries · Limited investigation · Final report · Jun 17, 2010 · N73PC · Substantial damage
  > The improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.
- [NTSB ERA09LA257](https://openairdocs.org/ntsb/ERA09LA257.md): Maule M-5-180C · Moultrie, GA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2009 · N66VJ · Substantial damage
  > A loss of engine power due to carburetor icing as a result of the maintenance technician's failure to detect and correct the condition of the carburetor heat duct.
- [NTSB MIA08LA187](https://openairdocs.org/ntsb/MIA08LA187.md): Piper J5A · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Sep 7, 2008 · N105F · Substantial damage
  > The loss of pitch control due to slippage of the elevator control cable resulting from the maintenance personnel’s improper installation and inspection of the cable.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' 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/050/sequence?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.