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 WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.Jun 21, 2023 · N3531Y · Substantial damageNTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.Jun 21, 2023 · N356AW · Substantial damageNTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.Jun 21, 2023 · N10BR · Substantial damageNTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.Jun 21, 2023 · N3127C · Substantial damageNTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.Jun 21, 2023 · N308ED · Substantial damageNTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.Jun 20, 2023 · N3069S · Substantial damageNTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.Jun 20, 2023 · N299KD · Substantial damageNTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.Jun 19, 2023 · N4076H · Substantial damageNTSB ERA23LA271Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Seymore, TNThe flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.Jun 18, 2023 · N12395 · Substantial damageNTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.Jun 18, 2023 · N463HP · Substantial damageNTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.Jun 18, 2023 · N932SH · Substantial damageNTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…Jun 18, 2023 · N290LA · Substantial damageNTSB ANC23LA043Accident · No injuriesClass 4 · LimitedFinal reportBuck/Crawford/Crawford Christavia MK-1 · Anchorage, AKThe instructor pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a wing impacting a runway light.Jun 18, 2023 · N5075T · Substantial damageNTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.Jun 17, 2023 · N28034 · Substantial damageNTSB WPR23LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305C (0-1E) · Big Bear City, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.Jun 17, 2023 · N62TX · Substantial damageNTSB ERA23LA291Accident · No injuriesClass 4 · LimitedFinal reportVolato 400 · Dublin, GAThe pilot’s improper landing flare which resulted in a runway undershoot and a hard landing, which substantially damaged the airplane’s firewall.Jun 17, 2023 · PR-ZVL · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.Jun 17, 2023 · N4287Y · Substantial damageNTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.Jun 16, 2023 · N91361 · Substantial damageNTSB CEN23LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Holyoke, COThe pilot's failure to maintain directional control during the landing roll.Jun 15, 2023 · N6106U · Substantial damageNTSB CEN23LA240Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC-65 · Sibley, IAThe pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.Jun 15, 2023 · N23679 · Substantial damageNTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.Jun 14, 2023 · UNREG · Substantial damageNTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.Jun 14, 2023 · N1025C · DestroyedNTSB ERA23LA294Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA50 · Wagener, SCThe pilot’s decision to take off from a short, grass runway in gusting wind conditions, resulting in a rejected takeoff and runway excursion.Jun 13, 2023 · OE-DSD · Substantial damageNTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.Jun 12, 2023 · N88GJ · Substantial damageNTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.Jun 12, 2023 · N3138C · Substantial damageNTSB CEN23LA238Accident · No injuriesClass 4 · LimitedFinal reportMooney M10 · Gassville, ARThe pilot’s failure to maintain control of the airplane during takeoff with a quartering tailwind.Jun 12, 2023 · N9523V · Substantial damageNTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.Jun 11, 2023 · N60605 · Substantial damageNTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.Jun 11, 2023 · N85TP · Substantial damageNTSB CEN23LA237Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Pratt, KSFuel exhaustion due to the pilot’s inadequate preflight planning.Jun 11, 2023 · N85RB · Substantial damageNTSB WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damageNTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.Jun 10, 2023 · N1778C · Substantial damageNTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…Jun 10, 2023 · N759F · DestroyedNTSB ERA23LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Lumberton, NJThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with the runway edge lights.Jun 10, 2023 · N8126X · Substantial damageNTSB ERA23LA267Accident · Serious injuriesClass 3 · LimitedFinal reportFly Gyros M24 Orion · Venice, FLThe pilot’s failure to maintain directional control on takeoff for unknown reasons; whether the pilot’s acute stroke contributed to, or resulted from, the accident could not be determined.Jun 10, 2023 · N49PF · Substantial damageNTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.Jun 10, 2023 · N6886P · Substantial damageNTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.Jun 9, 2023 · N56QC · Substantial damageNTSB WPR23LA227Accident · No injuriesClass 4 · LimitedFinal reportCamille E Patch Calidus · Jerome, IDThe pilot’s failure to maintain directional control during landing, which resulted in rollover.Jun 9, 2023 · N800YA · Substantial damageNTSB CEN23LA235Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Colorado Springs, COThe pilot’s failure to maintain directional control during landing.Jun 9, 2023 · N16JV · Substantial damageNTSB WPR23LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Bend, ORThe pilot’s failure to maintain clearance from the fuel station, resulting in a ground collision and fire.Jun 8, 2023 · N340SW · Substantial damageNTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.Jun 8, 2023 · N7318Y · Substantial damageNTSB WPR23FA219Accident · 2 fatalClass 3 · FieldFinal reportSteen Skybolt · Rio Vista, CAThe pilots’ exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall and subsequent loss of control.Jun 8, 2023 · N202GM · Substantial damageNTSB CEN23LA236Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Stevens Point, WIThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway.Jun 8, 2023 · N223WH · Substantial damageNTSB WPR23LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Wishram, WAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Jun 7, 2023 · N7155F · Substantial damageNTSB ERA23LA261Accident · No injuriesClass 3 · LimitedFinal reportDassault-Breguet Falcon 10 · Panama City, FLThe flight crew’s failure to appropriately configure the airplane for landing, which resulted in a failed attempt to utilize the thrust reversers during landing and the inability to stop the airplane using its brakes due to increased forward thrust.…Jun 7, 2023 · N87RT · Substantial damageNTSB ERA23FA260Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Colonial Beach, VAThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Jun 7, 2023 · N835BC · DestroyedNTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…Jun 6, 2023 · C-GNMT · DestroyedNTSB CEN23LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Harlingen, TXThe improper installation of the throttle control arm to the throttle control cable attachment end, which resulted in a failure of the control arm and a loss of engine power in flight.Jun 6, 2023 · N91157 · Substantial damageNTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.Jun 5, 2023 · N6174W · Substantial damageNTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…Jun 5, 2023 · N819KS · Substantial damage