# NTSB investigations, GA: Repair

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 ERA17FA050](https://openairdocs.org/ntsb/ERA17FA050.md): Curtiss JN4 · Williamson, GA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2016 · N1662 · Destroyed
  > The in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…
- [NTSB MIA08LA133](https://openairdocs.org/ntsb/MIA08LA133.md): Rockwell International S-2R · Colquitt, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 2008 · N8499V · Substantial damage
  > Loss of engine power due to the installation of incorrect turbine blades on the compressor turbine disk during repair of the disk assembly.

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

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