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 GAA17CA071Accident · No injuriesData collectionFinal reportCessna 120 · Lincoln, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Nov 14, 2016 · N120MD · Substantial damageNTSB GAA17CA061Accident · No injuriesData collectionFinal reportBeech 95B55 · Plattsburgh, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover.Nov 14, 2016 · N180GA · Substantial damageNTSB ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.Nov 13, 2016 · N94292 · Substantial damageNTSB CEN17LA039Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Pleasanton, TXMaintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.Nov 13, 2016 · N44C · Substantial damageNTSB GAA17CA070Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Stone Lake, WIThe pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.Nov 12, 2016 · N744JS · Substantial damageNTSB GAA17CA066Accident · No injuriesData collectionFinal reportLuscombe 8 · Conway, ARThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and ground loop.Nov 12, 2016 · N2604K · Substantial damageNTSB CEN17LA038Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Coleman, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Nov 12, 2016 · N2035J · Substantial damageNTSB WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.Nov 11, 2016 · N914HH · Substantial damageNTSB WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 10, 2016 · N9556U · Substantial damageNTSB GAA17CA073Accident · No injuriesData collectionFinal reportCarter Richard L Buddy Baby Lakes · Hurricane, UTThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.Nov 10, 2016 · N1028Q · Substantial damageNTSB GAA17CA068Accident · No injuriesData collectionFinal reportMaule MX7 · Port Aransas, TXThe pilot’s failure to maintain directional control of the airplane during landing with a crosswind.Nov 10, 2016 · N591SB · Substantial damageNTSB GAA17CA067Accident · No injuriesData collectionFinal reportCessna 172 · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing.Nov 10, 2016 · N53402 · Substantial damageNTSB ERA17LA042Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Blairstown, NJThe pilot's improper engine start procedure, which resulted in a loss of control on the ground and collision with a tree.Nov 10, 2016 · N8849H · Substantial damageNTSB ERA17FA038Accident · 2 fatalField investigationFinal reportQuad City Challenger · Crescent City, FLAn abrupt pitch-up maneuver following a descent, which resulted in the in-flight separation of the right wing due to the overload failure of both the forward and aft right wing attachment brackets.Nov 9, 2016 · N327SH · DestroyedNTSB GAA17CA065Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot’s improper landing flare, which resulted in a hard landing.Nov 8, 2016 · N2272C · Substantial damageNTSB GAA17CA062Accident · No injuriesData collectionFinal reportAeronca L 3B · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll.Nov 8, 2016 · N46893 · Substantial damageNTSB ERA17LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Hopkinton, RIThe pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 8, 2016 · N30703 · Substantial damageNTSB ERA17CA039Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Houlton, MEA total loss of engine power due to fuel starvation, which resulted from the pilot’s mismanagement of the available fuel.Nov 8, 2016 · N7682P · Substantial damageNTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.Nov 7, 2016 · N62744 · Substantial damageNTSB CEN17LA036Accident · Minor injuriesLimited investigationFinal reportStinson L 5 · San Marcos, TXThe pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn.Nov 6, 2016 · N4252K · Substantial damageNTSB GAA17LA090Accident · No injuriesLimited investigationFinal reportPiper PA28R · Watertown, WIThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…Nov 5, 2016 · N300KR · Substantial damageNTSB GAA17CA063Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Port Matilda, PAThe bystander's decision to walk onto the runway, which resulted in him being struck by the glider's left wing.Nov 5, 2016 · N484KS · No damageNTSB GAA17CA058Accident · No injuriesData collectionFinal reportBeech 58TC · Valdosta, GAThe pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.Nov 5, 2016 · N2CH · Substantial damageNTSB GAA17CA056Accident · No injuriesData collectionFinal reportBeech 76 · Davis, CAThe pilot's failure to maintain directional control during a simulated left engine failure during takeoff. Also causal to the accident was the flight instructor's delayed remedial action to maintain directional control and reduce the right engine mixture…Nov 5, 2016 · N6703L · Substantial damageNTSB CEN17FA035Accident · 1 fatalField investigationFinal reportStamper RV-10 · Dubois, WYThe pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…Nov 5, 2016 · N924WY · DestroyedNTSB GAA17CA069Accident · No injuriesData collectionFinal reportCessna 172 · Danville, KYThe student pilot’s improper landing flare, which resulted in a hard landing.Nov 4, 2016 · N456SP · Substantial damageNTSB GAA17CA059Accident · Minor injuriesData collectionFinal reportHaring Clay RV6 · Eureka, KSThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Nov 4, 2016 · N207HW · Substantial damageNTSB ERA17CA047Accident · No injuriesData collectionFinal reportHawker Beechcraft G58 · Atlanta, GAThe pilot’s failure to maintain the proper airspeed during final approach and his subsequent loss of directional control during landing, which resulted in a runway excursion.Nov 1, 2016 · N525 · Substantial damageNTSB GAA17CA055Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Bristow, VAThe pilot’s loss of directional control during a landing attempt at night, which resulted in a delayed go-around procedure and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of recent flight experience.Oct 31, 2016 · N781MA · Substantial damageNTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…Oct 30, 2016 · N411HA · Substantial damageNTSB GAA17CA289Accident · No injuriesData collectionFinal reportCessna R182 · Llano, TXThe pilot’s improper landing flare, which resulted in a bounced landing.Oct 29, 2016 · N855SP · Substantial damageNTSB GAA17CA198Accident · Serious injuriesData collectionFinal reportAeros 2 · Blountstown, FLThe noncertificated pilot's decision to fly the weight-shift-controlled aircraft without having received training in the aircraft type, which resulted in his loss of aircraft control shortly after takeoff.Oct 29, 2016 · UNREG · Substantial damageNTSB ERA17LA031Accident · Minor injuriesLimited investigationFinal reportHaddow William H Pitts Special S 1 · New Bern, NCA loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.Oct 29, 2016 · N27832 · Substantial damageNTSB ANC17FA004Accident · 1 fatalField investigationFinal reportFairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AKThe airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…Oct 29, 2016 · N5308F · Substantial damageNTSB ANC17FA003Accident · 1 fatalField investigationFinal reportCessna 172 · Palmer, AKThe student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.Oct 29, 2016 · N6353E · Substantial damageNTSB WPR17LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Starbuck, WAA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.Oct 28, 2016 · N369BD · Substantial damageNTSB ERA17CA030Accident · Minor injuriesData collectionFinal reportKolb Fire FLY · West Middlesex, PAThe noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.Oct 28, 2016 · UNREG · Substantial damageNTSB DCA17FA021Accident · Serious injuriesClass 1 · FieldFinal reportBoeing 767 · Chicago, ILThe failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…Oct 28, 2016 · N345AN · Substantial damageNTSB CEN17LA030Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bloomfield, NMMaintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power.Oct 28, 2016 · N234PJ · Substantial damageNTSB CEN17FA028Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Clarksville, TXThe pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.Oct 28, 2016 · N377MA · DestroyedNTSB DCA17IA020Incident · No injuriesIncident investigationFinal reportBoeing 737 7L9 · New York, NYThe first officer's failure to attain the proper touchdown point and the flight crew's failure to call for a go-around, which resulted in the airplane landing more than halfway down the runway. Contributing to the incident were, the first officer's initiation…Oct 27, 2016 · N278EA · Minor damageNTSB CEN17LA027Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Hereford, TXThe pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.Oct 27, 2016 · N8525G · Substantial damageNTSB GAA17CA048Accident · No injuriesData collectionFinal reportCessna 182 · Palo Alto, CAThe pilot's failure to perform a go-around when he recognized that the airplane was high and fast during the final approach, which resulted in an improper landing flare and a hard landing.Oct 26, 2016 · N387CS · Substantial damageNTSB CEN17FA026Accident · 1 fatalField investigationFinal reportRoe Cleo Wittman Tailwind W10 · Pearland, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…Oct 26, 2016 · N557CL · Substantial damageNTSB WPR17FA013Accident · 2 fatalField investigationFinal reportBeech A36 · Pittsburg, CAA loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane.Oct 25, 2016 · N364RM · DestroyedNTSB GAA17CA054Accident · No injuriesData collectionFinal reportCessna A185 · Winnemucca, NVThe pilot's failure to maintain directional control during the landing roll.Oct 25, 2016 · N7711L · Substantial damageNTSB ERA17CA056Accident · No injuriesData collectionFinal reportBell OH 58A · Ponce, PRThe helicopter flight instructor's inadequate demonstration of a simulated engine failure, which resulted in a hard landing.Oct 25, 2016 · N161PD · Substantial damageNTSB CEN17LA032Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Ingleside, TXThe pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.Oct 25, 2016 · N48182 · Substantial damageNTSB GAA17CA049Accident · No injuriesData collectionFinal reportAviat A-1C · Placerville, CAThe pilot’s failure to maintain directional control of the airplane during landing in gusty crosswind conditions.Oct 24, 2016 · N331MA · Substantial damageNTSB WPR17LA011Accident · No injuriesLimited investigationFinal reportMooney M20J · Coalinga, CAA partial loss of engine power due to the pilot's improper in-flight fuel management, which resulted in fuel starvation.Oct 23, 2016 · N201EU · Substantial damage