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 WPR17LA193Accident · No injuriesLimited investigationFinal reportCessna 140 · Empire, NVThe pilot's failure to maintain directional control during an off-airport precautionary landing on a dirt road with an uphill gradient.Aug 30, 2017 · N140X · Substantial damageNTSB GAA17CA576Accident · Minor injuriesData collectionFinal reportHunter George RV 6 · Montgomery, NYThe pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights.Aug 30, 2017 · N6GH · Substantial damageNTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.Aug 30, 2017 · N2982U · Substantial damageNTSB ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 30, 2017 · N8866L · Substantial damageNTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…Aug 29, 2017 · N339Z · Substantial damageNTSB WPR17IA189Incident · No injuriesClass 3 · IncidentFinal reportCessna 560XL · San Jose, CAThe mechanic’s incorrect installation of the right main landing gear (MLG) aft trunnion pivot pin, which resulted in the pin separating from the trunnion, the trunnion puncturing the right wing, and the right MLG collapsing.Aug 29, 2017 · N503UP · Minor damageNTSB GAA17CA514Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Sacramento, CAThe student pilot’s failure to maintain yaw control and the flight instructor’s delayed remedial action.Aug 29, 2017 · N622MP · Substantial damageNTSB GAA17CA512Accident · No injuriesData collectionFinal reportAviat A 1 · Cody, WYThe pilot’s failure to maintain directional control during the landing roll.Aug 28, 2017 · N335SB · Substantial damageNTSB ERA17LA302Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Harvest, ALThe pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 28, 2017 · N750UP · Substantial damageNTSB CEN17LA333Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA 5B · Carbondale, ILThe failure of the propeller due to fatigue as a result of improper installation by unknown maintenance personnel at some point during the life of the propeller.Aug 28, 2017 · N28005 · Substantial damageNTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.Aug 28, 2017 · N180LP · Substantial damageNTSB CEN17FA331Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Ellabell, GAThe total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…Aug 28, 2017 · N87RY · DestroyedNTSB GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.Aug 27, 2017 · N36KC · Substantial damageNTSB GAA17CA519Accident · No injuriesData collectionFinal reportPiper J5A · Springfield, VTThe pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.Aug 27, 2017 · N30897 · Substantial damageNTSB ERA17LA297Accident · 1 fatalLimited investigationFinal reportTukan Trike · Nicholasville, KYThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during takeoff.Aug 27, 2017 · UNREG · Substantial damageNTSB WPR17LA188Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · El Dorado Hills, CAMaintenance personnel's inadequate routine maintenance on the helicopter engine, which led to low cylinder compression, improper magneto timing, and camshaft lobe wear, which subsequently resulted in degraded engine performance.Aug 26, 2017 · N61NM · Substantial damageNTSB GAA17CA511Accident · No injuriesData collectionFinal reportPiper PA 12 · Gulkana, AKThe pilot’s inadequate in-flight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 26, 2017 · N3233M · Substantial damageNTSB ERA17CA295Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Palatka, FLThe student pilot's overpriming of the engine and the flight instructor's delayed remedial action, which resulted in an engine fire.Aug 25, 2017 · N84175 · Substantial damageNTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.Aug 24, 2017 · N6447M · Substantial damageNTSB GAA17CA509Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bremerton, WAThe student pilot’s improper bank control during takeoff, which resulted in a dynamic rollover.Aug 24, 2017 · N7198J · Substantial damageNTSB GAA17CA507Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Hillsboro, ORThe student pilot’s failure to maintain airplane control while landing in crosswind conditions and the flight instructor’s delayed remedial action.Aug 24, 2017 · N599CC · Substantial damageNTSB ANC17FA049Accident · 1 fatalField investigationFinal reportPiper PA-18AS · Tyonek, AKThe noninstrument-rated pilot's decision to initiate a visual flight rules flight into dark night, marginal visual flight rules to instrument flight rules conditions, which resulted in a loss of control due to spatial disorientation.Aug 24, 2017 · N1905A · DestroyedNTSB GAA17CA537Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Foley, ALThe ground crew’s incorrect hook up of the banner, which resulted in a nose-over.Aug 23, 2017 · N181TM · Substantial damageNTSB ERA17LA319Accident · No injuriesLimited investigationFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper landing flare, which resulted in a hard landing.Aug 23, 2017 · N97116 · Substantial damageNTSB WPR17LA186Accident · Minor injuriesLimited investigationFinal reportHawker Siddeley Hunter MK.58 · Pacific Ocean (Pacific Ocean)The pilot’s loss of airplane control after flying through another airplane's jet wash during an air defense exercise.Aug 22, 2017 · N338AX · DestroyedNTSB GAA17CA508Accident · No injuriesData collectionFinal reportCessna 182 · North Platte, NEThe pilot’s failure to maintain directional control during the landing roll.Aug 22, 2017 · N2465G · Substantial damageNTSB GAA17CA505Accident · No injuriesData collectionFinal reportCessna 177RG · Byron, CAThe pilot’s improper preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 22, 2017 · N8053G · Substantial damageNTSB CEN17LA327Accident · Minor injuriesLimited investigationFinal reportGreene R/Greene S Rans S 17 · Erie, COThe pilot's failure to maintain control following a rejected takeoff for a perceived loss of engine power. Contributing to the accident was the pilot's lack of training and experience in the airplane.Aug 22, 2017 · N117BE · Substantial damageNTSB GAA17CA500Accident · No injuriesData collectionFinal reportBeech C23 · Rexburg, IDThe pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing.Aug 21, 2017 · N6576R · Substantial damageNTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.Aug 21, 2017 · N2486D · Substantial damageNTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.Aug 21, 2017 · N2861K · Substantial damageNTSB ERA17LA293Accident · No injuriesLimited investigationFinal reportCessna 172 · Guntersville, ALThe pilot's failure to maintain directional control on takeoff.Aug 21, 2017 · N73929 · Substantial damageNTSB ERA17LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT 402A · Shaw, MSThe pilot’s decision to attempt takeoff at high gross weight, in high density altitude conditions, and with insufficient runway length. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 21, 2017 · N247LA · Substantial damageNTSB GAA17CA495Accident · No injuriesData collectionFinal reportBell 206 · Minden, NVThe pilot’s failure to maintain helicopter control during landing due to a loss of tail rotor effectiveness.Aug 20, 2017 · N6259C · Substantial damageNTSB ERA17LA285Accident · No injuriesLimited investigationFinal reportBell 47G · St Marys, PAThe student pilot's inadequate prefight planning and en route fuel management, which resulted in fuel exhaustion and a total loss of engine power.Aug 20, 2017 · N9526 · Substantial damageNTSB ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.Aug 20, 2017 · N46286 · Substantial damageNTSB CEN17LA326Accident · No injuriesLimited investigationFinal reportCessna 182 · Booneville, MOThe pilot’s failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion.Aug 20, 2017 · N182DW · Substantial damageNTSB WPR17FA185Accident · 1 fatalField investigationFinal reportRich Wheeler Express CT · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering in the airport traffic pattern for landing, which resulted in an exceedance of the airplane's critical angle of attack, a subsequent aerodynamic stall at an altitude too low to recover.Aug 19, 2017 · N246TM · DestroyedNTSB GAA17CA510Accident · No injuriesData collectionFinal reportLuscombe 8 · Angleton, TXThe pilot’s failure to maintain directional control during landing.Aug 19, 2017 · N71971 · Substantial damageNTSB GAA17CA503Accident · No injuriesData collectionFinal reportPiper PA 28 · Mohave, AZThe pilot’s improper airspeed and pitch control during landing in variable, gusting wind conditions, which resulted in an aerodynamic stall and hard landing.Aug 19, 2017 · N536CA · Substantial damageNTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.Aug 19, 2017 · N136BJ · Substantial damageNTSB GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.Aug 19, 2017 · N7677M · Substantial damageNTSB ERA17LA288Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Marietta, PAThe pilot's failure to maintain directional control during takeoff with a quartering tailwind. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.Aug 19, 2017 · N7108 · Substantial damageNTSB ERA17LA287Accident · No injuriesLimited investigationFinal reportCessna R182 · Clearwater, FLThe improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.Aug 19, 2017 · N9155C · Substantial damageNTSB GAA17CA504Accident · No injuriesData collectionFinal reportBoeing E75 · Centerville, TNThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action.Aug 18, 2017 · N4859N · Substantial damageNTSB ERA17LA280Accident · 1 fatalLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAThe flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.Aug 18, 2017 · N319TA · Substantial damageNTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.Aug 18, 2017 · N82912 · Substantial damageNTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.Aug 18, 2017 · N92DC · Substantial damageNTSB GAA17CA501Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s use of excessive braking during the landing roll, which resulted in a nose-over.Aug 17, 2017 · N7678D · Substantial damageNTSB GAA17CA494Accident · No injuriesData collectionFinal reportAerotechnik L 13 SEH Vivat · Moses Lake, WAThe pilot's improper takeoff configuration due to his failure to follow the pretakeoff checklist, which resulted in a loss of lift and collision with obstacles.Aug 17, 2017 · N8230S · Substantial damage