# NTSB investigations, VA: Initial climb

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 6 · 285 cases

## Latest cases

- [NTSB ANC26LA066](https://openairdocs.org/ntsb/ANC26LA066.md): Diamond Aircraft Ind DA 40 NG · Petersburg, VA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 29, 2026 · N602RF · Substantial damage
  > On June 29, 2026, about 1945 eastern daylight time (EDT), a Diamond Aircraft Industries Inc. DA40 NG airplane, N602RF, was substantially damaged when it was involved in an accident near Petersburg, Virginia. The flight instructor sustained serious injuries,…
- [NTSB ERA26LA201](https://openairdocs.org/ntsb/ERA26LA201.md): Sky Ranger SKY Ranger 1 · Front Royal, VA · Accident · No injuries · Class 4 · Limited · Final report · May 9, 2026 · N8092S · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in him taking off with the fuel selector in the OFF position, and the subsequent total loss of engine power due to fuel starvation.
- [NTSB ERA25LA203](https://openairdocs.org/ntsb/ERA25LA203.md): Seamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VA · Accident · Serious injuries · Class 3 · Limited · Final report · May 17, 2025 · N154RL · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…
- [NTSB OPS25LA032](https://openairdocs.org/ntsb/OPS25LA032.md): Airbus A319-114 · Arlington, VA · Incident · Class 3 · Limited · Preliminary report · Mar 28, 2025 · N342NB · 2 aircraft · No damage
  > On March 28, 2025, about 1516 eastern daylight time (EDT), DRAGO61, a flight of four US Air Force Northrop T38s, enroute to conduct an aerial flyby at Arlington National Cemetery, and Delta (DAL) Air Lines flight 2983 (DAL2983), an Airbus 319-114, N342NB,…
- [NTSB CEN25FA124](https://openairdocs.org/ntsb/CEN25FA124.md): Robinson Helicopter R44 · Danville, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 15, 2025 · N331ES · Destroyed
  > On March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA24LA361](https://openairdocs.org/ntsb/ERA24LA361.md): Cessna 172 · Lynchburg, VA · Accident · No injuries · Class 3 · Limited · Final report · Aug 29, 2024 · N734SY · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA24FA219](https://openairdocs.org/ntsb/ERA24FA219.md): M-Squared Breese 2 · Culpeper, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 17, 2024 · N99VY · Substantial damage
  > On May 17, 2024, about 1430 eastern daylight time, an M-Squared Aircraft Inc. Breese 2 airplane, N99VY, was involved in an accident near the Culpeper Regional Airport (CJR), Culpeper, Virginia. The commercial pilot was fatally injured. The airplane was…
- [NTSB ERA24LA094](https://openairdocs.org/ntsb/ERA24LA094.md): Cessna 208 · Dulles, VA · Incident · No injuries · Class 3 · Limited · Final report · Jan 19, 2024 · N1983X · Minor damage
  > The pilot-in-command’s approach to the critical angle of attack during initial climb, which resulted in a vibration the flight crew improperly identified as an engine issue and resulted in the subsequent off-airport landing. Contributing to the accident was…
- [NTSB ERA24LA061](https://openairdocs.org/ntsb/ERA24LA061.md): Diamond Aircraft Ind DA 40 · Manassas, VA · Accident · No injuries · Class 4 · Limited · Final report · Nov 29, 2023 · N999VC · Substantial damage
  > An in-flight collision with a bird during initial climb.
- [NTSB ERA24LA007](https://openairdocs.org/ntsb/ERA24LA007.md): Cirrus SR22 · Martinsville, VA · Accident · No injuries · Class 3 · Limited · Final report · Oct 12, 2023 · N253BC · Substantial damage
  > The pilot’s failure to maintain a positive climb rate after takeoff while distracted by primary flight display anomaly and terrain alerts. Contributing to the accident was the pilot’s decision to take off with the airplane over its maximum gross weight, which…
- [NTSB ERA23LA094](https://openairdocs.org/ntsb/ERA23LA094.md): Cessna 177 · Franklin, VA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 26, 2022 · N177D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…
- [NTSB ERA23FA008](https://openairdocs.org/ntsb/ERA23FA008.md): Cessna 172 · Newport News, VA · Accident · 1 fatal · Class 3 · Field · Final report · Oct 6, 2022 · N97883 · Substantial damage
  > The flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.
- [NTSB ERA22LA052](https://openairdocs.org/ntsb/ERA22LA052.md): Maule M-4-220C · Ridgeway, VA · Accident · No injuries · Class 4 · Limited · Final report · Nov 7, 2021 · N51127 · Substantial damage
  > The pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.
- [NTSB ERA21FA148](https://openairdocs.org/ntsb/ERA21FA148.md): Beech C23 · Purcellville, VA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 4, 2021 · N67013 · Substantial damage
  > The pilot's improper decision to depart from the short turf runway with a tailwind.
- [NTSB ERA21LA022](https://openairdocs.org/ntsb/ERA21LA022.md): Champion 7FC · Moneta, VA · Accident · No injuries · Class 4 · Limited · Final report · Oct 14, 2020 · N7532E · Substantial damage
  > The fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.
- [NTSB ERA19LA144](https://openairdocs.org/ntsb/ERA19LA144.md): Robinson R22 · Clover, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 7, 2019 · N4047H · Destroyed
  > The pilot's inadequate visual lookout, which resulted in a collision with trees. Contributing to the accident was the pilot’s decision to takeoff at night without adequate runway lighting.
- [NTSB ERA19FA036](https://openairdocs.org/ntsb/ERA19FA036.md): Titan Tornado 1 · Louisa, VA · Accident · 1 fatal · Field investigation · Final report · Nov 4, 2018 · N38FD · Substantial damage
  > The pilot's failure to maintain airspeed and the airplane's exceedance of its critical angle of attack, which resulted in an aerodynamic stall and spin at a low altitude.
- [NTSB ERA19LA033](https://openairdocs.org/ntsb/ERA19LA033.md): Piper PA28 · New Market, VA · Accident · No injuries · Limited investigation · Final report · Oct 25, 2018 · N68DW · Substantial damage
  > A loss of engine power on takeoff due to restricted air flow to the engine.
- [NTSB ERA19LA019](https://openairdocs.org/ntsb/ERA19LA019.md): Cessna 172 · Lynchburg, VA · Accident · No injuries · Limited investigation · Final report · Oct 18, 2018 · N924MM · Substantial damage
  > The stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a ditch.
- [NTSB ERA18LA169](https://openairdocs.org/ntsb/ERA18LA169.md): Cessna 172D · Quinton, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 16, 2018 · N2777U · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA18LA101](https://openairdocs.org/ntsb/ERA18LA101.md): Piper PA28 · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Mar 13, 2018 · N5646V · Substantial damage
  > The pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.
- [NTSB ERA18CA035](https://openairdocs.org/ntsb/ERA18CA035.md): Driggers Quillan E Titan Tornado · Mechanicsville, VA · Accident · No injuries · Data collection · Final report · Nov 29, 2017 · N50F · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.
- [NTSB ERA18FA006](https://openairdocs.org/ntsb/ERA18FA006.md): Piper PA 25-235 · Front Royal, VA · Accident · 1 fatal · Field investigation · Final report · Oct 7, 2017 · N90866 · Destroyed
  > The tow plane pilot's loss of airplane control for reasons that could not be determined based on the available evidence. Contributing to the accident was the glider instructor's diversion of attention away from the tow airplane which resulted in his delay in…
- [NTSB ERA18LA003](https://openairdocs.org/ntsb/ERA18LA003.md): Freeman Heritage Collection SE5A · Virginia Beach, VA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2017 · N685SE · Substantial damage
  > A partial loss of engine power due to an interruption of the normal fuel/air mixture to the engine.
- [NTSB ERA17LA280](https://openairdocs.org/ntsb/ERA17LA280.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VA · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2017 · N319TA · Substantial damage
  > The flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.
- [NTSB ERA17LA067](https://openairdocs.org/ntsb/ERA17LA067.md): Mathias Linda B Lightning · Franklin, VA · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 2016 · N59JL · Substantial damage
  > A partial loss of engine power due to pre-ignition damage to the No. 2 cylinder piston and the pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall.
- [NTSB ERA16FA288](https://openairdocs.org/ntsb/ERA16FA288.md): Beech 95 B55 (T42A) · Fredericksburg, VA · Accident · 6 fatal · Field investigation · Final report · Aug 12, 2016 · N128VB · Substantial damage
  > The pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.
- [NTSB ERA16LA204](https://openairdocs.org/ntsb/ERA16LA204.md): Bobbi Boucher DUO Deuce · Stafford, VA · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2016 · N808DD · Substantial damage
  > The pilot's failure to attain adequate airspeed during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA15LA300](https://openairdocs.org/ntsb/ERA15LA300.md): Cessna 182 · Hot Springs, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2015 · N7506S · Substantial damage
  > A partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.
- [NTSB ERA15LA282](https://openairdocs.org/ntsb/ERA15LA282.md): North American Navion · Waynesboro, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2015 · N91418 · Substantial damage
  > The pilot's early rotation of the airplane and his failure to attain a positive climb rate during takeoff with the airplane near its aft center of gravity limit from a runway with little margin for error.
- [NTSB ERA15LA212](https://openairdocs.org/ntsb/ERA15LA212.md): Gates Lear Jet 35 · Newport News, VA · Accident · No injuries · Class 2 · Limited · Final report · May 12, 2015 · N80PG · Substantial damage
  > The flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…
- [NTSB ERA15FA170](https://openairdocs.org/ntsb/ERA15FA170.md): Piper PA-28-140 · Orange, VA · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2015 · N32396 · Substantial damage
  > The student pilot's failure to maintain adequate airspeed after takeoff, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA15LA094](https://openairdocs.org/ntsb/ERA15LA094.md): Cessna 172 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Jan 6, 2015 · N2102P · Substantial damage
  > The engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.
- [NTSB ERA14LA302](https://openairdocs.org/ntsb/ERA14LA302.md): Bailey Robert Moyes Dragonfly · Melfa, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2014 · N286A · Substantial damage
  > The pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.
- [NTSB ERA12FA583](https://openairdocs.org/ntsb/ERA12FA583.md): Cessna 150M · Fredericksburg, VA · Accident · 2 fatal · Field investigation · Final report · Sep 29, 2012 · N66246 · Substantial damage
  > The pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.
- [NTSB ERA12CA088](https://openairdocs.org/ntsb/ERA12CA088.md): Anatra Bart T Vans RV-7A · Quinton, VA · Accident · No injuries · Data collection · Final report · Nov 25, 2011 · N816BA · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.
- [NTSB ERA12LA011](https://openairdocs.org/ntsb/ERA12LA011.md): Rivers William J KR-2 · Wytheville, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2011 · N7026G · Substantial damage
  > The pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.
- [NTSB ERA11CA377](https://openairdocs.org/ntsb/ERA11CA377.md): Cessna 150M · Ridgeway, VA · Accident · Serious injuries · Data collection · Final report · Jul 5, 2011 · N9416U · Substantial damage
  > The pilot's decision to takeoff using a flap setting higher than the manufacturer's recommended setting for takeoff.
- [NTSB ERA11LA240](https://openairdocs.org/ntsb/ERA11LA240.md): Piper PA-31-350 · Richmond, VA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 2011 · N3547C · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and subsequent impact with the ground.
- [NTSB ERA11LA234](https://openairdocs.org/ntsb/ERA11LA234.md): Let L 33 Solo · New Castle, VA · Accident · 1 fatal · Limited investigation · Final report · Apr 10, 2011 · N286BA · Substantial damage
  > Pilot incapacitation shortly after takeoff for unknown reasons.
- [NTSB ERA11FA222](https://openairdocs.org/ntsb/ERA11FA222.md): Replogle Lancair 360 · Chesapeake, VA · Accident · 2 fatal · Field investigation · Final report · Apr 3, 2011 · N164T · Substantial damage
  > The pilot did not maintain airspeed following a loss of engine power, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's selection of the wrong fuel tank at takeoff, which resulted in fuel starvation and the total…
- [NTSB ERA10LA377](https://openairdocs.org/ntsb/ERA10LA377.md): Cessna 172N · Waynesboro, VA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2010 · N3480E · Substantial damage
  > The pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.
- [NTSB ERA10FA195](https://openairdocs.org/ntsb/ERA10FA195.md): Piper PA46 · Roanoke, VA · Accident · 1 fatal · Field investigation · Final report · Mar 30, 2010 · N6913Z · Destroyed
  > A malfunction of the flight controls for undetermined reasons.
- [NTSB ERA10FA161](https://openairdocs.org/ntsb/ERA10FA161.md): Cessna T303 · Louisa, VA · Accident · 1 fatal · Field investigation · Final report · Mar 4, 2010 · N9305T · Substantial damage
  > The pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.
- [NTSB ERA09LA494](https://openairdocs.org/ntsb/ERA09LA494.md): Piper PA-28R-201 · Luray, VA · Accident · No injuries · Limited investigation · Final report · Aug 26, 2009 · N186CF · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB ERA09LA452](https://openairdocs.org/ntsb/ERA09LA452.md): Maxair Drifter · Bumpass, VA · Accident · 1 fatal · Limited investigation · Final report · Aug 9, 2009 · N160HA · Substantial damage
  > The accelerated stall induced by the pilot in a steep turn to avoid obstacles during takeoff. Contributing to the accident were the pilot’s chosen takeoff path and the density altitude.
- [NTSB ERA09LA347](https://openairdocs.org/ntsb/ERA09LA347.md): Cessna 150H · Lawrenceville, VA · Accident · No injuries · Limited investigation · Final report · Jun 13, 2009 · N22075 · Substantial damage
  > A loss of engine power due to carburetor icing.
- [NTSB ERA09LA043](https://openairdocs.org/ntsb/ERA09LA043.md): Miller J Kirtley RV-6 · Martinsville, VA · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2008 · N8LK · Substantial damage
  > The pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.
- [NTSB MIA08CA191](https://openairdocs.org/ntsb/MIA08CA191.md): Airframes Unlimited USA-1B · Surry, VA · Accident · No injuries · Data collection · Final report · Sep 7, 2008 · N723JH · Substantial damage
  > The pilot's improper handling of the powered parachute during takeoff/initial climb.
- [NTSB NYC08CA294](https://openairdocs.org/ntsb/NYC08CA294.md): Sacrey W Michael Zenair CH · Fincastle, VA · Accident · No injuries · Data collection · Final report · Aug 22, 2008 · N404BB · Substantial damage
  > The pilot's inadvertent premature rotation during takeoff.

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

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