NTSB investigations, VA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…NTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.NTSB ERA14LA006Accident · 4 fatalLimited investigationFinal reportCessna 340A · Hampton Roads, VAThe pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.NTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.NTSB ERA13CA419Accident · No injuriesData collectionFinal reportPiper PA28 151 · Abingdon, VAThe failure of the pilot to maintain directional control during a crosswind landing resulting in collision with terrain and aft displacement of the nose landing gear.NTSB ERA13LA418Accident · No injuriesLimited investigationFinal reportFleet 7 · Louisa, VAMaintenance personnel’s improper service, adjustment, and inspection of the brakes, which resulted in a runway excursion and subsequent noseover.NTSB ERA13IA396Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Chesapeake, VAMaintenance personnel’s inadequate inspection and compliance with a Federal Aviation Administration airworthiness directive, which resulted in an undetected corroded and cracked stabilator turnbuckle and the subsequent failure of the turnbuckle and loss of…NTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…NTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.NTSB ERA13CA362Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Fredericksburg, VAThe pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…NTSB ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.NTSB ERA13LA328Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Tappahannock, VAA failure of the engine crankshaft top rear trailing forward counterweight retaining plate, which resulted in a total loss of engine power. The reason for the retaining plate’s failure could not be determined during postaccident examination.NTSB ERA13LA258Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Herndon, VAThe pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA13FA227Accident · 2 fatalField investigationFinal reportNewgent, Barry S6S · Suffolk, VAThe pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…NTSB ERA13FA209Accident · 2 fatalField investigationFinal reportCessna 210E · Williamsburg, VAThe pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.NTSB ERA13LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · New Castle, VAThe pilot's failure to abort the takeoff after recognizing that the airplane was not accelerating properly, which led to an aerodynamic stall. The reason for the lack of acceleration could not be determined because postaccident examinations did not reveal any…NTSB ERA13LA173Accident · Serious injuriesLimited investigationFinal reportNew Piper PA32-301FT · Stafford, VAThe pilot's improper placement of the fuel tank selector handle during approach, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.NTSB ERA13CA091Accident · No injuriesData collectionFinal reportPiper PA28R · Newport News, VAThe pilot’s failure to properly monitor the flight controls (toe brake pedals) during engine start.NTSB ERA13CA092Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Lynchburg, VAThe student pilot’s improper flare, which resulted in a hard landing.NTSB ERA13CA067Accident · Serious injuriesData collectionFinal reportRadley Vincent Quicksilver Sport 2S · King George, VAThe pilot’s failure to maintain directional control during taxi.NTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…NTSB ERA13CA038Accident · No injuriesData collectionFinal reportCessna 172H · Weyers Cave, VAThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA13CA035Accident · Minor injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Roseland, VAThe pilot’s failure to maintain glider control during takeoff.NTSB ERA13CA008Accident · No injuriesData collectionFinal reportSanders Ben G III DR-107 · Warrenton, VAThe pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB ERA12FA583Accident · 2 fatalField investigationFinal reportCessna 150M · Fredericksburg, VAThe pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.NTSB ERA12FA526Accident · 1 fatalField investigationFinal reportBeech B24R · Dayton, VAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the noninstrument-rated pilot's decision to attempt a visual flight rules flight in instrument meteorological conditions…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.NTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.NTSB OPS12IA849Incident · No injuriesIncident investigationFinal reportArlington, VAA hearback/readback error on the part of the tower traffic management coordinator, who did not understand the request being made by the approach control area supervisor and then communicated that misunderstanding to the local controllers. Contributing to the…NTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12CA402Accident · No injuriesData collectionFinal reportAeronca 7AC · Blairs, VAThe pilot's failure to maintain directional control during a takeoff into sun glare.NTSB ERA12LA380Accident · Minor injuriesLimited investigationFinal reportPittman Eddie G CGS Hawk Arrow II · Monroe, VAThe pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.NTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…NTSB ERA12CA288Accident · No injuriesData collectionFinal reportCessna 180J · Abingdon, VAThe passenger’s inadvertent blockage of the rudder pedals, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB ERA12IA237Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Warrenton, VAMaintenance personnel's failure to identify stress corrosion cracking in the stabilator control cable during the most recent inspection, and the subsequent failure of the cable on the flight after the inspection.NTSB ERA12LA206Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Amisville, VAA total loss of engine power during cruise flight for reasons that could not be determined because of the damage due to the postcrash fire.NTSB ERA12LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Flat Rock, VAThe partial loss of engine power due to the failure of the exhaust valve spring seat for reasons that could not be determined.NTSB ERA12CA213Accident · No injuriesData collectionFinal reportZenair CH 2000 · Warrenton, VAThe student pilot's failure to follow instruction and to relinquish control of the airplane to the flight instructor in a timely manner, which resulted in a runway excursion.NTSB ERA12LA188Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Culpeper, VAThe pilot's failure to use the manufacturer's checklist to troubleshoot the perceived malfunction and thereby ensure the position of the landing gear before landing. The reason the landing gear were not down and locked could not be determined, as no…NTSB ERA12CA110Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmville, VAThe pilot did not maintain the proper approach path, which resulted in a runway undershoot.NTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.NTSB ERA12LA100Accident · No injuriesLimited investigationFinal reportSigmon Harvey E Vans RV 6 · Abingdon, VAThe failure of the Pitts pilot to see and avoid the RV-6 that had landed ahead. Contributing to the accident was the Pitts pilot's inability to hear the RV-6 pilot's radio calls due to the lack of a radio in the Pitts.NTSB ERA12CA059Accident · Minor injuriesData collectionFinal reportBeech F33A · Chesterfield, VAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.NTSB ERA12CA054Accident · Serious injuriesData collectionFinal reportAeros Trike · Amherst, VAThe student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.NTSB ERA12CA019Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Manassas, VAThe pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.NTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.NTSB ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.