# NTSB investigations, VA: Roll over

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 NYC02LA149](https://openairdocs.org/ntsb/NYC02LA149.md): Robinson R-22B · Madison Heights, VA · Accident · No injuries · Limited investigation · Final report · Jul 30, 2002 · N8347Y · Substantial damage
  > The pilot's failure to attain the proper touchdown point on the helipad, which resulted in a rollover. A factor in this accident was pilot fatigue.
- [NTSB IAD01LA041](https://openairdocs.org/ntsb/IAD01LA041.md): Bell BH-206-B · Ringgold, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 2001 · N17HA · Substantial damage
  > pilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.
- [NTSB NYC00LA152](https://openairdocs.org/ntsb/NYC00LA152.md): Schweizer 269-C1 · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Jun 3, 2000 · N721CB · Substantial damage
  > the failure of the student pilot to reduce the friction on the cyclic prior to raising the collective for the magneto check. A factor was the failure of the company to adequately define the steps in the checklist.
- [NTSB ATL82DA091](https://openairdocs.org/ntsb/ATL82DA091.md): Cessna 172 · Chantilly, VA · Accident · No injuries · Final report · Apr 4, 1982 · N5510D · Substantial damage
  > The pilot flew into an area of high forecast winds and altered his destination as a precaution. However, he failed to ask for or take precautionary measures after landing and the aircraft was blown over while taxiing.

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

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

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