# NTSB investigations, GA: Midair collision

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 ATL98FA060](https://openairdocs.org/ntsb/ATL98FA060.md): Cessna 525 · Marietta, GA · Accident · 5 fatal · Field investigation · Final report · Apr 4, 1998 · N111LR · 2 aircraft · Destroyed
  > The failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…
- [NTSB ATL93FA082](https://openairdocs.org/ntsb/ATL93FA082.md): American AA-1A · Statesboro, GA · Accident · 2 fatal · Field investigation · Final report · Apr 28, 1993 · N9317L · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…
- [NTSB ATL93FA061](https://openairdocs.org/ntsb/ATL93FA061.md): Robinson R22B · Atlanta, GA · Accident · 4 fatal · Field investigation · Final report · Feb 19, 1993 · N621SG · 2 aircraft · Destroyed
  > The failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…
- [NTSB ATL91FA108](https://openairdocs.org/ntsb/ATL91FA108.md): Cessna T37B · Chickamauga, GA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1991 · N120DB · 2 aircraft · Destroyed
  > The T-37 pilot misjudged the clearance between his aircraft and the A-26.
- [NTSB ATL87FA130](https://openairdocs.org/ntsb/ATL87FA130.md): Cessna 182R · Kennesaw, GA · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1987 · N5511N · 2 aircraft · Destroyed
  > N5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with…
- [NTSB MIA84FA241](https://openairdocs.org/ntsb/MIA84FA241.md): Cessna 152 · Valdosta, GA · Accident · 4 fatal · Field investigation · Final report · Aug 25, 1984 · N25853 · 2 aircraft · Destroyed
  > The two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…

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

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