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 GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.Jul 24, 2019 · N269RR · Substantial damageNTSB GAA19CA454Accident · No injuriesData collectionFinal reportCessna T188 · Deshler, NEThe pilot's failure to maintain clearance from wires during low-altitude maneuvering.Jul 24, 2019 · N3367J · Substantial damageNTSB GAA19CA453Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Stanton, TXThe pilot's failure to maintain clearance from wires during an agricultural application flight.Jul 24, 2019 · N15400 · Substantial damageNTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.Jul 24, 2019 · N1509E · Substantial damageNTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…Jul 24, 2019 · N921CD · DestroyedNTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 24, 2019 · N8910U · Substantial damageNTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.Jul 24, 2019 · N7976A · Substantial damageNTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.Jul 23, 2019 · N737DW · Substantial damageNTSB DCA19CA186Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · San Francisco, CAfailure of the ground crew to maintain clearance from the parked airplane during pushback.Jul 23, 2019 · N57852 · Substantial damageNTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.Jul 22, 2019 · N8251L · Substantial damageNTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.Jul 21, 2019 · N409EV · Substantial damageNTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.Jul 21, 2019 · N1831 · Substantial damageNTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.Jul 21, 2019 · N9201A · 2 aircraft · Minor damageNTSB ANC19TA037Accident · Serious injuriesClass 4Final reportPiper PA19 · Skwentna, AKThe pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.Jul 21, 2019 · N6PF · Substantial damageNTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.Jul 20, 2019 · N777DV · Substantial damageNTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.Jul 20, 2019 · N12ZT · Substantial damageNTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.Jul 20, 2019 · N7013M · Substantial damageNTSB CEN19CA227Accident · No injuriesData collectionFinal reportVans RV-8 · Oshkosh, WIThe pilot’s failure to maintain adequate spacing from the lead airplane while landing following revised landing instructions, which necessitated that the pilot conduct an improper landing flare and resulted in a hard landing.Jul 20, 2019 · N143MS · Substantial damageNTSB WPR19LA196Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 5(205) · Dallesport, ORThe pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.Jul 19, 2019 · N8260Z · DestroyedNTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.Jul 19, 2019 · N1330J · Substantial damageNTSB GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.Jul 19, 2019 · N3276A · Substantial damageNTSB GAA19CA440Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe student pilot's failure to maintain lateral control during a soft-field takeoff, which resulted in the left wing striking the runway and a runway excursion.Jul 19, 2019 · N403FR · Substantial damageNTSB ERA19TA233Accident · No injuriesClass 3Final reportBeech 95B55 · Sanford, FLThe pilot's failure to extend the landing gear during landing.Jul 19, 2019 · N386Q · Substantial damageNTSB ERA19LA232Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Ocean City, MDThe disconnection of the propeller governor control arm from the propeller governor due to a missing attachment bolt, which resulted in a partial loss of engine power during takeoff when the governor control vibrated to a high pitch, low rpm setting.Jul 19, 2019 · N849GS · Substantial damageNTSB ERA19LA231Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Poughkeepsie, NYA total loss of engine power due to fuel exhaustion as the result of a higher-than-expected fuel quantity reduction. Contributing was the pilot’s continued flight away from his selected precautionary landing site after identification of a fuel emergency,…Jul 19, 2019 · N811SK · Substantial damageNTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.Jul 19, 2019 · N68083 · Substantial damageNTSB WPR19TA193Accident · Minor injuriesClass 3Final reportCessna 550 · Mesquite, NVThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control on landing.Jul 18, 2019 · N320JT · DestroyedNTSB GAA19CA433Accident · No injuriesData collectionFinal reportBrumbaugh David R DRB Raider · Laramie, WYThe pilot's improper landing flare, which resulted in a hard landing.Jul 18, 2019 · N703DB · Substantial damageNTSB WPR19LA191Accident · 1 fatalClass 3 · LimitedFinal reportBolkow Phoebus · Alvord Desert, ORPilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.Jul 17, 2019 · N112AJ · DestroyedNTSB GAA19CA432Accident · Minor injuriesData collectionFinal reportAviat A1 · Ennis, MTThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's distraction due to looking at wildlife.Jul 17, 2019 · N137C · DestroyedNTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.Jul 17, 2019 · C-GAFT · Substantial damageNTSB GAA19CA428Accident · Minor injuriesData collectionFinal reportRobinson R44 · Council Bluff, IAThe pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.Jul 16, 2019 · N124LA · Substantial damageNTSB GAA19CA425Accident · No injuriesData collectionFinal reportAeros Skyranger · Brownville, METhe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control while attempting a go-around, which resulted in a runway excursion and impact with trees.Jul 16, 2019 · N75561 · Substantial damageNTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.Jul 16, 2019 · N1079M · Substantial damageNTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.Jul 16, 2019 · N4876N · Substantial damageNTSB ERA19LA229Accident · Serious injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Crescent, FLThe pilot’s misjudgment of his altitude during landing and subsequent decrease in pitch attitude, which resulted in a collision with the water.Jul 16, 2019 · N632FG · Substantial damageNTSB WPR19LA195Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hurricane, UTMaintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…Jul 15, 2019 · N6330N · Substantial damageNTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.Jul 15, 2019 · N144TG · Substantial damageNTSB GAA19CA487Accident · No injuriesData collectionFinal reportCessna 170 · Bison, SDThe pilot's improper landing flare, which resulted in a hard landing and subsequent ground loop.Jul 15, 2019 · N2946D · Substantial damageNTSB GAA19CA437Accident · Minor injuriesData collectionFinal reportPiper PA36 · Bancroft, IDThe pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.Jul 15, 2019 · N57799 · Substantial damageNTSB GAA19CA421Accident · Minor injuriesData collectionFinal reportWillie Bennett Glastar · Lompoc, CAThe pilot's failure to maintain a proper glidepath during a night landing, which resulted in impact with a tree.Jul 15, 2019 · N345BP · Substantial damageNTSB GAA19CA416Accident · No injuriesData collectionFinal reportThomas Wild Avid · York, SCThe pilot's inadvertent reduction of power during the initial climb, which resulted in an aerodynamic stall. Contributing to the pilot’s inadvertent reduction of power was his lack of experience with his left hand on the control stick and right hand on the…Jul 15, 2019 · N987TW · Substantial damageNTSB GAA19CA411Accident · No injuriesData collectionFinal reportPiper J3C · San Diego, CAThe pilot's failure to maintain directional control during landing, which resulted a ground loop.Jul 15, 2019 · N92628 · Substantial damageNTSB WPR19LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna P206 · Cascade, IDA loss of engine power due to the pilot’s improper leaning of the engine.Jul 14, 2019 · N131DV · Substantial damageNTSB GAA19CA447Accident · No injuriesData collectionFinal reportBiuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NVThe pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.Jul 14, 2019 · N821W · Substantial damageNTSB GAA19CA412Accident · No injuriesData collectionFinal reportCessna 172 · Elkton, FLThe pilot under instruction's failure to follow the flight instructor’s directions and the flight instructor's delayed remedial action and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 14, 2019 · N35585 · Substantial damageNTSB ERA19LA227Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Hastings, FLThe pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.Jul 14, 2019 · N7833D · Substantial damageNTSB CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.Jul 14, 2019 · N2863J · Substantial damageNTSB CEN19LA224Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Osceola, WIThe failure of the right horizontal stabilizer during takeoff, resulting in a loss of control and forced landing. Contributing to the accident was the installation of an unapproved stabilizer frame and failure of maintenance personnel to identify…Jul 14, 2019 · N6983B · Substantial damageNTSB CEN19LA223Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Elkhart, INAn inadvertent engine start of the airplane and subsequent takeoff without the pilot on-board for reasons that could not be determined based on available evidence.Jul 14, 2019 · N29516 · Substantial damage