NTSB investigations

19,222 cases where NTSB found Aircraft.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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 CEN23LA346Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Halstad, MNThe pilot’s attempt to rotate the airplane without sufficient airspeed which resulted in a lack of climb performance and impact with terrain. Contributing to the accident was the pilot’s decision to attempt the takeoff with a tailwind.Aug 2, 2023 · N45453 · Substantial damageNTSB CEN23LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Rosenberg, TXThe student pilot’s improper fuel management that resulted in fuel exhaustion, a total loss of engine power, and a subsequent forced landing and landing overrun at an alternate airport.Aug 2, 2023 · N38483 · Substantial damageNTSB ERA23LA320Accident · 1 fatalClass 3 · LimitedFinal reportMesnard Velocity Twin · Sandersville, GAA total loss of power in the right engine due to the right ECU injector wires being severed by the main landing gear actuator piston teeter bar as a result of a lack of clearance and protection of the wiring bundle.Aug 1, 2023 · N106VT · Substantial damageNTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.Aug 1, 2023 · N31PB · Substantial damageNTSB CEN23LA381Accident · Serious injuriesClass 4 · LimitedFinal reportGeorge Stone KIT FOX Model 3 · Scottsburg, INThe student pilot’s failure to maintain airplane control after takeoff that resulted in an impact with terrain.Aug 1, 2023 · N815US · Substantial damageNTSB ANC23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportCort J Neuman Apex · Wasilla, AKThe pilot’s failure to maintain clearance during takeoff, which resulted in impact with trees.Aug 1, 2023 · N907AX · Substantial damageNTSB WPR23LA295Accident · Serious injuriesClass 3 · LimitedFinal reportFish Larry W Lancair 360 · Renton, WAA loss of electrical power due to low battery voltage, which resulted in an inflight shut down of the capacitor discharge ignition system and a loss of engine power. Contributing to the accident was the pilot’s failure to switch batteries after the electrical…Jul 31, 2023 · N68XA · Substantial damageNTSB ERA23LA356Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 31, 2023 · N3036M · Substantial damageNTSB ERA23LA318Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Laconia, NHThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane, which resulted in a ground-loop.Jul 31, 2023 · N9855A · Substantial damageNTSB CEN23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Sherman, TXThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.Jul 31, 2023 · N6837F · Substantial damageNTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.Jul 31, 2023 · N567VF · Substantial damageNTSB WPR23LA297Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Blanchard, IDFuel contamination, which resulted in a loss of engine power. The source of the contamination could not be determined.Jul 30, 2023 · N613SS · Substantial damageNTSB WPR23LA294Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Ravensdale, WAPartial loss of power for undetermined reasons. Contributing to the accident was the siphoning of fuel from the left-wing fuel filler port due to wear on the fuel filler cap.Jul 30, 2023 · N195JL · Substantial damageNTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.Jul 30, 2023 · N2362Z · Substantial damageNTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.Jul 30, 2023 · N918KG · Substantial damageNTSB WPR23FA287Accident · 3 fatalClass 3 · FieldFinal reportBeech P35 · Upland, CAThe pilot’s exceedance of the airplane’s critical angle of attack, for reasons that could not be determined, which resulted in a subsequent aerodynamic stall and impact with a building.Jul 30, 2023 · N8572M · Substantial damageNTSB CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.Jul 30, 2023 · N967DT · Substantial damageNTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.Jul 29, 2023 · N314E · Substantial damageNTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.Jul 29, 2023 · N652HA · Substantial damageNTSB CEN23LA338Accident · Minor injuriesClass 4 · LimitedFinal reportRans S-6ES · Ozark, AROil starvation of the propeller speed reduction unit which resulted in a total loss of engine power.Jul 29, 2023 · N123TG · DestroyedNTSB CEN23LA336Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Alta, IAThe airplane’s encounter with a dust devil, which resulted in a loss of lift, and subsequent collision with powerlines.Jul 29, 2023 · N402PR · Substantial damageNTSB CEN23FA332Accident · 2 fatalClass 3 · FieldFinal reportNorth American AT-6D · Oshkosh, WIThe pilot’s failure to maintain airspeed while maneuvering, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.Jul 29, 2023 · N49961 · DestroyedNTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.Jul 28, 2023 · N185GG · Substantial damageNTSB WPR23FA286Accident · 1 fatalClass 3 · FieldFinal reportRisen 915 iS · Glendive, MTThe pilot’s failure to maintain airspeed, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.Jul 28, 2023 · N2442 · DestroyedNTSB CEN23LA335Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Tyler, MNThe pilot’s improper flap position during takeoff, which resulted in degraded climb performance and a collision with terrain.Jul 28, 2023 · N7094Z · Substantial damageNTSB WPR23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Eastsound, WAThe pilot’s improper in-flight fuel management, which led to fuel starvation and a total loss of engine power.Jul 27, 2023 · N6201M · Substantial damageNTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.Jul 27, 2023 · N15417 · Substantial damageNTSB CEN23LA334Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Aberdeen, SDThe pilot's failure to maintain directional control while taxiing with a quartering tailwind, which resulted in a ground loop.Jul 27, 2023 · N8503W · Substantial damageNTSB CEN23LA330Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cortland, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing.Jul 27, 2023 · N30632 · Substantial damageNTSB CEN23LA329Accident · Minor injuriesClass 3 · LimitedFinal reportVarga 2150A · Green Lake, WIA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.Jul 27, 2023 · N5601G · Substantial damageNTSB ERA23LA314Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20R · Chattanooga, TNThe pilot’s failure to maintain the proper glidepath during final approach, which resulted in a collision with the approach lights short of the runway. Contributing was the pilot’s distraction due to the cabin door opening.Jul 26, 2023 · N62GH · Substantial damageNTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.Jul 26, 2023 · N467HA · Substantial damageNTSB CEN23LA326Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Charles City, IAThe pilot’s improper preflight of the helicopter to ensure that it was within the loading and performance limitations that resulted in settling and impact with terrain during initial climb.Jul 26, 2023 · N4174L · Substantial damageNTSB ANC23LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Point Baker, AKThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.Jul 26, 2023 · N6782L · Substantial damageNTSB ERA23FA313Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Churchville, MDThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall/spin and loss of control that the pilot did not recover from.Jul 25, 2023 · N34PT · Substantial damageNTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.Jul 25, 2023 · N291DL · Substantial damageNTSB CEN23FA320Accident · Minor injuriesClass 3 · FieldFinal reportHeath V-Strut · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 25, 2023 · N9549 · Substantial damageNTSB ERA23LA310Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · New London, NCA partial loss of engine power due to the No. 4 cylinder’s stuck exhaust valve.Jul 24, 2023 · N98134 · Substantial damageNTSB CEN23LA322Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415-D · Waupun, WIThe pilot’s decision to take off without correcting a misinstalled fuel cap, which resulted in a loss of engine power due to fuel starvation caused by improper venting of the fuel system.Jul 23, 2023 · N415JC · Substantial damageNTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.Jul 23, 2023 · N17043 · Substantial damageNTSB WPR23LA284Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Red Lodge, MTThe pilot’s loss of directional control during landing with wind gusts, which resulted in a ground loop and collision with a fence.Jul 22, 2023 · N53132 · Substantial damageNTSB ERA23LA311Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Winter Haven, FLThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with a taxiway sign.Jul 22, 2023 · N7528W · Substantial damageNTSB CEN23LA319Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Wallis, TXThe failure of the tail boom structure due to cyclic torsion overloading as of a result of flutter in the empennage. The reason for the flutter could not be determined.Jul 22, 2023 · N64JG · Substantial damageNTSB CEN23LA317Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Patoka, ILA partial loss of engine power due to the failure of two compressor turbine blades as a result of the engine operating near or above the engine’s operating limits for an undetermined amount of time beyond the recommended engine’s TBO limit, which led to…Jul 22, 2023 · N9892 · Substantial damageNTSB WPR23LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12S · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.Jul 21, 2023 · N48MR · Substantial damageNTSB ERA23LA312Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Roanoke, VAThe student pilot’s failure to maintain directional control during the landing, and the flight instructor’s inadequate remedial action.Jul 21, 2023 · N524DS · Substantial damageNTSB ERA23LA307Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Terra Alta, WVThe pilot’s inability to maneuver the helicopter for recovery after experiencing a strong, unanticipated tailwind in a confined operating area, which resulted in a descent and subsequent impact with terrain.Jul 21, 2023 · N9913K · Substantial damageNTSB ERA23LA306Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300 · Mount Gilead, OHThe pilot’s improper fuel management by not switching fuel tanks in flight, resulting in fuel starvation to the engine and a total loss of engine power.Jul 21, 2023 · N9519C · Substantial damageNTSB CEN23LA327Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV10 · Chouteau, OKThe total loss of engine power as a result of a failed positive crankcase ventilation (PCV) valve and a subsequent impact with terrain.Jul 21, 2023 · N730WL · Substantial damageNTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.Jul 21, 2023 · N602AA · Substantial damage