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 GAA17CA473Accident · No injuriesData collectionFinal reportCessna 180 · Puntilla, AKThe airplane’s encounter with a downdraft while maneuvering at a low altitude, which resulted in the exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Aug 2, 2017 · N9455C · DestroyedNTSB GAA17CA472Accident · No injuriesData collectionFinal reportMooney M20 · Skiatook, OKThe pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…Aug 2, 2017 · N95442 · Substantial damageNTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.Aug 2, 2017 · N38HT · Substantial damageNTSB GAA17CA466Accident · No injuriesData collectionFinal reportAB Sportine Aviacija LAK 17 · Uvalde, TXThe ground crewmember’s failure to fully engage the tow hook release arm during preflight, which resulted in the premature release of the glider at insufficient altitude to complete a safe landing.Aug 2, 2017 · N128LA · DestroyedNTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…Aug 1, 2017 · N6216L · Substantial damageNTSB WPR17IA173Incident · No injuriesClass 3 · IncidentFinal reportColumbia Aircraft Mfg LC41 550FG · Chandler, AZThe over-tensioning of the accessory belt, which resulted in damage to the starter adapter and subsequent loss of oil that led to oil starvation and catastrophic engine failure.Aug 1, 2017 · N8725 · Minor damageNTSB CEN17LA298Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Bullard, TXThe partial loss of engine power due to carburetor icing and the pilot's inability to maintain adequate airspeed during the soft-field takeoff, which resulted in an exceedance of the airplane's critical angle-of-attack and an aerodynamic stall.Aug 1, 2017 · N8879S · Substantial damageNTSB WPR17LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802A · Wells, NVThe pilot's failure to maintain directional control during a period of thermal activity, which led to a runway excursion and impact with terrain.Jul 31, 2017 · N70LA · Substantial damageNTSB WPR17LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Seattle, WAThe total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.Jul 31, 2017 · N957TA · Substantial damageNTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.Jul 31, 2017 · N344MM · Substantial damageNTSB CEN17LA306Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Denver, COThe pilot’s failure to maintain directional control while landing.Jul 31, 2017 · N2146R · Substantial damageNTSB CEN17LA293Accident · Serious injuriesLimited investigationFinal reportChapman T-BIRD II · Potosi, MOThe pilot's loss of airplane control during a departure turn for reasons that could not be determined.Jul 31, 2017 · N204BC · Substantial damageNTSB GAA17CA536Accident · Minor injuriesData collectionFinal reportMenzimer Gary Ray Firestar · Westfield, PAThe pilot's improper decision to operate an airplane without recent flight training and his inadvertent application of left electric rudder trim before flight and a subsequent loss of airplane control.Jul 30, 2017 · UNREG · DestroyedNTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.Jul 30, 2017 · N497TC · Substantial damageNTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.Jul 30, 2017 · N616JJ · Substantial damageNTSB GAA17CA462Accident · No injuriesData collectionFinal reportChampion 7ECA · Butler, PAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.Jul 30, 2017 · N9682S · Substantial damageNTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.Jul 30, 2017 · N2204B · Substantial damageNTSB ERA17LA261Accident · 1 fatalLimited investigationFinal reportCessna 172 · Danbury, CTThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…Jul 30, 2017 · N612DF · Substantial damageNTSB CEN17LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA 46 350P · Tahlequah, OKThe total loss of engine power, which resulted from fatigue failure of two engine through bolts and the No. 2 cylinder attachment studs due to the lack of sufficient clamping force.Jul 30, 2017 · N786MD · Substantial damageNTSB WPR17FA171Accident · 2 fatalField investigationFinal reportCessna 172N · Big Bear, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in high density altitude conditions, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.Jul 29, 2017 · N5381J · Substantial damageNTSB WPR17FA170Accident · 4 fatalField investigationFinal reportBeech 19A · Waipi'o, HIThe pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.Jul 29, 2017 · N6142N · Substantial damageNTSB GAA17CA481Accident · No injuriesData collectionFinal reportMooney M20C · Clearwater, FLThe pilot’s distraction before landing by a helicopter that was transitioning to the airport and his subsequent failure to extend the landing gear before touchdown.Jul 29, 2017 · N2596W · Substantial damageNTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.Jul 29, 2017 · N1129K · Substantial damageNTSB GAA17CA460Accident · No injuriesData collectionFinal reportCessna 305 · Eagle Lake, TXThe pilot’s loss of directional control during landing in variable wind conditions.Jul 29, 2017 · N72BD · Substantial damageNTSB GAA17CA456Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD 55-1 · Mocksville, NCThe pilot’s improper landing flare in gusting wind conditions.Jul 29, 2017 · N817V · Substantial damageNTSB GAA17CA453Accident · No injuriesData collectionFinal reportPiper PA36 · McCook, NEThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while maneuvering downwind during an agricultural application flight, which resulted in an aerodynamic stall at low altitude.Jul 29, 2017 · N132VA · Substantial damageNTSB ERA17LA264Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA 4 · Orlando, FLA loss of directional control during taxi operations for reasons that could not be determined based on the available information, which resulted in the airplane rolling into a ditch.Jul 29, 2017 · N747CB · Substantial damageNTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.Jul 28, 2017 · N7243T · Substantial damageNTSB GAA17CA480Accident · No injuriesData collectionFinal reportThomas J Hankamp VAN'S Aircraft RV4 · Poughkeepsie, NYThe pilot’s failure to maintain directional control during takeoff.Jul 28, 2017 · N9214 · Substantial damageNTSB GAA17CA458Accident · No injuriesData collectionFinal reportRandall Marvin L Vans RV 3A · Spokane, WAThe other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.Jul 28, 2017 · N16MR · 2 aircraft · Substantial damageNTSB GAA17CA457Accident · No injuriesData collectionFinal reportSwearingen SA26 · Hondo, TXThe pilot’s failure to extend the landing gear before landing.Jul 28, 2017 · N541GF · Substantial damageNTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.Jul 28, 2017 · N6368K · Substantial damageNTSB GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.Jul 28, 2017 · N410BP · Substantial damageNTSB CEN17LA290Accident · Minor injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri G2 · Beaumont, TXThe flight instructor's low-altitude maneuvering, which exceeded the helicopter's performance capability in the high-density altitude conditions and resulted in a loss of control.Jul 28, 2017 · N722TX · Substantial damageNTSB CEN17FA287Accident · 2 fatalField investigationFinal reportAerofab Lake LA 4 250 · Oshkosh, WIThe pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.Jul 28, 2017 · N1400P · Substantial damageNTSB WPR17LA167Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Ana, CAThe pilot's failure to maintain helicopter control while maneuvering during takeoff.Jul 27, 2017 · N7535G · Substantial damageNTSB GAA17CA459Accident · No injuriesData collectionFinal reportRockwell International S 2R · McRae, GAThe pilot’s failure to maintain directional control during the landing roll in tailwind conditions.Jul 27, 2017 · N4886X · Substantial damageNTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.Jul 27, 2017 · N5596C · Substantial damageNTSB GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.Jul 27, 2017 · N302DM · Substantial damageNTSB CEN17FA288Accident · 2 fatalField investigationFinal reportZenith CH701SP · Laddonia, MOThe pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…Jul 27, 2017 · N701XL · DestroyedNTSB ANC17FA039Accident · 1 fatalClass 2 · FieldFinal reportCessna U206 · Port Alsworth, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…Jul 27, 2017 · N1749R · DestroyedNTSB WPR17FA166Accident · 4 fatalField investigationFinal reportBeech A36TC · Ogden, UTA loss of control during takeoff for reasons that could not be determined.Jul 26, 2017 · N60WB · Substantial damageNTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 26, 2017 · N208SS · Substantial damageNTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.Jul 26, 2017 · N421CA · Substantial damageNTSB WPR17LA168Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Lake Sutherlin, MTThe pilot’s transition into an out-of-ground-effect hover in high-density altitude conditions that exceeded the helicopter’s performance capabilities, which resulted in loss of rotor rpm.Jul 25, 2017 · N233JD · Substantial damageNTSB WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…Jul 25, 2017 · N7628L · Substantial damageNTSB GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.Jul 25, 2017 · N802DL · Substantial damageNTSB WPR17LA163Accident · Minor injuriesClass 3 · LimitedFinal reportBritish BAC Stkmstr MK80 · Henderson, NVThe failure of the pilot to ensure that the flaps were set to the proper position for takeoff which resulted in the airplane becoming airborne and unable to climb or accelerate and subsequently impacting terrain.Jul 24, 2017 · N605GV · DestroyedNTSB GAA17CA437Accident · No injuriesData collectionFinal reportCessna 172 · Powell, WYThe student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.Jul 24, 2017 · N6470E · Substantial damageNTSB GAA17CA436Accident · No injuriesData collectionFinal reportBell 47G 3B · Toterville, IAThe pilot’s failure to maintain rotor rpm while maneuvering at low altitude with low airspeed and a tailwind.Jul 24, 2017 · N47AH · Substantial damage