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 WPR19TA142Accident · No injuriesClass 3Final reportZenair Zenith CH 701 · Marion, VAThe noncertificated pilot's failure to maintain control following a bounced landing and his decision to fly the airplane without proper training.Apr 30, 2019 · N396PH · Substantial damageNTSB GAA19CA238Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Sula, MTThe pilot's failure to maintain adequate clearance from ground equipment, which resulted in a tail rotor blade impact.Apr 30, 2019 · N350DL · Substantial damageNTSB GAA19CA232Accident · No injuriesData collectionFinal reportPavel Vagner TANGO2 · Cobden, ILThe pilot's failure to maintain the proper airspeed during the approach, which resulted in a hard landing.Apr 30, 2019 · N857UV · Substantial damageNTSB ERA19TA166Accident · Minor injuriesClass 3Final reportCessna 172 · New Bern, NCThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.Apr 30, 2019 · N733UF · Substantial damageNTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.Apr 29, 2019 · N90LK · Substantial damageNTSB WPR19FA123Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Kailua, HIThe helicopter’s encounter with a strong downdraft or outflow boundary while operating at a higher than recommended airspeed in turbulence which resulted in a low-G condition, excessive main rotor flapping, and an in-flight breakup when the main rotor…Apr 29, 2019 · N808NV · DestroyedNTSB GAA19CA372Accident · No injuriesData collectionFinal reportCessna T206 · Porterville, CAThe pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.Apr 29, 2019 · N189JC · Substantial damageNTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.Apr 29, 2019 · N3031W · Substantial damageNTSB GAA19CA233Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Juneau, AKThe pilot's failure to maintain a proper approach to landing on a ridge and his failure to maintain clearance from snow-covered terrain, which resulted in a tail rotor strike.Apr 28, 2019 · N288CH · Substantial damageNTSB GAA19CA228Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Lincoln, CAThe pilot receiving instruction's failure to maintain directional control during landing, which resulted in an attempted go-around and collision with a trench, and the flight instructor's delayed remedial action during the landing.Apr 28, 2019 · N5046E · Substantial damageNTSB CEN19TA131Accident · No injuriesClass 3Final reportAir Tractor AT 602 · Quanah, TXThe pilot's failure to maintain clearance from the power line during a low altitude aerial application maneuver.Apr 28, 2019 · N602AM · Substantial damageNTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.Apr 27, 2019 · N621L · Substantial damageNTSB GAA19CA235Accident · No injuriesData collectionFinal reportBakeng Bakeng Deuce · Winston Salem, NCThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Apr 27, 2019 · N19RG · Substantial damageNTSB GAA19CA227Accident · No injuriesData collectionFinal reportMaule M7 · Roosevelt, UTThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a runway excursion and collision with a culvert.Apr 27, 2019 · N4257A · Substantial damageNTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…Apr 27, 2019 · N233P · Substantial damageNTSB CEN19CA128Accident · Serious injuriesData collectionFinal reportUltramagic S90 · La Mesa, TXThe pilot's improper decision to launch the balloon in known high wind conditions, and his failure to fully vent the balloon upon landing, which resulted in the balloon landing hard several times, tipping over, being pushed along uneven ground, and a serious…Apr 27, 2019 · N901UM · No damageNTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.Apr 26, 2019 · N67823 · Substantial damageNTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.Apr 26, 2019 · N3733D · Substantial damageNTSB GAA19CA226Accident · No injuriesData collectionFinal reportGuimbal Cabri · McMinnville, ORThe pilot's improper landing flare during a turning, full-down autorotation, which resulted in a lower-than-normal rotor rpm, a faster-than-normal ground run speed, and the subsequent loss of directional control, a runway excursion, and a roll-over.…Apr 26, 2019 · N367PA · Substantial damageNTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.Apr 25, 2019 · N797N · DestroyedNTSB ERA19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportAcro Super Acro Sport I · Elberton, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 25, 2019 · N20FB · Substantial damageNTSB GAA19CA219Accident · No injuriesData collectionFinal reportCessna 180 · Morgan, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and an attempted aborted landing and impact with bushes and terrain.Apr 24, 2019 · N1628C · Substantial damageNTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.Apr 23, 2019 · N1897V · Substantial damageNTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.Apr 23, 2019 · N366TA · Substantial damageNTSB ERA19FA155Accident · 2 fatalClass 2 · FieldFinal reportBellanca 1730 · Henderson, KYThe student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…Apr 23, 2019 · N9693E · Substantial damageNTSB WPR19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Prineville, ORThe pilot’s failure to maintain directional control during takeoff with a crosswind.Apr 22, 2019 · N4567C · Substantial damageNTSB WPR19FA118Accident · 1 fatalClass 2 · FieldFinal reportNorthrop N9M · Norco, CAThe pilot's loss of control for undetermined reasons.Apr 22, 2019 · N9MB · DestroyedNTSB ERA19LA157Accident · Serious injuriesClass 3 · LimitedFinal reportBarrows Bearhawk LSA · Holly Springs, NCThe pilot's failure to maintain clearance from powerlines during the visual approach.Apr 22, 2019 · N289EH · Substantial damageNTSB ERA19FA154Accident · 1 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Cleveland, NCA loss of control and impact with terrain while maneuvering.Apr 22, 2019 · N625J · DestroyedNTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…Apr 22, 2019 · N501CE · Substantial damageNTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.Apr 21, 2019 · N766WC · Substantial damageNTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.Apr 21, 2019 · N25TX · DestroyedNTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.Apr 20, 2019 · N6023V · Substantial damageNTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.Apr 20, 2019 · N1866B · Substantial damageNTSB GAA19CA218Accident · No injuriesData collectionFinal reportCessna 180 · Reedsburg, WIThe pilot's loss of directional control and subsequent improper brake application during the landing roll, which resulted in a nose-over.Apr 20, 2019 · N59DW · Substantial damageNTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.Apr 20, 2019 · N40956 · Substantial damageNTSB WPR19LA117Accident · Minor injuriesClass 3 · LimitedFinal reportNanchang CJ 6 · Grass Valley, CAA loss of brake control due to fatigue fracture of the brake control cable, which resulted in the separation of the cable from the brake handle.Apr 19, 2019 · N621JM · Substantial damageNTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…Apr 19, 2019 · N65MY · DestroyedNTSB WPR19FA116Accident · 2 fatalClass 3 · FieldFinal reportVans RV8 · Brookings, ORThe pilot’s failure to maintain aircraft control during an aggressive maneuver that resulted in a nose down collision with terrain.Apr 18, 2019 · N791PF · Substantial damageNTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.Apr 17, 2019 · N96671 · Substantial damageNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB WPR19LA111Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Hauula, HIFuel exhaustion as a result of the pilot’s fuel burn miscalculation. Contributing to the accident was the inoperative caution light indicating low fuel level.Apr 16, 2019 · N593C · Substantial damageNTSB WPR19FA109Accident · 2 fatalClass 3 · FieldFinal reportBell 206 · Fort McDowell, AZThe separation of the main rotor head from the mast as a result of a sudden displacement of the cyclic stick during a low-G maneuver, leading to mast bumping. Contributing to the accident were the unsecure positioning of the flight test engineer’s laptop…Apr 16, 2019 · N61PH · DestroyedNTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Apr 16, 2019 · N755K · Substantial damageNTSB GAA19CA215Accident · No injuriesData collectionFinal reportKaminskas RTH Jungster 1 · Lebanon, INThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Apr 15, 2019 · N3243 · Substantial damageNTSB GAA19CA208Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Outlaw · Elizabeth, COThe pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.Apr 15, 2019 · N5622D · Substantial damageNTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.Apr 15, 2019 · N55275 · Substantial damageNTSB ANC19TA017Accident · Serious injuriesClass 3Final reportCessna A185 · Nome, AKThe pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…Apr 15, 2019 · N5163E · Substantial damageNTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.Apr 14, 2019 · N355WC · Minor damageNTSB GAA19CA217Accident · Minor injuriesData collectionFinal reportVans Vans RV-12 · Wall, SDThe pilot's improper decision to depart from a slush-covered runway, which resulted in a loss of directional control, a runway excursion, and a subsequent nose-over.Apr 14, 2019 · N277E · Substantial damage