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 NYC05LA020Accident · Serious injuriesLimited investigationFinal reportUnknown Sky Raider · Rappahannock Ac, VAThe uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.NTSB NYC05LA009Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Dulles, VAThe pilot's improper in-flight decision to continue the instrument approach and landing, which resulted in a collision with a sign. A factor was the below instrument approach landing minimum weather conditions.NTSB IAD05MA006Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Stuart, VAThe flight crew's failure to properly execute the published instrument approach procedure, including the published missed approach procedure, which resulted in controlled flight into terrain. Contributing to the cause of the accident was the flight crew's…NTSB NYC05FA006Accident · 1 fatalField investigationFinal reportBeech H50 · Hartwood, VAThe pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.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.NTSB NYC04LA219Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-22A · Richmond, VAThe pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…NTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB NYC04LA182Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-27 · Windsor, VAThe pilot's improper use of a navigation aid, which resulted in him becoming lost, and having to perform a forced landing.NTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.NTSB NYC04LA168Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319 · Flat Rock, VAAn inadvertent encounter with turbulence in clouds during descent.NTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.NTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB NYC04CA112Accident · No injuriesData collectionFinal reportBolger Scott RV-6A · Fredericksburg, VAThe pilots failure to maintain airspeed during a precautionary landing which resulted in an undershoot and subsequent impact with terrain. A factor was the inadequate pre-flight inspection.NTSB NYC04LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Harrisonburg, VAThe pilot's improper decision to attempt a landing with an excessive tailwind, which resulted in an inadvertent stall while attempting to climb during a go-around. A factor related to the accident was the tailwind conditions and the rising terrain beyond the…NTSB NYC04LA065Accident · No injuriesLimited investigationFinal reportCessna 150F · Suffolk, VAThe failure of the number four cylinder barrel due to fatigue which originated from a corrosion pit at the base of a cooling fin.NTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.NTSB NYC04LA004Accident · 1 fatalLimited investigationFinal reportPfeifler Edge-540 · Warrenton, VAThe pilot's failure to maintain aircraft control while performing aerobatic maneuvers.NTSB IAD04CA002Accident · No injuriesData collectionFinal reportCessna 140 · Ridegway, VAThe pilot's improper pre-flight planning, which resulted in an engine failure due to fuel exhaustion.NTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.NTSB NYC03LA199Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Norfolk, VAthe airline ground person's failure to properly control the pushback tug, and her subsequent failure to maintain adequate clearance between the tug and the airplane. Factors contributing to the accident were the airline ground person's operation of the tug…NTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.NTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.NTSB NYC03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, VALoss of engine power due to unknown circumstances.NTSB IAD03LA073Accident · No injuriesLimited investigationFinal reportMooney M20K · Chesterfield, VAThe loss of engine power due to the fatigue fracture of the #2 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC03LA175Accident · No injuriesLimited investigationFinal reportStinson 108 · White Post, VAThe pilot/ mechanic's improper annual inspection including his rigging of the elevator flight control, and his subsequent inadequate preflight inspection of the airplane prior to flight, when he failed to detect the improperly rigged elevator flight control,…NTSB NYC03LA141Accident · No injuriesLimited investigationFinal reportCessna 170B · Brandy Station, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC03TA138Accident · No injuriesFinal reportAir Tractor 402A · Pearisburg, VAA compressor turbine blade fracture which resulted in a power loss, and forced landing. Factor were the rocks in the landing area, and the operator's decision to operate the engine beyond the engine manufacturer's recommendations for overhaul.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.NTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB NYC03LA111Accident · Serious injuriesLimited investigationFinal reportVirginia Wright Model B · Midland, VAThe pilot's failure to maintain aircraft control.NTSB NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.NTSB NYC03LA104Accident · Serious injuriesLimited investigationFinal reportBoeing B767-300 · New Market, VAThe inadvertent encounter with turbulence.NTSB IAD03LA048Accident · Serious injuriesLimited investigationFinal reportDornier 328-300 · Roanoke, VAThe airplane's encounter with unforecasted clear air turbulence during cruise flight.NTSB IAD03LA054Accident · Minor injuriesLimited investigationFinal reportRoger Mann Ragwing RW8-PT2S · Hanover, VAA loss of engine power for undetermined reasons. A factor was the wheat in the forced landing field.NTSB NYC03LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Blacksburg, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC03LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Shenandoah, VAThe pilot's inadvertent encounter with snow showers. Factors were the snow and the unsuitable landing area.NTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.NTSB IAD03LA036Accident · 1 fatalLimited investigationFinal reportCessna R172K · Richmond, VAThe passenger's failure to remain clear of the propeller. Factors included the passenger's recent use of marijuana, the pilot's inadequate pre-flight inspection, and the night lighting conditions.NTSB NYC03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mineral, VAThe flight instructor's delayed remedial action.NTSB IAD03FA035Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Leesburg, VAThe pilot's failure to fly a stabilized, published instrument approach procedure, and his failure to maintain adequate airspeed which led to an aerodynamic stall.NTSB IAD03LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesapeake, VAThe pilot's failure to adequately remove snow and ice from the airplane's wings prior to takeoff.NTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.NTSB NYC03LA029Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Suffolk, VAThe pilot's inadequate visual lookout while landing, which resulted in a collision with an embankment.