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 GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.Dec 12, 2015 · N35KF · Substantial damageNTSB ERA16LA068Accident · 1 fatalLimited investigationFinal reportMccorkle Robert B Rans S-12 Airaile · Benton, TNThe pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.Dec 12, 2015 · N6202N · Substantial damageNTSB ERA16LA066Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Fayetteville, NCMaintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…Dec 12, 2015 · N3241N · Substantial damageNTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…Dec 11, 2015 · N408FC · DestroyedNTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.Dec 11, 2015 · N432FL · Substantial damageNTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…Dec 11, 2015 · N72054 · DestroyedNTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.Dec 10, 2015 · N307AB · Substantial damageNTSB GAA16LA086Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 390 · Wheeling, ILThe pilots' decision to conduct an approach and landing in gusting wind conditions, and their failure to maintain control of the airplane during the first approach, which resulted in a wing strike.Dec 10, 2015 · N50VM · Substantial damageNTSB GAA16CA076Accident · Minor injuriesData collectionFinal reportCessna 172 · Abilene, TXThe student pilot's abrupt control inputs during the flare, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's lack of over sight and delayed reaction while landing.Dec 10, 2015 · N9868Q · Substantial damageNTSB CEN16FA062Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Council Bluffs, IAThe pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.Dec 10, 2015 · N145JR · Substantial damageNTSB GAA16CA075Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe student pilot's failure to maintain directional control during the landing, which resulted in a horizontal rotation of the helicopter, and abnormal runway contact.Dec 9, 2015 · N4427H · Substantial damageNTSB WPR16IA044Incident · No injuriesIncident investigationFinal reportCessna LC41-550FG · Seal Beach, CAImproper maintenance performed on the left magneto which led to a loss of engine power. Contributing to the incident was the pilot's failure to check the magnetos in flight in compliance with manufacturers guidance regarding rough running engine. The pilot's…Dec 8, 2015 · N932AC · Minor damageNTSB ERA16FA063Accident · 2 fatalField investigationFinal reportTimothy C Williams CCK-1865 · Linesville, PAThe noninstrument-rated pilot's improper decision to attempt a flight under visual flight rules at night in instrument meteorological conditions to an unlit airstrip, which resulted in controlled flight into terrain.Dec 7, 2015 · N541TC · Substantial damageNTSB CEN16LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Angleton, TXA loss of control while hovering for reasons that could not be determined, because postaccident examination revealed no mechanical anomalies or failures that would have precluded normal operation.Dec 7, 2015 · N607BP · Substantial damageNTSB CEN16FA054Accident · 2 fatalField investigationFinal reportCessna 140 · Keytesville, MOThe non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…Dec 7, 2015 · N90123 · Substantial damageNTSB WPR16FA035Accident · 2 fatalField investigationFinal reportAero Vodochody L 39C · Apple Valley, CAA total loss of engine power on takeoff, which resulted from a sudden over-temperature condition due to an improperly adjusted fuel control unit and the deteriorated condition of the fuel nozzles.Dec 6, 2015 · N39AY · DestroyedNTSB GAA16CA068Accident · No injuriesData collectionFinal reportAviat A-1C · Hurtsboro, ALThe pilot's incorrect use of brake pressure during the landing roll, which resulted in a nose over.Dec 6, 2015 · N76WY · Substantial damageNTSB CEN16LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Pontiac, MIThe pilot’s operation of the airplane below the glideslope and off course during a night, instrument approach, which resulted in a collision with trees and terrain.Dec 6, 2015 · N47480 · Substantial damageNTSB CEN16FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Pattonsburg, MOThe pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.Dec 6, 2015 · N8777T · DestroyedNTSB ERA16LA062Accident · No injuriesLimited investigationFinal reportBeech D35 · Vine Grove, KYThe pilot’s failure to ensure that the fuel selector was properly positioned before takeoff, which resulted in the subsequent total loss of engine power due to fuel starvation.Dec 4, 2015 · N2991B · Substantial damageNTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.Dec 3, 2015 · N5185D · Substantial damageNTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…Dec 3, 2015 · N546C · Substantial damageNTSB ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…Dec 3, 2015 · N216PK · Substantial damageNTSB GAA16CA070Accident · Minor injuriesData collectionFinal reportStinson 108 · Sharon, KSThe pilot's decision to continue the unstabilized approach and landing and his delayed decision to go around with an insufficient climb rate, which resulted with collision with trees.Dec 2, 2015 · N97537 · Substantial damageNTSB GAA16CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5 · West Point, VAThe pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.Dec 2, 2015 · N28295 · Substantial damageNTSB ERA16LA055Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Venice, FLThe flight instructor's failure to maintain control of the helicopter during an autorotation, which resulted in a hard landing.Dec 1, 2015 · N8560M · Substantial damageNTSB ERA16LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Opa Locka, FLMaintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.Dec 1, 2015 · N5568J · Substantial damageNTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.Nov 29, 2015 · N99210 · Substantial damageNTSB GAA16CA081Accident · No injuriesData collectionFinal reportCessna 182 · Salisbury, NCThe pilot's failure to maintain pitch control during the landing flare, causing the airplane to balloon and land hard.Nov 28, 2015 · N2000R · Substantial damageNTSB GAA16CA072Accident · No injuriesData collectionFinal reportSkaggs Ronnie Lynn Rans S6S · Oldtown, MDThe pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain.Nov 27, 2015 · N531VS · Substantial damageNTSB ERA16CA057Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Farmington, DEBoth pilots' failure to maintain visual separation during landing at an uncontrolled airport. Contributing to the accident was the Mooney pilot's lack of prompt evasive action once the biplane had been spotted on the same runway. In addition, the biplane…Nov 27, 2015 · N53488 · 2 aircraft · Substantial damageNTSB ANC16CA009Accident · No injuriesData collectionFinal reportCessna 172 · Manley Hot Springs, AKThe pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.Nov 27, 2015 · N7176A · Substantial damageNTSB WPR16LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Wickenburg, AZA partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.Nov 25, 2015 · N7PM · Substantial damageNTSB GAA16CA064Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe student pilot's improper flare during landing, which resulted in a bounced landing, and a runway excursion.Nov 24, 2015 · N52632 · Substantial damageNTSB GAA16CA063Accident · No injuriesData collectionFinal reportCessna 182D · Hamlet, NEThe student pilot's incorrect brake application which resulted in a runway excursion and a nose over.Nov 24, 2015 · N8983X · Substantial damageNTSB GAA16CA061Accident · No injuriesData collectionFinal reportMelvin K Callen Backcountry Supercub · Fort Morgan, COThe pilot's excessive braking during the landing roll, which resulted in a nose over.Nov 24, 2015 · N842MC · Substantial damageNTSB ERA16LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Lawrenceville, GAThe flight instructor's inadequate fuel management, which resulted in a total loss of engine power during initial climb due to fuel starvation and a subsequent forced landing.Nov 24, 2015 · N3971R · Substantial damageNTSB ERA16CA056Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Danbury, CTThe pilot's failure to maintain adequate clearance from obstructions while on approach to landing.Nov 24, 2015 · N771BT · Substantial damageNTSB GAA16CA111Accident · No injuriesData collectionFinal reportCessna 172 · Covington, TNThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, ground loop, and impact with the ground.Nov 22, 2015 · N5786R · Substantial damageNTSB GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.Nov 22, 2015 · N12WB · Substantial damageNTSB ERA16LA052Accident · No injuriesLimited investigationFinal reportBeech 95 B55 · Albany, NYThe pilot’s failure to maintain a proper flare while landing in gusting crosswind conditions, which resulted in a hard landing, overstress fracture of the nose landing gear trunnion, and a subsequent nose landing gear collapse.Nov 22, 2015 · N600VP · Substantial damageNTSB ERA16FA043Accident · 2 fatalField investigationFinal reportBeech A36TC · Orlando, FLThe pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…Nov 20, 2015 · N7FG · DestroyedNTSB CEN16CA070Accident · No injuriesData collectionFinal reportCessna 172 · Rush City, MNThe student pilot did not maintain directional control of the airplane and applied excessive right rudder during landing.Nov 20, 2015 · N1180U · Substantial damageNTSB WPR16FA029Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350B3E · Carlsbad, CAThe pilot's loss of control during landing on a dolly. Contributing to the accident were the pilot's decision to conduct the flight without an instructor despite multiple flight instructors' recommendations to the contrary, his failure to land on the ramp…Nov 19, 2015 · N711BE · Substantial damageNTSB GAA16CA054Accident · No injuriesData collectionFinal reportAeronca 7AC · Fowlerville, MIThe pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.Nov 17, 2015 · N84157 · Substantial damageNTSB GAA16CA051Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Portland, ORThe failure of the fuel truck driver to see and avoid the taxiing airplane.Nov 17, 2015 · N555RG · Substantial damageNTSB GAA16CA059Accident · No injuriesData collectionFinal reportCessna 172R · Westminster, MDThe student pilot's failure to maintain pitch control during the landing, which resulted in a hard landing.Nov 16, 2015 · N26499 · Substantial damageNTSB GAA16CA057Accident · No injuriesData collectionFinal reportChampion 7ECA · Eufaula, ALThe student pilot's decision to land with a quartering tailwind, resulting in a loss off directional control, excessive brake application, and a nose over.Nov 16, 2015 · N9649S · Substantial damageNTSB CEN16LA047Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Goshen, INThe failure of the Thomas coupling at the interface with the main gear box tail rotor output shaft, which resulted in the helicopter's loss of tail rotor control.Nov 16, 2015 · N88HA · Substantial damageNTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Nov 16, 2015 · N2440R · Destroyed