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 WPR13CA342Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Hilo, HIA loss of engine power due to the pilot's improper planning and mismanagement of the fuel supply, which resulted in fuel exhaustion.Jul 25, 2013 · N500PH · Substantial damageNTSB WPR13CA341Accident · No injuriesData collectionFinal reportCessna A185F · Pocatello, IDThe pilot's failure to maintain directional control during landing with gusting wind and a quartering tailwind.Jul 25, 2013 · N31YH · Substantial damageNTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.Jul 25, 2013 · N4249Z · Substantial damageNTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.Jul 25, 2013 · N28RR · Substantial damageNTSB CEN13FA432Accident · 1 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.Jul 25, 2013 · N8306Y · Substantial damageNTSB CEN13CA452Accident · No injuriesData collectionFinal reportCessna 172N · Tell City, INThe pilot's failure to maintain adequate clearance from an obstruction while taxiing.Jul 25, 2013 · N3012E · Substantial damageNTSB CEN13CA434Accident · No injuriesData collectionFinal reportDavid W Oakes RV-7A · Charlottesville, INThe improper landing attitude which damaged the nosewheel and a resulted in a hard landing.Jul 25, 2013 · N1243A · Substantial damageNTSB CEN13LA436Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Champaign, ILThe pilot’s failure to maintain control of the helicopter during an aerial application maneuver.Jul 24, 2013 · N176MR · Substantial damageNTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.Jul 24, 2013 · N5467C · Substantial damageNTSB ANC13LA067Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot’s loss of directional control of the airplane during a wheel landing.Jul 24, 2013 · N4814 · Substantial damageNTSB WPR13GA338Accident · 1 fatalFinal reportBell HH-1H · Mount Charleston, NVThe premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.Jul 23, 2013 · N233JP · No damageNTSB WPR13CA337Accident · No injuriesData collectionFinal reportHughes 269B · Lewiston, IDThe pilot's incorrect application of the cyclic control during the landing.Jul 23, 2013 · N9484F · Substantial damageNTSB ANC13LA089Accident · No injuriesLimited investigationFinal reportHoward M. Shepherd Supercub · Hoonah, AKThe pilot’s selection of an unsuitable off-airport landing site and his subsequent landing at too high of an airspeed, which resulted in his excessive use of brakes during the landing roll and resulted in a nose-over.Jul 23, 2013 · N13NV · Substantial damageNTSB WPR13LA334Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Las Vegas, NVThe pilot receiving instruction's failure to maintain control of the helicopter in a hover, which resulted in a tail rotor ground strike.Jul 22, 2013 · N115SH · Substantial damageNTSB WPR13FA335Accident · 1 fatalField investigationFinal reportMooney M20C · South Lake Tahoe, CAThe pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.Jul 22, 2013 · N6709U · Substantial damageNTSB ERA13LA347Accident · Serious injuriesLimited investigationFinal reportDurfee Fred Quicksilver MXL · Lexington, TNThe student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…Jul 22, 2013 · N2590B · Substantial damageNTSB ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.Jul 22, 2013 · N61954 · Substantial damageNTSB ERA13CA335Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna Beach, FLThe student pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.Jul 22, 2013 · N121CW · Substantial damageNTSB DCA13FA131Accident · Minor injuriesField investigationFinal reportBoeing 737 7H4 · Flushing, NYThe captain's attempt to recover from an unstabilized approach by transferring airplane control at low altitude instead of performing a go-around. Contributing to the accident was the captain's failure to comply with standard operating procedures.Jul 22, 2013 · N753SW · Substantial damageNTSB ERA13CA333Accident · Minor injuriesData collectionFinal reportMillhouse D Scott Kitfox II · Logan, WVThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose over. Contributing to the accident was the flight instructor’s inadequate supervision of the student.Jul 21, 2013 · N269KF · Substantial damageNTSB CEN13LA428Accident · 1 fatalLimited investigationFinal reportCooper, David W. Challenger II · Mill Creek, INThe noncertificated pilot's improper fuel planning, which led to fuel exhaustion and a loss of engine power. Contributing to the accident was the pilot's failure to obtain adequate instruction or an endorsement to solo in the accident airplane model, which…Jul 21, 2013 · N1519 · DestroyedNTSB ANC13LA066Accident · Minor injuriesLimited investigationFinal reportCessna T207A · King Salmon, AKThe pilot’s inadequate visual lookout while departing from a multiple-use waterway, which resulted in a collision with a drifting boat. Contributing to the accident were the lack of visual conspicuity of the boat and the limited amount of time the boat…Jul 21, 2013 · N499K · Substantial damageNTSB ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 20, 2013 · N117HB · Substantial damageNTSB CEN13LA426Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Shannon, ILThe pilot’s inability to maintain an adequate climb rate after encountering a sudden wind shift during takeoff.Jul 20, 2013 · N502MH · Substantial damageNTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.Jul 20, 2013 · N377TT · Substantial damageNTSB CEN13LA447Accident · No injuriesLimited investigationFinal reportBell 206B · Tamaroa, ILThe pilot's failure to maintain clearance from terrain during an agricultural application maneuver.Jul 19, 2013 · N23L · Substantial damageNTSB CEN13LA425Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Steward, ILThe pilot's failure to maintain clearance from the guy wires during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.Jul 19, 2013 · N155HF · Substantial damageNTSB CEN13LA424Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Huntingburg, INThe pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.Jul 19, 2013 · N86BM · DestroyedNTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.Jul 18, 2013 · N2333Z · Substantial damageNTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.Jul 18, 2013 · N926JB · Substantial damageNTSB CEN13FA420Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Oak Ridge, LAThe private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…Jul 18, 2013 · N2978G · Substantial damageNTSB WPR13CA332Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbra, CAThe pilot's inadequate landing flare, which resulted in a hard landing.Jul 17, 2013 · N971TA · Substantial damageNTSB ERA13LA329Accident · Serious injuriesLimited investigationFinal reportKrips Jack E JR Kolb MK III · Fowler, NYThe pilot’s improper landing flare, which resulted in a nose-down collision with water.Jul 17, 2013 · N175TS · Substantial damageNTSB ERA13LA327Accident · Minor injuriesLimited investigationFinal reportUnivair 108-1 · Tuftonboro, NHMaintenance personnel’s failure to remove circumferential gouges in the aft radius of the R2 rod journal on the crankshaft during its last engine overhaul, which resulted in the fatigue failure of the crankshaft and a subsequent total loss of engine power.Jul 17, 2013 · N8721K · Substantial damageNTSB ERA13IA326Incident · No injuriesIncident investigationFinal reportPiper PA-34 · Palm Coast, FLThe installation of an incorrect rudder trim tab control rod by unknown maintenance personnel, which resulted in the rod failing in flight due to overload and subsequent uncontrolled rudder oscillations.Jul 17, 2013 · N767PE · No damageNTSB ERA13CA324Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Woodruff, SCThe pilot’s decision to initiate a stall maneuver at a low altitude, which resulted in an uncontrolled descent and inadvertent collision with trees and terrain.Jul 17, 2013 · N5815V · Substantial damageNTSB CEN13LA422Accident · Serious injuriesLimited investigationFinal reportGrumman Aircraft Cor-Schweizer G-164A · Elmira, MIThe pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.Jul 17, 2013 · N8719H · Substantial damageNTSB CEN13LA421Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe gate agent’s premature removal of the tailstand without confirming with the flight crew that it was safe to remove, which allowed the airplane to tilt backward when a passenger stood up and stepped toward the back of the airplane.Jul 17, 2013 · N732MD · Substantial damageNTSB CEN13FA416Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-65 · Flushing, MIThe student pilot’s failure to maintain airspeed during the landing approach, which led to a stall/spin, and the flight instructor’s failure to monitor the approach and provide remedial action before the stall.Jul 17, 2013 · N36466 · DestroyedNTSB ERA13LA320Accident · 1 fatalLimited investigationFinal reportThompson Bruce D Sonerai II · Pulaski, TNThe pilot's failure to maintain airspeed during a near-vertical climb after takeoff, which resulted in an aerodynamic stall and subsequent collision with terrain.Jul 16, 2013 · N788T · DestroyedNTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.Jul 16, 2013 · N613LD · Substantial damageNTSB CEN13FA415Accident · 1 fatalField investigationFinal reportBell UH-1H · Dove Creek, COPilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…Jul 16, 2013 · N775AR · Substantial damageNTSB WPR13CA328Accident · No injuriesData collectionFinal reportCessna 172S · Redlands, CAThe student pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in the overrun landing.Jul 15, 2013 · N625SP · Substantial damageNTSB WPR13CA330Accident · Serious injuriesData collectionFinal reportKincaid Wade Dakota Hawk · San Simon, AZThe pilot's failure to maintain clearance from power lines during takeoff from an open field.Jul 14, 2013 · N544WK · Substantial damageNTSB WPR13CA326Accident · No injuriesData collectionFinal reportCessna A185F · Cascade, IDThe pilot’s failure to maintain clearance from trees during final approach due to the sun glare that obscured the pilot's vision.Jul 14, 2013 · N185BW · Substantial damageNTSB WPR13CA325Accident · No injuriesData collectionFinal reportBoeing E75 · Bozeman, MTThe pilot’s failure to maintain adequate airspeed during a turn, which resulted in a loss of lift and collision with terrain.Jul 14, 2013 · N5176N · Substantial damageNTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.Jul 14, 2013 · N855F · Substantial damageNTSB CEN13CA411Accident · No injuriesData collectionFinal reportLuscombe 8 · Rose Hill, KSThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.Jul 14, 2013 · N1837B · Substantial damageNTSB WPR13LA331Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Mesa, AZThe student pilot’s failure to monitor and maintain clearance while taxiing, which resulted in collision with the parked airplane. Contributing to the accident was the parked airplane’s insufficient distance from the taxiway centerline.Jul 13, 2013 · N4111T · Substantial damageNTSB WPR13CA329Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Inyokern, CAThe failure of the pilot to maintain aircraft control during a practice autorotation maneuver and the pilot providing training's delayed remedial action which resulted in a hard landing. Contributing to the accident was the lack of communication between the…Jul 13, 2013 · N123HP · Substantial damage