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 BFO93T#173Accident · No injuriesClass 3Final reportBell 206L-3 · Fairfax, VANTSB NYC93LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's inadequate supervision resulting in a delayed go-around.NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.NTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.NTSB BFO93FA132Accident · 2 fatalField investigationFinal reportNorth American T-6G · Berryville, VA1.) The pilot's poor judgment in performing a maneuver in close proximity to the ground, and 2.) the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and subsequent loss of control in flight, resulting in a collision…NTSB BFO93LA125Accident · Serious injuriesLimited investigationFinal reportHancock- Harris Pitts Special · Independent Hil, VAThe pilot's inadequate preflight planning/preparation which resulted in fuel exhaustion and subsequent loss of engine power.NTSB BFO93FA113Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Madison Heights, VAEngine failure due to oil starvation as a result of inadequate maintenance and inspection of the oil cooler lines.NTSB BFO93LA104Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Culpeper, VAThe pilot's failure to maintain directional control during landing rollout. A factor related to the accident include a ditch.NTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.NTSB NYC93LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gordonsville, VAWas a power loss due to fuel contamination, after the pilot refueled from cans and did not filter the fuel according to recommendations.NTSB BFO93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Manassas, VAThe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB BFO93LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Norfolk, VAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was the unsuitable terrain.NTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.NTSB NYC93LA092Accident · No injuriesLimited investigationFinal reportCessna P337 · Holland, VAThe pilot's improper inflight planning during the approach for landing, resulting in a touchdown too FAR down the runway, and the subsequent collision with objects off the end of the runway.NTSB NYC93LA091Accident · No injuriesLimited investigationFinal reportHomer Davis RV4 · Danville, VAThe loss of engine power due to a stuck carburetor needle valve; subsequent forced landing in unsuitable terrain, and impact with a tree.NTSB NYC93LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Nellysford, VAThe pilot's inadequate inflight decision and planning, and his failure to maintain an altitude adequate for terrain avoidance.NTSB NYC93LA084Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Buchanan, VAThe pilot's improper planning/decision, inadequate crew coordination, and failure to maintain directional control. The unfavorable wind and proximity of obstructions were related factors.NTSB NYC93LA069Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Leesburg, VAImproper use of the fuel selectors, which resulted in fuel starvation and loss of power in both engines. Darkness was a related factor.NTSB BFO93LA032Accident · 1 fatalLimited investigationFinal reportMorgan Challenger II · Quinton, VAThe pilot's impairment due to a neurological injury and drugs, and his failure to maintain control of the airplane during an approach to land. A factor related to the accident was the gusty wind condition.NTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.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.NTSB BFO93LA015Accident · No injuriesLimited investigationFinal reportMooney M20K · Orange, VAWater contamination in the fuel, and inadequate preflight inspection.NTSB BFO93LA009Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Dublin, VAImproper adjustment of the fuel pressure regulator which produced an inadequate fuel flow and subsequent fuel starvation. Factors related to the accident were: the rough terrain and trees in the emergency landing area.NTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.NTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayNTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB BFO92FA153Accident · 1 fatalField investigationFinal reportCessna 152 · Gloucester, VAThe pilot's failure to recover from an intentional stall, which resluted in inflight collision with the ground. Pilot inexperience is a contributing factor.NTSB BFO92FA135Accident · 2 fatalField investigationFinal reportBeech G35 · Hillsville, VALoss of engine power for an undetermined reason and failure of the pilot to maintain airspeed, which resulted in a stall/spin.NTSB NYC92FA153Accident · 2 fatalField investigationFinal reportDanny M Damron Long EZ · Front Royal, VAThe pilot's self induced pressure to complete the flight which resulted in intentional flight into IMC conditions, and a collision with trees. Factors related to the accident were the pilot's over confidence in his abilities, and the low clouds and fog which…NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.NTSB BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.NTSB BFO92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Moneta, VAFailure of the student pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's improper recovery from a bounced landing and proximity of the tree.NTSB BFO92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Greenville, VAThe fatigue failure of the fuel injector fuel line resulting in engine failure. Contributing to the accident was the unsuitable terrain in which the forced landing was made.NTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.NTSB NYC92LA126Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Waynesboro, VAThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall while on approach. Factors related to the accident were: the pilot's lack of experience, an improperly planned approach, and the gusty winds.NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.NTSB BFO92FA051Accident · 2 fatalField investigationFinal reportSam R. Crowell SH-2R · Somerville, VAThe pilot's inadequate handling of aircraft during aerobatic maneuver which resulted in a loss of control. Contributing factors were lack of experience in operation.NTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.NTSB BFO92LA053Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Amelia, VAThe pilot's misjudgement of distance and altitude that resulted in an landing overrun and collision with an embankment. Contributing was failure to initiate a go around and inadequate supervision.NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.NTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.NTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.NTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.NTSB BFO92FA025Accident · 1 fatalField investigationFinal reportBeech V35B · Manassas, VAThe pilot's failure to remove ice from the wings during the preflight inspection which resulted in a stall during takeoff due to ice on the wings.