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 DCA22LA135AccidentClass 4 · LimitedFinal reportAirbus A330 · New York, NYThe ITA Airways flightcrew’s misperception of the distance to maintain separation and safely pass the stopped Air France airplane.Jun 18, 2022 · EI-EJL · 2 aircraft · Minor damageNTSB CEN22LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Jacksonville, ILThe pilot’s failure to attain proper flare during landing, resulting in a bounced landing.Jun 18, 2022 · N6797E · Substantial damageNTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.Jun 18, 2022 · N5895Q · Substantial damageNTSB CEN22LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Yoakum, TXThe pilot's loss of helicopter control on approach to land due to a settling with power condition, which resulted in a hard landing.Jun 17, 2022 · N743DP · Substantial damageNTSB CEN22LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Bynum, TXThe pilot was not able to stop the airplane on the remaining runway after an aborted takeoff, which resulted in a runway excursion and the airplane impacting a fence.Jun 17, 2022 · N2975U · Substantial damageNTSB ERA22LA274Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Brevard, NCThe pilot’s failure to maintain altitude while maneuvering the airplane at a low altitude, which resulted in impact with trees and terrain.Jun 16, 2022 · N5064H · Substantial damageNTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.Jun 16, 2022 · N39880 · Substantial damageNTSB WPR22LA218Accident · Serious injuriesClass 4 · LimitedFinal reportAir Creation USA Skypper · Toledo, WAThe pilot’s improper control input during landing which resulted in an exceedance of the aircraft’s critical angle of attack, aerodynamic stall and impact with the ground.Jun 15, 2022 · N536AC · Substantial damageNTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.Jun 15, 2022 · N432CD · Substantial damageNTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.Jun 14, 2022 · N3553M · Substantial damageNTSB CEN22LA248Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Beaumont, TXThe pilot’s failure to maintain clearance from a power line pole while preparing for a low-level aerial application pass.Jun 14, 2022 · N42590 · Substantial damageNTSB ERA22LA267Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe student pilot’s loss of control during climb after an aborted landing, which resulted in an aerodynamic stall.Jun 13, 2022 · N78755 · Substantial damageNTSB ERA22LA266Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Sarasota, FLThe pilot’s inadequate preflight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a loss of engine power on approach.Jun 13, 2022 · N9577L · Substantial damageNTSB WPR22LA213Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Auburn, WAA total loss of engine power due to fuel starvation.Jun 12, 2022 · N7482P · Substantial damageNTSB ERA22LA319Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Charleston, SCThe failure of the torsion spring inside the drive clutch assembly of the landing gear actuator which prevented normal and manual extension of the landing gear.Jun 12, 2022 · N9158D · Substantial damageNTSB CEN22LA291Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Minot, NDThe student pilot’s failure to maintain airspeed and yaw control of the airplane during an aborted takeoff, which resulted in an aerodynamic stall and impact with the ground.Jun 12, 2022 · N737BW · Substantial damageNTSB WPR22LA232Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Copperopolis, CAThe pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.Jun 11, 2022 · N13ZF · Substantial damageNTSB ERA22LA269Accident · No injuriesClass 4 · LimitedFinal reportWalter S Johnson III AR-1 · Butler, PAThe pilot’s failure to monitor rotor disk speed on takeoff, which resulted in blade flapping and the main rotor blades striking the gyroplane’s tail assembly.Jun 11, 2022 · N688G · Substantial damageNTSB ANC22LA043Accident · Minor injuriesClass 4 · LimitedFinal reportPepperd Greg J Caribou Cruiser · Wasilla, AKThe pilot's overapplication of brakes during landing, which resulted in a nose-over.Jun 11, 2022 · N907GP · Substantial damageNTSB WPR22LA212Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A-1B · Big Creek, IDThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with fencing.Jun 10, 2022 · N55HU · Substantial damageNTSB WPR22FA210Accident · 1 fatalClass 3 · FieldFinal reportMooney M20K · Camarillo, CAThe pilot’s spatial disorientation and loss of airplane control after entering instrument meteorological conditions shortly after takeoff.Jun 10, 2022 · N305L · DestroyedNTSB CEN22LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305 · Sioux Falls, SDThe pilot’s failure to maintain directional control after an attempted go-around, which resulted in a runway excursion and impact with terrain.Jun 10, 2022 · N201FM · Substantial damageNTSB WPR22LA211Accident · Minor injuriesClass 3 · LimitedFinal reportRans S21 · Fairfield, UTThe owner’s (pilot) failure to properly torque a fuel filter b-nut fitting, which likely introduced air into the fuel system and resulted in a loss of engine power. Contributing to the loss of power was a missing restricted bypass line and a header tank vent…Jun 9, 2022 · N46JH · Substantial damageNTSB WPR22LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Sunriver, ORThe pilot's failure to maintain control of the airplane during takeoff, which resulted in a collision with terrain.Jun 9, 2022 · N94078 · Substantial damageNTSB CEN22LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 337G · Greenbrier, ARThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.Jun 9, 2022 · N53705 · Substantial damageNTSB CEN22LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Salina, KSThe pilot’s poor pitch control during an aborted takeoff which resulted in a hard landing.Jun 9, 2022 · N831KS · Substantial damageNTSB CEN22LA242Accident · No injuriesClass 4 · LimitedFinal reportAMD CH2000 · Gladewater, TXThe student pilot’s failure to maintain/attain aircraft control during a go-around from a bounced landing that resulted in an aerodynamic stall and impact with terrain.Jun 9, 2022 · N364AM · Substantial damageNTSB CEN22LA239Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Braunfels, TXThe pilot’s failure to maintain directional control during takeoff.Jun 9, 2022 · N3798K · Substantial damageNTSB ANC22LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Anchorage, AKThe pilot’s improper landing flare which resulted in a hard landing.Jun 9, 2022 · N9209H · Substantial damageNTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.Jun 9, 2022 · N402SH · Substantial damageNTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.Jun 8, 2022 · N8889G · Substantial damageNTSB DCA22LA126Incident · No injuriesClass 3 · LimitedFinal reportBoeing 757-236 · Tulsa, OKThe flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…Jun 8, 2022 · N949FD · No damageNTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.Jun 8, 2022 · N78KL · Minor damageNTSB CEN22LA243Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MT-7-235 · Flasher, NDThe pilot’s loss of control during a takeoff from a narrow gravel road, resulting in a collision with a fixed obstacle.Jun 8, 2022 · N235MG · Substantial damageNTSB CEN22LA238Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Hot Springs, SDThe passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.Jun 8, 2022 · N9158Z · No damageNTSB ANC22LA042Accident · No injuriesClass 4 · LimitedFinal reportShort Bros. & Harland SC7 · Chisana, AKThe pilot’s selection of an unsuitable landing site, which resulted in the nosewheel collapsing.Jun 8, 2022 · N731E · Substantial damageNTSB WPR22LA207Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175 · Blackfoot, IDThe pilot’s loss of airplane control during the landing approach which, resulted in an undershoot and collision with a fence.Jun 7, 2022 · N7303M · Substantial damageNTSB WPR22LA201Accident · No injuriesClass 4 · LimitedFinal reportBombardier BD100 1A10 · Hawthorne, CAThe multi-engine pilot's failure to maintain clearance from another airplane during taxi.Jun 7, 2022 · N694PD · 2 aircraft · Minor damageNTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.Jun 7, 2022 · N18244 · Substantial damageNTSB CEN22LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s inadequate fuel management that resulted in a loss of engine power due to fuel starvation.Jun 7, 2022 · N8283V · Substantial damageNTSB WPR22LA206Accident · No injuriesClass 4 · LimitedFinal reportShea Pitts Special S-1C · Reno, NVThe pilot’s failure to maintain directional control during landing roll.Jun 6, 2022 · N52JH · Substantial damageNTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.Jun 6, 2022 · N4067V · Substantial damageNTSB WPR22LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBearhawk Bearhawk · Holbrook, AZThe pilot’s failure to maintain directional control during landing.Jun 6, 2022 · N22LD · Substantial damageNTSB ERA22LA263Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s loss of control during a go-around and the delayed remedial action initiated by the flight instructor, which resulted in a runway excursion and collision with trees.Jun 6, 2022 · N29501 · Substantial damageNTSB ERA22FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201 · Panama City, FLMaintenance personnel’s failure to follow the avionics installation guidance for the oil pressure sensor, which resulted in the high-cycle fatigue failure of an line, oil starvation, and the subsequent loss of engine power. Contributing to the accident was…Jun 6, 2022 · N160LL · Substantial damageNTSB CEN22LA235Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nashville, ARThe pilot was not able to stop the airplane on a wet runway due to hydroplaning.Jun 6, 2022 · N787CD · Substantial damageNTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.Jun 5, 2022 · UNREG · Substantial damageNTSB CEN22FA224Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS135 · Midlothian, TXThe pilot’s incapacitation by an aortic dissection (natural disease).Jun 5, 2022 · N2817H · No damageNTSB WPR22LA228Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Palm Springs, CAThe failure of the pilot to ensure the landing gear was down and locked before landing.Jun 4, 2022 · N4752K · Substantial damageNTSB WPR22LA204Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Snohomish, WAThe total loss of engine power during takeoff due to fuel starvation and the pilot’s improper fuel tank selection and inadequate preflight inspection.Jun 4, 2022 · N561PK · Substantial damage