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 CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.Aug 1, 2021 · N443JB · Substantial damageNTSB ERA21LA327Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Sterling, MAThe flight instructor’s lack of remedial action, which resulted in an aerodynamic stall in the landing flare and a hard landing.Jul 31, 2021 · N373BA · Minor damageNTSB ERA21LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Martinsburg, WVThe flight instructor’s loss of directional control after an aerodynamic stall at takeoff.Jul 31, 2021 · N805CP · Substantial damageNTSB ERA21LA310Accident · Serious injuriesClass 3 · LimitedFinal reportLiteflite PTY Dragonfly Model C · Middletown, NYThe improper installation of the carburetor, which resulted in a momentary total loss of engine power during initial climb. Contributing was the pilot’s failure to maintain control of the airplane following the initial power loss.Jul 31, 2021 · N799HG · Substantial damageNTSB CEN21LA349Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Randolph, WIThe pilot’s failure to maintain clearance from power lines during a low-level aerial application flight.Jul 31, 2021 · N285RG · Substantial damageNTSB CEN21FA345Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Hartford, WIThe flight crew’s exceedance of the airplane’s critical angle of attack during a simulated engine failure during initial climb after takeoff, which led to an aerodynamic stall/spin and loss of control. Contributing to the severity of the occupants’ injuries…Jul 31, 2021 · N42522 · Substantial damageNTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.Jul 30, 2021 · N9197F · DestroyedNTSB WPR21LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Morton, WAThe pilot's improper landing flare which resulted in a hard landing and subsequent nosewheel collapse.Jul 30, 2021 · N60524 · Substantial damageNTSB WPR21FA298Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Banning, CAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.Jul 30, 2021 · N8520G · Substantial damageNTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.Jul 30, 2021 · N857TL · Substantial damageNTSB CEN21LA346Accident · Serious injuriesClass 3 · LimitedFinal reportHpH, Spol. S.R.O. Glasflügel 304S · Briggs, TXThe overstress fracture of the elevator control tube due to reduced wall thickness from water intrusion and subsequent corrosion. Contributing to the accident was the lack of a drain hole at the bottom of the elevator control tube, which allowed the tube to…Jul 30, 2021 · N304AB · Substantial damageNTSB CEN21LA344Accident · Minor injuriesClass 4 · LimitedFinal reportWeiss Denis Sparrow II · Oshkosh, WIThe pilot’s improper landing flare which resulted in a bounced landing, a loss of control, and runway excursion.Jul 30, 2021 · N725DW · Substantial damageNTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.Jul 28, 2021 · N46MU · Substantial damageNTSB ERA21LA305Accident · Serious injuriesClass 3 · LimitedFinal reportTucker Twin · Unionville, TNThe loss of directional control during a precautionary landing, which resulted in a collision with a fence post.Jul 28, 2021 · N327TT · Substantial damageNTSB CEN21LA342Accident · Minor injuriesClass 4 · LimitedFinal reportAlexander Vagner Tango II · Childress, TXThe student pilot’s failure to maintain control while landing the gyroplane.Jul 28, 2021 · N910V · Substantial damageNTSB WPR21LA314Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Roseburg, ORThe pilot’s failure to maintain directional control during the landing roll which, resulted in a runway excursion and collision with a tree.Jul 27, 2021 · N161BS · Substantial damageNTSB WPR21FA288Accident · 1 fatalClass 3 · FieldFinal reportBorom Long-EZ · Tucson, AZThe pilot's failure to maintain adequate airspeed and to retract the speed brake during the approach, which resulted in a hard landing short of the runway. Contributing to the accident was the flight instructor’s decision to conduct a flight review in an…Jul 27, 2021 · N966EZ · Substantial damageNTSB ERA21LA371Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · New Shoreham, RIThe pilot’s improper decision to reject the takeoff at an excessive speed, resulting in a runway excursion and collision with a fence. Contributing to the accident was the pilot’s failure to lock the door as required by the placarded door closing procedures.Jul 27, 2021 · N110CG · Substantial damageNTSB ERA21LA316Accident · No injuriesClass 3 · LimitedFinal reportSocata TBM-700 C2 · Mount Pleasant, SCThe pilot’s decision to continue an unstable approach, which resulted in a runway excursion.Jul 27, 2021 · N48UM · Substantial damageNTSB ERA21LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Farmingdale, NYThe pilot’s failure to maintain clearance with a fuel truck while taxiingJul 27, 2021 · N73334 · Substantial damageNTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.Jul 27, 2021 · N6162R · Substantial damageNTSB CEN21LA340Accident · Serious injuriesClass 4 · LimitedFinal reportStephen L Kruer Superstol · Floyds Knobs, INThe pilot’s failure to maintain clearance from the trees during a go-around.Jul 27, 2021 · N852SK · Substantial damageNTSB WPR21FA286Accident · 6 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Truckee, CAThe first officer’s (FO’s) improper decision to attempt to salvage an unstabilized approach by executing a steep left turn to realign the airplane with the runway centerline, and the captain’s failure to intervene after recognizing the FO’s erroneous action,…Jul 26, 2021 · N605TR · DestroyedNTSB ANC21FA065Accident · 2 fatalClass 3 · FieldFinal reportCessna 172P · Eagle River, AKAn inflight collision with terrain under unknown circumstances. Contributing to the delayed rescue response was the failure of the emergency locator transmitter (ELT) to activate as designed, and the mechanic’s failure to ensure the correct ELT was installed…Jul 26, 2021 · N65698 · Substantial damageNTSB WPR21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Kernville, CAThe pilot’s failure to maintain airplane control during landing after an encounter with a wind gust which resulted in a collision with trees.Jul 25, 2021 · N728KG · Substantial damageNTSB WPR21LA289Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-1 · Bozeman, MTThe pilot’s failure to maintain directional control during landing which resulted in a ground loop.Jul 25, 2021 · N8844K · Substantial damageNTSB ERA21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Bloomsburg, PAThe pilot’s loss of directional control during the landing rollout, which resulted in a runway excursion and impact with terrain.Jul 25, 2021 · N76596 · Substantial damageNTSB ERA21LA299Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6 · Ocracoke, NCThe pilot's failure to perform a go-around during the unstabilized approach, which resulted in the airplane landing too far down the runway, and a subsequent runway excursion.Jul 25, 2021 · N464DM · Substantial damageNTSB CEN21FA334Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Benoit, MSThe pilot’s exceedance of the airplane’s takeoff performance capabilities and his failure to abort the takeoff in a timely manner. Contributing to the accident was the pilot’s impairment due to his use of ethanol and prohibited medications.Jul 25, 2021 · N363BG · Substantial damageNTSB WPR21LA345Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · Rock Springs, WYThe pilot’s improper pitch control during takeoff which resulted in an aerodynamic stall and subsequent hard landingJul 24, 2021 · N419TT · Substantial damageNTSB WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.Jul 24, 2021 · N946PD · Substantial damageNTSB WPR21LA297Accident · No injuriesClass 4 · LimitedFinal reportKevin P Stolhammer KR 1 · Electric City, WAThe pilot's failure to maintain directional control during the landing roll.Jul 24, 2021 · N832VS · Substantial damageNTSB WPR21FA283Accident · 1 fatalClass 3 · FieldFinal reportSiai-Marchetti SM-1019B · Lewiston, IDThe pilot’s failure to remove the flight control lock before departure, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was his failure to perform an adequate preflight inspection and flight control check…Jul 24, 2021 · N28U · Substantial damageNTSB CEN21LA337Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Larimore, NDThe pilot’s loss of control during the initial climb for reasons that could not be determined based on the available information.Jul 24, 2021 · N83411 · Substantial damageNTSB CEN21LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Rock Falls, ILThe right seat pilot’s improper decision to perform a low approach with full flaps and the failure of the flaps to retract during the attempted go-around, which resulted in a forced landing.Jul 24, 2021 · N7893F · Substantial damageNTSB ERA21LA303Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006T · Clearwater, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was the flight instructor’s inadequate supervision to confirm the landing gear was extended.Jul 23, 2021 · N4445T · Substantial damageNTSB ERA21LA297Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Arden, NCThe inadequate inspection of the throttle control cable assembly, which resulted in a partial loss of engine power during cruise flight.Jul 23, 2021 · N3059X · Substantial damageNTSB CEN21LA338Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Harrah, OKThe pilot’s decision to fly the airplane without a carburetor heat control in atmospheric conditions conducive to the development of serious carburetor icing, which resulted in a partial loss of engine power.Jul 23, 2021 · N83365 · Substantial damageNTSB CEN21LA336Accident · No injuriesClass 3 · LimitedFinal reportDriver RV-7 · Oshkosh, WIThe RV-8 pilot’s failure to account for the position of the RV-7 behind him during the landing roll in a staggered landing formation, which resulted in a ground collision of the two airplanes. Contributing to the accident was the self-induced pressure created…Jul 23, 2021 · N977RV · 2 aircraft · Substantial damageNTSB CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.Jul 23, 2021 · N51CF · Substantial damageNTSB WPR21LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Chelan, WAThe pilot’s unstable approach to land in turbulent conditions, which resulted in a hard landing short of the runway and subsequent loss of directional control and collision with terrain.Jul 22, 2021 · N315JT · Substantial damageNTSB ERA21LA302Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot's failure to maintain an appropriate distance between the airplane and hangar, which resulted in substantial damage to the right wing.Jul 22, 2021 · N472SP · Substantial damageNTSB DCA21LA184Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-211 · Romulus, MIWhile conducting the safety briefing, the forward flight attendant was thrown backwards into the flight deck door due to the sudden stopping of the airplane by the flight crew to prevent a collision with a bus. Contributing to this accident was the bus…Jul 22, 2021 · N376DN · No damageNTSB CEN21LA373Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · New Albany, MSThe pilot’s delayed decision to abort the landing that resulted in a collision with a fence post. Contributing to the accident was the failure of the alternator drive belt during cruise flight for unknown reasons and the subsequent inoperative electrical…Jul 22, 2021 · N6474Q · Substantial damageNTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.Jul 21, 2021 · N46287 · Substantial damageNTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.Jul 21, 2021 · N750RS · Substantial damageNTSB ERA21LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Reading, PAThe captain’s improper decision to continue an unstabilized approach despite several go-around calls by the pilot monitoring, which resulted in a runway excursion and substantial damage to the pressure vessel.Jul 21, 2021 · N46CF · Substantial damageNTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.Jul 21, 2021 · N3S · Substantial damageNTSB CEN21LA452Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mineral Point, WIThe pilot’s failure to see and avoid a wire during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N44XB · Substantial damageNTSB CEN21LA339Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · West Liberty, IAThe pilot’s failure to see and avoid a wire while maneuvering at low altitude during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N983HA · Substantial damage