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 ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.Oct 29, 2023 · N9159W · Substantial damageNTSB ERA24LA029Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Elmira, NYThe pilot’s failure to attain a proper glidepath for a landing on the intended runway, which resulted in an off-airport landing and impact with soft terrain.Oct 28, 2023 · N17903 · Substantial damageNTSB ERA24LA028Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot’s abrupt control input and the flight instructor’s inadequate remedial action, which resulted in a dynamic rollover.Oct 28, 2023 · N964SH · Substantial damageNTSB ERA24LA027Accident · No injuriesClass 4 · LimitedFinal reportMustang II · Asheville, ALThe pilot’s failure to maintain control of the airplane during initial climb after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.Oct 28, 2023 · N71CB · Substantial damageNTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.Oct 28, 2023 · N910MG · Substantial damageNTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.Oct 27, 2023 · N915DV · Substantial damageNTSB OPS24LA004IncidentClass 4 · LimitedFinal reportAirbus A321-271N · Long Beach, CAThe local controller’s poor judgment in prioritization of their ground traffic ahead of their airborne traffic, that became a distraction and led to a loss of situational awareness resulting in a near midair collision. Contributing to the incident was the…Oct 27, 2023 · N216HA · 2 aircraft · No damageNTSB ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.Oct 27, 2023 · N3910M · Substantial damageNTSB WPR24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace Commander 690C · Reno, NVThe pilot applicant’s excessive nose down pitch, and the check pilot’s delayed remedial action, which resulted in an impact with terrain.Oct 26, 2023 · N840KB · Substantial damageNTSB ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.Oct 26, 2023 · N1953Y · Substantial damageNTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…Oct 26, 2023 · N141CD · Substantial damageNTSB ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.Oct 25, 2023 · N7981E · Substantial damageNTSB CEN24FA024Accident · 1 fatalClass 3 · FieldFinal reportLancair 320 · Manitowoc, WIThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from trees and terrain during an unapproved instrument approach. Contributing to the accident was the pilot’s…Oct 25, 2023 · N320P · Substantial damageNTSB DCA24FA017Accident · No injuriesClass 2 · FieldFinal reportTextron 510 · Houston, TXThe takeoff by the flight crew of N269AA, without a takeoff clearance, which resulted in a collision with N510HM that was landing on an intersecting runway. Contributing to the accident was the N269AA crew’s expectation bias and distraction.Oct 24, 2023 · N510HM · 2 aircraft · Substantial damageNTSB CEN24LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Savoy, ILThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision to ensure that the landing gear was extended.Oct 24, 2023 · N5331N · Substantial damageNTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…Oct 24, 2023 · N5180W · Substantial damageNTSB CEN24LA020Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA 46-350P · Pierre, SDThe total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.Oct 23, 2023 · N92884 · Substantial damageNTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.Oct 22, 2023 · N5954Q · Substantial damageNTSB CEN24LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Iola, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 22, 2023 · N5324F · Substantial damageNTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.Oct 21, 2023 · N8248K · DestroyedNTSB ERA24LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orangeburg, SCThe student pilot’s failure to maintain adequate clearance from a fuel truck while taxiing. Also contributing was the flight instructor’s inadequate monitoring of the student pilot.Oct 21, 2023 · N7607T · Substantial damageNTSB CEN24LA031Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Manhattan, KSThe pilot’s improper modification of the engine cooling system that resulted in an engine overheat and total loss of power. Contributing to the accident was the pilot’s decision to continue the flight after the engine overheat light illuminated instead of…Oct 21, 2023 · N52631 · Substantial damageNTSB ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.Oct 20, 2023 · N9101J · Substantial damageNTSB ERA24LA017Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Tellico Plains, TNThe pilot's overapplication of brakes after landing long on a constrained runway and with a tailwind, which resulted in a nose-over.Oct 20, 2023 · N958TW · Substantial damageNTSB CEN24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Wichita, KSThe pilot’s inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Oct 20, 2023 · N1413Y · Substantial damageNTSB DCA24LA043Incident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Chicago, ILThe flight crew’s misperception of the distance required to safely pass the hangar and failure to request additional ground handling support while taxiing, which resulted in a collision with a hangar. Contributing to the accident was United Airlines…Oct 19, 2023 · N30913 · Minor damageNTSB WPR24LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Bandera, WAThe pilot’s decision to land at a closed water-soaked grass runway, which resulted in a runway excursion.Oct 18, 2023 · N734LJ · Substantial damageNTSB ERA24LA012Accident · No injuriesClass 3 · LimitedFinal reportBeech 300 · Atlanta, GAThe pilot’s failure to maintain a proper approach speed, which resulted in a runway overrun. Contributing to the runway overrun were the pilot’s application of full reverse at an airspeed higher than that allowed by the system, which added power and forward…Oct 18, 2023 · N93GA · Substantial damageNTSB WPR24FA014Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Williams, AZThe pilot’s failure to maintain sufficient airspeed and exceedance of the airplane’s critical angle of attack during initial climb after takeoff, resulting in an aerodynamic stall. Contributing was the pilot’s inadequate preflight airplane performance…Oct 17, 2023 · N6192J · Substantial damageNTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…Oct 17, 2023 · N118T · Substantial damageNTSB CEN24LA015Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Greeley, COThe pilot’s decision to turn out early during the initial climb and failure to maintain adequate airspeed/angle-of-attack, which resulted in an aerodynamic stall and impact with airport hangars. Contributing to the accident was the variable wind conditions…Oct 17, 2023 · N41DH · Substantial damageNTSB CEN24LA013Accident · No injuriesClass 3 · LimitedFinal reportMagni M24 · Mount Sterling, ILThe pilot’s failure to maintain gyroplane control on the downwind leg, which resulted in impact with terrain. Contributing to the accident was the pilot’s distraction.Oct 16, 2023 · N90HM · Substantial damageNTSB ERA24LA010Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Southport, NCThe student pilot’s use of carburetor heat during takeoff, which resulted in a partial loss of engine power during initial climb due to an excessively rich fuel-air mixture.Oct 15, 2023 · N72FU · Substantial damageNTSB CEN24LA012Accident · No injuriesClass 3 · LimitedFinal reportTvap 4 · Franksville, WIThe improper installation of the supplemental ignition system, which resulted in a total loss of engine power.Oct 15, 2023 · N42VZ · Substantial damageNTSB CEN24LA011Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Red Oak, IAThe fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.Oct 15, 2023 · N6JA · Substantial damageNTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.Oct 14, 2023 · N87621 · Substantial damageNTSB WPR24LA026Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage · Fairfield, UTThe pilot’s failure to maintain airplane control during the landing, which resulted in a ground loop.Oct 13, 2023 · N866SA · Substantial damageNTSB WPR24LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Eastsound, WAThe pilot's unstable approach and improper configuration of the flaps during a go-around which resulted in an aerodynamic stall and subsequent impact with terrain.Oct 13, 2023 · N509Z · Substantial damageNTSB ERA24LA008Accident · Serious injuriesClass 3 · LimitedFinal reportRotorsport UK Mtosport 2017 · Easton, MDThe pilot’s failure to maintain control of the gyroplane on takeoff.Oct 13, 2023 · N975CD · Substantial damageNTSB CEN24LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Denton, TXThe student pilot’s failure to maintain directional control while landing with a tailwind.Oct 13, 2023 · N6605J · Substantial damageNTSB WPR24LA016Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Provo, UTThe pilot’s failure to maintain directional control during landing.Oct 12, 2023 · N235PR · Substantial damageNTSB WPR24LA015Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Mesa, AZThe flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Oct 12, 2023 · N4777V · Substantial damageNTSB WPR24LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Boise, IDThe pilot’s failure to maintain directional control while taxiing, which resulted in impact with a fence.Oct 12, 2023 · N682JS · Substantial damageNTSB ERA24LA007Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Martinsville, VAThe pilot’s failure to maintain a positive climb rate after takeoff while distracted by primary flight display anomaly and terrain alerts. Contributing to the accident was the pilot’s decision to take off with the airplane over its maximum gross weight, which…Oct 12, 2023 · N253BC · Substantial damageNTSB CEN24FA010Accident · 2 fatalClass 3 · FieldFinal reportCessna 414 · Patterson, LAThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Oct 12, 2023 · N880A · DestroyedNTSB WPR24LA012Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-46-310P · Chandler, AZThe pilot’s failure to adequately confirm the fuel quantity before departure, resulting in fuel exhaustion and a partial loss of engine power.Oct 11, 2023 · N4380D · Substantial damageNTSB ERA24LA006Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Jonesboro, GABoth pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.Oct 11, 2023 · N55162 · Substantial damageNTSB WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…Oct 10, 2023 · N75RT · Substantial damageNTSB CEN24LA009Accident · Serious injuriesClass 4 · LimitedFinal reportBallonbau Wörner NL-STU/1000 · Crandall, TXThe pilot-in-command’s inadequate descent planning that resulted in the balloon contacting power lines shortly after landing and an explosion of hydrogen gas.Oct 10, 2023 · D-OGBL · Substantial damageNTSB WPR24LA008Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe pilot’s failure to maintain directional control during landing, resulting in a roll over.Oct 9, 2023 · N838SH · Substantial damage