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 CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…Nov 15, 2022 · N247DH · Substantial damageNTSB ERA23LA066Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot’s failure to appropriately use carburetor heat, which resulted in a total loss of engine power due to carburetor icing.Nov 14, 2022 · N9858P · Substantial damageNTSB ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.Nov 14, 2022 · N81PW · Substantial damageNTSB ERA23LA058Accident · No injuriesClass 3 · LimitedFinal reportAntonov AN2 · Opa-Locka, FLThe pilot's failure to properly configure the cowl flaps and oil cooler shutters, which resulted in a total loss of engine power due to overheating of the engine. Contributing to the accident was the pilot's decision to operate the airplane in with an…Nov 14, 2022 · CU-A1885 · Substantial damageNTSB WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.Nov 13, 2022 · N5171B · Substantial damageNTSB ERA23LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 310J · Fulton, NYThe pilots failure to slow the airplane down prior to turning off the runway, which resulted in damage to the airplane’s fuselage structure in the vicinity of the nose landing gear.Nov 13, 2022 · N3048L · Substantial damageNTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.Nov 13, 2022 · N222UM · Substantial damageNTSB CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…Nov 12, 2022 · N7227C · 2 aircraft · DestroyedNTSB WPR23LA043Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Kapolei, HIThe pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.Nov 11, 2022 · N948WB · Substantial damageNTSB WPR23LA030Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s improper decision to takeoff from an unimproved airstrip with insufficient takeoff distance which, resulted in a runway overrun and collision with vegetation.Nov 11, 2022 · N615DD · Substantial damageNTSB ERA23LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 175 · Gilford, NHThe pilot’s decision to continue the approach to land in conditions where he was unable to see in front of the airplane due to sun glare, which resulted in in a collision a building.Nov 10, 2022 · N7223M · DestroyedNTSB ANC23FA004Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to fly at low altitude, which resulted in a collision with a cable.Nov 10, 2022 · N7123K · Substantial damageNTSB ERA23LA055Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Allentown, PAThe flight instructor’s decision to remove the nosewheel chock while the engine was still operating.Nov 9, 2022 · N8543E · No damageNTSB CEN23LA033Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Bridgeport, TXThe pilot’s loss of control due to a wind gust during landing.Nov 9, 2022 · N1855K · Substantial damageNTSB CEN23LA032Accident · No injuriesClass 4 · LimitedFinal reportMulholland Robert A Vans RV-7 · Englewood, COAn encounter with windshear during the initial climb after takeoff, which resulted in a loss of control. Contributing to the accident was the pilot’s improper decision to takeoff with a tailwind.Nov 9, 2022 · N771RG · Substantial damageNTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.Nov 9, 2022 · N234PM · DestroyedNTSB ERA23LA051Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Virus SW · Cross City, FLThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent deployment of the ballistic parachute recovery system.Nov 7, 2022 · N91RR · Substantial damageNTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · DestroyedNTSB CEN23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Murdo, SDThe pilot’s failure to maintain directional control during takeoff with strong gusty surface winds.Nov 6, 2022 · N699XM · Substantial damageNTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.Nov 5, 2022 · N700YZ · Substantial damageNTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.Nov 5, 2022 · N51AL · Substantial damageNTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…Nov 4, 2022 · N150NE · Substantial damageNTSB ERA23LA063Accident · No injuriesClass 3 · LimitedFinal reportHagerty Glasair Super IIS-TD · Jasper, GAThe loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.Nov 4, 2022 · N430JV · Substantial damageNTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.Nov 4, 2022 · N7254L · Substantial damageNTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.Nov 3, 2022 · N101DC · Substantial damageNTSB ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…Nov 3, 2022 · N84R · DestroyedNTSB DCA23LA060Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319 · New Orleans, LAThe captain’s pitch up input to avoid an overspeed condition, which resulted in a flight attendant falling and fracturing her ankle. Contributing was the airplane’s excessive airspeed during the transition to the automation-managed descent profile.Nov 3, 2022 · N519NK · No damageNTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.Nov 3, 2022 · N61KH · Substantial damageNTSB ERA23LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Tanner, ALThe pilot’s inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Nov 2, 2022 · N8667W · Substantial damageNTSB ERA23LA049Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Greenville, SCThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.Nov 2, 2022 · N65615 · Substantial damageNTSB CEN23LA029Accident · No injuriesClass 4 · LimitedFinal reportMaule M7-235B · Topeka, KSThe pilot’s failure to maintain airplane control during landing with strong gusty surface winds.Nov 2, 2022 · N190Y · Substantial damageNTSB CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.Nov 2, 2022 · N9244A · Substantial damageNTSB ERA23FA047Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G58 · Alpharetta, GAThe pilot’s loss of aircraft control for unknown reasons.Oct 31, 2022 · N495AU · DestroyedNTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.Oct 29, 2022 · N964RS · Substantial damageNTSB CEN23LA023Accident · Minor injuriesClass 4 · LimitedFinal reportStephen J Hoffman MS-500 · Houston, TXThe pilot’s failure to secure the magneto switch before attempting to hand rotate the engine which resulted in an inadvertent engine start, a runaway airplane, and subsequent impact with parked airplanes. Contributing to the accident was the failure to…Oct 29, 2022 · N778MS · Substantial damageNTSB WPR23LA093Accident · No injuriesClass 4 · LimitedFinal reportVans RV10 · Reno, NVThe pilot’s improper flare, which resulted in a hard landing.Oct 28, 2022 · N673PH · Substantial damageNTSB ERA23LA069Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · Accident, MDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.Oct 28, 2022 · N68531 · Substantial damageNTSB ERA23LA052Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Columbia, SCThe pilot’s failure to maintain directional control during the crosswind landing.Oct 28, 2022 · N5153P · Substantial damageNTSB ERA23FA046Accident · 1 fatalClass 3 · FieldFinal reportZenith CH750 Cruzer · Southington, OHThe pilot's failure to maintain proper airspeed while maneuvering in the airport traffic pattern and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude that was too low to recover.Oct 28, 2022 · N820RC · Substantial damageNTSB ERA23LA159Accident · Minor injuriesClass 3 · LimitedFinal reportTextron 172S · Tuskegee, ALThe flight instructor’s improper flare, which resulted in a hard landing and subsequent runway excursion.Oct 27, 2022 · N858AU · Substantial damageNTSB ERA23LA043Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Roberta, GAThe pilot’s failure to maintain a stabilized approach speed on landing, which resulted in a runway excursion and collision with logs.Oct 27, 2022 · N4349R · Substantial damageNTSB ANC23LA005Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · Kenai, AKImproper installation of the crankshaft drive gear by maintenance personnel, who failed to install all required hardware, resulting in an in-flight engine failure.Oct 27, 2022 · N8119D · Substantial damageNTSB WPR23LA050Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Long Beach, CAThe pilot’s failure to maintain directional control during landing.Oct 26, 2022 · N75321 · Substantial damageNTSB WPR23LA026Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Puyallup, WAThe pilot’s inadequate fuel management that resulted in the loss of engine power due to fuel exhaustion.Oct 26, 2022 · N6492F · Substantial damageNTSB WPR23LA025Accident · 1 fatalClass 3 · LimitedFinal reportAirborne Windsports Edge X · Alturas, CAThe non-certificated pilot’s loss of control for undetermined reasons.Oct 26, 2022 · N354MB · Substantial damageNTSB CEN23LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Osage, ARA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Oct 26, 2022 · N8457D · Substantial damageNTSB CEN23FA019Accident · 1 fatalClass 3 · FieldFinal reportBell 407 · Morgan City, LAThe pilot’s loss of consciousness due to a cardiovascular event.Oct 26, 2022 · N34BM · DestroyedNTSB ERA23LA167Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Winter Haven, FLThe pilot’s failure to properly secure the rear seat headset, resulting in an obstruction of the airplane’s rudder controls.Oct 24, 2022 · N6ND · Substantial damageNTSB ERA23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRhinehart Stolp Sdtr TOO SA300 · Lordstown, OHThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the improper installation of the elevator trim tab control, which created control feedback…Oct 23, 2022 · N160JR · Substantial damageNTSB CEN23LA018Accident · No injuriesClass 3 · LimitedFinal reportSea Ray LSX · Lago Vista, TXThe pilot’s inadequate fuel planning and improper in-flight decision making which resulted in a low fuel status and a loss of engine power due to fuel starvation.Oct 23, 2022 · N17TS · Substantial damage