NTSB investigations, 2014, VA

11 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2014, VA per year, 2008–2026: 190 cases
200815
200912
20109
201113
201212
201313
201411
201516
201617
201712
201817
20198
20206
20213
20226
20233
20247
20257
20263

Latest cases

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 year(c.\"eventDate\") = 2014
    AND 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.

NTSB ERA15CA059Accident · No injuriesData collectionFinal reportHiller OH 23B · Leesburg, VAA 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.Nov 24, 2014 · N6057 · Substantial damageNTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.Oct 4, 2014 · N3619T · Substantial damageNTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe 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.Sep 19, 2014 · N531KG · DestroyedNTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.Sep 19, 2014 · N749KY · Substantial damageNTSB ERA14LA415Accident · 1 fatalLimited investigationFinal reportCirrus SR22 · Wallops Island, VAThe pilot’s impairment and subsequent incapacitation for reasons that could not be determined because the pilot and airplane were not recovered.Aug 30, 2014 · N930RH · Substantial damageNTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.Jul 30, 2014 · N6004U · Substantial damageNTSB ERA14FA328Accident · 2 fatalField investigationFinal reportCessna 150J · Topping, VAThe pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.Jul 6, 2014 · N50824 · Substantial damageNTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…May 31, 2014 · N6RP · Substantial damageNTSB ERA14CA262Accident · Minor injuriesData collectionFinal reportEvolution Trikes Revo · Williamsburg, VAThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water.May 25, 2014 · N9912S · Substantial damageNTSB ERA14CA240Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Norfolk, VAThe student pilot's failure to maintain directional control during takeoff.May 14, 2014 · N32002 · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damage