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 GAA19CA214Accident · No injuriesData collectionFinal reportCessna 180 · Limington, METhe pilot's failure to maintain directional control during touchdown, which resulted in runway excursion onto snow.Apr 14, 2019 · N4796B · Substantial damageNTSB GAA19CA213Accident · Minor injuriesData collectionFinal reportCessna 152 · Bangor, METhe pilot's improper landing flare, which resulted in a hard landing.Apr 14, 2019 · N4916B · Substantial damageNTSB GAA19CA205Accident · No injuriesData collectionFinal reportPiper PA22 · Seward, AKThe pilot's failure to maintain directional control during an attempted go-around, which resulted in impact with a snowbank.Apr 14, 2019 · N3821P · Substantial damageNTSB ERA19LA150Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New York, NYThe pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…Apr 14, 2019 · N5296H · Substantial damageNTSB GAA19CA207Accident · No injuriesData collectionFinal reportNorth American SNJ · Chino, CAThe other pilot's failure to maintain clearance from a stopped airplane while taxiing.Apr 13, 2019 · N3375G · 2 aircraft · Substantial damageNTSB ERA19TA153Accident · No injuriesClass 3Final reportRobinson R22 · Bradenton Beach, FLThe pilot's improper decision to execute a low altitude turn that resulted in a strong tailwind and to reduce the airspeed to 0 knots and the flight instructor's diverted attention and inadequate monitoring, which resulted in the helicopter settling with…Apr 13, 2019 · N689M · Substantial damageNTSB CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…Apr 13, 2019 · N4890L · DestroyedNTSB CEN19FA119Accident · 3 fatalClass 2 · FieldFinal reportRockwell International NA-265-65 · New Albany, MSAn unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.Apr 13, 2019 · N265DS · DestroyedNTSB GAA19CA209Accident · No injuriesData collectionFinal reportBell 206 · Big Pine, FLThe pilot's failure to maintain helicopter control while it was being reloaded with the rotors turning in gusting wind conditions, which resulted in a rotor strike with ground equipment.Apr 12, 2019 · N173MS · Substantial damageNTSB DCA19CA137Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Fort Meyers, FLmissing attach screws on the aft galley oven, which allowed it to become dislodged landing, injuring a flight attendant.Apr 12, 2019 · N31412 · No damageNTSB ANC19LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Bethel, AKA total loss of engine power due to a fatigue failure of the crankshaft. A contributing factor was the inadequate inspection during the engine’s last overhaul.Apr 12, 2019 · N4466T · Substantial damageNTSB GAA19CA204Accident · No injuriesData collectionFinal reportCessna R182 · Marysville, OHThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and nose-over.Apr 11, 2019 · N2238T · Substantial damageNTSB GAA19CA203Accident · No injuriesData collectionFinal reportCessna 172 · Fullteron, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose-over.Apr 11, 2019 · N9964L · Substantial damageNTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.Apr 11, 2019 · N3795J · Substantial damageNTSB DCA19LA134Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · New York, NYThe captain’s excessive left rudder pedal input during the takeoff ground roll, which caused a large heading deviation and a left roll upon rotation that resulted in the left wingtip striking the ground.Apr 11, 2019 · N114NN · Substantial damageNTSB GAA19CA202Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Sisters, ORThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose-over.Apr 10, 2019 · N92798 · Substantial damageNTSB ERA19CA147Accident · Minor injuriesData collectionFinal reportGaskins Safari 400 · Gallatin, TNThe pilot/owner's improper decision to make a right turn instead of terminating the approach to a hover and his subsequent loss of helicopter control while attempting to land on sloping terrain, which resulted in a roll-over.Apr 10, 2019 · N104CV · Substantial damageNTSB CEN19FA117Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT 502 · Harlingen, TXThe pilot’s failure to maintain clearance from power transmission lines during low altitude flight operations. Contributing to the accident was the pilot’s impairment due to a sedating medication.Apr 9, 2019 · N7314D · DestroyedNTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.Apr 8, 2019 · N118LS · DestroyedNTSB ERA19CA148Accident · Minor injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.Apr 8, 2019 · N68727 · Substantial damageNTSB ERA19LA144Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Clover, VAThe pilot's inadequate visual lookout, which resulted in a collision with trees. Contributing to the accident was the pilot’s decision to takeoff at night without adequate runway lighting.Apr 7, 2019 · N4047H · DestroyedNTSB DCA19CA146Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD88 · Atlanta, GAfailure of the tug driver to give way to the taxiing airplane.Apr 5, 2019 · N977DL · Substantial damageNTSB GAA19CA200Accident · No injuriesData collectionFinal reportZenair Zenith CH 801 · Fort Worth, TXThe pilot's failure to maintain lateral control in flight and his subsequent loss of directional control during landing with a crosswind, which resulted in a runway excursion and impact with terrain.Apr 4, 2019 · N801R · Substantial damageNTSB GAA19CA199Accident · No injuriesData collectionFinal reportBeech 36 · Monument Valley, UTThe pilot's failure to maintain directional control and runway heading during landing, which resulted in a runway excursion and the nose landing gear collapsing.Apr 4, 2019 · N925SF · Substantial damageNTSB ERA19LA143Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Edgefield, SCThe total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.Apr 4, 2019 · N7622M · Substantial damageNTSB GAA19CA196Accident · No injuriesData collectionFinal reportPiper PA32 · Lakeland, FLThe pilot's failure to maintain clearance from a fence post during taxi to parking.Apr 3, 2019 · N4821S · Substantial damageNTSB CEN19LA132Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Prairieville, LAInstallation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…Apr 3, 2019 · N41AT · Minor damageNTSB GAA19CA195Accident · No injuriesData collectionFinal reportRobinson R44 · Taunton, MAThe pilot's improper decision to land with a gusting left quartering tailwind and his subsequent attempt to reposition the helicopter and take off, which resulted in a dynamic rollover.Apr 2, 2019 · N344R · Substantial damageNTSB GAA19CA194Accident · Minor injuriesData collectionFinal reportCessna 172 · Clemson, SCThe pilot's failure to maintain directional control during the landing roll and his exceedance of the airplane's critical angle of attack when it inadvertently became airborne, which resulted in an aerodynamic stall.Apr 2, 2019 · N54222 · Substantial damageNTSB CEN19LA116Accident · No injuriesClass 3 · LimitedFinal reportBerkey S-6ES · Lafe, ARThe non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.Apr 2, 2019 · N265GB · Substantial damageNTSB WPR19LA104Accident · Serious injuriesClass 3 · LimitedFinal reportCameron A-400 · Yountville, CAThe pilot’s inability to maintain obstacle clearance after the balloon’s encounter with a downdraft, which resulted in a collision with power lines.Apr 1, 2019 · N6954Y · No damageNTSB WPR19FA103Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Farmington, NMThe noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Mar 31, 2019 · N173CT · DestroyedNTSB GAA19CA252Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Coldfoot, AKThe gunner’s improper net gun firing, which resulted in a net weight impacting the rotor blades.Mar 31, 2019 · C-GTNV · Substantial damageNTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…Mar 31, 2019 · N902RA · Substantial damageNTSB GAA19CA191Accident · No injuriesData collectionFinal reportPiper PA32 · Swainsboro, GAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and the landing gear collapsing.Mar 31, 2019 · N75242 · Substantial damageNTSB GAA19CA184Accident · No injuriesData collectionFinal reportPiper PA 16 · Afton, WYThe pilot's improper landing flare, which resulted in a bounced landing and loss of directional control and the airplane’s subsequent impact with a snowbank and nose-over during an attempted go-around.Mar 31, 2019 · N676SC · Substantial damageNTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.Mar 30, 2019 · N4335R · Substantial damageNTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…Mar 30, 2019 · N81KK · Substantial damageNTSB GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.Mar 29, 2019 · N195PC · Substantial damageNTSB GAA19CA186Accident · Serious injuriesData collectionFinal reportBell 206 · Valley Center, CAThe ground crew’s attachment of the load fill hose to the helicopter without telling the pilot, which resulted in a loss of helicopter control during takeoff.Mar 29, 2019 · N83181 · Substantial damageNTSB CEN19TA112Accident · Minor injuriesClass 3Final reportPiper PA28 · Aberdeen, MSThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a collision with a fence and impact with terrain during the attempted aborted landing.Mar 29, 2019 · N8397W · Substantial damageNTSB GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.Mar 28, 2019 · N4250X · Substantial damageNTSB ERA19CA289Accident · No injuriesData collectionFinal reportPiper PA28 · Winder, GAThe student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.Mar 28, 2019 · N6412W · Substantial damageNTSB CEN19LA113Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Spring, TXThe pilot’s failure to maintain airplane directional control while taxiing at an unsafe ground speed.Mar 28, 2019 · N494JB · Substantial damageNTSB CEN19FA109Accident · 1 fatalClass 3 · FieldFinal reportAerospatiale AS350 · Montgomery, TXMaintenance personnel's failure to properly re-install and secure a fuel line, which resulted in a total loss of engine power.Mar 27, 2019 · N818MC · Substantial damageNTSB GAA19CA193Accident · No injuriesData collectionFinal reportCessna 172 · Pella, IAThe student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.Mar 26, 2019 · N7127G · Substantial damageNTSB ERA19LA138Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Dakota Hawk · McAlpin, FLThe pilot's failure to use carburetor heat while operating at idle power in atmospheric conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power during takeoff.Mar 26, 2019 · N30271 · DestroyedNTSB ERA19LA136Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95B55 · Clewiston, FLThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to perform the appropriate emergency checklists following the loss of engine power.Mar 25, 2019 · N323MT · Substantial damageNTSB GAA19CA234Accident · No injuriesData collectionFinal reportCessna T310 · Philadelphia, PAThe pilot’s and flight instructor's failure to verify that the landing gear were extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s inadvertent pulling of the landing gear motor circuit, which prevented the…Mar 24, 2019 · N358MN · Substantial damageNTSB GAA19CA177Accident · Minor injuriesData collectionFinal reportChampion 7EC · Fayetteville, ARThe pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.Mar 24, 2019 · N815PB · Substantial damage