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 ERA22LA042Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Flemingsburg, KYThe pilot’s failure to obtain the proper touchdown point or go-around, which resulted in a runway excursion.Oct 27, 2021 · N4363W · Substantial damageNTSB ERA22LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Ballston Spa, NYThe flight instructor’s and student pilot’s inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 27, 2021 · N2353Z · Substantial damageNTSB CEN22FA021Accident · 1 fatalClass 3 · FieldFinal reportBeech B36TC · Lena, WIImpairment and subsequent incapacitation of the pilot for reasons that could not be determined. The incapacitation resulted in a loss of engine power due to fuel starvation. Likely contributing was pilot hypoxia due to altitude exposure, possibly worsened by…Oct 27, 2021 · N75RM · Substantial damageNTSB ERA22LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Immokalee, FLThe flight instructor’s delayed remedial action which resulted in the airplane impacting terrain short of the runway.Oct 26, 2021 · N305JD · Substantial damageNTSB ERA22LA031Accident · 1 fatalClass 3 · LimitedFinal reportVans RV-12 · Folkston, GAThe pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.Oct 26, 2021 · N525AT · DestroyedNTSB CEN22LA020Accident · No injuriesClass 4 · LimitedFinal reportHall Terrence / Hall Cathie Cruzer CH-750 · Benton, ILThe pilot’s improper landing flare, which resulted in a hard landing and the nose landing gear collapsing.Oct 26, 2021 · N816ZH · Substantial damageNTSB WPR22LA024Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · St Ignatius, MTThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 24, 2021 · N25WX · Substantial damageNTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.Oct 24, 2021 · N3771M · Substantial damageNTSB ANC22LA004Accident · 1 fatalClass 3 · LimitedFinal reportGregg Origer PA-18 Replica · Willow, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.Oct 24, 2021 · N368G · Substantial damageNTSB ERA22LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Sligo, PAA total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.Oct 23, 2021 · N7371P · Substantial damageNTSB DCA22LA015Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Miami, FLAn abrupt jerk of the airplane as the captain applied the parking brake during the tow that caused a flight attendant to fall and break her wrist.Oct 23, 2021 · N252NN · No damageNTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.Oct 23, 2021 · N94400 · Substantial damageNTSB CEN22FA019Accident · 2 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Marengo, WIThe pilot’s failure to maintain adequate airspeed during the steep turn, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Also causal was the pilot’s decision to conduct steep turns without sufficient altitude to…Oct 23, 2021 · N843AC · DestroyedNTSB ERA22LA027Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB500 · Orlando, FLThe pilot's inadvertent application of the right brake during the landing roll, which resulted in a loss of directional control and a subsequent runway excursion.Oct 22, 2021 · N925DR · Substantial damageNTSB ERA22FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Walterboro, SCThe pilot’s inadequate fuel planning and fuel management, which resulted in a loss of engine power due to fuel starvation.Oct 22, 2021 · N1652H · DestroyedNTSB ANC22LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Juneau, AKThe pilot’s loss of directional control for reasons that could not be determined.Oct 22, 2021 · N754KP · Substantial damageNTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.Oct 21, 2021 · N6888A · Substantial damageNTSB ERA22LA025Accident · Serious injuriesClass 4 · LimitedFinal reportPipistrel Apis-Bee · Columbia, SCThe pilot’s failure to maintain control of the glider during the landing approach, which resulted in an aerodynamic stall and subsequent impact with the runway.Oct 21, 2021 · N812DS · Substantial damageNTSB ERA22FA024Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Holly Ridge, NCThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall/mush during takeoff and initial climb. Contributing to the accident was the pilot’s loading the airplane near its maximum allowable gross weight and near its aft cg…Oct 21, 2021 · N3933H · Substantial damageNTSB WPR22FA021Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Dunsmuir, CAThe non-certificated pilot’s improper decision to continue the flight under visual flight rules into instrument meteorological conditions which resulted in controlled flight into terrain.Oct 20, 2021 · N5268Q · Substantial damageNTSB CEN22LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Dallas, TXA temporary loss of engine power during the takeoff due to a damaged fuel pump, which resulted in a forced landing and a runway excursion. The source of the damage to the fuel pump could not be determined.Oct 20, 2021 · N1235U · Substantial damageNTSB CEN22FA017Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-181 · Buxton, NDThe pilot’s intentional flight into terrain as an act of suicide.Oct 19, 2021 · N820ND · DestroyedNTSB ERA22LA019Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Mount Pleasant, SCThe pilot’s failure to maintain clearance with the parked fuel truck while taxiing for takeoff. Contributing to the outcome was the pilot’s decision to park the airplane in the congested ramp area and his excessive taxi speed.Oct 18, 2021 · N996LM · Substantial damageNTSB CEN22FA016Accident · 1 fatalClass 3 · FieldFinal reportAutoGyro Cavalon · Stroud, OKThe pilot’s lack of experience in the gyroplane and his decision to takeoff with a tailwind. As a result, the gyroplane did not generate enough lift to takeoff before it struck a barbed wire fence. Contributing to the accident was the pilot’s failure to wear…Oct 18, 2021 · N419LB · Substantial damageNTSB WPR22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Laurier, WAThe flight instructor’s delayed remedial action to prevent the airplane from landing long which, resulted in a runway overrun and collision with terrain.Oct 17, 2021 · N832DC · Substantial damageNTSB WPR22FA012Accident · 1 fatalClass 3 · FieldFinal reportRockwell 112 · Three Points, AZThe pilot’s failure to maintain proper airspeed while maneuvering, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane entering an aerodynamic stall.Oct 17, 2021 · N112LS · Substantial damageNTSB WPR22LA018Accident · No injuriesClass 4 · LimitedFinal reportAirbus A350 · Tucson, AZThe pilot's failure to maintain clearance from ground equipment during landing.Oct 16, 2021 · N544AM · Substantial damageNTSB WPR22LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · White Swan, WAA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.Oct 16, 2021 · N3388T · Substantial damageNTSB ERA22LA018Accident · Serious injuriesClass 3 · LimitedFinal reportZ-Hi-Max 1400 · Benton, PAThe pilot’s loss of control and encounter with an aerodynamic stall during a planned low-altitude turn toward the airport after takeoff.Oct 16, 2021 · N668CL · Substantial damageNTSB WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.Oct 15, 2021 · N7584M · Substantial damageNTSB ERA22LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Inverness, FLThe pilots inadequate recovery from a wind gust during landing, which resulted in a hard landing and substantial damage to the fuselage.Oct 14, 2021 · N3299T · Substantial damageNTSB ERA22LA016Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox IV · North Canaan, CTThe pilot's mismanagement of the airplane's altitude, airspeed, and course during a forced landing following a partial loss of engine power, which resulted in collision with trees and terrain. Contributing was the pilot’s inadvertent omission of stowing the…Oct 14, 2021 · N9259M · Substantial damageNTSB ERA22FA014Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-260 · Blairsville, GAThe pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.Oct 13, 2021 · N9126P · DestroyedNTSB WPR22LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Kalispell, MTThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop and a runway excursion.Oct 12, 2021 · N926LL · Substantial damageNTSB CEN22FA013Accident · 2 fatalClass 3 · FieldFinal reportNew Glasair Glastar · Waukesha, WIThe noninstrument-rated pilot’s decision to depart and continue flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Oct 12, 2021 · N628RS · DestroyedNTSB WPR22FA004Accident · 2 fatalClass 3 · FieldFinal reportCessna 340A · Santee, CALoss of control due to spatial disorientation.Oct 11, 2021 · N7022G · DestroyedNTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…Oct 11, 2021 · N6748V · DestroyedNTSB WPR22LA006Accident · No injuriesClass 4 · LimitedFinal reportBevilacqua Jeffrey L Dragonfly Mkiih · Camarillo, CAThe pilot’s failure to maintain airplane control during takeoffOct 10, 2021 · N186JB · Substantial damageNTSB ERA22FA010Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cornwall, NYThe non-instrument-rated pilot’s continued flight into deteriorating weather conditions, which resulted in a loss of control due to spatial disorientation.Oct 10, 2021 · N637HP · DestroyedNTSB ANC22LA001Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe unmanned aircraft pilot’s failure to yield the right of way to the helicopter.Oct 10, 2021 · N555EL · 2 aircraft · Substantial damageNTSB WPR22LA005Accident · No injuriesClass 3 · LimitedFinal reportBeech B36TC · Los Banos, CAThe total loss of engine power due to the improper installation of the No. 4 connecting rod bolt nut during a recent overhaul.Oct 9, 2021 · N7220B · Substantial damageNTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.Oct 9, 2021 · N8592B · Substantial damageNTSB ERA22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Fruitland Park, FLThe pilot’s failure to establish a proper landing flare, which resulted in a hard landing.Oct 9, 2021 · N5797B · Substantial damageNTSB ERA22LA012Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Winchester, VAThe pilot’s misapplication of brakes during the landing roll which resulted in a nose-over event and substantial damage to the airplane.Oct 9, 2021 · N4581M · Substantial damageNTSB CEN22LA015Accident · No injuriesClass 4 · LimitedFinal reportZuber Thomas P Zuber Super Drifter · Horseshoe Bay, TXThe pilot’s failure to adequately monitor airspeed during a low-level turn, which resulted in an aerodynamic stall and impact with the water.Oct 9, 2021 · N70TZ · Substantial damageNTSB CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .Oct 9, 2021 · N24783 · Substantial damageNTSB ERA22FA009Accident · 4 fatalClass 3 · FieldFinal reportCessna P210 · Atlanta, GAThe pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…Oct 8, 2021 · N128EE · DestroyedNTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.Oct 7, 2021 · N98241 · Substantial damageNTSB ERA22LA007Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Batavia, NYThe pilot’s failure to disengage the autopilot prior to climbing out of a fog bank.Oct 7, 2021 · N505TJ · Substantial damageNTSB CEN22LA010Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24 · Loveland, COThe pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.Oct 7, 2021 · N5585P · Substantial damage