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 GAA19CA560Accident · No injuriesData collectionFinal reportThomas Lee Nieuport 11 · Rose Hill, KSThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and an impact with runway lights.Sep 23, 2019 · N1398 · Substantial damageNTSB ERA19TA277Accident · Serious injuriesClass 3Final reportVans RV 6 · Lakeland, FLThe pilot’s inability to maintain control due to passenger interference.Sep 23, 2019 · N12033 · Substantial damageNTSB ANC19LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Beluga, AKThe pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.Sep 23, 2019 · N7071B · Substantial damageNTSB GAA19CA563Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Mountain Village, AKThe pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…Sep 22, 2019 · N77KZ · Substantial damageNTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.Sep 21, 2019 · C-GOZJ · DestroyedNTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.Sep 20, 2019 · N212DX · Substantial damageNTSB GAA19CA562Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 MK.1 · Kotzebue, AKThe pilot's delayed decision to abort the takeoff from water after the airplane impacted a submerged object, which resulted in insufficient airspeed for liftoff and led to the pilot steering the airplane toward a mud embankment to avoid rocks.Sep 20, 2019 · N67112 · Substantial damageNTSB GAA19CA559Accident · No injuriesData collectionFinal reportPiper PA60 · Sedona, AZThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.Sep 20, 2019 · N700NJ · Substantial damageNTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.Sep 20, 2019 · N895SF · Substantial damageNTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.Sep 19, 2019 · N1891X · DestroyedNTSB WPR19FA262Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Torrance, CAThe pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.Sep 19, 2019 · N2323Y · DestroyedNTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Sep 18, 2019 · N93069 · Substantial damageNTSB CEN19TA335Accident · Minor injuriesClass 3Final reportVans RV 4 · De Soto, MSA total loss of engine power due to fuel exhaustion.Sep 18, 2019 · N64HS · Substantial damageNTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.Sep 18, 2019 · N5438U · DestroyedNTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.Sep 17, 2019 · N6741L · Substantial damageNTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.Sep 17, 2019 · N472TC · Substantial damageNTSB GAA19CA552Accident · No injuriesData collectionFinal reportMaule M 6-235 · Palmer, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain directional control during the landing, which resulted in the airplane hitting a rut, bouncing, and then nosing over.Sep 17, 2019 · N88DK · Substantial damageNTSB ERA19LA273Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sardis, GAFatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.Sep 17, 2019 · N827JE · Substantial damageNTSB ERA19FA275Accident · 2 fatalClass 3 · FieldFinal reportVans RV 8 · Stroudsburg, PAThe pilot's failure to maintain control of the airplane for undetermined reasons.Sep 17, 2019 · N7TL · DestroyedNTSB GAA19CA554Accident · No injuriesData collectionFinal reportPiper PA32R · Owasso, OKThe pilot's improper altitude and airspeed control during landing, which resulted in the airplane landing long and a subsequent runway overrun and impact with a drainage culvert.Sep 16, 2019 · N6887J · Substantial damageNTSB GAA19CA550Accident · No injuriesData collectionFinal reportPzl Okecie PZL104 · Reno, NVThe pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain.Sep 16, 2019 · N123T · Substantial damageNTSB GAA19CA555Accident · Serious injuriesData collectionFinal reportCessna 175 · Toklat, AKThe pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.Sep 15, 2019 · N6837E · Substantial damageNTSB GAA19CA551Accident · No injuriesData collectionFinal reportPiper PA 12 · Healy, AKThe pilot's exceedance of the airplane's critical angle of attack while taking off from water in shifting wind conditions.Sep 15, 2019 · N4315M · Substantial damageNTSB GAA19CA549Accident · No injuriesData collectionFinal reportCessna L19 · Kennett, MOThe pilot's failure to install the engine oil filler cap before the first flight of the day; his subsequent failure to conduct a preflight check before the accident flight, which resulted in his failure to note that the cap was not installed; and his improper…Sep 15, 2019 · N4584N · Substantial damageNTSB ERA19LA272Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA40 · Norfolk, VAA partial loss of engine power due to the mechanic's failure to properly tighten the two clamps securing the flexible coupling from the intercooler to the induction inlet.Sep 15, 2019 · N292RA · Substantial damageNTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.Sep 14, 2019 · N1085W · Substantial damageNTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.Sep 13, 2019 · N4746F · Substantial damageNTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.Sep 13, 2019 · N854T · Substantial damageNTSB CEN19LA320Accident · Minor injuriesClass 2 · LimitedFinal reportCirrus SR22 · Hoagland, INA catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance…Sep 13, 2019 · N578SP · Substantial damageNTSB WPR19LA257Accident · Serious injuriesClass 3 · LimitedFinal reportKubicek BB60 · Goodsprings, NVThe pilot's failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injuries to the pilot and two passengers.Sep 12, 2019 · N505CZ · Substantial damageNTSB GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.Sep 12, 2019 · N5229F · Substantial damageNTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.Sep 12, 2019 · N21979 · Substantial damageNTSB GAA19CA542Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's failure to maintain directional control during an aborted takeoff, which resulted in a runway excursion and impact with runway signs while attempting to maneuver back onto the runway.Sep 12, 2019 · N796WW · Substantial damageNTSB ERA19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Bowie, MDA blockage of the pitot static system that preclude the airspeed indicator from displaying speeds greater than 40 mph, which led the pilot to abort the landing and overrun the runway.Sep 12, 2019 · N202JB · Substantial damageNTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.Sep 12, 2019 · N6035L · Substantial damageNTSB GAA19CA596Accident · No injuriesData collectionFinal reportPitts S1 · Reno, NVThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.Sep 11, 2019 · N515JD · Substantial damageNTSB GAA19CA581Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, which resulted in a hard landing and a collapsed nose landing gear.Sep 11, 2019 · N904WA · Substantial damageNTSB DCA19CA223Accident · No injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Chicago OHare, ILthe tug driver's inability to maintain visual contact with the wing walkers and lack of situational awareness during pushback.Sep 11, 2019 · N710SK · 2 aircraft · Substantial damageNTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.Sep 11, 2019 · N24DR · DestroyedNTSB CEN19LA317Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Boca Raton, FLThe total loss of engine power for reasons that could not be determined based on available evidence and the pilot’s decision to take off without fully troubleshooting the partial loss of engine power that occurred during the previous flight.Sep 11, 2019 · N2890T · DestroyedNTSB CEN19LA314Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Colorado Springs, COThe pilot's improper taxi speed and his excessive use of brakes, which resulted in a brake fire and substantial thermal damage to the airplane.Sep 11, 2019 · N8384E · Substantial damageNTSB WPR19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Maricopa, AZThe flight instructor’s failure to prevent the student pilot from exceeding the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the student pilot’s failure to make a positive…Sep 10, 2019 · N3816H · Substantial damageNTSB ERA19TA276Accident · No injuriesClass 3Final reportBeech 23 · Panama City, FLA total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.Sep 10, 2019 · N3555R · Substantial damageNTSB CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.Sep 10, 2019 · N5347T · Substantial damageNTSB GAA19CA585Accident · No injuriesData collectionFinal reportBeech 23 · Keystone Heights, FLThe pilot's failure to maintain clearance from a construction sign during taxi operations.Sep 9, 2019 · N6009U · Substantial damageNTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Sep 8, 2019 · N6300Z · DestroyedNTSB WPR19FA252Accident · 2 fatalClass 3 · FieldFinal reportBeech C24 · Las Vegas, NVThe pilot’s operation of the airplane over its maximum gross weight and outside of center of gravity limits at a high-density altitude, which resulted in the exceedance of the airplane's critical angle of attack while maneuvering and subsequent aerodynamic…Sep 8, 2019 · N24030 · DestroyedNTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.Sep 8, 2019 · N602SS · Substantial damageNTSB GAA19CA529Accident · No injuriesData collectionFinal reportCessna 172 · Mekoryuk, AKThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting wind conditions.Sep 8, 2019 · N737NJ · Substantial damageNTSB ERA19FA266Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.Sep 8, 2019 · N9436X · Substantial damage