# NTSB investigations, GA: On ground/water encounter with weather

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 ATL94LA066](https://openairdocs.org/ntsb/ATL94LA066.md): Boeing PT-17 · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1994 · N57TH · Substantial damage
  > The pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.
- [NTSB ATL87LA227](https://openairdocs.org/ntsb/ATL87LA227.md): Piper PA-18-150 · Hopeful, GA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1987 · N1023K · Substantial damage
  > The plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…
- [NTSB ATL86LA215](https://openairdocs.org/ntsb/ATL86LA215.md): Maule M-7-235 · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N56616 · Substantial damage
  > The plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=330&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.