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 CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.Aug 7, 1993 · N4724K · Substantial damageNTSB CHI93DTK02Accident · Minor injuriesFinal reportHiller UH-12E · Milbank, SDUndeterminedJul 18, 1993 · N4028M · DestroyedNTSB CHI93DTK01Accident · 1 fatalFinal reportCrowser Avid MK 3.75 · Philip, SDThe pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.Jul 5, 1993 · N42CJ · DestroyedNTSB CHI93LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rapid City, SDThe pilot in command's inadequate compensation for wind conditions.Jun 23, 1993 · N5435E · Substantial damageNTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.Jun 11, 1993 · N3890E · Substantial damageNTSB CHI93LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Yankton, SDThe pilot in command's failure to maintain proper clearance. Gusty wind conditions were a factor.Apr 24, 1993 · N5548W · DestroyedNTSB CHI93IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Sioux Falls, SDThe pilot-in-command's inadequate preflight.Dec 29, 1992 · N31SV · Minor damageNTSB CHI92LA233Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Madison, SDThe pilot's inadequate visual lookout and inadvertent descent.Aug 9, 1992 · N30SV · Substantial damageNTSB CHI92LA236Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Winner, SDFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.Aug 7, 1992 · N30MT · Substantial damageNTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · DestroyedNTSB CHI92DTK02Accident · No injuriesFinal reportWeatherly 201C · Timber Lake, SDThe pilot's improper use of the propeller control during takeoff and initial climb.Jun 1, 1992 · N1290W · DestroyedNTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.May 18, 1992 · N4427Y · DestroyedNTSB CHI92LA138Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Sioux Falls, SDThe pilot-in-command's failure to maintain directional control.Apr 29, 1992 · N87020 · Substantial damageNTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.Mar 19, 1992 · N1013E · Substantial damageNTSB CHI93LA381Accident · No injuriesLimited investigationFinal reportCessna 172 · Union Center, SDImproper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.Jan 19, 1992 · N8529U · Substantial damageNTSB CHI91DTK04Accident · 1 fatalFinal reportBoland/Poe Tsunami · Pierre, SDA bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…Sep 25, 1991 · NX39JR · DestroyedNTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.Sep 10, 1991 · N8814L · Substantial damageNTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.Aug 24, 1991 · N16098 · 2 aircraft · Substantial damageNTSB CHI91LA239Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Bridgewater, SDDirectional control was not maintained by the pilot. A factor related to the accident was a fence.Aug 1, 1991 · N6373A · Substantial damageNTSB CHI91DTK03Accident · 1 fatalFinal reportWag-Aero Super Cuby · Roscoe, SDThe pilot's inadvertent stall and inadequate remedial action. Associated factors are the pilot's lack of recent total experience and inadequate preflight planning/preparation.Jul 19, 1991 · N336DT · DestroyedNTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.Jul 13, 1991 · N9399G · Substantial damageNTSB CHI91LA210Accident · 2 fatalLimited investigationFinal reportCessna 150F · Faulkton, SDAn inadvertent stall. A factor related to the accident was the pilot's failure to maintain airspeed.Jul 5, 1991 · N6263R · DestroyedNTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.Jul 4, 1991 · N1844G · Substantial damageNTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.Jun 27, 1991 · N541FL · Substantial damageNTSB CHI91DTK01Accident · 2 fatalFinal reportPiper PA-18-125 · Newell, SDAn inadvertent stall/spin during maneuvering flight and inadequate remedial action by the pilot. Factors associated with the accident are the pilot's disregard for procedures and directives and inadequate initial training.May 26, 1991 · N1799A · DestroyedNTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.Apr 24, 1991 · N5720C · Substantial damageNTSB CHI91LA117Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankton, SDFailure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.Mar 27, 1991 · N1743V · Substantial damageNTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.Sep 15, 1990 · N73059 · DestroyedNTSB CHI90LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sturgis, SDPoor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.Aug 10, 1990 · N15803 · Substantial damageNTSB CHI90LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, SDThe pilot in command's improper in flight planning which resulted in fuel exhaustion and a forced landing in a field at which time the aircraft nosed over.Jul 15, 1990 · N68422 · Substantial damageNTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.Jun 9, 1990 · N7136Z · DestroyedNTSB DEN90LA127Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Sisseton, SDA total loss of power due to fuel starvation. Fuel starvation was caused by a missing fuel valve support clamp and a resultant cracked fuel line. Inadequate maintenance inspections and rough, uneven terrain were contributing factors.Jun 7, 1990 · N5649X · Substantial damageNTSB DEN90LA125Accident · No injuriesLimited investigationFinal reportCessna 188A · Martin, SDThe on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.Jun 4, 1990 · N78516 · Substantial damageNTSB DEN90LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Sturgis, SDPilot inadvertently stalling the airplane. Contributing to the accident was the pilot's lack of total experience.Jun 4, 1990 · N6418F · DestroyedNTSB DEN90LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sioux Falls, SDThe pilot's loss of directional control during landing roll.May 20, 1990 · N4850S · Substantial damageNTSB DEN90DTK01Accident · 1 fatalFinal reportPiper PA-36-375 · Woonsocket, SDFailure of the pilot of N3634E to follow the briefed plan of operation, and failure of both pilots to see-and-avoid each other (inadequate visual lookout).May 8, 1990 · N3634E · 2 aircraft · DestroyedNTSB DEN90LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Edgemont, SDThe failure of the pilot to maintain directional control during the landing rollout.Apr 21, 1990 · N8528D · Substantial damageNTSB DEN90FA076Accident · 4 fatalField investigationFinal reportCessna 182N · Caputa, SDImproper planning/decision by the pilot, accumulation of structural ice and the pilot's failure to maintain control of the aircraft. The adverrse weather was a related factor.Mar 22, 1990 · N92292 · DestroyedNTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.Mar 11, 1990 · N35485 · Substantial damageNTSB DEN90LA070Accident · 1 fatalLimited investigationFinal reportChampion 7EC · Pine Ridge, SDThe failure of the pilot to maintain an adequate airspeed, after diverting his attention, which resulted in an inadvertent stall.Mar 4, 1990 · N4301C · DestroyedNTSB CHI90TL#03Accident · Serious injuriesClass 3Final reportBell 206B · Fort Thompson, SDFeb 12, 1990 · N620 · DestroyedNTSB DEN90FA055Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rapid City, SDFailure of the pilot to maintain adequate airspeed (VMC), which resulted in a loss of aircraft control. A factor related to the accident was: fatigue failure of a coupling shaft in the #1 engine, which resulted in loss of power in that engine.Feb 9, 1990 · N64MD · Substantial damageNTSB DEN90LA038Accident · No injuriesLimited investigationFinal reportCessna 182M · Pierre, SDInadequate compensation for the wind conditions by the pilot. An on ground encounter with wind gusts is considered an additional cause.Jan 11, 1990 · N70844 · Substantial damageNTSB DEN90IA016Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Rapid City, SDThe inflight failure of the recirculating fan unit and several air duct temperature limiting sensors.Oct 27, 1989 · N344UA · No damageNTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.Sep 2, 1989 · N2685G · Substantial damageNTSB DEN89LA176Accident · No injuriesLimited investigationFinal reportCessna 170B · Kyle, SDThe pilot used poor preflight planning & decision-making in selecting a road on which to land during gusty wind conditions which resulted in the failure to maintain direction control.Jul 23, 1989 · N8102A · Substantial damageNTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.May 23, 1989 · N82644 · DestroyedNTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.Apr 14, 1989 · N8272W · Substantial damageNTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.Mar 7, 1989 · N150C · Substantial damageNTSB DEN88LA208Accident · No injuriesLimited investigationFinal reportCessna 421B · Winner, SDThe private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…Sep 20, 1988 · N44HV · Substantial damage