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.

NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.Apr 23, 2011 · N3963Y · Substantial damageNTSB ERA11LA240Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Richmond, VAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and subsequent impact with the ground.Apr 12, 2011 · N3547C · Substantial damageNTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.Apr 10, 2011 · N286BA · Substantial damageNTSB ERA11FA222Accident · 2 fatalField investigationFinal reportReplogle Lancair 360 · Chesapeake, VAThe 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…Apr 3, 2011 · N164T · Substantial damageNTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.Sep 24, 2010 · N65648 · Substantial damageNTSB ERA10CA497Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Castle, VAThe pilot's delayed decision to abort the takeoff, which resulted in a collision with terrain.Sep 22, 2010 · N8001J · Substantial damageNTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.Aug 21, 2010 · N417JN · Substantial damageNTSB ERA10LA377Accident · No injuriesLimited investigationFinal reportCessna 172N · Waynesboro, VAThe pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.Jul 24, 2010 · N3480E · Substantial damageNTSB ERA10FA346Accident · 1 fatalField investigationFinal reportCessna 172P · Chesapeake, VAThe airplane's impact with terrain for undetermined reasons following the pilot's report of a flight control malfunction.Jul 5, 2010 · N52614 · Substantial damageNTSB ERA10CA329Accident · No injuriesData collectionFinal reportNorth American SNJ-4 · Suffolk, VAThe pilot's failure to maintain directional control during the landing.Jun 17, 2010 · N43NA · Substantial damageNTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…May 21, 2010 · N91HR · Substantial damageNTSB ERA10FA195Accident · 1 fatalField investigationFinal reportPiper PA46 · Roanoke, VAA malfunction of the flight controls for undetermined reasons.Mar 30, 2010 · N6913Z · DestroyedNTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe 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.Mar 4, 2010 · N9305T · Substantial damageNTSB ERA10LA098Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · Suffolk, VAThe 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…Dec 21, 2009 · N524SC · Substantial damageNTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.Sep 18, 2009 · N999DJ · Substantial damageNTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.Sep 13, 2009 · N734TV · Substantial damageNTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.Aug 26, 2009 · N186CF · Substantial damageNTSB ERA09LA452Accident · 1 fatalLimited investigationFinal reportMaxair Drifter · Bumpass, VAThe 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.Aug 9, 2009 · N160HA · Substantial damageNTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA 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.Aug 3, 2009 · N3549N · Substantial damageNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.Jul 25, 2009 · N20930 · Substantial damageNTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.Jul 5, 2009 · N578DC · Substantial damageNTSB ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.Jun 13, 2009 · N22075 · Substantial damageNTSB ERA09LA344Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 Twin · Orange, VAThe pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.Jun 13, 2009 · N204EH · No damageNTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.Mar 22, 2009 · N2360M · Substantial damageNTSB ERA09LA111Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works SportCruiser · Emporia, VAThe student pilot's failure to maintain directional control during the landing. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information.Dec 23, 2008 · N524SC · Substantial damageNTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe 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.Nov 7, 2008 · N8LK · Substantial damageNTSB ERA09CA046Accident · No injuriesData collectionFinal reportHilderson Oswald Aventura HP · Weirwood, VAThe pilot's failure to maintain control of the airplane following an in-flight encounter with turbulence during approach, which led to a loss of engine power due to fuel starvation, and subsequent forced landing into trees.Oct 31, 2008 · N1932H · Substantial damageNTSB ERA09FA029Accident · 2 fatalField investigationFinal reportPiper PA-24 · Red Hill, VAThe pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…Oct 24, 2008 · N8820P · DestroyedNTSB NYC08LA323Accident · No injuriesLimited investigationFinal reportBeech A200 · Bridgewater, VAThe pilot's decision to land with a tailwind on a short, wet runway, resulting in landing long and runway overrun. Contributing to the accident was the operator’s lack of standard operating procedures for test flights.Sep 25, 2008 · N30W · Substantial damageNTSB MIA08CA191Accident · No injuriesData collectionFinal reportAirframes Unlimited USA-1B · Surry, VAThe pilot's improper handling of the powered parachute during takeoff/initial climb.Sep 7, 2008 · N723JH · Substantial damageNTSB NYC08CA267Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Windsor, VAThe student pilot's improper maneuvering at low altitude.Aug 3, 2008 · N33964 · Substantial damageNTSB MIA08LA142Accident · Serious injuriesLimited investigationFinal reportJ. E. Douglas Starduster 2 · Tappahannock, VALoss of engine power for undetermined reasons.Jul 15, 2008 · N27ED · Substantial damageNTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.Jul 12, 2008 · N1066M · Substantial damageNTSB NYC08LA254Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Northumberland, VAThe pilot's inadequate remedial action after an inadvertent encounter with loss of tail rotor effectiveness.Jul 11, 2008 · N61425 · Substantial damageNTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.Jun 29, 2008 · N184W · Substantial damageNTSB MIA08LA105Accident · 1 fatalLimited investigationFinal reportAviate Raptor · Bealeton, VAAn in-flight loss of control for undetermined reasons.May 23, 2008 · N74TK · Substantial damageNTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.Apr 27, 2008 · N429RM · DestroyedNTSB NYC08CA127Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's improper engine starting procedures.Mar 8, 2008 · N733LE · Substantial damageNTSB MIA08LA035Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Spotsylvania, VAThe pilot's failure to follow the checklist and failure to achieve the proper touchdown point during a forced landing. Contributing to the accident was a loss of engine power due to a cracked No. 4 top sparkplug insulator, resulting in pre-ignition/detonation…Jan 5, 2008 · N758FQ · Substantial damage