Final NTSB investigations, SD

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\" = 'SD' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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.

NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.Jun 15, 2012 · N45379 · Substantial damageNTSB CEN12LA346Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Clark, SDThe pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.Jun 7, 2012 · N18012 · Substantial damageNTSB CEN12LA357Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Howard, SDA fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.May 23, 2012 · N8421V · Substantial damageNTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.May 23, 2012 · N30951 · Substantial damageNTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.Apr 24, 2012 · N8121R · Substantial damageNTSB CEN12LA242Accident · Minor injuriesLimited investigationFinal reportBell 407 · Aberdeen, SDThe fatigue failure of two turbine engine blades due to vibration.Apr 14, 2012 · N509MT · Substantial damageNTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.Apr 5, 2012 · N104MH · Substantial damageNTSB CEN12LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rapid City, SDThe loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.Feb 24, 2012 · N20GG · Substantial damageNTSB CEN12CA159Accident · No injuriesData collectionFinal reportMaule MX-7-235 · Tea, SDThe pilot did not maintain directional control of the airplane during a crosswind landing.Feb 8, 2012 · N5664N · Substantial damageNTSB CEN12LA103Accident · No injuriesLimited investigationFinal reportBeech C23 · Watertown, SDA total loss of engine power during initial climb for undetermined reasons.Dec 9, 2011 · N6717K · Substantial damageNTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…Dec 9, 2011 · N421SY · Substantial damageNTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.Nov 11, 2011 · N13584 · Substantial damageNTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damageNTSB CEN12FA001Accident · 1 fatalField investigationFinal reportRobinson Helicopter R66 · Philip, SDThe in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.Oct 1, 2011 · N266CY · DestroyedNTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.Aug 20, 2011 · N7051Z · Substantial damageNTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.Aug 10, 2011 · N127FC · Substantial damageNTSB CEN11FA437Accident · 3 fatalField investigationFinal reportAmerican Champion 7GCBC · Hayti, SDThe pilot's decision to attempt low-altitude flight and his failure to maintain adequate clearance from power lines.Jul 3, 2011 · N711AT · Substantial damageNTSB CEN11LA452Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Estelline, SDThe pilot’s failure to maintain control of the airplane during takeoff for undetermined reasons because the pilot did not recall the accident.Jun 28, 2011 · N1588M · Substantial damageNTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.Jun 18, 2011 · N7018Z · Substantial damageNTSB CEN11LA399Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Highmore, SDThe pilot did not maintain control of the airplane while maneuvering at low altitude.Jun 17, 2011 · N57885 · Substantial damageNTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.Apr 25, 2011 · N3104S · Substantial damageNTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.Mar 23, 2011 · N4057C · Substantial damageNTSB CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.Nov 8, 2010 · N3029Z · Substantial damageNTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Sep 24, 2010 · N5364H · Substantial damageNTSB CEN10LA430Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Spearfish, SDThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Jul 24, 2010 · N1158X · Substantial damageNTSB CEN10LA429Accident · 1 fatalLimited investigationFinal reportWarth Dennis J Classic Sport S-18 · Tea, SDA loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.Jul 24, 2010 · N216TB · Substantial damageNTSB CEN10CA415Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Bison, SDThe pilot's failure to maintain directional control of the airplane after encountering a gust of wind while taking off with a crosswind.Jul 7, 2010 · N391EU · Substantial damageNTSB CEN10CA305Accident · No injuriesData collectionFinal reportCessna 337 · Custer, SDA partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.Jun 5, 2010 · N2267X · Substantial damageNTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.May 29, 2010 · N88399 · Substantial damageNTSB CEN10CA244Accident · No injuriesData collectionFinal reportPiper J3L · Kyle, SDThe pilot's improper touchdown on a soft landing area, resulting in a nose over.May 8, 2010 · N24502 · Substantial damageNTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.Sep 29, 2009 · N3260N · Substantial damageNTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.Aug 16, 2009 · N98AW · Substantial damageNTSB CEN09CA519Accident · No injuriesData collectionFinal reportCessna 182A · Watertown, SDA loss of engine power due to fuel exhaustion as a result of a fuel tank leak. Contributing to the accident was the reported malfunction of the fuel gauge.Jul 31, 2009 · N2131G · Substantial damageNTSB CEN09LA388Accident · Serious injuriesLimited investigationFinal reportBeech B100 · Rapid City, SDThe flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.Jun 15, 2009 · N4490M · No damageNTSB CEN09CA616Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Clark, SDThe pilot's inadequate visual lookout and failure to maintain clearance from a levy.Jun 12, 2009 · N57625 · Substantial damageNTSB CEN09CA305Accident · No injuriesData collectionFinal reportFlight Design CT2K · Mitchell, SDThe pilot's inadequate compensation for the gusting winds during landing.May 13, 2009 · N433CT · Substantial damageNTSB CEN09LA206Accident · No injuriesLimited investigationFinal reportCessna 402B · Aberdeen, SDThe pilot's continued flight into adverse weather and icing conditions, and his failure to maintain aircraft control resulting in a hard landing. Contributing to the accident was the accumulation of airframe ice and the strong, gusting crosswinds.Mar 10, 2009 · N402BP · Substantial damageNTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.Mar 6, 2009 · N648LA · Substantial damageNTSB CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.Dec 24, 2008 · N89418 · Substantial damageNTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.Oct 10, 2008 · N162NJ · Substantial damageNTSB CHI08CA296Accident · No injuriesData collectionFinal reportPiper PA28 · Gann Valley, SDThe pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.Sep 27, 2008 · N6266J · Substantial damageNTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.Aug 10, 2008 · N9078G · Substantial damageNTSB CHI08CA245Accident · No injuriesData collectionFinal reportAir Tractor 301 · Herreid, SDFailure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.Aug 5, 2008 · N3161A · Substantial damageNTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.Aug 4, 2008 · N16235 · Substantial damageNTSB CHI08CA232Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Wall, SDThe pilot not maintaining airplane control during the landing. Contributing to the accident was the reported wind shear.Aug 3, 2008 · N5951Z · Substantial damageNTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.Apr 18, 2008 · N32394 · Substantial damageNTSB CHI08CA111Accident · No injuriesData collectionFinal reportVeldhuizen Highlander · Onida, SDThe separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.Apr 18, 2008 · N8888V · Substantial damageNTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.Oct 29, 2007 · N77LU · Substantial damageNTSB CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.Jul 30, 2007 · N661FB · Substantial damageNTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.Jul 17, 2007 · N5069B · No damage