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 ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…May 7, 2023 · N725AS · Substantial damageNTSB WPR23LA181Accident · No injuriesClass 4 · LimitedFinal reportSteven Radenbaugh JA35 Superstol · Moorpark, CAThe pilot’s failure to maintain control of the airplane during an off airport precautionary landing. Contributing to the accident was the pilot’s decision to continue the flight with a possible mechanical malfunction.May 6, 2023 · N799CP · Substantial damageNTSB ERA23LA225Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Hillsborough Township, NJThe partial loss of engine power due to maintenance personnel’s failure to ensure that the ignition harnesses were properly secured and the pilot’s inappropriate pitch control inputs, which resulted in the airplane exceeding its critical angle of attack and…May 6, 2023 · N262MK · Substantial damageNTSB ERA23LA224Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Clyde, OHThe pilot’s inadequate fuel management, which resulted in fuel starvation and a forced landing.May 6, 2023 · N678FL · Substantial damageNTSB CEN23LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech F33A · Tahlequah, OKThe pilot’s failure to remove the wheel chocks before engine start which resulted in the inadvertent contact with the propeller while the engine was running.May 6, 2023 · N2294L · Minor damageNTSB CEN23LA179Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COThe pilot’s decision to adjust his seat during taxi, which resulted in his seat sliding aft, and subsequent loss of directional control.May 6, 2023 · N34BL · Substantial damageNTSB CEN23LA178Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC130 · Carta Valley, TXThe right rear-seat passenger’s improper judgement to release his restraint system and depart the helicopter while in a hover, which resulted in him sustaining serious injuries. Contributing to the accident was his impairment from effects of alcohol…May 6, 2023 · N254DM · No damageNTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…May 6, 2023 · N15188 · DestroyedNTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.May 6, 2023 · N6798T · DestroyedNTSB WPR23LA179Accident · No injuriesClass 4 · LimitedFinal reportELY John M Vans Acft RV-8 · North Las Vegas, NVThe pilot’s failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.May 5, 2023 · N83SE · Substantial damageNTSB ERA23LA221Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC-CONV · Fort Mill, SCThe pilot’s failure to apply carburetor heat before initiating a descent in conditions conducive to the development of carburetor icing, which resulted in a partial loss of engine power due to carburetor ice.May 5, 2023 · N3058E · Substantial damageNTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.May 5, 2023 · N180LR · Substantial damageNTSB DCA23LA278Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Charlotte, NCThe captain’s failure to maintain the appropriate airspeed and pitch attitude during landing which resulted in a tailstrike.May 5, 2023 · N921US · Substantial damageNTSB WPR23LA177Accident · No injuriesClass 3 · LimitedFinal reportCessna 210M · Pasco, WAImproper maintenance on the fuel outlet line to the fuel servo, which resulted in the line partially separating from the fuel outlet fitting and the subsequent fuel starvation and total loss of engine power.May 4, 2023 · N777CF · Substantial damageNTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.May 4, 2023 · N26941 · Substantial damageNTSB ERA23LA217Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Defuniak Springs, FLThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information.May 4, 2023 · N3796T · Substantial damageNTSB CEN23LA177Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Longville, MNThe pilot’s failure to maintain directional control during the landing roll with an unexpected windshift, which resulted in a runway excursion.May 4, 2023 · N8210R · Substantial damageNTSB CEN23LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Brookings, SDThe student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…May 4, 2023 · N1674E · Substantial damageNTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.May 4, 2023 · N440RS · Substantial damageNTSB CEN23LA180Accident · No injuriesClass 4 · LimitedFinal reportSearey LSX · Pottsboro, TXThe pilot’s failure to retract the landing gear before a water landing.May 3, 2023 · N40SR · Substantial damageNTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.May 3, 2023 · N750TK · Substantial damageNTSB WPR23LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll.May 2, 2023 · N29TR · Substantial damageNTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.May 1, 2023 · N2038Y · Substantial damageNTSB CEN23LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Batesville, MSThe pilot’s failure to maintain airplane control while landing with a left gusting crosswind. Contributing to the accident was the partial loss of engine power during the go-around.May 1, 2023 · N8713X · Substantial damageNTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.Apr 30, 2023 · N575ND · Substantial damageNTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.Apr 30, 2023 · N1113B · Substantial damageNTSB CEN23FA167Accident · 1 fatalClass 3 · FieldFinal reportTitan Tornado · Lewisville, ARThe non-certificated pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Apr 30, 2023 · N31311 · DestroyedNTSB WPR23LA354Accident · No injuriesClass 4 · LimitedFinal reportKerr John Hatz Classic · Ennis, MTThe pilot’s failure to maintain directional control during the landing roll which resulted in a ground-loop.Apr 29, 2023 · N687HZ · Substantial damageNTSB WPR23LA170Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Van Nuys, CAThe pilot’s failure to maintain lateral control of the helicopter, which resulted in a hard landing.Apr 28, 2023 · N549TS · Substantial damageNTSB ERA23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G500 · Dulles, VAThe initiation of the takeoff while before the flight attendant had returned to her seat, which resulted in a serious injury during takeoff.Apr 28, 2023 · N507GD · No damageNTSB CEN23LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Nacogdoches, TXThe student pilot’s failure to maintain directional control during the landing roll.Apr 28, 2023 · N52602 · Substantial damageNTSB WPR23LA169Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe student pilot’s improper landing flare, which resulted in a hard landing and the flight instructor’s delayed remedial action.Apr 27, 2023 · N76GX · Substantial damageNTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.Apr 26, 2023 · N140D · Substantial damageNTSB ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Apr 26, 2023 · N327WC · Substantial damageNTSB ERA23FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 177B · Watkinsville, GAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an in-flight overload separation of the right wing during the uncontrolled descent.Apr 26, 2023 · N123DS · DestroyedNTSB CEN23LA166Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Columbia, MSThe pilot’s lack of proper maintenance, which allowed the fuel filters to become obstructed, leading to fuel starvation and a subsequent engine power loss.Apr 25, 2023 · N44048 · Substantial damageNTSB WPR23LA167Occurrence · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Page, AZThe fueler’s inadvertent addition of diesel exhaust fluid (DEF) to the FSII reservoir on the fuel truck, and its subsequent mixture with the JET A that was used to fuel the airplane, resulting in a total loss of power to the right engine and a partial loss of…Apr 24, 2023 · N135SH · No damageNTSB WPR23LA165Accident · No injuriesClass 4 · LimitedFinal reportOneal J R/Oneal R C EDI Express · Tracy, CAThe pilot’s failure to maintain directional control during the takeoff roll.Apr 24, 2023 · N92734 · Substantial damageNTSB ERA23LA215Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Good Hope, ALThe pilot’s decision to land on a runway where there was insufficient clearance from obstructions (wheat crop) to operate safely.Apr 24, 2023 · N623LA · Substantial damageNTSB ERA23LA206Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · West Palm Beach, FLThe loss of engine power due to fuel exhaustion.Apr 24, 2023 · N7555X · Substantial damageNTSB CEN23FA164Accident · Serious injuriesClass 3 · FieldFinal reportMaule MXT-7-180 · La Porte, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for an emergency landing following a partial loss of engine power, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the…Apr 24, 2023 · N4008J · Substantial damageNTSB WPR23LA164Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s failure to maintain directional control, and the flight instructor’s delayed remedial action.Apr 22, 2023 · N4402A · Substantial damageNTSB DCA23LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Atlantic Ocean (Atlantic Ocean)An encounter with inadvertent convective turbulence during cruise flight.Apr 22, 2023 · N770AN · No damageNTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…Apr 22, 2023 · N60860 · Substantial damageNTSB ANC23LA030Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Soldotna, AKThe pilot’s selection of an unsuitable landing site, which resulted in the main landing gear wheels breaking through the snow and the airplane nosing over.Apr 22, 2023 · N454FU · Substantial damageNTSB CEN23LA161Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Flint Township, MIThe pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.Apr 20, 2023 · N419W · Substantial damageNTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.Apr 19, 2023 · N4166C · Substantial damageNTSB CEN23FA160Accident · Serious injuriesClass 3 · FieldFinal reportAero Vodochody L-139 · Bridgeport, TXThe pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…Apr 19, 2023 · N1390A · Substantial damageNTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.Apr 18, 2023 · N349VR · Substantial damageNTSB ERA23LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · St. Augustine, FLThe pilot’s failure to extend the landing gear before landing.Apr 18, 2023 · N751WW · Substantial damage