NTSB investigations, VA
190 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA18CA550Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA18CA513Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.NTSB GAA18CA414Accident · No injuriesData collectionFinal reportNorth American AT · Moneta, VAThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing and his subsequent failure to maintain directional.NTSB ERA18LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172D · Quinton, VAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18FA150Accident · 1 fatalField investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.NTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.NTSB ERA18FA127Accident · 1 fatalField investigationFinal reportCessna 525 · Crozet, VAThe pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting…NTSB GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe 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 ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe 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 GAA18CA060Accident · No injuriesData collectionFinal reportHughes 300 · Woodlawn, VAThe pilot’s inappropriate descent profile during landing with a quartering gusting tailwind, which resulted in a loss of main rotor rpm.NTSB GAA18CA004Accident · Minor injuriesData collectionFinal reportMooney M20 · Topping, VAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.NTSB ERA18FA006Accident · 1 fatalField investigationFinal reportPiper PA 25-235 · Front Royal, VAThe 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 ERA17LA280Accident · 1 fatalLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAThe 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 ERA17FA274Accident · 2 fatalField investigationFinal reportBell 407 · Charlottesville, VAThe 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 GAA17CA430Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Whaleyville, VAThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA438Accident · No injuriesData collectionFinal reportPiper PA28 · New Market, VAThe airplane’s collision with a deer during the landing roll.NTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe 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 ERA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Emporia, VAThe student pilot's failure to maintain an adequate airspeed for landing and his improper landing flare and recovery from a bounced landing.NTSB GAA17CA295Accident · Minor injuriesData collectionFinal reportFairchild 24R · Catlett, VAThe pilot’s selection of an unsuitable landing area, which resulted in the airplane impacting wheat stalks and a subsequent nose-over.NTSB ERA17CA186Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Bristow, VAThe 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 GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.NTSB ERA17LA067Accident · Serious injuriesLimited investigationFinal reportMathias Linda B Lightning · Franklin, VAA 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 GAA17CA055Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Bristow, VAThe pilot’s loss of directional control during a landing attempt at night, which resulted in a delayed go-around procedure and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB ERA16LA333Accident · No injuriesLimited investigationFinal reportRyan Navion · Hurt, VAIncorrect installation of the oil temperature probe and an inadequate annual inspection that failed to detect leaking oil around the loose probe, which resulted in a catastrophic engine failure due to oil starvation.NTSB GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.NTSB GAA16CA460Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in a porpoise, a loss of directional control, and a runway excursion.NTSB ERA16FA288Accident · 6 fatalField investigationFinal reportBeech 95 B55 (T42A) · Fredericksburg, VAThe 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 GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.NTSB ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.NTSB ERA16CA211Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Williamsburg, VAThe 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 GAA16CA294Accident · No injuriesData collectionFinal reportBellanca 17 30 · Fredericksburg, VAThe pilot's failure to maintain directional control during the landing roll in gusting wind resulting in a runway excursion and substantial damage.NTSB ERA16LA204Accident · Serious injuriesLimited investigationFinal reportBobbi Boucher DUO Deuce · Stafford, VAThe 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 ERA16FA194Accident · 2 fatalField investigationFinal reportJihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VAThe pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…NTSB ERA16LA179Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12 D · Critz, VAThe 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 GAA16CA167Accident · No injuriesData collectionFinal reportSewell William K Zodiac 601 · Clarksville, VAThe pilot's failure to maintain directional control during takeoff, which resulted in the airplane drifting to the left of the runway and impacting trees.NTSB ERA16LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-250 · Danville, VAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA16CA110Accident · Minor injuriesData collectionFinal reportPiper PA32RT · Melfa, VAThe pilot's inadequate compensation for a gusting crosswind during landing, which resulted in an aerodynamic stall, impact with a structure, and subsequent postimpact fire.NTSB GAA16CA094Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Chesapeake, VAThe pilot's loss of directional control during takeoff which resulted in impact with the ground.NTSB GAA16CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5 · West Point, VAThe 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 GAA16LA046Accident · Serious injuriesLimited investigationFinal reportU-Fly-It Aerolite 103 · Midland, VAThe pilot’s failure to attain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during takeoff with the airplane’s center of gravity aft of its limit, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA16CA024Accident · Minor injuriesData collectionFinal reportMaule M5 · Warrentown, VAThe pilot's failure to maintain clearance of a cattle-guard fence on landing. Contributing to the accident was his lack of recent flying experience.NTSB ERA16LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bluemont, VAA total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.NTSB ERA16LA016Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado · Mitchells, VAA total loss of engine power due to fatigue cracking and separation of the No. 3 cylinder exhaust valve stem.NTSB ERA15LA375Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Blacksburg, VAA 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 ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe 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 ERA15LA300Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hot Springs, VAA 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 ERA15LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Galax Hillsville, VAThe 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 ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.