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 WPR18FA091Accident · 1 fatalField investigationFinal reportPiper PA34 · Minden, NVThe pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.Feb 19, 2018 · N14GQ · DestroyedNTSB GAA18CA144Accident · No injuriesData collectionFinal reportPiper PA 22 · Ashland, OHThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.Feb 18, 2018 · N6157D · Substantial damageNTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.Feb 18, 2018 · N700VX · DestroyedNTSB GAA18CA139Accident · No injuriesData collectionFinal reportCessna 402 · Mount Sterling, KYThe pilot’s failure to maintain directional control during the landing roll on a wet surface.Feb 17, 2018 · N402MY · Substantial damageNTSB GAA18CA136Accident · No injuriesData collectionFinal reportCessna 180 · Big Lake, AKThe pilot’s selection of unsuitable terrain for landing, which led to both skis breaking through the ice while positioning the airplane after landing.Feb 17, 2018 · N2934A · Substantial damageNTSB GAA18CA148Accident · No injuriesData collectionFinal reportHarris Pierce Velocity XL RG · Locust Grove, GAThe pilot’s failure to extend the landing gear due to his distraction by talking on the radio, which resulted in a gear-up landing.Feb 16, 2018 · N551ZL · Substantial damageNTSB CEN18LA102Accident · Serious injuriesLimited investigationFinal reportScheineman-Van Buren T 18 · Longmont, COThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a groundloop and nose over.Feb 16, 2018 · N89ER · Substantial damageNTSB GAA18LA131Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Charleston, SCThe flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.Feb 14, 2018 · N337H · Substantial damageNTSB GAA18CA130Accident · No injuriesData collectionFinal reportPiper PA 16 · Phoenix, AZThe pilot’s failure to maintain directional control while landing in crosswind conditions.Feb 13, 2018 · N5726H · Substantial damageNTSB GAA18CA129Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wadsworth, TXThe passenger’s gun becoming lodged in the flight controls during takeoff and his failure to remove it, which resulted in impact with terrain.Feb 13, 2018 · N843SH · Substantial damageNTSB CEN18LA106Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stockbridge, MIThe pilot’s failure to maintain adequate clearance from terrain while maneuvering the helicopter at a low altitude after departure. Contributing to the accident were the pilot’s distraction by the smoke in the cabin and the limited visible features in the…Feb 13, 2018 · N471RA · Substantial damageNTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.Feb 13, 2018 · N123JN · DestroyedNTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.Feb 12, 2018 · N118MF · Substantial damageNTSB GAA18CA127Accident · No injuriesData collectionFinal reportHughes 369 · Heber City, UTThe pilot’s failure to maintain clearance from an elk while maneuvering at a low altitude.Feb 12, 2018 · N338HW · Substantial damageNTSB WPR18MA087Accident · 5 fatalClass 3 · MajorFinal reportEurocopter EC130 · Peach Springs, AZA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.Feb 11, 2018 · N155GC · DestroyedNTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…Feb 11, 2018 · N52TH · Substantial damageNTSB GAA18CA235Accident · No injuriesData collectionFinal reportCessna 150 · Statesville, NCThe pilot’s failure to maintain crosswind correction during landing and the flight instructor’s delayed remedial action. Contributing to the accident was the pilot’s and flight instructor’s decision to land with gusting tailwinds.Feb 11, 2018 · N23398 · Substantial damageNTSB GAA18CA126Accident · No injuriesData collectionFinal reportCessna 180 · Nenana, AKThe pilot’s failure to maintain an adequate approach path to an unimproved airstrip, which resulted in a hard landing short of the airstrip.Feb 11, 2018 · N2347C · Substantial damageNTSB GAA18CA123Accident · No injuriesData collectionFinal reportOliver Lawrence R Kitfox IV 1200 · Carson City, NVThe flight instructor’s failure to maintain directional control during the landing roll and lateral control during the go-around in gusting crosswind conditions. Contributing to the accident was the lack of communication between the flight instructor and the…Feb 11, 2018 · N76478 · Substantial damageNTSB GAA18CA132Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Carson City, NVThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 10, 2018 · N88ZQ · Substantial damageNTSB GAA18CA125Accident · Serious injuriesData collectionFinal reportBaker Victor R Kitfox · Carson City, NVThe pilot-receiving-instruction’s failure to maintain directional control during takeoff.Feb 9, 2018 · N377KJ · Substantial damageNTSB GAA18CA182Accident · No injuriesData collectionFinal reportHeinlein George GH125 · Valkaria, FLThe pilot’s decision to exit the paved runway into soft terrain, which resulted in a ground loop and landing gear collapse.Feb 8, 2018 · N79GH · Substantial damageNTSB CEN18LA097Accident · No injuriesLimited investigationFinal reportPiper PA 24-260 · Fargo, NDThe pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…Feb 8, 2018 · N9360P · Substantial damageNTSB CEN18LA095Accident · Serious injuriesLimited investigationFinal reportHenderson Thorp T 18 · Troy, MOThe pilot's failure to maintain adequate clearance from trees while landing in crosswind conditions.Feb 8, 2018 · N600HH · Substantial damageNTSB CEN18LA092Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Centralia, ILThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.Feb 8, 2018 · N1409U · Substantial damageNTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.Feb 7, 2018 · N925JH · Substantial damageNTSB WPR18FA084Accident · 2 fatalField investigationFinal reportCessna 182T · Santee, CAThe pilot's decision to take off into instrument meteorological conditions that resulted in spatial disorientation, and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Feb 6, 2018 · N3525T · Substantial damageNTSB CEN18LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Patterson, LAThe pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion.Feb 6, 2018 · N9148B · Substantial damageNTSB GAA18CA121Accident · No injuriesData collectionFinal reportPiper PA28 · Metter, GAThe student pilot’s failure to maintain directional control during landing.Feb 5, 2018 · N8475W · Substantial damageNTSB GAA18CA119Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.Feb 5, 2018 · N271BJ · Substantial damageNTSB GAA18CA118Accident · No injuriesData collectionFinal reportSomerton David J JA30 Superstol · Kerrville, TXThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 5, 2018 · N726AD · Substantial damageNTSB ERA18LA083Accident · 1 fatalLimited investigationFinal reportGregory Newman Sonex Trainer · Carrabelle, FLA loss of engine power for reasons that could not be determined because the airplane was not recovered. Also causal was the pilot's decision to conduct a low-altitude turn following the loss of engine power, which resulted in an exceedance of the airplane's…Feb 5, 2018 · N543SX · Substantial damageNTSB CEN18LA094Accident · No injuriesLimited investigationFinal reportRaytheon 400A · Cleveland, OHThe airplane's reduced braking performance due to an ice-covered runway, which resulted in a runway excursion. Contributing to the accident was the crew's selection of a runway with a tailwind.Feb 5, 2018 · N570TM · Substantial damageNTSB GAA18CA134Accident · No injuriesData collectionFinal reportCessna T303 · Great Barrington, MAThe pilot’s failure to see the taxiway when returning to the ramp from the snow-covered runway, which resulted in the airplane rolling down an embankment.Feb 4, 2018 · N303TL · Substantial damageNTSB GAA18CA124Accident · No injuriesData collectionFinal reportCessna 150 · El Dorado, KSThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport landing and nose-over.Feb 4, 2018 · N61024 · Substantial damageNTSB WPR18LA082Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · North Las Vegas, NVLoss of aircraft control during an unplanned go-around for reasons that could not be determined based on available information. Contributing to the accident was the delayed remedial action by the flight instructor.Feb 2, 2018 · N128W · Substantial damageNTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.Feb 2, 2018 · N519AC · Substantial damageNTSB GAA18CA117Accident · No injuriesData collectionFinal reportHughes Helicopters 369 · Wrightwood, CAThe pilot’s high altitude, high gross weight landing with insufficient tail rotor thrust resulting in a loss of tail rotor effectiveness.Feb 1, 2018 · N618SG · Substantial damageNTSB WPR18FA077Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Newport Beach, CAThe pilot's failure to perform weight and balance calculations before departing on the flight, which resulted in his operation of the helicopter outside of its published weight and balance limitations and a subsequent loss of control shortly after takeoff.Jan 30, 2018 · N7530R · DestroyedNTSB ANC18FA022Accident · 1 fatalField investigationFinal reportBeech 35 A33 · Helenwood, TNThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow the air start checklist.Jan 30, 2018 · N9378Y · Substantial damageNTSB WPR18FA075Accident · 1 fatalField investigationFinal reportCessna 152 · Concord, CAA loss of control for reasons that could not be determined based on the available information.Jan 29, 2018 · N93316 · Substantial damageNTSB GAA18CA114Accident · No injuriesData collectionFinal reportWayne Miller Sport Copter II · Van Nuys, CAThe pilot’s decision to takeoff in gusting wind conditions with insufficient rotor rpm.Jan 29, 2018 · N767LW · Substantial damageNTSB ERA18LA075Accident · No injuriesLimited investigationFinal reportBell OH 58C · Zebulon, GAThe pilot's failure to fully open the throttle before initiating the power recovery in response to a simulated engine failure.Jan 29, 2018 · N942SC · Substantial damageNTSB GAA18CA113Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Homstead, FLThe pilot’s diverted attention to his phone while maneuvering at a low altitude, which resulted in collision with terrain.Jan 28, 2018 · N127AG · Substantial damageNTSB ERA18IA078Incident · No injuriesClass 3 · IncidentFinal reportAirbus Helicopters EC 130 · Memphis, TNThe pilot’s failure to lock the collective pitch control after landing, and the mechanic’s failure to properly balance the collective pitch control after converting the helicopter to a single-pilot configuration, which resulted in an uncommanded collective…Jan 28, 2018 · N894GT · Minor damageNTSB WPR18FA074Accident · 1 fatalField investigationFinal reportHughes 369D · Pomeroy, WAA loss of control following the gunner's failure to ensure that the net maintained clearance from the tail rotor.Jan 27, 2018 · N369TH · Substantial damageNTSB ERA18LA073Accident · No injuriesLimited investigationFinal reportAero Commander 680 F · Lapine, ALThe pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…Jan 27, 2018 · N900L · Substantial damageNTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Jan 27, 2018 · N9673W · Substantial damageNTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.Jan 27, 2018 · N8559U · DestroyedNTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.Jan 26, 2018 · N1046F · Substantial damage