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 ERA20CA267Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Indian Trail, NCThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway overrun.Jul 29, 2020 · N33JM · Substantial damageNTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.Jul 29, 2020 · N1049P · Substantial damageNTSB WPR20CA243Accident · Minor injuriesClass 4 · Data collectionFinal reportQuest Kodiac 100 · Hunts Point, WAThe pilot’s failure to retract the landing gear during a water landing, which resulted in a nose over. Contributing to the accident was the pilot’s failure to properly use a prelanding checklist.Jul 28, 2020 · N856TC · Substantial damageNTSB CEN20LA309Accident · 1 fatalClass 3 · LimitedFinal reportCessna A188 · Corsica, SDThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control.Jul 27, 2020 · N53163 · DestroyedNTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…Jul 27, 2020 · N9278G · Substantial damageNTSB CEN20CA316Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Hebron, NEA loss of engine power due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight to sump the fuel tanks prior to flight.Jul 27, 2020 · N771GB · Substantial damageNTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.Jul 27, 2020 · N570WH · Substantial damageNTSB CEN20CA312Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 602 · Tiro, OHThe pilot's failure to maintain clearance while attempting to fly under power lines during an aerial application pass.Jul 27, 2020 · N602FH · Substantial damageNTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.Jul 27, 2020 · N9190Q · Substantial damageNTSB ANC20CA080Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18 · Fairbanks, AKThe pilot's improper decision to depart from an off-airport surface that had standing water, which resulted in a loss of control and impact with terrain.Jul 27, 2020 · N1277A · Substantial damageNTSB WPR20LA239Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Henefer, UTThe total loss of engine power due to the separation of the idler gear shaft bolts as a result of improper installation, which allowed for the idler gear to become disengaged.Jul 26, 2020 · N514BS · Substantial damageNTSB ERA20CA276Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lakeland, FLThe pilot’s failure to maintain control of the airplane during the attempted engine start.Jul 26, 2020 · N2629V · Substantial damageNTSB WPR20LA238Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA32R · West Jordan, UTThe pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…Jul 25, 2020 · N7677C · Substantial damageNTSB CEN20LA306Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Grant, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover. Contributing to the accident was the pilot’s…Jul 25, 2020 · N502KJ · Substantial damageNTSB CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.Jul 25, 2020 · N716RL · DestroyedNTSB CEN20CA310Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Angola, INThe pilot's failure to maintain control of the airplane during a low-level pass, resulting in the airplane exceeding its critical angle of attack that caused an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot's…Jul 25, 2020 · N86614 · Substantial damageNTSB CEN20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportVans Vans RV 6 · Imperial, NEThe pilot's inadequate preflight performance planning and his decision not to utilize all available runway during high density altitude operations which led to an inflight loss of control and subsequent collision with terrain.Jul 25, 2020 · N327WB · Substantial damageNTSB WPR20LA237Accident · 1 fatalClass 3 · LimitedFinal reportVans Vans RV-8 · Tehachapi, CAThe pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at too low of an altitude to recover.Jul 24, 2020 · N138PM · Substantial damageNTSB ERA20CA260Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Whitehall, MDThe pilot's failure to maintain adequate clearance from a known obstacle while landing from a hover.Jul 24, 2020 · N350DM · Substantial damageNTSB WPR20CA254Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Clearwater, ORThe pilot's improper pitch attitude during the soft-field landing roll, which resulted in the tail striking the runway.Jul 22, 2020 · N9747H · Substantial damageNTSB CEN20LA301Accident · No injuriesClass 3 · LimitedFinal reportVans RV4 · Idabel, OKThe pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.Jul 22, 2020 · N54WP · Substantial damageNTSB CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.Jul 22, 2020 · N2158P · Substantial damageNTSB CEN20CA299Accident · No injuriesClass 4 · Data collectionFinal reportRockwell 112 · Tomball, TXThe pilot did not maintain control of the airplane during the landing and subsequent go around.Jul 22, 2020 · N1013J · Substantial damageNTSB ERA20LA258Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Pottstown, PAThe pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.Jul 21, 2020 · N4092D · Substantial damageNTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.Jul 21, 2020 · N284M · Substantial damageNTSB CEN20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Cambridge, MNThe pilot's loss of directional control while landing a tailwheel airplane with a slight left quartering a tailwind. Contributing to the accident was the flight instructor's delayed remedial action.Jul 21, 2020 · N2943C · Substantial damageNTSB WPR20LA229Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · College Place, WAThe pilot’s premature retraction of the flaps which resulted in the airplane settling back onto the runway, contacting it hard, and veering off the runway.Jul 20, 2020 · N846JM · Substantial damageNTSB WPR20CA233Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Bear Valley, AKThe pilot's over application of brakes during taxi, which resulted in a nose over.Jul 20, 2020 · N2929C · Substantial damageNTSB CEN20CA300Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dickeyville, WIThe pilot did not maintain clearance from wires during an aerial application flight.Jul 20, 2020 · N570WH · Substantial damageNTSB ERA20CA256Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Wellington, FLThe pilot’s inadequate compensation for a wind gust during landing.Jul 19, 2020 · N1655V · Substantial damageNTSB CEN20LA292Accident · No injuriesClass 3 · LimitedFinal reportBeech A23-24 · Burns Flat, OKThe mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.Jul 19, 2020 · N3412C · Substantial damageNTSB WPR20CA230Accident · No injuriesClass 4 · Data collectionFinal reportSeele XPA-18 · Reno, NVAn inadequate flare which resulted in a bounced landing and the pilot's failure to maintain directional control.Jul 18, 2020 · N113MX · Substantial damageNTSB ERA20CA268Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Linconville, METhe pilot's improper landing flare, which resulted in a bounced landing and subsequent main landing gear collapse.Jul 18, 2020 · N4365M · Substantial damageNTSB ERA20CA264Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Block Island, RIA hard landing and subsequent loss of control.Jul 18, 2020 · N58066 · Substantial damageNTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.Jul 18, 2020 · N140AB · Substantial damageNTSB CEN20LA290Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Loveland, OHThe loss of engine power due to fuel starvationJul 18, 2020 · N4816A · Substantial damageNTSB CEN20CA317Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Osceola, WIThe pilots did not maintain directional control of the airplane during landing.Jul 17, 2020 · N1926N · Substantial damageNTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.Jul 17, 2020 · N86WM · Substantial damageNTSB ERA20CA257Accident · Minor injuriesClass 4 · Data collectionFinal reportKade Aventura II · Astor, FLThe pilot's failure to retract the amphibious airplane’s landing gear prior to the water landing, which resulted in a nose over.Jul 16, 2020 · N86KD · Substantial damageNTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.Jul 16, 2020 · N630JL · Substantial damageNTSB ANC20CA070Accident · No injuriesClass 4 · Data collectionFinal reportBell 206L-1 · Homer, AKThe pilot's failure to see and avoid the boat's mast, which resulted in a main rotor blade strike. Contributing to the accident was the pilot's inadequate preflight planning by not having the boat's mast measured.Jul 16, 2020 · N1432D · Substantial damageNTSB WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.Jul 15, 2020 · N8488Y · Substantial damageNTSB ERA20CA253Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Washington, NCThe pilot's failure to maintain directional during landing on a wet grass runway.Jul 15, 2020 · N2038Q · Substantial damageNTSB CEN20CA285Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Rochester, INThe pilot's failure to maintain directional control during landing resulting in a ground loop.Jul 15, 2020 · N2231T · Substantial damageNTSB WPR20CA222Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hayward, CAThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the flight instructor's delayed remedial action, which resulted in the left wing striking the runway.Jul 14, 2020 · N530CA · Substantial damageNTSB ERA20CA251Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 22 · Fuquay Varina, NCThe pilot's failure to attain a proper approach speed, which resulted in an overrun of the wet grass runway.Jul 14, 2020 · N1520P · Substantial damageNTSB CEN20CA284Accident · No injuriesClass 4 · Data collectionFinal reportBeech 95 55 · Spring, TXExcessive wear of the left brake liners which reduced brake effectiveness resulting in a runway excursion.Jul 14, 2020 · N1332Z · Substantial damageNTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.Jul 14, 2020 · N72EB · Substantial damageNTSB CEN20CA280Accident · No injuriesClass 4 · Data collectionFinal reportWaco YKC · New Carlisle, OHThe pilot's failure to maintain proper approach speed and descent path to the runway, which resulted in excessive speed at touchdown and insufficient runway remaining to safely bring the airplane to a stop before the end of the runway. Contributing to the…Jul 14, 2020 · N14139 · Substantial damageNTSB ANC20CA071Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Palmer, AKThe pilot's loss of control during landing, which resulted in a ground loop and left main landing gear collapse.Jul 14, 2020 · N360DC · Substantial damage