# NTSB investigations, VA: Approach

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 8 · 367 cases

## Latest cases

- [NTSB CEN26FA253](https://openairdocs.org/ntsb/CEN26FA253.md): Montana Coyote · Fredericksburg, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N448VQ · Substantial damage
  > On July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…
- [NTSB ERA25LA354](https://openairdocs.org/ntsb/ERA25LA354.md): Jonker Sailplanes JS3 · New Castle, VA · Accident · No injuries · Class 4 · Limited · Final report · Sep 13, 2025 · N68MF · Substantial damage
  > The pilot’s failure to properly configure the glider for landing, which resulted in an excessive descent rate during approach, and subsequent collision with trees short of the intended landing area.
- [NTSB ERA25LA210](https://openairdocs.org/ntsb/ERA25LA210.md): Vans RV-12 · Abingdon, VA · Accident · Serious injuries · Class 4 · Limited · Final report · May 24, 2025 · N813JC · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA25LA189](https://openairdocs.org/ntsb/ERA25LA189.md): Champion 7GCBC · Weyers Cave, VA · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2025 · N9117L · Substantial damage
  > A total loss of engine power on approach due to carburetor ice.
- [NTSB ERA25LA011](https://openairdocs.org/ntsb/ERA25LA011.md): Saint Glasair II SFT · Forest, VA · Accident · No injuries · Class 3 · Limited · Final report · Oct 11, 2024 · N952W · Substantial damage
  > The installation of a non-failsafe coupler that resulted in the separation of the throttle cable from the throttle arm and a subsequent partial loss of engine power.
- [NTSB ERA24FA136](https://openairdocs.org/ntsb/ERA24FA136.md): Israel Aircraft Industries 1125 Westwind Astra · Hot Springs, VA · Accident · 5 fatal · Class 3 · Field · Final report · Mar 10, 2024 · N1125A · Destroyed
  > The PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…
- [NTSB ERA24LA137](https://openairdocs.org/ntsb/ERA24LA137.md): Cessna 172 · Leesburg, VA · Accident · No injuries · Class 4 · Limited · Final report · Mar 1, 2024 · N1057R · Substantial damage
  > An in-flight collision with a bird while on the downwind leg of the airport traffic pattern.
- [NTSB ERA24FA053](https://openairdocs.org/ntsb/ERA24FA053.md): Beech C23 · Midland, VA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 3, 2023 · N76SB · Destroyed
  > The pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…
- [NTSB ERA23FA103](https://openairdocs.org/ntsb/ERA23FA103.md): Piper PA28 · Suffolk, VA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 7, 2023 · N592FL · Destroyed
  > The pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…
- [NTSB ERA23LA068](https://openairdocs.org/ntsb/ERA23LA068.md): Piper PA28 · Manassas, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 21, 2022 · N7261F · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA22LA084](https://openairdocs.org/ntsb/ERA22LA084.md): Cessna 172S · Midland, VA · Accident · No injuries · Class 4 · Limited · Final report · Dec 3, 2021 · N2100S · Substantial damage
  > Collision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.
- [NTSB ERA21LA202](https://openairdocs.org/ntsb/ERA21LA202.md): Cessna 172S · Martinsville, VA · Accident · No injuries · Class 4 · Limited · Final report · May 2, 2021 · N1089D · Substantial damage
  > The pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.
- [NTSB ERA21LA183](https://openairdocs.org/ntsb/ERA21LA183.md): Piper PA-28-140 · Weyers Cave, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 12, 2021 · N7242F · Substantial damage
  > Maintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.
- [NTSB ERA20LA195](https://openairdocs.org/ntsb/ERA20LA195.md): Piper PA24 · South Boston, VA · Accident · No injuries · Class 3 · Limited · Final report · May 26, 2020 · N5948P · Substantial damage
  > The powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.
- [NTSB ERA20FA097](https://openairdocs.org/ntsb/ERA20FA097.md): Aviastroitel AC 4C · Front Royal, VA · Accident · 1 fatal · Class 3 · Field · Final report · Feb 9, 2020 · N912ES · Substantial damage
  > The pilot's exceedance of the glider’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB ERA20CA072](https://openairdocs.org/ntsb/ERA20CA072.md): Beech 23 · Norfolk, VA · Accident · Minor injuries · Data collection · Final report · Jan 7, 2020 · N24690 · Substantial damage
  > The pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.
- [NTSB ERA19FA066](https://openairdocs.org/ntsb/ERA19FA066.md): Eipper Quicksilver · Fredericksburg, VA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2018 · N350FT · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.
- [NTSB GAA18CA537](https://openairdocs.org/ntsb/GAA18CA537.md): Cessna 180 · Richmond, VA · Accident · No injuries · Data collection · Final report · Sep 5, 2018 · C-GODA · Substantial damage
  > The pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the total loss of engine power.
- [NTSB ERA18LA233](https://openairdocs.org/ntsb/ERA18LA233.md): Cessna 172 · New Kent, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 26, 2018 · N1537U · Substantial damage
  > The student pilot’s loss of airplane control during a go-around.
- [NTSB GAA18CA215](https://openairdocs.org/ntsb/GAA18CA215.md): Page Russell L Long EZ · Wakefield, VA · Accident · No injuries · Data collection · Final report · Apr 13, 2018 · N27RP · Substantial damage
  > The pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…
- [NTSB ERA17LA229](https://openairdocs.org/ntsb/ERA17LA229.md): Aviat A-1C-180 · Dillwyn, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2017 · N272WY · Substantial damage
  > The pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.
- [NTSB ERA17CA186](https://openairdocs.org/ntsb/ERA17CA186.md): Piper PA 28-181 · Bristow, VA · Accident · No injuries · Data collection · Final report · May 21, 2017 · N8304F · Substantial damage
  > The flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.
- [NTSB ERA17LA165](https://openairdocs.org/ntsb/ERA17LA165.md): Ganjoo Amit Sonex · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2017 · N212AG · Substantial damage
  > The pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.
- [NTSB GAA17CA241](https://openairdocs.org/ntsb/GAA17CA241.md): American AA 1 · New Market, VA · Accident · Minor injuries · Data collection · Final report · Apr 9, 2017 · N5690L · Substantial damage
  > The pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.
- [NTSB GAA17CA208](https://openairdocs.org/ntsb/GAA17CA208.md): Dempsey Daniel M Zodiac CH601XLB · Louisa, VA · Accident · No injuries · Data collection · Final report · Mar 25, 2017 · N978ER · Substantial damage
  > The pilot’s in-flight fuel mismanagement and subsequent failure to maintain adequate airspeed while attempting to land on the runway, which resulted in an aerodynamic stall and a hard landing.
- [NTSB DCA16CA226](https://openairdocs.org/ntsb/DCA16CA226.md): Bombardier DHC 8 202 · Dulles, VA · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N366PH · Substantial damage
  > incorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.
- [NTSB ERA16LA322](https://openairdocs.org/ntsb/ERA16LA322.md): Aero Vodochody L 39 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Sep 23, 2016 · N139AJ · Substantial damage
  > An uncommanded flap retraction for reasons that could not be determined, as a postaccident examination of the flap system did not reveal evidence of any preaccident anomalies.
- [NTSB ERA16CA211](https://openairdocs.org/ntsb/ERA16CA211.md): Piper PA-28 · Williamsburg, VA · Accident · Serious injuries · Data collection · Final report · Jun 10, 2016 · N9297J · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a go-around which led to the airplane exceeding its critical angle-of-attack and experiencing aerodynamic stall.
- [NTSB ERA16LA179](https://openairdocs.org/ntsb/ERA16LA179.md): Taylorcraft BC12 D · Critz, VA · Accident · Serious injuries · Limited investigation · Final report · May 7, 2016 · N43363 · Substantial damage
  > The pilot’s failure to maintain airspeed while on final approach, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.
- [NTSB GAA16CA066](https://openairdocs.org/ntsb/GAA16CA066.md): Grumman American Avn. AA 5 · West Point, VA · Accident · No injuries · Data collection · Final report · Dec 2, 2015 · N28295 · Substantial damage
  > The pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.
- [NTSB ERA15LA354](https://openairdocs.org/ntsb/ERA15LA354.md): Cessna 177 · Moneta, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 2015 · N2835X · Substantial damage
  > The pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…
- [NTSB ERA15LA315](https://openairdocs.org/ntsb/ERA15LA315.md): Piper PA 28-161 · Bristow, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2015 · N82587 · Substantial damage
  > The student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.
- [NTSB ERA15LA257](https://openairdocs.org/ntsb/ERA15LA257.md): Piper PA28 · Galax Hillsville, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 2015 · N43503 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning onto the final approach leg of the traffic pattern, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA15FA144](https://openairdocs.org/ntsb/ERA15FA144.md): Mooney M20F · Norfolk, VA · Accident · 3 fatal · Field investigation · Final report · Mar 4, 2015 · N66BB · Substantial damage
  > The pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…
- [NTSB ERA15CA012](https://openairdocs.org/ntsb/ERA15CA012.md): Schweizer SGS 2 33A · Waynesboro, VA · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N3619T · Substantial damage
  > The glider's inadvertent encounter with low altitude wind shear.
- [NTSB ERA14FA328](https://openairdocs.org/ntsb/ERA14FA328.md): Cessna 150J · Topping, VA · Accident · 2 fatal · Field investigation · Final report · Jul 6, 2014 · N50824 · Substantial damage
  > The pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.
- [NTSB ERA14FA231](https://openairdocs.org/ntsb/ERA14FA231.md): Eagle C-7 · Ruther Glen, VA · Accident · 3 fatal · Field investigation · Final report · May 9, 2014 · N3016Z · Destroyed
  > The pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.
- [NTSB ERA14FA075](https://openairdocs.org/ntsb/ERA14FA075.md): Beech A36TC · Chatlottesville, VA · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2013 · N3705Z · Substantial damage
  > The pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…
- [NTSB ERA14LA006](https://openairdocs.org/ntsb/ERA14LA006.md): Cessna 340A · Hampton Roads, VA · Accident · 4 fatal · Limited investigation · Final report · Oct 10, 2013 · N4TK · Destroyed
  > The pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.
- [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 ERA13FA227](https://openairdocs.org/ntsb/ERA13FA227.md): Newgent, Barry S6S · Suffolk, VA · Accident · 2 fatal · Field investigation · Final report · May 4, 2013 · N388KB · Destroyed
  > The pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…
- [NTSB ERA13FA209](https://openairdocs.org/ntsb/ERA13FA209.md): Cessna 210E · Williamsburg, VA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2013 · N111BK · Substantial damage
  > The pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.
- [NTSB ERA13LA173](https://openairdocs.org/ntsb/ERA13LA173.md): New Piper PA32-301FT · Stafford, VA · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 2013 · N32EV · Substantial damage
  > The pilot's improper placement of the fuel tank selector handle during approach, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA13LA065](https://openairdocs.org/ntsb/ERA13LA065.md): Beech C90A · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2012 · N702DK · Substantial damage
  > The failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…
- [NTSB OPS12IA849](https://openairdocs.org/ntsb/OPS12IA849.md): Arlington, VA · Incident · No injuries · Incident investigation · Final report · Jul 31, 2012 · No damage
  > A hearback/readback error on the part of the tower traffic management coordinator, who did not understand the request being made by the approach control area supervisor and then communicated that misunderstanding to the local controllers. Contributing to the…
- [NTSB ERA12LA486](https://openairdocs.org/ntsb/ERA12LA486.md): Piper PA-24-250 · Blacksburg, VA · Accident · No injuries · Limited investigation · Final report · Jul 27, 2012 · N6248P · Substantial damage
  > The pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA12CA054](https://openairdocs.org/ntsb/ERA12CA054.md): Aeros Trike · Amherst, VA · Accident · Serious injuries · Data collection · Final report · Oct 30, 2011 · N6111F · Substantial damage
  > The student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.
- [NTSB ERA12CA019](https://openairdocs.org/ntsb/ERA12CA019.md): Aeronca 7AC · Manassas, VA · Accident · Minor injuries · Data collection · Final report · Oct 22, 2011 · N4300E · Substantial damage
  > The pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.
- [NTSB ERA11FA443](https://openairdocs.org/ntsb/ERA11FA443.md): Maule M-7-235 · Warrenton, VA · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2011 · N747GL · Substantial damage
  > The pilot's inadequate airspeed and excessive bank angle while maneuvering for landing, which resulted in an aerodynamic stall.
- [NTSB ERA11CA423](https://openairdocs.org/ntsb/ERA11CA423.md): Piper PA-28-161 · Quinton, VA · Accident · Minor injuries · Data collection · Final report · Jul 26, 2011 · N81917 · Substantial damage
  > The pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.

Next page: https://openairdocs.org/ntsb-phases/500/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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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