# NTSB investigations, 2009: Abrupt maneuver

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 ERA10LA041](https://openairdocs.org/ntsb/ERA10LA041.md): Boeing 717-200 · Pleasant Grove, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2009 · N935AT · No damage
  > The captain's excessive maneuver in response to a traffic alert and collision avoidance system (TCAS) alert, which resulted in a serious injury to a flight attendant. Contributing to the accident was the operator's inadequate TCAS training and guidance.
- [NTSB WPR09GA407](https://openairdocs.org/ntsb/WPR09GA407.md): Air Tractor AT-802A · Austin, NV · Accident · 1 fatal · Final report · Aug 20, 2009 · N807MA · Substantial damage
  > The pilot’s failure to maintain a stabilized approach prior to the retardant drop and his subsequent failure to release the retardant load, resulting in a stall/mush and collision with terrain.
- [NTSB WPR09CA232](https://openairdocs.org/ntsb/WPR09CA232.md): Atkins John RAF 2000 G · South Prairie, WA · Accident · Minor injuries · Data collection · Final report · May 9, 2009 · N1435X · Substantial damage
  > The pilot's abrupt maneuver to avoid a collision that resulted in an airspeed reduction and subsequent loss of lift provided by the rotor system. Contributing to the accident was the failure of both pilots to maintain an adequate visual lookout for other…
- [NTSB ERA09FA148](https://openairdocs.org/ntsb/ERA09FA148.md): Cirrus Design SR22 · Moncks Corner, SC · Accident · 1 fatal · Field investigation · Final report · Jan 29, 2009 · N224SB · Substantial damage
  > A loss of aircraft control during the landing approach for undetermined reasons.

## 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") = 2009
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '270')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/270/cases?year=2009

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