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 IAD00LA063Accident · No injuriesLimited investigationFinal reportBeech BE-55 (T42A) · Chesapeake, VAthe pilot's misjudgment of his altitude/clearance above the runway during the aborted takeoff which resulted in an improper flare for landing. A factor in the accident was the pilot's premature rotation during the takeoff roll.NTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.NTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.NTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.NTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.NTSB NYC00LA157Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti SF260TP · Norfolk, VAFuel starvation of the engine, caused by the failure of the fuel transfer pump.NTSB NYC00LA152Accident · No injuriesLimited investigationFinal reportSchweizer 269-C1 · Chesapeake, VAthe failure of the student pilot to reduce the friction on the cyclic prior to raising the collective for the magneto check. A factor was the failure of the company to adequately define the steps in the checklist.NTSB NYC00LA142Accident · No injuriesLimited investigationFinal reportHeli-Eagle Ultrasport 496 · Newport News, VAThe pilot's failure to maintain control of the helicopter.NTSB IAD00LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tappahannock, VAthe pilots's inability to maintain aircraft control after a loss of consciosness.NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.NTSB NYC00LA125Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Nassawadox, VAA loss of engine power caused by detonation of the #2 piston.NTSB NYC00FA119Accident · 2 fatalField investigationFinal reportBeech N35 · Conicville, VAThe pilot's in-flight decision to continue flight into IMC conditions, and his failure to maintain control of the airplane. Factors related to the accident were the failure of the vacuum pump and the pilot's lack of recent instrument time.NTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.NTSB IAD00LA037Accident · Minor injuriesLimited investigationFinal reportGreenleaf Exec 162F · Manassas, VAWas the pilot' use of an unsecured ballast weight in the cockpit that shifted in flight and blocked the collective control movement.NTSB NYC00FA112Accident · 1 fatalField investigationFinal reportCessna 172H · Grottoes, VAThe pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.NTSB IAD00LA021Accident · 2 fatalLimited investigationFinal reportWood Seawind 3000 · Cumberland Gap, VAThe pilot's continued flight from visual flight rules into instrument meteorological conditions.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB IAD00LA014Accident · Minor injuriesLimited investigationFinal reportPrudhomme Velocity RG 173 · Richmond, VAthe improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.NTSB NYC00LA059Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Blacksburg, VAThe pilot in command's failure to recover from a bounced landing.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB IAD00FA003Accident · 1 fatalField investigationFinal reportCoughlin LONG-EZ · Remington, VAthe pilot's failure to maintain adequate altitude/clearance from the trees while maneuvering at low altitude.NTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC99LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Manassas, VAThe pilot's failure to recover from a sideslip maneuver, and flare the airplane before touchdown.NTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB NYC99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Isle Of Wight, VAThe improper visual inspection of overhauled engine components by maintenance personnel.NTSB NYC99LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, VAThe pilot's failure to adequately calculate required fuel for the flight, which resulted in a total loss of engine power.NTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.NTSB NYC99FA163Accident · 1 fatalField investigationFinal reportPiper PA-31T · Deerfield, VALoss of control of the airplane due to pilot incapacitation following a heart attack.NTSB NYC99LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Forest, VAThe pilot's misjudgment of distance/speed, also causal was his failure to execute a go-around. Contributing factors were the night conditions and the tailwind.NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.NTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB IAD99LA044Accident · Serious injuriesLimited investigationFinal reportMayers SEA REY · Ashland, VAwas a loss of engine power for undetermined reasons.NTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB IAD99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Manassas, VAThe student pilot's failure to maintain the proper rate of descend on final approach followed by an improper flare which resulted on a hard landing.NTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…NTSB NYC99FA074Accident · 2 fatalField investigationFinal reportCessna 340A · Chesapeake, VAThe pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.NTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.NTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.NTSB NYC99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Richmond, VAThe pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.NTSB NYC99LA063Accident · 1 fatalLimited investigationFinal reportPiper PA 32R-301 · Dulles, VAThe FBO employee's diverted attention, resulting in an inadvertent encounter with a rotating propeller.NTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.NTSB NYC99LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lynchburg, VAFuel exhaustion for undetermined reasons.NTSB IAD99LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Fairfield, VAThe owner's failure to comply with the Airworthiness Directive and the subsequent fuel system filter blockage by ice leading to fuel starvation and power loss of the right engine. Additionally, the pilot's improper selection of the left auxiliary fuel tank…NTSB NYC99LA035Accident · No injuriesLimited investigationFinal reportBeech 36 · Mathews, VAThe pilot's decision to land with less than full-down flaps. Contributing factors were the wet landing surface and the tree.NTSB NYC99LA034Accident · No injuriesLimited investigationFinal reportUnivair 7GC-AA · Garner, VAA jammed right wheel for undetermined reasons.