NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 CEN23LA341Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Arthur, ILThe pilot’s failure to maintain clearance from trees during a low-level aerial application flight.Jul 31, 2023 · N644ME · 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 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 WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.Jul 30, 2023 · N8675W · 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 CEN23LA342Accident · 1 fatalClass 4 · LimitedFinal reportBell 206B · Denison, IAThe pilot’s inflight distraction, which resulted in his failure to see and avoid wires.Jul 30, 2023 · N231RL · 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 WPR23FA289Accident · Serious injuriesClass 3 · FieldFinal reportCessna 177 · Gillette, WYThe pilot's decision to depart the high-density-altitude airport with the airplane at the maximum gross weight limit.Jul 29, 2023 · N3357T · 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 DCA23LA384Accident · No injuriesClass 3 · LimitedFinal reportBoeing 767-322 · Houston, TXThe first officer’s improper control inputs after the airplane touched down. Contributing to the severity of the damage was the flight crew’s lack of recognition that the speedbrakes were not armed, which led to their delayed deployment.Jul 29, 2023 · N641UA · Substantial damageNTSB 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 CEN23FA333Accident · 2 fatalClass 3 · FieldFinal reportRotorway 162F · Oshkosh, WIThe failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.Jul 29, 2023 · N193AZ · 2 aircraft · DestroyedNTSB 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 WPR23LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Dune City, ORThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and impact with terrain.Jul 28, 2023 · N66165 · Substantial damageNTSB 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 DCA23LA382Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Myrtle Beach (Atlantic Ocean)An encounter with convectively induced turbulence (CIT) while in cruise flight.Jul 28, 2023 · N77431 · No damageNTSB CEN23LA343Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCX-1865 · Charleston, WVThe pilot’s failure to maintain direction control during the landing roll.Jul 28, 2023 · N28ZV · Substantial damageNTSB 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 ERA23LA316Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Maiden, NCThe flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.Jul 27, 2023 · N6194Q · 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 ERA23LA315Accident · Serious injuriesClass 4 · LimitedFinal reportHead Balloons AX8-88 · Guilford, CTThe pilot’s inadequate supervision of the boarding process and the ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb.Jul 24, 2023 · N4522E · No damageNTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Jul 24, 2023 · N279WN · No damageNTSB ERA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Stow, MAThe pilot’s delayed decision to abort the landing, which resulted in a collision with trees.Jul 23, 2023 · N7ET · Substantial damageNTSB DCA23LA395Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Fort Lauderdale, FLThe flight crew’s abrupt change in pitch in response to a traffic collision advisory system resolution advisory that resulted in a serious injury to a flight attendant.Jul 23, 2023 · N229NV · No 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 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 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 damageNTSB WPR23LA283Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C35 · Rock Springs, WYMaintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.Jul 20, 2023 · N620D · Substantial damage