# NTSB investigations, NC: Vortex turbulence encountered

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 ATL89LA038](https://openairdocs.org/ntsb/ATL89LA038.md): Cessna 152F · Harkers Island, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1988 · N8225F · Destroyed
  > The plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…
- [NTSB ATL87LA211](https://openairdocs.org/ntsb/ATL87LA211.md): Cessna 172M · Raleigh, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1987 · N80929 · Destroyed
  > The pilot was vectored for landing on runway 23R behind a Boeing 727. The approach controller advised the pilot that he could land on 23L if he preferred but the pilot elected to continue with the approach to 23R. The tower controller cleared the flight to…

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

This list as a web page: https://openairdocs.org/ntsb?occurrence=410&state=NC

---
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.