Skip to content

NTSB investigations, VA

27 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

Where

Latest cases

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310)
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 NYC06CA212Accident · No injuriesData collectionFinal reportPiper PA 38-112 · Chesapeake, VAThe presence of deer on the runway during the landing roll, which resulted in a collision. A factor in the accident was the dark night.Aug 21, 2006 · N6401A · Substantial damage NTSB NYC06CA103Accident · No injuriesData collectionFinal reportMaule M-5-210C · Linville, VAThe pilot's improper decision to depart with a tailwind.Apr 23, 2006 · N62015 · Substantial damage NTSB NYC05CA007Accident · No injuriesData collectionFinal reportBeech A23 · New Market, VAA collision with a deer during the takeoff roll. A factor in the accident was the night.Oct 16, 2004 · N130SV · Substantial damage NTSB NYC03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mineral, VAThe flight instructor's delayed remedial action.Mar 12, 2003 · N276T · Substantial damage NTSB NYC02LA081Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Louisa, VAThe airplane's inadvertent collision with a deer while landing at night. A factor in the accident was the night condition.Apr 8, 2002 · N2375Z · Substantial damage NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.Mar 9, 2002 · N622BR · Substantial damage NTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…Jan 20, 2002 · N837AT · Substantial damage NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.Jun 30, 2001 · N25846 · Substantial damage NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.May 28, 1999 · N282SC · Substantial damage NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.May 23, 1999 · N9070T · No damage NTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.Feb 6, 1999 · N19186 · Destroyed NTSB NYC99LA035Accident · No injuriesLimited investigationFinal reportBeech 36 · Mathews, VAThe pilot's decision to land with less than full-down flaps. Contributing factors were the wet landing surface and the tree.Dec 8, 1998 · N3237Q · Substantial damage NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.Aug 2, 1997 · N23831 · Substantial damage NTSB BFO95LA076Accident · No injuriesLimited investigationFinal reportCessna 172D · Hague, VAFailure of the pilot to maintain proper alignment with the runway during the landing. Factors relating to the accident were: the crosswind and the proximity of tall corn (crop) to the narrow runway.Aug 5, 1995 · N2418Y · Substantial damage NTSB BFO93LA184Accident · No injuriesLimited investigationFinal reportCessna 172 · Emporia, VAThe pilot's selection of unsuitable terrain for a takeoff. A factor related to the accident was the pilot's delay in initiating an aborted takeoff.Sep 25, 1993 · N9841L · Substantial damage NTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.Dec 6, 1992 · N58ND · Substantial damage NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.Jul 27, 1992 · N731MR · Substantial damage NTSB BFO92LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Portsmouth, VACollisiion with the deer on the runway. A factor was the dark night.Nov 15, 1991 · N19595 · Substantial damage NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.Jun 26, 1991 · N2641J · Substantial damage NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.May 26, 1991 · N949Z · 2 aircraft · Substantial damage NTSB BFO91LA010Accident · No injuriesLimited investigationFinal reportAeronca L3B · Farmville, VAThe failure of the pilot to properly secure the aircraft while starting the engine by hand proping.Nov 4, 1990 · N1336J · Substantial damage NTSB BFO90LA078Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Bealeton, VAThe pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…Sep 23, 1990 · N9279 · 2 aircraft · Destroyed NTSB BFO88LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Winchester, VAThe T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said…May 1, 1988 · N905PS · 2 aircraft · Substantial damage NTSB BFO87LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fredericksburg, VAThe CFI stated that drg tkof, the acft accelerated slower than normal. After rolling abt 1800', the student rotated the acft to a normal climb attitude & it climbed aprx 5' to 10'. At about that time, the CFI noted that the airspeed indcn had dropped to abt…May 30, 1987 · N25448 · Substantial damage NTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…May 17, 1987 · N527B · Substantial damage NTSB BFO87DID01Accident · No injuriesFinal reportPiper PA-28RT-201 · Lynchburg, VAWhile on the takeoff roll, the acft collided with a deer. The plt rprtd that he had accelerated to 50 KTS & was about 1000 ft down the rwy when the deer ran in front of theOct 4, 1986 · N3005V · Substantial damage NTSB ATL84FA102Accident · No injuriesField investigationFinal reportCessna 182RG II · Chantilly, VAPlt stated he saw baggage tug at a stop, apparently holding, btw taxiways T-1 and T-2. Tug driver reported he stopped at the stop sign, looked left, looked right and observing no acft. He accelerated his vehicle and saw N1734R directly in front of him. He…Feb 9, 1984 · N1734R · Substantial damage