NTSB investigations, WV
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ATL83FA290Accident · No injuriesField investigationFinal reportCessna TR 182 · Seneca Rocks, WVThe acft collided with trees and the ground following a reported loss of power. The acft had completed a descent of 2000-3000 ft to observe rock formations and had commenced a climb when power loss occurred. The plt said the mixture wasleft in lean position…NTSB ATL83AA285Accident · 4 fatalFinal reportPiper PA-31P · Lost Creek, WVThe acft took off with 4 occupants & an estimated 596 lbs of cargo on board. After it took off, the ATC controller noted that it was climbing slower than expected. After climbing to about 4200 ft MSL, the aircrew reported a problem with the left eng & said…NTSB ATL83LA283Accident · No injuriesLimited investigationFinal reportCessna 310 · Wheeling, WVDuring the apch, the plt was unable to get a safe down indication for the right main gear. He changed the light bulb & still did not get a safe indication. A tower flyby was made, but the tower operator was unable to confirm if the right gear was locked. To…NTSB ATL83FA247Accident · 1 fatalField investigationFinal reportBeech G18S · Keyser, WVThe manager of blackhawk airways had cleared the flt for a 1000 EDT departure, but the actual takeoff time was not established. No record of a preflt wx briefing was found. However, during a telephone conversation prior to the flt, the plt indicated to his…NTSB ATL83LIJ03Accident · No injuriesFinal reportPiper PA-28-140 · Bruceton Mills, WVThe acft collided with a fence during an attempted takeoff from a short sod private strip. The privately owned grass strip is approx. 800 feet long with a 5 deg upgrade from the midway point. The pilot said he realized he could not climbfast enough so he…NTSB ATL83LA217Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Shinnston, WVThe instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a…NTSB ATL83FIJ02Accident · Serious injuriesFinal reportCessna 182P · Bluefield, WVThe plt reported that he began an ILS approach to the mercer county arpt. He stated that he planned to descend to 3200 ft MSL, then execute a missed approach & return to abington, VA. The arpt elevation was 2857 ft MSL. He stated that he remembered glancing…NTSB ATL83LA160Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Charleston, WVDuring an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing…NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…NTSB ATL83FIJ01Accident · 2 fatalFinal reportPiper PA-28-161 · Man, WVA witness reported that the pilot landed about 2100 ft down the 2750 ft, turf runway, rolled several hundred feet, then attempted to go around. When the aircraft was about 4 or 5 ft in the air, it hit some trees while heading into a river basin near the end…NTSB ATL83IA032Incident · No injuriesIncident investigationFinal reportCessna 185 · Clarksburg, WVThe aircraft had been tentatively sold to the 2 passengers and was being flown from marlboro, ma to dumas, ar with a refueling stop at Clarksburg, WV. Shortly after taking off from Clarksburg, a radio problem was encountered. The pilot was cleared to land on…NTSB NYC82FA237Accident · 5 fatalField investigationFinal reportPiper PA-32-R-300 · Berkeley Spring, WVWhile en route, the aircraft collided with the side of a mountain during level flight at about 2000 ft MSL. The impact occurred where the terrain sloped upward at about a 45 deg angle. Prior to takeoff, the pilot was advised of marginal VFR conditions and…NTSB ATL82DA266Accident · No injuriesFinal reportAero Commander 112 · Fayetteville, WVUpon arrival at the destination arpt, the rwy lights were off & the plt diverted to the fayette arpt. During final the acft struck a tree 200 ft from the displaced threshold of rwy 21. The tree was 13 ft above the rwy end elevation.NTSB ATL82DA225Accident · No injuriesFinal reportPiper PA-38-112 · Keyser, WVPilot was making a go-around over a 1700 foot runway. Full flaps were left down until end of runway and then raised to 21 degrees. Terrain was rising faster then aircraft was climbing. Aircraft struck trees and nosed down into the ground. Temperature was 85…NTSB ATL82DA201Accident · No injuriesFinal reportCessna 182E · Taplin, WVThe pilot stated that the sod runway had just been mowed. During the takeoff roll, the left wheel pant became filled with cut grass and locked the wheel. Subsequently, the aircraft veered to the left. The pilot reported that the left wing contacted low trees…NTSB ATL82DA191Accident · No injuriesFinal reportBeech V35 · Huntington, WVBefore departing st louis, MO, attempts to restart the engine were unsuccessful until an auxiliary power unit was used. The aircraft took off at 1746, and about one hour later, the pilot noticed that the ammeter indicated a discharge. The flight was…NTSB ATL82DA181Accident · No injuriesFinal reportCessna 172 · Martinsburg, WVShortly after level-off to cruise, the engine began to lose power. The pilot attempted to restore the power, but the engine RPM continued to decrease. A turn was made back toward the airport. While scanning the instruments, zero oil pressure and a high oil…NTSB ATL82DA133Accident · No injuriesFinal reportCessna 182 · Summersville, WVAccording to the pilot, he made his landing approach high and hot. He touched down long and was unable to stop on the remaining runway. While applying brakes, the aircraft veered off the side of the runway. Subsequently, the nose and right main gear failed.NTSB ATL82FIJ02Accident · 2 fatalFinal reportPiper PA-12 · Dunbar, WVThe pilot took off eastbound toward multiple power lines that crossed the river. The aircraft climbed to about 100 feet and was turning left away from the wires when it nosed over and crashed into the river. The pilot did not have a seaplane rating but had…NTSB ATL82FIJ01Accident · 1 fatalFinal reportBrantley B-2B · Athens, WVThe helicopter crashed in a wooded, rocky area while the pilot was en route from the welch hospital to his residence in Athens, WV. An investigation revealed that the fuel tank bladder had ruptured, but no odor of fuel was noted. Later, the engine was…NTSB ATL82DA117Accident · Minor injuriesFinal reportCessna 152 · White Sulphur S, WVThe pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the…NTSB ATL82DA112Accident · No injuriesFinal reportCessna 172 · Buckhannon, WVThe pilot reported making a normal approach to runway 26 in turbulent and windy conditions. He estimated that the wind was from 360 degrees at 15 to 20 knots. After the main wheels touched down, he encountered a gust of wind that he estimated was above 30…NTSB ATL82DA069Accident · Minor injuriesFinal reportCessna 182P · Huntington, WVAccording to the pilot the engine failed after liftoff at about the 3500 foot point down the runway at approximately 300 feet AGL. The runway has 1000 feet of overrun and the aircraft came to rest near the runup area for runway 12. The aircraft had not been…NTSB ATL82IA034Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Clarksburg, WVDuring taxi out from greensboro, NC, the captain noted that the aircraft was pulling to the right. The problem alleviated itself when the pilot tapped the right brake. After a normal takeoff, the copilot noticed during gear retraction that the right main…NTSB ATL82FA020Accident · 3 fatalClosedCessna T210 · Charleston, WVNTSB ATL82FGM01Accident · No injuriesClosedPiper PA-38 · New Cumberland, WVNTSB ATL81DIJ14Accident · No injuriesClosedCessna 152 · Smithville, WVNTSB ATL81FA114Accident · 2 fatalClosedHughes 269C · Falls Mill, WVNTSB ATL81FIJ13Accident · No injuriesClosedCessna 172N · Glenville, WVNTSB ATL81FIJ12Accident · No injuriesClosedBeech B-60 · Charleston, WVNTSB ATL82FA109Accident · 3 fatalClosedCessna 172F · Wolf Pen, WVNTSB ATL81FIJ11Accident · Minor injuriesClosedHughes 269B · Ceredo, WVNTSB ATL81IA082Incident · No injuriesClosedGrum Amer AA-5A · Clarksburg, WVNTSB ATL81FIJ10Accident · No injuriesClosedCessna 150 · Hurricane, WVNTSB ATL81FIJ09Accident · Serious injuriesClosedBaby Ace D · S.Charleston, WVNTSB ATL81FA077Accident · 2 fatalClosedPiper PA-28R · Huttonville, WVNTSB ATL81FIJ08Accident · No injuriesClosedCessna 172H · Spring Hill, WVNTSB ATL81DIJ07Accident · No injuriesClosedCessna 152 · Bridgeport, WVNTSB ATL81FIJ05Accident · Serious injuriesClosedBell 47G · Sharples, WVNTSB ATL81FIJ05Accident · Minor injuriesClosedHughes 269B · Hurricane, WVNTSB ATL81FA055Accident · 1 fatalClosedBeech 35 · Buckhannon, WVNTSB ATL81FIJ04Accident · No injuriesClosedCessna 150 · Buckhannon, WVNTSB ATL81FA049Accident · Minor injuriesClosedBeech A60 · Davis, WVNTSB ATL81FA045Accident · 1 fatalClosedPiper PA-34 · Morgantown, WVNTSB DCA81AA007Accident · 5 fatalClosedCessna 500 · Bluefield, WVNTSB NYC81FGM08Accident · No injuriesClosedCessna 172H · New Cumberland, WVNTSB ATL81FIJ01Accident · Serious injuriesClosedCessna 180 · Morgantown, WVNTSB ATL81IA014Incident · No injuriesClosedBeech D-18 · Parkersburg, WVNTSB ATL80FA096Accident · No injuriesClosedCessna 152 · Bluefield, WVNTSB ATL80FA095Accident · No injuriesClosedCessna 172 · Bluefield, WV