# NTSB investigations, VA: Maneuvering

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.

Page 1 of 4 · 188 cases

## Latest cases

- [NTSB ERA26LA232](https://openairdocs.org/ntsb/ERA26LA232.md): North American SNJ-5C · Midland, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 6, 2026 · N98RJ · Substantial damage
  > On June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA195](https://openairdocs.org/ntsb/ERA26LA195.md): Air Tractor AT-602 · Bealeton, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N602RH · Substantial damage
  > On May 1, 2026, at 1230 eastern daylight time, an Air Tractor AT-602, N602RH, was substantially damaged when it was involved in an accident near Bealeton, Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA25FA065](https://openairdocs.org/ntsb/ERA25FA065.md): Truitt James B Vans RV-8A · Fort Blackmore, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 4, 2024 · N627TT · Substantial damage
  > On December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was…
- [NTSB ERA23LA326](https://openairdocs.org/ntsb/ERA23LA326.md): Hughes 369 · Elberon, VA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 5, 2023 · N353AH · Substantial damage
  > The pilot’s failure to maintain clearance from a power line structure arm, which resulted in main rotor blade contact.
- [NTSB ERA23FA260](https://openairdocs.org/ntsb/ERA23FA260.md): Vans RV6 · Colonial Beach, VA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 7, 2023 · N835BC · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.
- [NTSB ERA22LA302](https://openairdocs.org/ntsb/ERA22LA302.md): Air Tractor AT-502B · Center Cross, VA · Accident · No injuries · Class 3 · Limited · Final report · Jul 8, 2022 · N50075 · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA22LA238](https://openairdocs.org/ntsb/ERA22LA238.md): MX MXS · Bealeton, VA · Accident · No injuries · Class 4 · Limited · Final report · May 22, 2022 · N104MX · Substantial damage
  > An inflight collision with a bird while conducting low level aerobatics.
- [NTSB ERA21LA053](https://openairdocs.org/ntsb/ERA21LA053.md): Beech V35 · Deltaville, VA · Accident · 1 fatal · Class 3 · Limited · Final report · Nov 24, 2020 · N35AW · Destroyed
  > An uncontrolled descent and impact with terrain following an in-flight collision with seagulls.
- [NTSB ERA20CA178](https://openairdocs.org/ntsb/ERA20CA178.md): Schempp Hirth Ventus 2CT · Stuarts Draft, VA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 11, 2020 · N514TW · Substantial damage
  > A loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.
- [NTSB ERA20LA080](https://openairdocs.org/ntsb/ERA20LA080.md): Team Rocket F-1 F-1 · Suffolk, VA · Accident · No injuries · Class 3 · Limited · Final report · Dec 24, 2019 · N230BW · Substantial damage
  > A structural failure of the horizontal stabilizer during aerobatic maneuvers near the airplane’s never-exceed speed. Contributing to the failure was the construction of the horizontal stabilizer that did not meet the kit manufacturer’s specifications.
- [NTSB ERA19TA098](https://openairdocs.org/ntsb/ERA19TA098.md): Cessna 172 · Lignum, VA · Accident · Minor injuries · Class 3 · Final report · Feb 10, 2019 · N7414N · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA19FA010](https://openairdocs.org/ntsb/ERA19FA010.md): Vans RV8 · Culpeper, VA · Accident · 1 fatal · Class 2 · Field · Final report · Oct 12, 2018 · N804RL · Destroyed
  > The pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.
- [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 ERA15LA375](https://openairdocs.org/ntsb/ERA15LA375.md): Schempp-Hirth Ventus 2CT · Blacksburg, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2015 · N710JC · Substantial damage
  > A loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.
- [NTSB ERA15CA120](https://openairdocs.org/ntsb/ERA15CA120.md): Piper PA 18-150 · Brookneal, VA · Accident · Minor injuries · Data collection · Final report · Feb 4, 2015 · N619GB · Substantial damage
  > The flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15FA076](https://openairdocs.org/ntsb/ERA15FA076.md): Titan Tornado II · Catlett, VA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2014 · N50402 · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA15CA059](https://openairdocs.org/ntsb/ERA15CA059.md): Hiller OH 23B · Leesburg, VA · Accident · No injuries · Data collection · Final report · Nov 24, 2014 · N6057 · Substantial damage
  > A loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.
- [NTSB ERA14FA445](https://openairdocs.org/ntsb/ERA14FA445.md): North American T 28C · Alton, VA · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2014 · N531KG · Destroyed
  > The pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.
- [NTSB ERA14LA319](https://openairdocs.org/ntsb/ERA14LA319.md): Waco UPF 7 · Warrenton, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2014 · N32162 · Substantial damage
  > A total loss of engine power during a low pass for reasons that could not be determined during postaccident examination of the engine.
- [NTSB ERA14CA262](https://openairdocs.org/ntsb/ERA14CA262.md): Evolution Trikes Revo · Williamsburg, VA · Accident · Minor injuries · Data collection · Final report · May 25, 2014 · N9912S · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water.
- [NTSB ERA13FA330](https://openairdocs.org/ntsb/ERA13FA330.md): Cessna 172M · Fredericksburg, VA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2013 · N61954 · Substantial damage
  > The pilot's intentional descent into the ground to commit suicide.
- [NTSB ERA12FA527](https://openairdocs.org/ntsb/ERA12FA527.md): Bell 407 · Abingdon, VA · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2012 · N407N · Substantial damage
  > The pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…
- [NTSB ERA12RA367](https://openairdocs.org/ntsb/ERA12RA367.md): Beech V35B · Sumerduck, VA · Accident · 2 fatal · Foreign investigation · May 28, 2012 · N6658R · 2 aircraft · Destroyed
  > On May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…
- [NTSB ERA11LA216](https://openairdocs.org/ntsb/ERA11LA216.md): Hiller UH-12E · Culpeper, VA · Accident · No injuries · Limited investigation · Final report · Mar 25, 2011 · N4033P · Substantial damage
  > Mechanical failure of the transmission for reasons that could not be determined because the transmission could not be torn down.
- [NTSB ERA11FA101](https://openairdocs.org/ntsb/ERA11FA101.md): Cessna 172H · Weyers Cave, VA · Accident · 2 fatal · Field investigation · Final report · Dec 31, 2010 · N2876L · 2 aircraft · Substantial damage
  > The inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…
- [NTSB ERA10FA435](https://openairdocs.org/ntsb/ERA10FA435.md): North Wing Scout X-C · Amherst, VA · Accident · 2 fatal · Field investigation · Final report · Aug 21, 2010 · N417JN · Substantial damage
  > The pilot's loss of aircraft control for an undetermined reason.
- [NTSB ERA10LA387](https://openairdocs.org/ntsb/ERA10LA387.md): Schweizer SGS 2-33AK · Windsor, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2010 · N17965 · Substantial damage
  > The unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.
- [NTSB ERA10FA346](https://openairdocs.org/ntsb/ERA10FA346.md): Cessna 172P · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · Jul 5, 2010 · N52614 · Substantial damage
  > The airplane's impact with terrain for undetermined reasons following the pilot's report of a flight control malfunction.
- [NTSB ERA10LA098](https://openairdocs.org/ntsb/ERA10LA098.md): Czech Aircraft Works Sportcruiser · Suffolk, VA · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 2009 · N524SC · Substantial damage
  > The pilot's inadequate recovery from a stall and inadvertent spin. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information. Also contributing was the instructor's inadequate…
- [NTSB ERA09LA441](https://openairdocs.org/ntsb/ERA09LA441.md): Mooney M20F · Suffolk, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2009 · N3549N · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.
- [NTSB ERA09FA376](https://openairdocs.org/ntsb/ERA09FA376.md): Pilatus PC-12/45 · Raphine, VA · Accident · 4 fatal · Field investigation · Final report · Jul 5, 2009 · N578DC · Substantial damage
  > The pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.
- [NTSB ERA09LA344](https://openairdocs.org/ntsb/ERA09LA344.md): Dehavilland DHC-6 Twin · Orange, VA · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2009 · N204EH · No damage
  > The pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.
- [NTSB ERA09LA317](https://openairdocs.org/ntsb/ERA09LA317.md): Hughes 369D · Greenville, VA · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2009 · N8356F · Substantial damage
  > The inadequate design of the fourth-stage turbine wheel, resulting in the fatigue failure of one airfoil and a subsequent loss of engine power.
- [NTSB NYC08LA318](https://openairdocs.org/ntsb/NYC08LA318.md): Hiller UH-12E · Naruna, VA · Accident · No injuries · Limited investigation · Final report · Sep 16, 2008 · N3324F · Substantial damage
  > The fatigue failure of a main rotor blade drag strut.
- [NTSB NYC08FA292](https://openairdocs.org/ntsb/NYC08FA292.md): Steven A. Jones Lancair IV P · Stafford, VA · Accident · No injuries · Field investigation · Final report · Aug 11, 2008 · N731SJ · Substantial damage
  > The pilot's decision to install voltage regulators in the engine compartment where they were susceptible to water intrusion, which resulted in a malfunction of the standby electrical system's voltage regulator and a subsequent in-flight fire.
- [NTSB NYC08LA254](https://openairdocs.org/ntsb/NYC08LA254.md): Schweizer 269C-1 · Northumberland, VA · Accident · No injuries · Limited investigation · Final report · Jul 11, 2008 · N61425 · Substantial damage
  > The pilot's inadequate remedial action after an inadvertent encounter with loss of tail rotor effectiveness.
- [NTSB MIA08LA105](https://openairdocs.org/ntsb/MIA08LA105.md): Aviate Raptor · Bealeton, VA · Accident · 1 fatal · Limited investigation · Final report · May 23, 2008 · N74TK · Substantial damage
  > An in-flight loss of control for undetermined reasons.
- [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.
- [NTSB NYC08LA043](https://openairdocs.org/ntsb/NYC08LA043.md): Robinson R22 · Suffolk, VA · Accident · No injuries · Limited investigation · Final report · Nov 24, 2007 · N442FA · Substantial damage
  > The V-drive belts' rolling off the sheaves for undetermined reasons, resulting in a loss of power to the rotor system, and the pilot's failure to maintain adequate rotor rpm during the autorotation, resulting in a hard landing.
- [NTSB NYC08LA005](https://openairdocs.org/ntsb/NYC08LA005.md): Pelt Mad Max II Special · Blacksburg, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2007 · N26VT · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was a lack of suitable terrain for a forced landing.
- [NTSB NYC07LA219](https://openairdocs.org/ntsb/NYC07LA219.md): North American SNJ-2 · Virginia Beach, VA · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2007 · N52033 · Destroyed
  > The pilot's inability to maintain control of the airplane due to physiological incapacitation. Contributing to the accident was the failure of the Federal Aviation Administration to deny or restrict the pilot's medical certification, and the pilot's improper…
- [NTSB NYC07LA174](https://openairdocs.org/ntsb/NYC07LA174.md): Wolfe Titan · Surry, VA · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2007 · UNREG · Substantial damage
  > The pilot's failure to maintain aircraft control for undetermined reasons. Contributing to the accident was the pilot's lack of recent experience.
- [NTSB NYC07LA136](https://openairdocs.org/ntsb/NYC07LA136.md): Beech K35 · Cross Junction, VA · Accident · No injuries · Limited investigation · Final report · Jun 11, 2007 · N615T · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB NYC07FA025](https://openairdocs.org/ntsb/NYC07FA025.md): Czech Aircraft Works CH 601 XL RTF · Basye, VA · Accident · 1 fatal · Field investigation · Final report · Nov 11, 2006 · N601VA · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB NYC07LA008](https://openairdocs.org/ntsb/NYC07LA008.md): Flynn William Pazmany PL-4 · Fredricksburg, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 15, 2006 · N640F · Substantial damage
  > The pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.
- [NTSB NYC07FA007](https://openairdocs.org/ntsb/NYC07FA007.md): Extra Flugzeugbau Gmbh 300 · Culpeper, VA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2006 · N168EX · Destroyed
  > The pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.
- [NTSB NYC06LA115](https://openairdocs.org/ntsb/NYC06LA115.md): Embraer 145LR · Winchester, VA · Accident · Serious injuries · Limited investigation · Final report · May 13, 2006 · N653AE · No damage
  > The passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.
- [NTSB NYC06LA073](https://openairdocs.org/ntsb/NYC06LA073.md): Cessna 182D · Weyers Cave, VA · Accident · 1 fatal · Limited investigation · Final report · Feb 24, 2006 · N9178X · Destroyed
  > The pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.
- [NTSB NYC06LA024](https://openairdocs.org/ntsb/NYC06LA024.md): Lo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 2005 · N41094 · Substantial damage
  > Failure of the ignition system, which resulted in a loss of engine power.
- [NTSB NYC05LA096](https://openairdocs.org/ntsb/NYC05LA096.md): Hall Maxair Drifter · Gloucester, VA · Accident · 1 fatal · Limited investigation · Final report · Jun 12, 2005 · N9238V · Substantial damage
  > The in-flight separation of the empennage, which resulted in a loss of control and subsequent impact with the ground.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=VA&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?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.