# NTSB investigations, 2006: 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 SEA07IA019](https://openairdocs.org/ntsb/SEA07IA019.md): Cessna 172 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Nov 16, 2006 · N9522S · No damage
  > The instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…
- [NTSB CHI06FA154](https://openairdocs.org/ntsb/CHI06FA154.md): Piper PA-32R-301T · Parkville, MO · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2006 · N292HH · Destroyed
  > The pilot's improperly planned approach which resulted in the encounter with wake turbulence while the airplane's airspeed exceeded maneuvering speed. This encounter resulted in the subsequent loss of aircraft control and the in-flight separation of the left…
- [NTSB DEN06LA038](https://openairdocs.org/ntsb/DEN06LA038.md): Canadair CL-600 · Aspen, CO · Accident · No injuries · Limited investigation · Final report · Feb 9, 2006 · N900LG · Substantial damage
  > the flight's encounter with wake turbulence from the departing airplane resulting in the pilot's inability to control the airplane and the subsequent impact with the runway.

## 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 year(c."eventDate") = 2006
  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&year=2006

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