NTSB investigations

2,519 cases where NTSB found Psychological.

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\", '0202'))
  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 CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.Aug 27, 2022 · N132JD · Substantial damageNTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.Aug 23, 2022 · N770HP · Substantial damageNTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.Aug 22, 2022 · N96095 · Substantial damageNTSB ERA22LA379Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Bealeton, VAThe pilot of the departing airplane’s failure to see and avoid the landing airplane before takeoff, resulting in a collision with the landing airplane. Contributing was the airport’s failure to encourage pilots to use radios for traffic deconfliction when…Aug 20, 2022 · N55267 · 2 aircraft · Substantial damageNTSB WPR22FA309Accident · 3 fatalClass 3 · FieldFinal reportCessna 152 · Watsonville, CAThe failure of the pilot of the multi-engine airplane to see and avoid the single-engine airplane while performing a straight-in approach for landing.Aug 18, 2022 · N49931 · 2 aircraft · Substantial damageNTSB WPR22LA305Accident · No injuriesClass 4 · LimitedFinal reportHughes Helicopters 369E · Ely, NVThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.Aug 15, 2022 · N500AR · Substantial damageNTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.Aug 14, 2022 · N320DA · Substantial damageNTSB ERA22LA364Accident · Minor injuriesClass 4 · LimitedFinal reportAerotek Pitts Special S-1S · Erwinna, PAThe inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…Aug 6, 2022 · N49310 · 2 aircraft · Substantial damageNTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.Aug 5, 2022 · N722BS · Substantial damageNTSB ERA22LA370Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Shirley, NYThe flight instructor’s failure to ensure clearance from an electrical junction box during takeoff, which resulted in a collision.Aug 4, 2022 · N2055T · Substantial damageNTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.Aug 4, 2022 · N8865T · Substantial damageNTSB WPR22LA290Accident · No injuriesClass 3 · LimitedFinal reportEADS Socata TBM 700 · Carlsbad, NMThe pilot’s failure to extend the landing gear before landing due to a distraction, which resulted in an impact with the runway.Aug 3, 2022 · N620WG · Substantial damageNTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…Aug 3, 2022 · N459BT · Substantial damageNTSB CEN22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Melville, LAThe pilot improperly monitored the operating environment which resulted in a collision with a tree located in the middle of a field.Aug 3, 2022 · N41850 · Substantial damageNTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.Jul 30, 2022 · N501MW · DestroyedNTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.Jul 28, 2022 · N719TF · Substantial damageNTSB ERA22FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Portland, ARThe failure of both pilots to see and avoid the other airplane during aerial application and ferry operations.Jul 26, 2022 · N749LA · 2 aircraft · DestroyedNTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.Jul 25, 2022 · N497SU · Substantial damageNTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.Jul 21, 2022 · N1540S · Substantial damageNTSB ERA22LA347Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Franklin, PAThe pilot’s inadequate visual lookout while flying at a low level over a river, which resulted in a wire strike.Jul 19, 2022 · N203PA · Substantial damageNTSB CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.Jul 19, 2022 · N9688Q · Substantial damageNTSB ERA22LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Orlando, FLThe flight instructor’s inadequate remedial actions following the student pilot’s improper control inputs, which resulted in dynamic rollover.Jul 17, 2022 · N224MG · Substantial damageNTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…Jul 17, 2022 · N97CX · 2 aircraft · DestroyedNTSB ERA22LA433Accident · No injuriesClass 4 · LimitedFinal reportEaster William C M-1 · Okeechobee, FLThe premature placement of an airport runway closure marker short of the runway, which resulted in the airplane’s collision with the marker during the landing approach. Contributing was the pilot’s inability to see the marker due the nose-high attitude of the…Jul 16, 2022 · N150MM · Substantial damageNTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…Jul 15, 2022 · N3659Y · DestroyedNTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.Jul 15, 2022 · N2005Z · Substantial damageNTSB ANC22LA057Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Lake Louise, AKThe pilot's failure to maintain a proper glide path, which resulted in a hard landing short of the airstrip.Jul 15, 2022 · N3980T · Substantial damageNTSB ANC22LA056Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot's failure to maintain control of the airplane during taxi operations on a riverbank with shallow water.Jul 15, 2022 · N4040W · Substantial damageNTSB ERA22LA326Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot’s loss of situational awareness (geographic position), which resulted in his inability to locate the intended landing runway and his decision to perform an off-airport landing.Jul 10, 2022 · N3616Q · Substantial damageNTSB WPR22LA245Accident · Serious injuriesClass 4 · LimitedFinal reportHiller UH-12E · Wenatchee, WAThe pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.Jul 6, 2022 · N130HA · DestroyedNTSB WPR22LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Prescott, AZThe pilot receiving instructions failure to maintain directional during the takeoff ground roll and the flight instructor’s inadequate supervision.Jun 27, 2022 · N2809N · Substantial damageNTSB ERA22LA283Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A · Charlestown, NHThe pilot’s failure to see and avoid power lines while maneuvering at low altitude.Jun 22, 2022 · N1927A · Substantial damageNTSB WPR22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Red Bluff, CAThe pilot’s failure to detect the tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing.Jun 20, 2022 · N4383D · Substantial damageNTSB CEN22LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fargo, NDThe flight instructor’s failure to adequately monitor the pilot flying, which resulted in a nose-wheel first hard landing.Jun 19, 2022 · N5256S · Substantial damageNTSB WPR22LA220Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Auburn, WAThe student pilot’s loss of helicopter control and the flight instructor’s delayed remedial action while providing hover training which resulted in a dynamic rollover.Jun 18, 2022 · N944BC · Substantial damageNTSB 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 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 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 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 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 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 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 CEN22LA226Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Weiner, ARThe pilot’s failure to maintain clearance from the telephone pole during a low-level aerial application pass.May 27, 2022 · N579LA · DestroyedNTSB CEN22LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, INThe student pilot’s improper landing flare and the flight instructor’s delayed remedial response which resulted in an aerodynamic stall.May 19, 2022 · N2128E · Substantial damageNTSB ERA22LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Lancaster, NYThe student pilot’s excessive pitch during takeoff resulted in a loss of control and impact with terrain. Contributing was the student’s failure to relinquish the controls when ordered by the instructor.May 14, 2022 · N20459 · Substantial damageNTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.May 9, 2022 · N988JA · Substantial damageNTSB WPR22FA172Accident · 2 fatalClass 3 · FieldFinal reportVans RV10 · Sausalito, CAThe pilot’s improper decision to continue a visual flight rules flight into an area of limited visibility conditions, which resulted in spatial disorientation and a loss of airplane control.May 6, 2022 · N54MG · Substantial damageNTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.Apr 26, 2022 · N32042 · Substantial damage