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 ERA18LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech B 55 · Statesville, NCA total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.Nov 17, 2017 · N592SS · Substantial damageNTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.Nov 16, 2017 · N75919 · Substantial damageNTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.Nov 16, 2017 · N5381F · Substantial damageNTSB CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.Nov 15, 2017 · N9825M · Substantial damageNTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.Nov 14, 2017 · N30SU · Substantial damageNTSB GAA18CA051Accident · No injuriesData collectionFinal reportCessna 182H · Tucson, AZThe pilot’s failure to use taxiways shown on the airport diagrams and his subsequent failure to avoid a ditch.Nov 12, 2017 · N8515S · Substantial damageNTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…Nov 12, 2017 · N3371W · DestroyedNTSB WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.Nov 11, 2017 · N744BS · Substantial damageNTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.Nov 11, 2017 · N141WC · Substantial damageNTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.Nov 10, 2017 · N6547A · Substantial damageNTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.Nov 9, 2017 · N2138W · Substantial damageNTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.Nov 8, 2017 · N76238 · Substantial damageNTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.Nov 8, 2017 · N275AE · Substantial damageNTSB ERA18FA016Accident · 2 fatalField investigationFinal reportPiper PA 32 · Morrison, TNThe pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.Nov 8, 2017 · N47831 · DestroyedNTSB GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.Nov 7, 2017 · N55234 · Substantial damageNTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.Nov 7, 2017 · N231JD · Substantial damageNTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.Nov 7, 2017 · N138WH · No damageNTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.Nov 7, 2017 · N922BA · Substantial damageNTSB CEN18LA025Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Larchwood, IAThe pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.Nov 6, 2017 · N7085M · Substantial damageNTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.Nov 5, 2017 · N98299 · Substantial damageNTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.Nov 5, 2017 · N893CA · Substantial damageNTSB CEN18FA024Accident · 4 fatalField investigationFinal reportCessna 172N · Hatch, NMThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.Nov 4, 2017 · N251CH · Substantial damageNTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…Nov 4, 2017 · N777PH · DestroyedNTSB WPR18LA023Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B95 · Las Vegas, NVThe flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing.Nov 3, 2017 · N9628R · Substantial damageNTSB WPR18FA026Accident · 1 fatalClass 2 · FieldFinal reportPiper PA 18-150 · Murphy, IDFailure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.Nov 3, 2017 · N4393Z · Substantial damageNTSB ERA18LA019Accident · Serious injuriesLimited investigationFinal reportMaurer Elmo A V Star SA900 · Erwinna, PAThe pilot's failure to maintain airplane control during landing.Nov 3, 2017 · N21EM · Substantial damageNTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.Nov 2, 2017 · N3512L · Substantial damageNTSB ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…Oct 31, 2017 · N293GC · Substantial damageNTSB WPR18LA021Accident · No injuriesLimited investigationFinal reportMetcalfe Robert B Vans RV 6 · Selma, CAThe pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power.Oct 30, 2017 · N88MV · Substantial damageNTSB ANC18LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · Dawsonville, GAThe failure of the pilot, who was not a certified mechanic, to tighten the B-nut on a remotely mounted oil filter line, which resulted in oil exhaustion, a total loss of oil pressure, and a subsequent total loss of engine power.Oct 30, 2017 · N4213F · Substantial damageNTSB GAA18CA033Accident · No injuriesData collectionFinal reportEvolution Revo · Berlin, NHThe pilot’s failure to center the ground steering before landing, which resulted in a loss of directional control.Oct 29, 2017 · N401HK · Substantial damageNTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.Oct 28, 2017 · N6582P · Substantial damageNTSB WPR18CA028Accident · No injuriesData collectionFinal reportStill Michael J Titan T-51 · Chandler, AZThe pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.Oct 28, 2017 · N651P · Substantial damageNTSB GAA18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Skwentna, AKThe pilot’s decision to land on an unimproved snow-covered airstrip, which resulted in the airplane coming to rest inverted.Oct 28, 2017 · N2661Q · Substantial damageNTSB GAA18CA035Accident · No injuriesData collectionFinal reportSmith Aerostar 600A · Tallahassee, FLThe pilot's incorrect pitch control and premature landing gear retraction during the initial climb.Oct 27, 2017 · N211W · Substantial damageNTSB GAA18CA029Accident · Serious injuriesData collectionFinal reportSix Chuter West Legend XL · Mabton, WAThe pilot’s failure to see and avoid transmission wires.Oct 26, 2017 · N781SC · Substantial damageNTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.Oct 26, 2017 · N927D · Substantial damageNTSB GAA18CA026Accident · No injuriesData collectionFinal reportJohn A Brewer ELA Aviacion 10 Ecli · Bristol, TNThe pilot’s failure to maintain lateral control during the landing roll.Oct 26, 2017 · N230MG · Substantial damageNTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Oct 24, 2017 · N8494K · Substantial damageNTSB WPR18FA016Accident · 1 fatalField investigationFinal reportRobinson R22 · Arlington, WAThe pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.Oct 24, 2017 · N8537J · Substantial damageNTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.Oct 24, 2017 · N19EC · Substantial damageNTSB CEN18LA020Accident · No injuriesLimited investigationFinal reportBell 206B · Groom, TXThe total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to operate the helicopter with minimum fuel on board.Oct 24, 2017 · N60EA · Substantial damageNTSB CEN18LA019Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502B · Olton, TXThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Oct 24, 2017 · N502G · DestroyedNTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 23, 2017 · N5129C · Substantial damageNTSB GAA18CA022Accident · No injuriesData collectionFinal reportAviat A1 · Williamsport, PAThe pilot’s failure to verify that the parking brake was disengaged before landing, which resulted in a runway excursion.Oct 22, 2017 · N337AM · Substantial damageNTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Oct 22, 2017 · N7GL · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · Substantial damageNTSB WPR18LA014Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA 1A · Maricopa, AZThe pilot’s failure to see and avoid unmarked power lines during the approach to land.Oct 21, 2017 · N9239L · Substantial damageNTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…Oct 21, 2017 · N3636E · Substantial damageNTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…Oct 21, 2017 · N414MT · Destroyed