NTSB investigations, VA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB NYC07FA025Accident · 1 fatalField investigationFinal reportCzech Aircraft Works CH 601 XL RTF · Basye, VAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC07CA019Accident · No injuriesData collectionFinal reportCessna 172M · Wakefield, VAThe student pilot's failure to maintain control during the landing. A factor to the accident was the wind gusts.NTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…NTSB NYC07LA008Accident · 1 fatalLimited investigationFinal reportFlynn William Pazmany PL-4 · Fredricksburg, VAThe pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.NTSB NYC07FA007Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau Gmbh 300 · Culpeper, VAThe pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.NTSB NYC06FA215Accident · 2 fatalField investigationFinal reportCessna 150G · Penhook, VAThe pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…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.NTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.NTSB DFW06FA180Accident · 2 fatalField investigationFinal reportBeech C24R · Virginia Beach, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while maneuvering at a low altitude. Contributing was the pilot's diverted attention to an open door.NTSB NYC06LA151Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Dulles, VAThe driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.NTSB NYC06CA211Accident · No injuriesData collectionFinal reportErcoupe 415-C · Harrisonburg, VAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with trees.NTSB NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB NYC06FA145Accident · 2 fatalField investigationFinal reportRaytheon B36TC · North Garden, VAThe pilot's failure to maintain airspeed while turning onto the final approach, which resulted in an inadvertent stall/spin and subsequent impact with terrain.NTSB ENG06IA020Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Norfolk, VAHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the engine high pressure compressor when the pilots retarded the power levers causing compressor surges and the flameouts of both engines. Contributing factors were…NTSB NYC06FA138Accident · Minor injuriesField investigationFinal reportDornier DO-328-300 · Manassas, VAThe partially blocked pitot system, which resulted in an inaccurate airspeed indicator display, and an overrun during an aborted takeoff. A factor associated with the accident was the pilot-in-command's delayed decision to abort the takeoff.NTSB NYC06FA128Accident · Serious injuriesField investigationFinal reportEmbraer EMB-170 · Dulles, VAImproper servicing of the nose landing gear strut and the operator's inadequate maintenance procedure. A factor was the inadequate checklist provided to the flight crew by the operator.NTSB NYC06CA135Accident · Minor injuriesData collectionFinal reportFlight Design Gmbh · Leesburg, VAThe pilot's improper remedial action to regain directional control after takeoff. A factor was the pilot's failure to maintain directional control after takeoff.NTSB NYC06CA158Accident · No injuriesData collectionFinal reportBoeing A75N1 · South Hill, VAThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop and a subsequent nose over.NTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.NTSB NYC06CA117Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-120 · Montvale, VAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor in the accident were the wind gusts.NTSB NYC06LA115Accident · Serious injuriesLimited investigationFinal reportEmbraer 145LR · Winchester, VAThe passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.NTSB NYC06CA110Accident · Serious injuriesData collectionFinal reportHelo Werks HX-1 Wasp · Hampton Roads, VAThe inadvertent activation of the helicopter manufacturer's improperly located, unguarded fuel shutoff switch.NTSB NYC06CA103Accident · No injuriesData collectionFinal reportMaule M-5-210C · Linville, VAThe pilot's improper decision to depart with a tailwind.NTSB NYC06LA099Accident · Serious injuriesLimited investigationFinal reportBombardier CL600-2B19 · Front Royal, VAAn inadvertent encounter with clear air turbulence.NTSB NYC06LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Norfolk, VAThe pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.NTSB NYC06CA087Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. A factor was the gusting winds.NTSB NYC06LA073Accident · 1 fatalLimited investigationFinal reportCessna 182D · Weyers Cave, VAThe pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.NTSB NYC06FA072Accident · 4 fatalField investigationFinal reportLancair LC41-550FG · Stafford, VAThe pilot's failure to execute the published missed approach. Factors included the night lighting conditions, low ceilings and fog.NTSB NYC06CA067Accident · No injuriesData collectionFinal reportPergerson Highlander · Appomattox, VAThe pilot's failure to maintain directional control during landing. A factor in the accident was the pilot's improper use of flaps.NTSB NYC06FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Leesburg, VAThe flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.NTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB NYC06LA002Accident · Serious injuriesLimited investigationFinal reportEmbraer 170 · Dulles, VAThe flight crew's excessive maneuver in response to a traffic alert during the landing approach.NTSB IAD05CA148Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Windsor, VAThe solo student pilot's loss of control during landing.NTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.NTSB IAD05CA104Accident · No injuriesData collectionFinal reportCessna 172S · Charlottesville, VAThe student pilot's improper flare which resulted in a hard landing.NTSB NYC05CA107Accident · No injuriesData collectionFinal reportCessna 172L · Tangier, VAThe pilot's failure to maintain directional control during landing.NTSB NYC05LA096Accident · 1 fatalLimited investigationFinal reportHall Maxair Drifter · Gloucester, VAThe in-flight separation of the empennage, which resulted in a loss of control and subsequent impact with the ground.NTSB NYC05IA093Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Dulles, VAFailure of the right main landing gear to extend and lock for undetermined reasons, which resulted in the right main landing gear collapsing during touchdown.NTSB NYC05LA084Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Saluda, VAA loss of engine power due to an unsecured mixture control cable, which was not properly secured by maintenance personnel during a recent annual inspection. Also causal was the airplane owner's continued operation of the airplane with known deficiencies.NTSB IAD05LA063Accident · 2 fatalLimited investigationFinal reportAeronca 65-TAC · Harrisonburg, VAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.NTSB IAD05TA058Accident · Minor injuriesFinal reportHughes 369FF · Quantico, VAThe flight crew's failure to maintain adequate altitude/clearance from a building, which resulted in contact with the building, dynamic rollover, and collision with terrain.NTSB IAD05CA056Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA40 · Leesburg, VAThe pilot's failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the uphill terrain.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB NYC05CA031Accident · No injuriesData collectionFinal reportFlight Design CT-2K · Waynesboro, VAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB NYC05LA030Accident · No injuriesLimited investigationFinal reportDay VP-2 · Warrenton, VAA loss of engine power for an undetermined reason.NTSB IAD05LA022Accident · No injuriesLimited investigationFinal reportCessna 414 · Petersburg, VAThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).NTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB NYC05FA021Accident · 2 fatalField investigationFinal reportCessna 310R · Paeonian Spring, VAThe pilot's failure to follow the published instrument approach procedure, which resulted in an in-flight collision with terrain. A factor related to the accident was the low cloud ceiling.