NTSB investigations, WV
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\" = 'WV' 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" = 'WV' 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 DCA10IA022Incident · No injuriesIncident investigationFinal reportBombardier CL600 · Charleston, WV(1) The flight crewmembers’ unprofessional behavior, including their nonadherence to sterile cockpit procedures by engaging in nonpertinent conversation, which distracted them from their primary flight-related duties and led to their failure to correctly set…NTSB ERA10FA088Accident · 1 fatalField investigationFinal reportPiper PA-30 · Raneille, WVThe pilot's improper decision to attempt visual flight into deteriorating night weather conditions, and his subsequent controlled flight into terrain.NTSB ERA09CA534Accident · No injuriesData collectionFinal reportAeromot AMT200 · Wheeling, WVThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the pilot's failure to properly secure the canopy latch which resulted in an in-flight canopy opening.NTSB ERA09LA530Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Fairmont, WVThe pilot's delay in aborting the takeoff, resulting in an overun. Contributing to the accident was the overweight condition of the airplane.NTSB ERA09FA429Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Ravenswood, WVThe pilot's improper modification of the certified, on-board oxygen system, which resulted in incapacitation due to hypoxia, and the airplane's subsequent uncontrolled descent into terrain.NTSB DCA09FA065Accident · No injuriesField investigationFinal reportBoeing 737 · Charleston, WVFuselage skin failure due to preexisting fatigue at a chemically milled step.NTSB ERA09CA390Accident · No injuriesData collectionFinal reportPiper J3C · South Charleston, WVThe pilot's failure to maintain control during the attempted go-around.NTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.NTSB ERA09CA367Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Morgantown, WVThe pilot’s failure to maintain control of the helicopter during the practice hovering autorotation. Contributing to the accident was the pilot’s lack of experience in night vision goggle helicopter operations.NTSB ERA09LA348Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Fairmont, WVThe pilot’s failure to maintain control of the airplane during takeoff. Contributing to the accident was the pilot's inadequate use of the checklist.NTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.NTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…NTSB NYC08LA196Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Romney, WVA partial loss of engine power during takeoff due to failure of the left magneto. Contributing to the accident was unsuitable terrain to conduct a forced landing.NTSB NYC08LA129Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58HT · Belmont, WVThe fatigue failure of a tail rotor blade during an external load lift.NTSB NYC08CA119Accident · No injuriesData collectionFinal reportCessna 182Q · S.Charleston, WVThe pilot's failure to obtain a proper touchdown point. Contributing to the accident was the windshear as reported by the pilot.NTSB NYC08LA033Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Durbin, WVThe loss of engine power while in cruise flight due to the partially separated crankshaft oil seal.NTSB NYC08FA012Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Wiley Ford, WVA partial power loss in the right engine due to the failure of the number one exhaust valve, and the airplane's inability to maintain a climb on one engine for unknown reasons. Contributing to the accident were fog and rising terrain. [This report was…NTSB MIA07CA142Accident · Minor injuriesData collectionFinal reportFurey Kitfox IV · Cowen, WVThe in-flight collision with a bird resulting in separation of the propeller.NTSB NYC07CA204Accident · Minor injuriesData collectionFinal reportCessna 172 · Julian, WVThe pilot's inadequate preflight planning. Contributing to the accident were the overcast cloud conditions and the pilot's failure to maintain directional control during the landing roll.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB NYC07LA095Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS8-18 · Circleville, WVThe glider's inadvertent encounter with mechanical turbulence.NTSB NYC07FA041Accident · 1 fatalField investigationFinal reportMooney M20R · Summersville, WVThe airplane's encounter with in-flight icing, which resulted in a loss of engine power. Contributing to the accident were the pilot's improper weather evaluation, the in-flight icing conditions, the reduced visibility from a snow squall during the forced…NTSB NYC07CA014Accident · No injuriesData collectionFinal reportCessna 172N · Morgantown, WVThe student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.NTSB NYC06LA175Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Danville, WVA partial failure of the override clutch assembly. A contributing factor to the accident was the manufacturer's inadequate inspection procedures of the override clutch assembly following a tail rotor strike.NTSB NYC06CA173Accident · No injuriesData collectionFinal reportBell 47G-2 · Petersburg, WVThe passenger's inadvertent interference with the flight controls, which resulted in a loss of directional control and subsequent impact with the ground.NTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.NTSB NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…NTSB NYC06LA066Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Henderson, WVThe pilot's improper decision to attempt the off-airport takeoff; and his improper decision to continue the takeoff after striking a pole during the takeoff roll.NTSB NYC06CA012Accident · No injuriesData collectionFinal reportWeber Glastar · Summersville, WVa loss of engine power due to a stuck carburetor float needle.NTSB IAD05CA143Accident · No injuriesData collectionFinal reportMaule MT7-235 · Capon Bridge, WVThe pilot's misjudged distance/speed which resulted in an overrun and a subsequent impact with trees.NTSB IAD05LA122Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Saulsville, WVThe pilot's inadequate remedial action following a loss of control during the landing approach.NTSB IAD05CA092Accident · No injuriesData collectionFinal reportCallahan Rotorway Exec 90 · Weston, WVA loss of engine power for undetermined reasons during an attempted power recovery. A factor in the accident was the pilot's failure to maintain rotor rpm, which resulted in a hard landing and subsequent post crash fire.NTSB IAD05LA046Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Leet, WVA fatigue fracture of the main transmission drive pinion. Also causal was the manufacturer's failure to remove the affected pinions from service during the period that transpired between the initial failures and the accident flight.NTSB NYC05LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Cameron, WVA loss of engine power due to carburetor icing, which resulted in a forced landing. A factor in this accident was the carburetor icing conditions.NTSB NYC05LA049Accident · Minor injuriesLimited investigationFinal reportAeronca 65CA · Ravenswood, WVThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB IAD05CA025Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Wheeling, WVThe pilot misjudged his distance/speed, and his intentional landing on an unsuitable taxiway at night. A factor in the accident was the night light conditions.NTSB NYC05LA024Accident · No injuriesLimited investigationFinal reportCessna 172R · Martinsburg, WVA loss of engine power for undetermined reasons.NTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.NTSB IAD05LA011Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Clarksburg, WVThe pilot's inability to operate the airplane's brake pedals which resulted in the loss of aircraft control.NTSB NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.NTSB NYC04CA207Accident · No injuriesData collectionFinal reportCessna 402C · Charleston, WVThe pilot's improper decision to abort the takeoff with insufficient runway remaining. A factor was the wet runway.NTSB IAD04LA035Accident · Serious injuriesLimited investigationFinal reportGiles Mustang II · Rainelle, WVThe partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrainNTSB NYC04CA180Accident · No injuriesData collectionFinal reportCessna 182Q · Pence Springs, WVThe pilot's failure to maintain airspeed during final approach, which resulted in a hard landing and gear collapse.NTSB NYC04FA170Accident · 5 fatalField investigationFinal reportPiper PA-32R-301T · Wheeling, WVThe pilot's failure to maintain terrain clearance while executing an instrument approach. A factor was the night instrument meteorological conditions.NTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.NTSB NYC04FA139Accident · 2 fatalField investigationFinal reportBeech 200 · Rupert, WVThe pilot-in-command's improper decision to continue VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors were the FAA Principle Operations Inspector's inadequate surveillance of the operator, and a low ceiling.NTSB NYC04LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Davis, WVThe pilot's failure to maintain directional control after encountering a snow patch on the runway. A factor related to the accident was the snowdrift.NTSB NYC04CA032Accident · Minor injuriesData collectionFinal reportCessna 172N · Philippi, WVThe pilot's improper decision to depart from a runway of insufficient length. Factors in the accident were the turf runway and tailwind condition.NTSB NYC04LA024Accident · 1 fatalLimited investigationFinal reportCessna 150H · Bruceton Mills, WVThe pilot's physical impairment due to alcohol and his improper decision to attempt flight with a low cloud ceiling, low visibility, after consuming alcohol. A related factor in the accident was the low cloud ceiling.NTSB NYC04CA001Accident · No injuriesData collectionFinal reportWilliams RV-4 · Metz, WVThe pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landing