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 NYC93LA161Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Morgantown, WVThe pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.NTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.NTSB BFO93FA082Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Lyburn, WVFailure of the pilot to attain sufficient altitude to remain clear of rising terrain and objects. Factors related to the accident were darkness and rising terrain.NTSB BFO93LA069Accident · No injuriesLimited investigationFinal reportBeech B100 · Clarksburg, WVThe pilot's failure to maintain adequate clearance from the hangar. Contributing to the accident was the dark night.NTSB BFO93FA049Accident · Minor injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Beckley, WVFailure of the captain to assure proper alignment with the plowed portion of the runway (or perform a missed approach). Factors related to the accident were: darkness, the adverse weather condition, inadequate removal of snow from the runway with snow along…NTSB NYC93LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Valley Point, WVThe failure of the pilot to make a rejected landing when the airplane failed to decelerate properly. A factor related to the accident was the failure of the pilot to close the throttle upon touchdown.NTSB BFO93FA005Accident · 3 fatalField investigationFinal reportCessna 177B · War, WVVFR flight by the pilot into instrument meteorological conditions, his failure to maintain control of the airplane due to spatial disorientation, and the pilot allowing the design stress limits of the aircraft to be exceeded. Factors related to the accident…NTSB BFO93FA003Accident · 1 fatalField investigationFinal reportCessna 310R · Summersville, WVThe pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.NTSB NYC93LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Mallory, WVThe pilot failed to maintain control of the airplane, which resulted in the airplane departing the runway and striking a tree.NTSB NYC93LA027Accident · No injuriesLimited investigationFinal reportCessna 177 · Morgantown, WVThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing on a highway.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB NYC93FA005Accident · 3 fatalField investigationFinal reportBeech 35 · New Manchester, WVThe pilot's failure to obtain adequate airspeed and abort the takeoff. The pilot's premature rotation, upsloping runway, and a tailwind are contributing factors.NTSB BFO92LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenville, WVThe pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB NYC92LA151Accident · Minor injuriesLimited investigationFinal reportRockwell 112-TC · St Mary'S, WVThe fatigue cracking fracture of the propeller hub, resulting in a forced landing, and collision with a house.NTSB BFO92LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Charleston, WVThe pilot's failure to attain adequate airspeed to outclimb obstacles.NTSB NYC92LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Lewisburg, WVThe failure of the instructor pilot to take proper remedial action during a takeoff resulting in a loss of airplane control and subsequent inadvertant stall. Factors related to the accident were the instructor's lack of total, recent and instructional flight…NTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.NTSB BFO92FA048Accident · 2 fatalField investigationFinal reportMooney M20M · Youngs Bottom, WVThe pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.NTSB NYC92FA061Accident · 1 fatalField investigationFinal reportMooney M20K · Wheeling, WVThe pilot's failure to maintain airspeed and his improper handling of the aircraft which resulted in an inadvertent stall at an altitude insufficient for proper recovery. A factor related to the accident was icing conditions which resulted in airframe ice.NTSB BFO92LA012Accident · No injuriesLimited investigationFinal reportJohn W Upton SA-300 · Leon, WVThe defective welding between the axle and the wheel assembly causing the right main gear to collapse.NTSB BFO92LA007Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Spanishburg, WVThe pilot's intentional flight into instrument meteorological conditions. Contributing to the accident was the low ceiling in conjunction with the mountainous terrain and the pilot's over confidence.NTSB BFO92LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, WVThe engine failure caused by fuel starvation and the pilot's improper fuel management.NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.NTSB BFO91LA067Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Norton, WVThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the lost of engine power.NTSB BFO91DOA01Accident · Minor injuriesFinal reportBell UH-1B · Iaeger, WVThe loss of engine power for undetermined reasons, while operating over unsuitable terrain.NTSB BFO91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Beckley, WVThe pilot's failure to attain adequate flying speed.NTSB BFO91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Elkins, WVThe loss of engine power for undetermined reasons.NTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.NTSB BFO91FA031Accident · Serious injuriesField investigationFinal reportCessna 182F · Princeton, WVThe pilot's inadequate inflight decision which resulted in airframe icing.NTSB DCA91MA019Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Beckley, WVFlight into known adverse weather conditions by the pilot, which resulted in ice accumulation on the aircraft and subsequent loss of aircraft control (tail plane stall) as the flaps were fully extended. Factors related to the accident were: the pilot's…NTSB NYC91LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, WVTotal loss of engine power in cruise flight due to failure of the accessory drive gear dowel pin resulting in a forced landing over unsuitable terrain and subsequent nose over on landing roll. A factor related to the accident was the improper procedure used…NTSB BFO91LA017Accident · No injuriesLimited investigationFinal reportRockwell 690C · Summerville, WVPilot's failure to maintain adequate aircraft control during the landing flare/touchdown. The turbulent weather was a related factor.NTSB NYC91LA020Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Parkersburg, WVCatastrophic failure of the left engine fan disc due to low cycle fatigue.NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.NTSB BFO90FA076Accident · 1 fatalField investigationFinal reportPiper PA-601P · Wiley Ford, WVThe pilot's improper IFR procedure by not maintaining sufficient altitude, while circling to land. Factors related to the accident were: the low ceiling and visibility conditions in fog.NTSB BFO90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Charleston, WVFuel exhaustion due to fatigue failure of a fuel line. Factors related to the accident were: lack of suitable terrain and obstructions (trees & utility pole) in the emergency landing area.NTSB BFO90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · S. Charleston, WVPilot's failure to maintain directional control of the airplane. A related factor crosswind conditions.NTSB BFO90LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Alderson, WVThe pilot's failure to maintain adequate airspeed, causing the aircraft to stall. Low altitude and inattention were related factors.NTSB BFO90FA057Accident · 2 fatalField investigationFinal reportMooney M20E · Charleston, WVThe pilot's improper IFR procedures, his failure to maintain a proper glide path on the ILS approach, and his failure to initiate a missed approach at the decision height. The adverse weather was a related factor.NTSB BFO90FA054Accident · 2 fatalField investigationFinal reportCessna 172RG · Onego, WVVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate clearance (altitude) from mountainous terrain. The terrain and adverse weather conditions were related factors.NTSB BFO90FA050Accident · 4 fatalField investigationFinal reportRockwell 114 · Anawalt, WVFailure of the pilot to maintain proper altitude and clearance above the terrain. Factors related to the accident were: darkness, mountainous terrain, and low ceiling.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.NTSB BFO90FA046Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Capon Bridge, WVInadequate visual lookout by the pilots of the DC-3, which resulted in their failure to see-and-avoid the powerlines. Factors related to the accident were: the obstruction (transmission wires), and the lack of visual cues for the pilots.NTSB BFO90IA039Incident · No injuriesIncident investigationFinal reportBellanca 17-30 · Davis, WVThe improper installation of the connecting rod bearings on the number one cylinder.NTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.