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 GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.Aug 17, 2017 · N687BP · Substantial damageNTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.Aug 17, 2017 · N48TZ · Substantial damageNTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.Aug 17, 2017 · N32LF · Substantial damageNTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.Aug 16, 2017 · N6082B · Substantial damageNTSB ERA17LA277Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Canton, GAMaintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.Aug 15, 2017 · N2804T · Substantial damageNTSB DCA17CA181Accident · No injuriesData collectionFinal reportBoeing 737 832 · Queens, NYthe Delta B737 captain's failure to maintain proper clearance between his airplane and the stopped American B757.Aug 15, 2017 · N377DA · 2 aircraft · Minor damageNTSB GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.Aug 14, 2017 · N97UP · Substantial damageNTSB GAA17CA487Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's failure to maintain directional control during landing.Aug 14, 2017 · N915PA · Substantial damageNTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.Aug 13, 2017 · N305EF · Substantial damageNTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.Aug 13, 2017 · N98550 · Substantial damageNTSB GAA17CA492Accident · Minor injuriesData collectionFinal reportCessna 182 · Quitman, MSThe student pilot’s failure to maintain directional control during takeoff in gusting wind conditions after passing a large hill.Aug 12, 2017 · N147DD · Substantial damageNTSB GAA17CA488Accident · Minor injuriesData collectionFinal reportCharles D Walker Walker Curtiss JN4D · Bowling Green, KYThe pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.Aug 12, 2017 · N8262 · Substantial damageNTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.Aug 12, 2017 · N52450 · Substantial damageNTSB ERA17FA274Accident · 2 fatalField investigationFinal reportBell 407 · Charlottesville, VAThe pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…Aug 12, 2017 · N31VA · DestroyedNTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.Aug 12, 2017 · N243CC · Substantial damageNTSB WPR17LA183Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 28R-200 · West Jordan, UTThe pilot's failure to account for operation at high density altitude at or near the airplane’s maximum gross weight, which led to degraded engine performance and prevented the airplane from achieving an adequate airspeed for a positive rate of climb,…Aug 11, 2017 · N33732 · Substantial damageNTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.Aug 11, 2017 · N4189V · Substantial damageNTSB ERA17FA272Accident · 1 fatalField investigationFinal reportCessna 172 · New Milford, CTThe flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.Aug 11, 2017 · N1727V · Substantial damageNTSB CEN17LA316Accident · Serious injuriesLimited investigationFinal reportNavion Navion G · Adrian, MIA leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.Aug 11, 2017 · N249KC · Substantial damageNTSB GAA17CA484Accident · No injuriesData collectionFinal reportConstrucciones Aeronauticas C.A.S.A. 1.131 · Ocean City, NJThe pilot’s failure to maintain directional control during the landing roll.Aug 10, 2017 · N211BP · Substantial damageNTSB ERA17LA324Accident · No injuriesLimited investigationFinal reportCessna 195 · Newman, GAThe improper rigging of the tailwheel assembly, which resulted in a loss of directional control during takeoff. Contributing to accident was the pilot’s decision to operate the airplane despite knowing it required excessive right rudder inputs for it to move…Aug 10, 2017 · N2100C · Substantial damageNTSB CEN17LA359Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Raton, NMThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.Aug 10, 2017 · N702N · Substantial damageNTSB CEN17LA314Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Villa Grove, COThe pilot’s failure to maintain main rotor clearance from a power line tower during low-level maneuvering.Aug 10, 2017 · N58424 · Substantial damageNTSB GAA17CA506Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe pilot receiving instruction’s failure to maintain directional control during landing.Aug 9, 2017 · N6048H · Substantial damageNTSB GAA17CA483Accident · No injuriesData collectionFinal reportRockwell International 114 · Cairo, ILThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing and a runway overrun.Aug 9, 2017 · N4986S · Substantial damageNTSB ERA17LA269Accident · Serious injuriesLimited investigationFinal reportRose Herbert D Pietenpol AIR Camper · Tower City, PAThe pilot's incapacitation due to fainting as a result of complications from a previously undiagnosed heart condition.Aug 9, 2017 · N709HR · Substantial damageNTSB CEN17LA309Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Galesburg, ILA total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…Aug 9, 2017 · N528MB · Substantial damageNTSB CEN17LA307Accident · 2 fatalLimited investigationFinal reportPegasus Quantum · Fort Atkinson, WIThe student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.Aug 9, 2017 · N56092 · Substantial damageNTSB CEN17FA315Accident · 1 fatalField investigationFinal reportPiper PA 22-150 · Las Vegas, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to land, which resulted in an accelerated stall and the pilot’s subsequent loss of control. Contributing to the accident was the gap in the pilot’s flight experience, his…Aug 9, 2017 · N3664Z · Substantial damageNTSB GAA17CA478Accident · No injuriesData collectionFinal reportKing John E JR Kitfox · Reno, NVThe pilot’s failure to maintain directional control during landing in variable wind conditions.Aug 8, 2017 · N993JK · Substantial damageNTSB WPR17LA180Accident · No injuriesLimited investigationFinal reportLockheed P2V 5F · Pocatello, IDMaintenance personnel's failure to secure hardware, which resulted in an uncommanded upward deflection of the left elevator and aft movement of the control yoke and inhibited the flight crew from adjusting the airplane's pitch attitude in flight. Contributing…Aug 6, 2017 · N410NA · Substantial damageNTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…Aug 6, 2017 · N56884 · Substantial damageNTSB ERA17FA265Accident · 1 fatalField investigationFinal reportNorth Wing Freedom · Green Township, NJThe pilot's improper preflight setup of the aircraft's foldable wing, during which he incorrectly attached a nylon strap loop pull handle, instead of the steel cable shackle at the end of the strap, to its mounting hook. The nylon strap failed in flight,…Aug 6, 2017 · N2854L · Substantial damageNTSB CEN17LA304Accident · Serious injuriesLimited investigationFinal reportRoger M Allen RA2 · Hector, MNThe pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight.Aug 6, 2017 · N952RA · Substantial damageNTSB GAA17CA476Accident · No injuriesData collectionFinal reportCessna 172 · Drexel, MOThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Aug 5, 2017 · N8226U · Substantial damageNTSB GAA17CA471Accident · No injuriesData collectionFinal reportChampion 7ACA · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s use of excessive braking, which led to a nose-over.Aug 5, 2017 · N1227G · Substantial damageNTSB CEN17LA305Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OHThe pilot’s failure to follow the before takeoff checklist, which resulted in an improper takeoff configuration and subsequent uncontrolled descent into terrain during a departure climb.Aug 5, 2017 · N102BK · Substantial damageNTSB ANC17LA042Accident · No injuriesLimited investigationFinal reportBeech 19A · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the right main landing (MLG) tire impacting a rock and the subsequent loss of directional control and collapse of the right MLG.Aug 5, 2017 · N6523T · Substantial damageNTSB WPR17LA181Accident · Serious injuriesLimited investigationFinal reportRans S9 · Athol, IDThe pilot's loss of pitch attitude and ground proximity awareness, which resulted in an unintentionally steep initial climb and an overcorrection into a steep descent and ground impact.Aug 4, 2017 · N519TB · Substantial damageNTSB GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.Aug 4, 2017 · N9829B · Substantial damageNTSB GAA17CA475Accident · No injuriesData collectionFinal reportCessna 180 · Willow, AKThe pilot’s improper landing flare while landing on water with glassy water conditions, which resulted in the airplane nosing over.Aug 4, 2017 · N5236D · Substantial damageNTSB GAA17CA468Accident · Serious injuriesData collectionFinal reportCessna 170 · Moab, UTThe pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.Aug 4, 2017 · N1214D · Substantial damageNTSB GAA17CA465Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCThe physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.Aug 4, 2017 · N777NG · Substantial damageNTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…Aug 4, 2017 · N3047J · Substantial damageNTSB ERA17LA270Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Immokalee, FLThe pilot's failure to attain adequate airspeed during an attempted go-around, which resulted in an aerodynamic stall.Aug 3, 2017 · N811AW · Substantial damageNTSB CEN17LA302Accident · Minor injuriesLimited investigationFinal reportJames F Hake MTO Sport · Mentone, INThe pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.Aug 3, 2017 · N571UJ · Substantial damageNTSB CEN17LA301Accident · No injuriesLimited investigationFinal reportBeech D17S · Colorado Springs, COThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.Aug 3, 2017 · N44562 · Substantial damageNTSB ANC17LA040Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Solomon, AKThe pilot's failure to maintain adequate altitude above water, and his loss of situational awareness, which resulted in an inadvertent descent and collision with water.Aug 3, 2017 · N4138M · Substantial damageNTSB ANC17CA041Accident · No injuriesData collectionFinal reportAirbus AS350 · Delta Junction, AKThe pilot’s failure to maintain clearance from a steel frame attached to a tracked drilling unit. Contributing to the accident was the pilot’s failure to visually identify the steel frame during the reconnaissance process.Aug 3, 2017 · N351SH · Substantial damageNTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.Aug 2, 2017 · N91966 · Substantial damage