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 WPR12FA184Accident · 3 fatalField investigationFinal reportCessna A185F · Blanding, UTThe pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…Apr 25, 2012 · N243W · Substantial damageNTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.Apr 25, 2012 · N969W · Substantial damageNTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.Apr 25, 2012 · N505EV · Substantial damageNTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.Apr 25, 2012 · N510KW · Substantial damageNTSB WPR12LA182Accident · No injuriesLimited investigationFinal reportMays Kitfox Lite 2 · Cedarville, CAA loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.Apr 22, 2012 · N32122 · Substantial damageNTSB WPR12LA178Accident · Serious injuriesLimited investigationFinal reportBeechcraft A36TC · Pendleton, ORThe pilot's failure to maintain an adequate glidepath for landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's failure to secure the left-side fuel cap before departure. Contributing to the…Apr 22, 2012 · N3862C · Substantial damageNTSB WPR12CA179Accident · Minor injuriesData collectionFinal reportCessna 182J · Delle, UTThe pilot’s failure to properly monitor the environment during the departure from a gravel parking area and runway, which resulted in the airplane’s collision with a mound of gravel.Apr 22, 2012 · N2701F · Substantial damageNTSB CEN12LA254Accident · No injuriesLimited investigationFinal reportAlvarez Marvin R Rans S-6S · New Braunfels, TXThe non-certificated pilot's loss of airplane control during takeoff.Apr 22, 2012 · N137AB · Substantial damageNTSB CEN12LA253Accident · Serious injuriesLimited investigationFinal reportBumford-Royer Christen Eagle II · Pearland, TXA loose B nut on the fuel inlet line due to maintenance personnel’s application of insufficient torque on the nut at an unknown time, which resulted in a fuel leak and a subsequent total loss of engine power during initial climb.Apr 22, 2012 · N80BH · Substantial damageNTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.Apr 22, 2012 · N8518M · Substantial damageNTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.Apr 22, 2012 · N7911F · Substantial damageNTSB CEN12LA259Accident · No injuriesLimited investigationFinal reportMoody-Siple A · Stuttgart, ARThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.Apr 21, 2012 · N78RB · Substantial damageNTSB CEN12FA251Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Newcomerstown, OHThe pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.Apr 21, 2012 · N110EB · Substantial damageNTSB ANC12CA032Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Alpha · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a tailrotor strike.Apr 21, 2012 · N121MR · Substantial damageNTSB WPR12CA177Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Sierraville, CAThe pilot did not maintain directional control during the landing roll.Apr 20, 2012 · N8451Y · Substantial damageNTSB ERA12LA295Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Yorktown, NYThe pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.Apr 20, 2012 · N821SM · Substantial damageNTSB WPR12LA176Accident · Serious injuriesLimited investigationFinal reportSkykits USA Savannah ADV · Ookala, HIA loss of engine power during cruise for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s failure to avoid an…Apr 19, 2012 · N5089F · Substantial damageNTSB ERA12LA294Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, KYA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…Apr 19, 2012 · N28BC · Substantial damageNTSB ERA12LA292Accident · Serious injuriesLimited investigationFinal reportMooney M20F · McKinnon, TNThe pilot's delayed decision to go-around after failing to recognize that he was attempting to land with a tailwind, and his failure to retract the landing gear and wing flaps for the go-around, which resulted in a collision with trees and terrain near the…Apr 19, 2012 · N9722M · Substantial damageNTSB ERA12LA290Accident · 1 fatalLimited investigationFinal reportCessna 421CPilot incapacitation, which resulted in the pilot’s inability to maintain airplane control and the airplane’s subsequent ocean impact.Apr 19, 2012 · N48DL · Substantial damageNTSB ANC12CA033Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Valdez, AKThe pilot's selection of an unsuitable landing surface, which resulted in the tail rotor contacting terrain.Apr 18, 2012 · N191EH · Substantial damageNTSB WPR12CA172Accident · No injuriesData collectionFinal reportRockwell International S-2R · Palouse, WAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s distraction and subsequent failure to have the airplane refueled.Apr 17, 2012 · N4971X · Substantial damageNTSB WPR12CA169Accident · No injuriesData collectionFinal reportCessna 182G · Georgetown, CAThe pilot’s failure to maintain control of the airplane while landing with a gusting wind.Apr 17, 2012 · N3272S · Substantial damageNTSB WPR12CA168Accident · Minor injuriesData collectionFinal reportApollo Monsoon · Oro Valley, AZThe pilot’s failure to lower the nose landing gear in time to prevent it from slamming onto the runway and collapsing.Apr 17, 2012 · N125AP · Substantial damageNTSB ERA12CA288Accident · No injuriesData collectionFinal reportCessna 180J · Abingdon, VAThe passenger’s inadvertent blockage of the rudder pedals, which resulted in the pilot’s inability to maintain directional control during the landing roll.Apr 17, 2012 · N180BA · Substantial damageNTSB CEN12LA247Accident · No injuriesLimited investigationFinal reportHughes 269A · Grinnell, IAThe pilot's improper liftoff technique, which resulted in ground resonance, and the pilot's delayed recognition of the ground resonance.Apr 17, 2012 · N69HJ · Substantial damageNTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…Apr 17, 2012 · N56RD · Substantial damageNTSB WPR12CA175Accident · No injuriesData collectionFinal reportLuscombe 8E · Winslow, AZThe pilot did not maintain directional control during the landing roll.Apr 16, 2012 · N25E · Substantial damageNTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.Apr 16, 2012 · N5025G · Substantial damageNTSB ERA12CA328Accident · Serious injuriesData collectionFinal reportUltramagic N425 · Clermont, FLThe balloon passenger's failure to maintain her grip during landing, which resulted in a fall and injury to another passenger.Apr 16, 2012 · N990BR · No damageNTSB WPR12CA170Accident · No injuriesData collectionFinal reportCessna 180F · McCall, IDThe pilot did not maintain directional control during the landing roll.Apr 15, 2012 · N2157Z · Substantial damageNTSB WPR12CA166Accident · Minor injuriesData collectionFinal reportMooney M20B · Rosamond, CAA loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.Apr 15, 2012 · N74518 · Substantial damageNTSB ERA12LA285Accident · Serious injuriesLimited investigationFinal reportWilloughby Pete A Streak Shadow · Salem, WVA total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…Apr 15, 2012 · N2828W · Substantial damageNTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.Apr 15, 2012 · N965TE · Substantial damageNTSB ANC12CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot's decision not to initiate a go-around.Apr 15, 2012 · N7227D · Substantial damageNTSB ERA12LA282Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Farmington, CTThe pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…Apr 14, 2012 · N1152W · Substantial damageNTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.Apr 14, 2012 · N235MW · Substantial damageNTSB ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.Apr 14, 2012 · N714JJ · Substantial damageNTSB WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.Apr 13, 2012 · N3583K · Substantial damageNTSB ERA12LA287Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cross Keys, NJThe pilot's failure to maintain control of the airplane during landing, which resulted in the overstress and subsequent failure of the right main landing gear assembly.Apr 13, 2012 · N7001K · Substantial damageNTSB ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.Apr 13, 2012 · N24V · Substantial damageNTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.Apr 13, 2012 · N75487 · Substantial damageNTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.Apr 13, 2012 · N70451 · Substantial damageNTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.Apr 12, 2012 · N32EG · DestroyedNTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.Apr 12, 2012 · N17304 · Substantial damageNTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.Apr 12, 2012 · N12003 · Substantial damageNTSB WPR12CA163Accident · No injuriesData collectionFinal reportAvian Balloon Magnum IX · Sedona, AZThe pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.Apr 10, 2012 · N2037U · 2 aircraft · Substantial damageNTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.Apr 10, 2012 · N9518J · Substantial damageNTSB ERA12CA276Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Iuka, MSThe pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Apr 10, 2012 · N43003 · Substantial damageNTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.Apr 10, 2012 · N5253Q · Substantial damage