NTSB investigations, 2008, VA

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 2008
    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 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