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 ERA20FA019Accident · 2 fatalClass 3 · FieldFinal reportMooney M20A · Summit Point, WVThe pilot’s decision to conduct a practice stall maneuver at low altitude, which resulted in inadequate altitude remaining in which to recover before impacting terrain.Oct 24, 2019 · N8354E · DestroyedNTSB GAA20CA095Accident · No injuriesData collectionFinal reportCessna 120 · Marion, ALThe student pilot's overapplication of the brakes during landing to avoid a deer on the runway, which resulted in a nose-over.Oct 23, 2019 · N77200 · Substantial damageNTSB CEN20FA012Accident · 2 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Hebbronville, TXThe failure of the spotter helicopter pilot to maintain clearance from the gunner helicopter while maneuvering. Contributing to the accident were the effects from the pilot’s use of impairing drugs.Oct 23, 2019 · N7189D · 2 aircraft · DestroyedNTSB CEN20LA013Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502 · Lamesa, TXThe pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.Oct 22, 2019 · N9143F · Minor damageNTSB GAA20CA044Accident · No injuriesData collectionFinal reportRichard B Carpenter AR-1 · Brooksville, FLThe pilot's failure to attain the proper rotor speed before takeoff, which resulted in the rotor blade striking the rudder. Contributing to the accident was the pilot's failure to abort the takeoff in a timely manner.Oct 21, 2019 · N147AR · Substantial damageNTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.Oct 21, 2019 · N1052T · Substantial damageNTSB WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…Oct 20, 2019 · N7742P · Substantial damageNTSB GAA20CA040Accident · No injuriesData collectionFinal reportKitfox S7 · Reno, NVThe pilot's use of excessive braking control during the landing roll, which resulted in a nose over.Oct 20, 2019 · C-GPMT · Substantial damageNTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…Oct 20, 2019 · N3784A · Substantial damageNTSB ERA20FA014Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32 · Raleigh, NCThe pilot’s failure to maintain a safe glidepath during final approach to the runway, which resulted in a collision with trees and terrain. Contributing was the pilot’s lack of recent instrument flight experience.Oct 20, 2019 · N534Z · DestroyedNTSB GAA20CA079Accident · No injuriesData collectionFinal reportPiper PA28 · Quakertown, PAThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and collision with a drainage culvert.Oct 19, 2019 · N2961W · Substantial damageNTSB GAA20CA037Accident · No injuriesData collectionFinal reportUltramagic N 250 · Albuquerque, NMThe pilot's failure maintain clearance from power lines, which resulted in an explosion and preimpact fire.Oct 19, 2019 · N275WB · Substantial damageNTSB GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.Oct 18, 2019 · N801PZ · Substantial damageNTSB GAA20CA036Accident · No injuriesData collectionFinal reportTitan Titan Tornado II · Marble Canyon, AZThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.Oct 18, 2019 · N49PD · Substantial damageNTSB GAA20CA034Accident · Minor injuriesData collectionFinal reportBell 47G · King City, CAThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing and the main rotor blades striking the tailboom.Oct 18, 2019 · N7060J · Substantial damageNTSB ERA20LA018Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Madisonville, TNThe pilot's unstable approach and delayed decision to go-around. Contributing to the accident was the unporting of the fuel supply following a forward slip maneuver during the approach, which resulted in the loss of engine power during the go-around.Oct 18, 2019 · N564T · Substantial damageNTSB ERA20FA013Accident · 1 fatalClass 3 · FieldFinal reportSportine Aviacija LAK17B · Tamaqua, PAThe pilot's exceedance of the glider's critical angle of attack while climbing in thermal lift, which resulted in an aerodynamic stall/spin.Oct 18, 2019 · N830DK · Substantial damageNTSB DCA20MA002Accident · 1 fatalClass 1 · MajorFinal reportSaab 2000 · Unalaska, AKThe landing gear manufacturer’s incorrect wiring of the wheel speed transducer harnesses on the left main landing gear during overhaul. The incorrect wiring caused the antiskid system not to function as intended, resulting in the failure of the left outboard…Oct 18, 2019 · N686PA · Substantial damageNTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.Oct 17, 2019 · N5073Y · Substantial damageNTSB GAA20CA035Accident · No injuriesData collectionFinal reportRobinson R22 · Overton, NVThe pilot’s failure to maintain a proper approach and the flight instructor's subsequent failure to maintain an adequate climb rate during an attempted go-around in gusting tailwind conditions, which resulted in a hard landing and dynamic rollover.Oct 17, 2019 · N4066S · Substantial damageNTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.Oct 17, 2019 · N9033T · Substantial damageNTSB GAA20CA032Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Monument Valley, UTThe pilot's failure to maintain lateral control and to attain adequate altitude during takeoff with a quartering tailwind in gusting wind conditions, which resulted in impact with a sandy berm left of the runway.Oct 17, 2019 · N771TX · Substantial damageNTSB GAA20CA031Accident · No injuriesData collectionFinal reportErcoupe 415 · Alvin, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport landing, during which the airplane landed hard and then ground looped.Oct 17, 2019 · N2585H · Substantial damageNTSB ERA20FA012Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · New Salem, NCThe pilot's inadequate visual lookout, which resulted in impact with a powerline.Oct 17, 2019 · N167AG · Substantial damageNTSB DCA20CA003Accident · No injuriesData collectionFinal reportKitty Hawk Heaviside2 · Tres Pinos, CAa software timing error initiated by a battery charging script that was not properly terminated prior to the test flight due to operator error.Oct 17, 2019 · N221HV · Substantial damageNTSB CEN20FA008Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Green Bay, WIThe pilot’s low final approach path and his failure to see and avoid a truck traveling on a roadway, which resulted in a collision with the truck.Oct 17, 2019 · N82308 · Substantial damageNTSB GAA20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Gerlach, NVThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.Oct 16, 2019 · N2894P · Substantial damageNTSB ERA20LA016Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier BD 700 1A10 · Augusta, GAThe first officer's failure to maintain a safe distance from a large turbine-powered airplane while escorting passengers, resulting in a passenger encounter with jet blast.Oct 16, 2019 · N307KP · No damageNTSB GAA20CA029Accident · No injuriesData collectionFinal reportCessna 180 · Flannigan, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a wing strike.Oct 15, 2019 · N180JL · Substantial damageNTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.Oct 15, 2019 · N2037B · Substantial damageNTSB GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneOct 15, 2019 · N6097G · Substantial damageNTSB GAA20CA014Accident · No injuriesData collectionFinal reportPiper PA38 · Colorado Springs, COThe pilot's failure to maintain the runway heading while taking off with a gusting tailwind, which resulted in impact with a fence.Oct 15, 2019 · N9708T · Substantial damageNTSB GAA20CA045Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Buckeye, AZThe pilot's failure to maintain directional control during an aborted landing with a crosswind, which resulted in tailwheel impacting vegetation and the left main landing gear collapsing.Oct 14, 2019 · N441B · Substantial damageNTSB GAA20CA022Accident · No injuriesData collectionFinal reportBeech 36 · Douglas, GAThe pilot's failure to extend the landing gear due to intoxication during an unauthorized flight.Oct 14, 2019 · N8047R · Substantial damageNTSB GAA20CA013Accident · No injuriesData collectionFinal reportSocata TBM700 · Breckenridge, TXThe pilot's failure to maintain bank control and adequate altitude during the approach, which resulted in his failure to maintain the runway heading and a subsequent collision with trees and terrain.Oct 14, 2019 · N850NK · Substantial damageNTSB ERA20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Cameron, NCThe pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…Oct 14, 2019 · N4332J · Substantial damageNTSB GAA20CA025Accident · Serious injuriesData collectionFinal reportCessna 172 · Key West, FLThe pilot’s and the passenger's improper decision to have the passenger attempt to move a wheel chock while the propeller was turning, which resulted in a serious injury.Oct 13, 2019 · N5522S · No damageNTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Oct 13, 2019 · N96709 · Substantial damageNTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.Oct 13, 2019 · N7267A · Substantial damageNTSB ANC20CA006Accident · No injuriesData collectionFinal reportPiper PA18 · Moose Pass, AKThe pilot's improper approach, which resulted in his failure to maintain clearance from a tree while landing in dusk conditions, and his subsequent loss of directional control, which resulted in a runway excursion.Oct 13, 2019 · N645DT · Substantial damageNTSB GAA20CA026Accident · Minor injuriesData collectionFinal reportLlewellyn, Warwinc W Vans RV-4 · Lusby, MDThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain and a subsequent cartwheel.Oct 12, 2019 · N15WL · Substantial damageNTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.Oct 12, 2019 · N333DW · Substantial damageNTSB GAA20CA011Accident · No injuriesData collectionFinal reportChampion 8GCBC · Henrys Lake, IDThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over.Oct 12, 2019 · N632K · Substantial damageNTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.Oct 12, 2019 · N498AG · Substantial damageNTSB GAA20CA027Accident · Minor injuriesData collectionFinal reportZenith Zenith 601XLB · Gastonia, NCThe pilot's failure to latch the canopy before departure, which resulted in the canopy opening and the subsequent loss of airplane control.Oct 11, 2019 · N235JH · Substantial damageNTSB GAA20CA021Accident · No injuriesData collectionFinal reportWingtip To Wingtip Panzl S-330 · Cedartown, GA***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…Oct 11, 2019 · N540ML · 2 aircraft · Substantial damageNTSB GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Oct 11, 2019 · N3090C · Substantial damageNTSB GAA20CA019Accident · Serious injuriesData collectionFinal reportAntares MA33 · Coeur d'Alene, IDThe student pilot's improper release of the throttle and failure to maintain lateral control during takeoff.Oct 11, 2019 · N92287 · Substantial damageNTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.Oct 11, 2019 · N612RF · Substantial damageNTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.Oct 10, 2019 · N8078X · Substantial damage