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 WPR14LA230Accident · 1 fatalLimited investigationFinal reportCessna 172M · Laytonville, CAThe pilot’s impairment due to alcohol ingestion, which resulted in his failure to maintain clearance from trees during a low-altitude flyby.Jun 6, 2014 · N1186U · Substantial damageNTSB ERA14CA286Accident · No injuriesData collectionFinal reportCessna 162 · Cross City, FLThe student pilot's improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.Jun 6, 2014 · N6017R · Substantial damageNTSB ERA14CA284Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Defuniak Springs, FLThe pilot's failure to maintain directional control in gusty wind conditions during landing, which resulted in a runway excursion and collision with terrain.Jun 6, 2014 · N2890Z · Substantial damageNTSB CEN14LA281Accident · Serious injuriesLimited investigationFinal reportOffchiss Edward R Avid Flyer · Lamoni, IAThe student pilot’s failure to maintain control of the airplane while landing.Jun 6, 2014 · N111ED · Substantial damageNTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.Jun 6, 2014 · N30537 · Substantial damageNTSB CEN14CA280Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus 3/24.5 · Wallis, TXThe pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.Jun 6, 2014 · N245AB · Substantial damageNTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…Jun 6, 2014 · N1301H · Substantial damageNTSB CEN14CA291Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Middleton, WIThe pilot's failure to maintain directional control during takeoff.Jun 5, 2014 · N752J · Substantial damageNTSB WPR14LA225Accident · No injuriesLimited investigationFinal reportEmery Mark Rotorway 162F · Merced, CAThe helicopter pilot/owner's decision to install a belt type not recommended by the kit manufacturer in the tail rotor drive system using the incorrect tension values, which led to the belt’s in-flight failure and the subsequent loss of tail rotor drive…Jun 4, 2014 · N78291 · DestroyedNTSB WPR14CA229Accident · No injuriesData collectionFinal reportAeronca 11AC · Tacoma, WAThe student pilot's improper application of rudder resulted in a loss of control during the landing roll and the flight instructor's inadequate oversight.Jun 4, 2014 · N9791E · Substantial damageNTSB WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.Jun 4, 2014 · N1672P · Substantial damageNTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…Jun 4, 2014 · N223G · Substantial damageNTSB CEN14LA290Accident · Serious injuriesLimited investigationFinal reportTeunis Starduster TOO SA300 · Fort Worth, TXThe non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.Jun 4, 2014 · N8DT · Substantial damageNTSB CEN14CA285Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Lebanon, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.Jun 4, 2014 · N3FN · Substantial damageNTSB WPR14LA222Accident · 1 fatalLimited investigationFinal reportPhillips BD 4 · Dayton, NVThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the turn onto the final base leg in gusting wind conditions, which resulted in a stall/spin at too low an altitude to allow recovery.Jun 3, 2014 · N11DV · DestroyedNTSB WPR14CA223Accident · No injuriesData collectionFinal reportPiper J3C 65 · Bellingham, WAThe pilot's failure to maintain directional control during the landing on a narrow airstrip, which resulted in a collision with trees.Jun 3, 2014 · N1205P · Substantial damageNTSB WPR14CA221Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · McCall, IDLoss of directional control during landing rollout due to a wind disturbance, which resulted in a runway veeroff and impact with a ditch.Jun 3, 2014 · N505V · Substantial damageNTSB ERA14CA276Accident · Minor injuriesData collectionFinal reportSwearingen SA 226AT · Dayton, TNThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Jun 3, 2014 · N120SC · Substantial damageNTSB WPR14LA220Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A 9B · Gardiner, MTThe pilot’s inadequate preflight planning and his subsequent takeoff with the airplane over its allowable gross weight in high density altitude conditions, which degraded the airplane’s climb performance and led to a subsequent forced landing.Jun 2, 2014 · N7292V · Substantial damageNTSB ERA14LA279Accident · No injuriesLimited investigationFinal reportFrederick Hays-Roth Velocity Twin · Sebastian, FLThe pilot’s improper landing flare, which resulted in a bounced landing. Also causal to the accident were the pilot’s subsequent delayed decision to abort the landing and his improper execution of the aborted landing, which resulted in the airplane exceeding…Jun 2, 2014 · N360VT · Substantial damageNTSB ERA14CA277Accident · No injuriesData collectionFinal reportCessna 177B · Cartersville, GAThe pilot's failure to maintain directional control during a go-around after landing.Jun 2, 2014 · N30820 · Substantial damageNTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…Jun 1, 2014 · N121JM · DestroyedNTSB ERA14CA274Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Middletown, NYThe pilot's failure to maintain directional control during a bounced landing.Jun 1, 2014 · N7638 · Substantial damageNTSB CEN14LA277Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Durango, COThe student pilot’s decision to fly solo into an unfamiliar, mountain airport during high-wind conditions. Contributing to the accident was a partial loss of engine power during the attempted go-around, which was caused by an over-rich mixture setting.Jun 1, 2014 · N583KM · Substantial damageNTSB CEN14LA272Accident · 1 fatalLimited investigationFinal reportDehavilland DHC 6 200 · Middletown, OHThe skydiving operator employee’s failure to see and avoid the rotating propeller blades when she walked toward the cockpit while the airplane’s engines were running.Jun 1, 2014 · N223AL · Minor damageNTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Jun 1, 2014 · N206ND · Substantial damageNTSB CEN14FA266Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Stevens Point, WIThe pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.Jun 1, 2014 · N176FD · Substantial damageNTSB WPR14FA218Accident · 2 fatalField investigationFinal reportNebert Vans RV-10 · Toledo, ORA total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…May 31, 2014 · N62DN · Substantial damageNTSB WPR14CA219Accident · Minor injuriesData collectionFinal reportPzl-Swidnik PW 5 · Enumclaw, WAThe pilot's failure to maintain control of the glider during the landing flare which resulted in a stall and hard landing.May 31, 2014 · N77FZ · Substantial damageNTSB WPR14CA216Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Manuel, AZThe pilot's failure to maintain an adequate obstacle clearance altitude from phone wires while performing low-level operations.May 31, 2014 · N7122E · Substantial damageNTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…May 31, 2014 · N6RP · Substantial damageNTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.May 31, 2014 · N8394U · Substantial damageNTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.May 31, 2014 · N6275G · Substantial damageNTSB CEN14CA533Accident · No injuriesData collectionFinal reportAviat Pitts S 2B · Grants, NMThe pilot's failure to maintain control of the airplane during landing in gusty wind conditions.May 31, 2014 · N9YH · Substantial damageNTSB ANC14CA032Accident · No injuriesData collectionFinal reportFound Acft Canada FBA 2C2 · Willow, AKThe pilot's loss of control of the airplane during landing on water due to an encounter with wind shear, which resulted in the airplane's abnormal contact with the surface.May 31, 2014 · N602BC · Substantial damageNTSB ERA14LA269Accident · Minor injuriesLimited investigationFinal reportGarlick Helicopters OH 58A+ · Whitefield, MEA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to land as soon as possible when the master caution warning light first illuminated as prescribed and his failure to ensure the proper setting of the…May 30, 2014 · N650MH · Substantial damageNTSB CEN14IA270Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Island 182AThe improper repair of the outer combustion case, which led to its ultimate failure due to the continued progression of a fatigue crack and resulted in a partial loss of engine power during takeoff.May 30, 2014 · N1197 · No damageNTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.May 30, 2014 · N5495K · Substantial damageNTSB CEN14CA271Accident · No injuriesData collectionFinal reportBRM Aero Sro Bristell S-LSA · Boerne, TXThe instructor pilot's failure to regain control of the airplane following the student pilot's initial loss of control of the airplane.May 30, 2014 · N348BL · Substantial damageNTSB ANC14LA035Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Homer, AKThe flutter failure of the right elevator servo tab due to the improper fabrication of the servo tab and maintenance personnel’s subsequent failure to detect anomalies with the servo tab.May 30, 2014 · N3125N · Substantial damageNTSB ANC14CA033Accident · No injuriesData collectionFinal reportCessna 172F · Fairbanks, AKThe pilot's improper inflight planning, which resulted in fuel starvation and a loss of engine power. A factor was the pilot's selection of a low cruise flight altitude, which provided little time for the selection of suitable terrain for the forced landing…May 30, 2014 · N8646U · Substantial damageNTSB WPR14CA224Accident · No injuriesData collectionFinal reportMeyers MAC 145 · La Cholla, AZThe pilot's overcorrection to a wind gust, which resulted in a loss of directional control and runway veeroff.May 29, 2014 · N34374 · Substantial damageNTSB CEN14CA282Accident · No injuriesData collectionFinal reportLuscombe 8B · Galion, OHThe pilot's misapplication of brakes after landing, which resulted in the airplane nosing over.May 29, 2014 · N39092 · Substantial damageNTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.May 29, 2014 · UNREG · Substantial damageNTSB WPR14CA217Accident · No injuriesData collectionFinal reportCessna 210 · Moab, UTThe pilot's inadequate landing flare, which resulted in a hard landing.May 28, 2014 · N9589T · Substantial damageNTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.May 28, 2014 · N51853 · Substantial damageNTSB CEN14LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COThe pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.May 28, 2014 · N8808L · Substantial damageNTSB ANC14FA030Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Chugiak, AKThe pilot's loss of control of the helicopter due to impairment or incapacitation from a sudden, acute cardiac event.May 28, 2014 · N392GP · DestroyedNTSB ANC14CA031Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilot's inadequate remedial action during landing on soft terrain, which resulted in a nose-over.May 28, 2014 · N8929L · Substantial damageNTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.May 27, 2014 · N222RS · Substantial damage