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 DCA01MA064Accident · 64 fatalMajor investigationFinal reportBoeing 757-200 · Arlington, VAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB NYC01LA220Accident · No injuriesLimited investigationFinal reportAndre Mini Max 1500R · Chesapeake, VAThe pilot's failure to follow the engine manufacturer's descent procedure, which resulted in a lean mixture condition and subsequent engine seizure.NTSB IAD01LA102Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ-135ER · Richmond, VAInadequate company procedures/directives, which resulted in the flight attendant leaving her seat prematurely, while the airplane was still in an area of turbulence.NTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.NTSB NYC01LA205Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Sydnorsville, VAA loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.NTSB IAD01LA091Accident · Serious injuriesLimited investigationFinal reportDelbridge Rotorway Exec 162F · Carrollton, VApilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.NTSB IAD01IA093Incident · No injuriesIncident investigationFinal reportMorrison Rans S-12 · Midland, VAThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing and separation of the landing gear. A factor in the incident was the pilot's improper decision to participate in an unauthorized activity with his airplane.NTSB IAD01LA090Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Warrenton, VAThe pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB IAD01LA076Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Front Royal, VAthe pilot's inadequate altitude/clearance from a tree along his final approach path.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB NYC01LA143Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Fredericksburg, VAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun.NTSB NYC01FA122Accident · 1 fatalField investigationFinal reportCessna U206E · New Market, VAA loss of engine power due to a failure of the number 5 piston for undetermined reasons. A factor in this accident was the inadequate emergency handling provided by the air route traffic controller.NTSB IAD01FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Afton, VAThe pilot's loss of consciousness due to a medical condition, which resulted in his failure to maintain control of the airplane and subsequent impact with rising terrain.NTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.NTSB NYC01IA107Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Norfolk, VAThe manufacturer's inadequate quality control, which resulted in a jammed elevator trim actuator.NTSB IAD01LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · King George, VAThe failure of cylinder case and thru studs due to fatigue, which resulted in a loss of engine power over unsuitable terrain.NTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.NTSB NYC01LA105Accident · No injuriesLimited investigationFinal reportCessna 337F · Quinton, VAThe pilot's improper recovery from a bounced landing. Factors in the accident were the crosswind, and the pilot's lack of experience in make and model.NTSB NYC01LA096Accident · Serious injuriesLimited investigationFinal reportDornier 328-100 · Springfield, VAAn inadvertent encounter with turbulence during descent.NTSB IAD01LA041Accident · Minor injuriesLimited investigationFinal reportBell BH-206-B · Ringgold, VApilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.NTSB NYC01LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, VAThe pilot's inadequate compensation for the runway conditions. Factors included the soggy runway conditions, and the lack of available takeoff performance data in the owners manual.NTSB NYC01LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wintergreen, VAThe pilot's improper decision to continue the flight into deteriorating weather.NTSB IAD01FA039Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Paris, VApilot's continued visual flight into instrument meteorological conditions.NTSB IAD01FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-RT201 · Manassas, VAThe pilot's spatial disorientation due to a night visual illusion. A factor was the dark night condition.NTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.NTSB IAD01LA026Accident · No injuriesLimited investigationFinal reportAyres S2R · Crewe, VAthe loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.NTSB IAD01FA021Accident · Minor injuriesField investigationFinal reportJetstream 4101 · Charlottesville, VAThe captain's improper application of power after responding to a beta warning light during landing rollout, which resulted in an excessive rollout speed and an inability to stop the airplane before it reached the end of the runway.NTSB NYC01LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmville, VAthe failure of the pilot to maintain directional control.NTSB IAD01IA017Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Dulles, VAthe operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.NTSB IAD01FA015Accident · No injuriesField investigationFinal reportBeech F90 · Lynchburg, VAImproper rigging of both propeller assemblies by maintenance personnel, which resulted in the inadvertent feathering of both propellers after takeoff. Factors included a lack of rigging experience in airplane make and model by maintenance personnel, unclear…NTSB NYC01LA041Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blacksburg, VAThe pilot's improper flare while landing.NTSB IAD01LA014Accident · No injuriesLimited investigationFinal reportGick Aerocomp CA6WB · White Post, VAThe pilot's inadequate preflight. Also causal in the accident was the under-inflated tire that flattened and locked during landing, and collapsed the nose landing gear.NTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.NTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.NTSB IAD01LA008Accident · Minor injuriesLimited investigationFinal reportConn Sonerai II · Manassas, VAFuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.NTSB IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB IAD01LA004Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Berryville, VAThe pilot's improper flare, which resulted in a hard landing and separation of the nose landing gear.NTSB NYC01LA018Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ridgeway, VAThe pilot's failure to maintain proper runway alignment during the landing roll. A factor in this accident was a slight bend in the runway.NTSB NYC01LA008Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Fork Union, VAThe pilot's inadequate flare which resulted in a hard landing. A factor related to the accident was the uneven landing area condition.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB NYC00LA266Accident · Serious injuriesLimited investigationFinal reportMorrison RANS-12 · Warrenton, VAThe pilot's inadequate airspeed which resulted in the inadvertent stall. A factor related to the accident was the gusting wind condition.NTSB IAD00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Headwaters, VAPilot's failure to maintain aircraft control during take-off, which resulted in a stall.NTSB NYC00FA245Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lexington, VAThe pilot's attempted VFR flight into instrument meteorological conditions that resulted in spatial disorientation. A factor in this accident was the pilot's inadequate preflight planning.NTSB NYC00LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAThe partial loss of power due to an inadequate annual inspection, which resulted in the throttle linkage becoming disconnected from the throttle.NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.NTSB NYC00FA209Accident · 1 fatalField investigationFinal reportCessna 210D · Ashland, VAThe failure of the pilot to maintain control of the airplane due to spatial disorientation. Factors were the dark night, low ceiling and fog.NTSB IAD00LA066Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Warrenton, VAthe loss of engine power over unsuitable terrain due to an inoperative magneto.