NTSB investigations, VA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 NYC97LA074Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Waynesboro, VAThe pilot's failure to maintain directional control during landing.NTSB IAD97LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Warrenton, VAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.NTSB IAD97FA039Accident · 4 fatalField investigationFinal reportAerostar 601P · Chesapeake, VAfailure of the pilot to maintain proper altitude/clearance above the ground after takeoff. A related factor was the pilot's self-induced pressure to depart before the arrival of bad weather.NTSB NYC97LA039Accident · No injuriesLimited investigationFinal reportCessna 150D · Catawba Valley, VAthe pilot's improper planning/decision, and his failure to attain adequate airspeed, which resulted in a stall after takeoff and collision with ground. Factors relating to the accident were: the pilot's use of inadequate terrain for takeoff, high vegetation…NTSB DCA97MA016Accident · 6 fatalClass 1 · MajorFinal reportDouglas DC-8-63F · Narrows, VAthe inappropriate control inputs applied by the flying pilot during a stall recovery attempt, the failure of the nonflying pilot-in-command to recognize, address, and correct these inappropriate control inputs, and the failure of ABX to establish a formal…NTSB NYC97LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Charlottesville, VAThe pilot's miscalculation of fuel consumption and his inadequate in-flight decision making, which resulted in fuel exhaustion and the loss of engine power.NTSB IAD97FA023Accident · Serious injuriesField investigationFinal reportBeech 65-A90 · Orange, VAThe pilot's inadequate preflight inspection and his failure to complete the pretakeoff checklist which resulted in a takeoff roll with the control lock in place.NTSB IAD97LA017Accident · Serious injuriesLimited investigationFinal reportVanatta KR-2 · Blackstone, VAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, which resulted in a loss of control (stall) and collision with the ground.NTSB IAD97FA014Accident · 2 fatalField investigationFinal reportCessna 172L · Brandy Station, VAthe certificated flight instructor's failure to ensure that proper altitude/clearance was maintained above the terrain and trees, while on final approach. Darkness was a related factor.NTSB IAD97LA013Accident · No injuriesLimited investigationFinal reportCessna 140 · Wakefield, VAuncommanded operation of the parking brake, due to a missing tension spring, which resulted in locked brakes and subsequent nose over of the airplane during landing.NTSB NYC96FA163Accident · 1 fatalField investigationFinal reportBeech A36 · Roanoke, VAthe pilot's failure to follow the published instrument approach procedures, and his delayed missed approach, which resulted in an inflight collision with mountainous terrain.NTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.NTSB IAD96LA094Accident · No injuriesLimited investigationFinal reportRotorway Exec 152 · Gretna, VAfailure of the bearing assembly shaft insert inside the main rotor shaft. Related factors are the jammed rotorcraft flight control which restricted the pilot's ability to control the helicopter and resulted in a hard touchdown.NTSB DCA96IA061Incident · No injuriesIncident investigationFinal reportBoeing B-737-201 · Richmond, VAThe yaw/roll upset of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.NTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.NTSB IAD96LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAthe student pilot's failure to maintain adequate control of the aircraft during the touch and go landing. Related factors were the crosswind condition and the student pilot's lack of experience.NTSB IAD96LA071Accident · No injuriesLimited investigationFinal reportBeech A36 · Hot Springs, VAthe pilot's failure to attain adequate aircraft speed during takeoff. Related factors were the density altitude and gusty wind conditions.NTSB IAD96LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culpeper, VAThe pilot's improper compensation for the crosswind.NTSB IAD96LA068Accident · No injuriesLimited investigationFinal reportBeech B55 · Lynchburg, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve and landing gear collapse. A related factor was the strong crosswind.NTSB IAD96LA063Accident · 2 fatalLimited investigationFinal reportGlasair GL20 · Rocky Mount, VAthe pilot's continued flight into adverse weather conditions which led to airframe ice and a loss of control. Related factors were: the failure of the FSS briefer to advise the pilot of a valid AIRMET regarding icing conditions, the icing conditions, and…NTSB IAD96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Saluda, VAwas the pilot's failure to follow the manufacturer's recommended approach reference speed (VREF) during the approach.NTSB IAD96FA061Accident · 1 fatalField investigationFinal reportCessna P206C · Hartwood, VAthe inadvertent/premature deployment of the first skydiver's parachute, which resulted in contact with the airplane's horizontal stabilizer by the first skydiver and his parachute, loss of integrity of the empennage to the aft fuselage, loss of aircraft…NTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.NTSB IAD96LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Roanoke, VAloss of engine power for undetermined reason(s). Darkness and the pilot's improper emergency procedures were related factors.NTSB IAD96FA050Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Marion, VAthe pilot's failure to maintain adequate altitude/clearance during the instrument approach (FAF/Outer Marker to Threshold IFR), which resulted in the in-flight collision with trees. A related factor was the foggy weather conditions.NTSB IAD96LA049Accident · Minor injuriesLimited investigationFinal reportKitfox IV-1200 · Saluda, VAa partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.NTSB IAD96LA045Accident · Serious injuriesLimited investigationFinal reportAdvanced Technology Ultra Sport 254 · West Point, VAthe pilot's failure to maintain control of the helicopter during low altitude flight/maneuvering, which resulted in the helicopter impacting terrain. A related factor was the pilot's lack of flight experience in the make and model of helicopter.NTSB IAD96LA109Accident · 1 fatalLimited investigationFinal reportMooney M20F · Cape Charles, VAThe pilot's improper in-flight planning/decision making by continuing flight into known adverse weather conditions. Related factors were the dark night and the winter storm (snow and fog).NTSB BFO96LA030Accident · No injuriesLimited investigationFinal reportCessna 172K · Lovingston, VAthe pilot's improper planning/decision during the approach/landing phase of flight. Related factors were: the pilot's selection of the wrong runway, and the gusty tailwind conditions.NTSB BFO96LA021Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Manassas, VAfailure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…NTSB BFO96LA026Accident · No injuriesLimited investigationFinal reportCessna 210E · Newport News, VAthe failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.NTSB BFO96LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, VAfailure of the propeller blade due to fatigue cracking originating from corrosion damage. A related factor was the soft terrain encountered during the forced landing.NTSB BFO96LA013Accident · Serious injuriesLimited investigationFinal reportZenair CH 2000 · Saluda, VAthe pilot's failure to maintain control of the airplane during an attempted go around.NTSB BFO96LA009Accident · No injuriesLimited investigationFinal reportAerostar Raven S49A · Ark, VAthe flight instructor's improper procedures while inflating the balloon using an external fuel source, and the fuel leak.NTSB BFO96LA006Accident · Minor injuriesLimited investigationFinal reportMadsen/Rans Rans S12 Airaile · Cobbs Creek, VAloss of engine power for undetermined reasons.NTSB BFO96LA001Accident · No injuriesLimited investigationFinal reportRudy Kitfox 1 · Charlottesville, VAthe pilot's improper fuel management which resulted in fuel exhaustion. A related factor was the pilot's inadequate fuel consumption calculations.NTSB MIA95LA237Accident · 1 fatalLimited investigationFinal reportAerotek Pitts - S2S · Clarksville, VAcontinued flight by the pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and his inability to control the airplane. The weather condition and the lack of instruments in the airplane were related factors.NTSB NYC95MA220Accident · 12 fatalMajor investigationFinal reportBeech 65 · West Point, VAThe pilot's inadequate preflight/preparation, his failure to ensure proper weight and balance of the airplane, and his failure to obtain/maintain minimum control speed, which resulted in a loss of aircraft control after loss of power in one engine. A factor…NTSB BFO95LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAThe pilot's improper in-flight planning/decision, which resulted a loss of engine power due to fuel exhaustion. Factors relating to the accident were: the pilot's inadequate planning/preparation, her lack of familiarity with the airplane, and soft terrain in…NTSB BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB BFO95LA078Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-5 · Luray, VAthe pilot's failure to attain the proper touchdown point on the runway during a precautionary landing. A factor was an undetermined lubricating system problem.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.NTSB NYC95LA176Accident · 1 fatalLimited investigationFinal reportKenneth Savidge Vari Viggen · Abingdon, VAThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A contributing factor was the pilot's lack of experience in make and model.NTSB BFO95LA072Accident · No injuriesLimited investigationFinal reportKolb Twinstar · Abingdon, VAThe loss of engine power due to undetermined reasons. Factors found to be involved in this accident were the condition inspection was overdue and the inadequate training received by the student pilot owner/builder.NTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.NTSB BFO95LA055Accident · Minor injuriesLimited investigationFinal reportDevaughn Teenie II · Winchester, VAthe pilot's failure to properly judge the airplane fuel supply. The resultant loss of engine power occurred over unsuitable terrain, which was a contributing factor.NTSB BFO95LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Head Waters, VAthe pilot's poor planning/decision making in the attempted departure. Contributing factors are the wet, recently mowed grass airstrip, and the embankment/downhill grade encountered during the aborted takeoff.