# Fatal NTSB investigations, VA: Fire/smoke (post-impact)

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 ERA18FA150](https://openairdocs.org/ntsb/ERA18FA150.md): Piper PA28 · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · May 22, 2018 · N6177W · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.
- [NTSB ERA17FA274](https://openairdocs.org/ntsb/ERA17FA274.md): Bell 407 · Charlottesville, VA · Accident · 2 fatal · Field investigation · Final report · Aug 12, 2017 · N31VA · Destroyed
  > The pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…
- [NTSB ERA13FA385](https://openairdocs.org/ntsb/ERA13FA385.md): Piper PA-28-161 · Danville, VA · Accident · 1 fatal · Field investigation · Final report · Aug 29, 2013 · N9089N · Destroyed
  > The student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…
- [NTSB MIA08FA094](https://openairdocs.org/ntsb/MIA08FA094.md): Mooney M20M · Midlothian, VA · Accident · 2 fatal · Field investigation · Final report · Apr 27, 2008 · N429RM · Destroyed
  > The pilot’s improper control inputs resulting from spatial disorientation.

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

This list as a web page: https://openairdocs.org/ntsb-events/170/sequence?fatal=1&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
