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 IAD99FA023Accident · 1 fatalField investigationFinal reportArmbruster MINI-500 · Midland, VAthe improper repair of the engine following a previous engine seizure which resulted in the loss of engine power over unsuitable terrain.NTSB IAD99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Melfa, VAThe loss of engine power for undetermined reasons.NTSB IAD99FA008Accident · Minor injuriesField investigationFinal reportLearjet 45 · Wallops Island, VAThe failure of the pilot to obtain/maintain alignment with the water pool, which resulted in the loss of control. Factors in the accident were the inadequate preflight planning of the flight test facility and the airplane manufacturer which resulted in…NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.NTSB NYC98LA151Accident · No injuriesLimited investigationFinal reportCessna A185F · Moneta, VAThe pilot's failure to maintain airspeed which resulted in a stall and subsequent collision with water.NTSB IAD98LA077Accident · Minor injuriesLimited investigationFinal reportBennett Piel Emeraude · Hillsville, VAA blocked fuel strainer due to an inadequate maintenance inspection by the previous owner, which resulted in fuel starvation.NTSB IAD98LA075Accident · Minor injuriesLimited investigationFinal reportHoffmann Fisher FP 404 · Louisa, VALoss of engine power for undetermined reasons.NTSB IAD98LA073Accident · No injuriesLimited investigationFinal reportSaab-Scania F-35 Draken · Oceana, VAThe pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.NTSB IAD98FA068Accident · 2 fatalField investigationFinal reportBeech F33A · Delaplane, VAThe pilot's inadequate in-flight decision which led to VFR flight into instrument meteorological conditions. Also causal was the pilot's failure to maintain adequate terrain clearance resulting in collision with mountainous terrain. Contributing factors were…NTSB NYC98LA121Accident · Serious injuriesLimited investigationFinal reportCawood Fisher Classic · Abingdon, VAThe pilot's inadequate preflight of the airplane which resulted in water contamination of the fuel system. A factor was the location of the fuel tank's sump.NTSB IAD98LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Floyd, VAThe pilot's improper selection of fuel tank position resulting in fuel starvation of both engines.NTSB IAD98FA061Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Manassas, VAThe pilot's failure to maintain adequate altitude/clearance during an aerobatic maneuver.NTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.NTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.NTSB IAD98LA051Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Chesterfield, VAThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power.NTSB NYC98LA098Accident · No injuriesLimited investigationFinal reportMasak Scimitar · Hardscrabble, VAThe pilots encounter with an unexpected downdraft.NTSB NYC98LA096Accident · No injuriesLimited investigationFinal reportBeech C-50 · Ford, VAA loss of engine power simultaneously on both engines as reported by the pilot, for undetermined reasons.NTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.NTSB NYC98LA085Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Elk Garden, VAthe pilot's improper weather evaluation. The gusty wind condition was a related factor.NTSB NYC98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Weyers Cave, VAthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing roll, which resulted in an encounter with a fence on uneven terrain and a nose over.NTSB IAD98LA038Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Castlewood, VAThe pilot's failure to achieve the proper touchdown point and the delayed execution of the go around. A contributing factor was the fence.NTSB IAD98GA039Accident · No injuriesFinal reportBell 412 · Quantico, VAthe pilot's failure to maintain adequate altitude/clearance above the terrain and the lack of management oversight of aircrews and equipment.NTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.NTSB IAD98FA032Accident · 2 fatalField investigationFinal reportCessna 172P · Langley Afb, VAThe pilot's inadvertent VFR flight into IMC conditions, and the subsequent loss of aircraft control due to spatial disorientation. A factor in the accident was the low ceiling.NTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.NTSB NYC98LA068Accident · No injuriesLimited investigationFinal reportZwart KIT FOX Vixen · Weyers Cave, VAThe failure of the propeller drive train after the pilot/builder installed an improper drive belt.NTSB NYC98LA122Accident · Serious injuriesLimited investigationFinal reportGoins Sonerai II LTS · Suffolk, VAThe pilot's failure to maintain directional control during the initial takeoff climb. Factors related to the accident were habit interference, the pilot's lack of experience in the make and model, and the trees.NTSB NYC98LA056Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Ferncliff, VAthe improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…NTSB NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.NTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.NTSB NYC98LA022Accident · Serious injuriesLimited investigationFinal reportBeech B200 · Norfolk, VAThe passenger tripped for an undetermined reason.NTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..NTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.NTSB IAD98LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Oceana, VAImproper flare by the pilot, which resulted in a hard landing. A related factor was the diverted attention.NTSB NYC98LA007Accident · No injuriesLimited investigationFinal reportCessna 120 · Prince George, VAThe pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.NTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.NTSB NYC97LA182Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Crimora, VAThe pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..NTSB NYC97LA175Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fredericksburg, VAA loss of engine power for undetermined reasons.NTSB NYC97LA158Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Quinton, VAThe pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.NTSB IAD97LA097Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Culpeper, VAThe pilot's inadequate preflight planning which fail to provide an adequate fuel supplyNTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.NTSB NYC97LA117Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harrisonburg, VAthe pilot's failure to obtain the proper touchdown point. A contributing factor was the transmission line.NTSB NYC97LA112Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Charlottesville, VAThe left main landing gear collapsed due to corrosion.NTSB NYC97LA105Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Fredericksburg, VAThe pilot's delayed go-around which resulted in the inflight collision with trees off the departure end of the runway.NTSB IAD97GA081Accident · Minor injuriesFinal reportPiper PA-18-150 · Harrisonburg, VAThe pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.NTSB NYC97FA103Accident · 3 fatalField investigationFinal reportCessna 210M · Elliston, VAfailure of the PIC to maintain control of the airplane, due to spatial disorientation.NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.NTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.