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.
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
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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.NTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.NTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.NTSB 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.NTSB 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.NTSB 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.NTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.