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 CEN20CA074Accident · No injuriesData collectionFinal reportPiper PA32 · Kingfisher, OKThe pilot's improper continuation of a landing in which he landed too far down the runway at too high a speed, which resulted in a loss of directional control and a runway excursion.Feb 3, 2020 · N711PF · Substantial damageNTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.Feb 2, 2020 · N309MA · Substantial damageNTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeFeb 2, 2020 · N5969W · Substantial damageNTSB ERA20CA093Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.Jan 31, 2020 · N739XT · Substantial damageNTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.Jan 30, 2020 · N7047W · Substantial damageNTSB ANC20CA016Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Big Lake, AKThe pilot's failure to apply full carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power, a forced landing, and impact with a tree.Jan 30, 2020 · N19524 · Substantial damageNTSB CEN20TA071Accident · Minor injuriesClass 3Final reportBeech 60 · Big Spring, TXA total loss of engine power in both engines due to fuel exhaustion, which resulted in a landing short of the runway.Jan 29, 2020 · N50JR · Substantial damageNTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.Jan 29, 2020 · N425GZ · Substantial damageNTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.Jan 28, 2020 · N6071R · DestroyedNTSB WPR20CA085Accident · No injuriesData collectionFinal reportCessna 180 · Eloy, AZThe pilot's failure to maintain directional control while landing in crosswind conditions, which resulted in a ground-loop.Jan 27, 2020 · N9729B · Substantial damageNTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.Jan 27, 2020 · N214K · DestroyedNTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…Jan 26, 2020 · N72EX · DestroyedNTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.Jan 26, 2020 · N238SH · Substantial damageNTSB WPR20CA084Accident · No injuriesData collectionFinal reportCessna 150 · Prescott, AZThe pilot's improper approach and landing flare, which resulted in a stall and a subsequent hard, bounced landing.Jan 25, 2020 · N31ER · Substantial damageNTSB ERA20LA221Accident · No injuriesClass 3 · LimitedFinal reportGulfstream 150 · San Juan, PRThe pilot’s loss of control during landing on a wet runway after encountering standing water.Jan 25, 2020 · N373ML · Substantial damageNTSB ERA20LA089Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Summerland Key, FLThe pilot's failure to remove the flight control gust lock before takeoff, which resulted in an inability to rotate, aborted takeoff, and subsequent runway overrun. Contributing to the accident was a missing piece of the flight control gust lock, which did…Jan 25, 2020 · N41VK · Substantial damageNTSB ERA20FA086Accident · 2 fatalClass 3 · FieldFinal reportMustang II · Senoia, GAThe pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.Jan 25, 2020 · UNREG · DestroyedNTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.Jan 25, 2020 · N55455 · DestroyedNTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.Jan 24, 2020 · N3672K · DestroyedNTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.Jan 24, 2020 · N50249 · DestroyedNTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.Jan 24, 2020 · N130JK · Substantial damageNTSB CEN20LA066Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Charlotte, TXThe pilot's failure to maintain clearance from a powerline during landing.Jan 24, 2020 · N8364Y · Substantial damageNTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.Jan 22, 2020 · N36TT · DestroyedNTSB WPR20CA074Accident · Minor injuriesData collectionFinal reportPiper PA-18 Replica · Jean, NVThe pilot's inadvertent application of the brakes during the landing roll, which resulted in a nose-over.Jan 22, 2020 · N944KM · Substantial damageNTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.Jan 22, 2020 · N14GC · Substantial damageNTSB CEN20LA068Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Minot, NDThe pilot's failure to maintain clearance from fencing around the landing pad during landing, which resulted in the tail rotor contacting the fence.Jan 22, 2020 · N947LH · Substantial damageNTSB ERA20LA084Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Tallahassee, FLThe pilot's improper fuel planning, resulting in fuel exhaustion and a total loss of engine power in cruise flight.Jan 21, 2020 · N424WB · Substantial damageNTSB CEN20CA064Accident · Serious injuriesData collectionFinal reportGuimbal Cabri G2 · Independence, IAThe student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.Jan 21, 2020 · N715RK · Substantial damageNTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.Jan 20, 2020 · N4763X · DestroyedNTSB WPR20CA071Accident · No injuriesData collectionFinal reportCessna 172 · Sun River, ORThe pilot's failure to maintain directional control during the landing roll on a runway with icy patches, which resulted in impact with a snowbank and a subsequent nose-over.Jan 20, 2020 · N73707 · Substantial damageNTSB ERA20LA094Accident · Serious injuriesClass 3 · LimitedFinal reportAirborne America AX9-140 · Homestead, FLThe pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…Jan 19, 2020 · N970TC · Minor damageNTSB WPR20CA070Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · Gold Canyon, AZThe pilot's failure to maintain directional control during an aborted takeoff, which resulted in collision with a barricade.Jan 18, 2020 · N260AZ · Substantial damageNTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.Jan 18, 2020 · N4283V · Substantial damageNTSB CEN20LA063Accident · Serious injuriesClass 3 · LimitedFinal reportPiel CP301 · Paulding, OHThe pilot’s failure to maintain control of the airplane following the loss of engine power. The loss of engine power was the result of fuel starvation due to the degraded fuel tank and fuel contamination.Jan 17, 2020 · N4120 · DestroyedNTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…Jan 16, 2020 · N6630D · Substantial damageNTSB ANC20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 200 · Unalaska, AKThe pilot’s improper decision to takeoff downwind and to load the airplane beyond its allowable gross weight and center of gravity limits, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the inadequacy of the…Jan 16, 2020 · N547LM · Substantial damageNTSB WPR20FA065Accident · 1 fatalClass 3 · FieldFinal reportCessna T310 · Roy, UTThe pilot’s inadequate preflight fuel planning and fuel management, which resulted in a total loss of power to the left engine due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the…Jan 15, 2020 · N5805M · Substantial damageNTSB ERA20LA076Accident · Serious injuriesClass 3 · LimitedFinal reportMagni M-24 Plus · Nashua, NHThe pilot's incapacitation during the takeoff roll due to a stroke.Jan 15, 2020 · N327JD · Substantial damageNTSB ERA20CA075Accident · Minor injuriesClass 4 · Data collectionFinal reportVans Vans RV 9 · Coleman, FLThe pilot's failure to properly configure the airplane for takeoff, which resulted in premature liftoff, loss of control, and collision with terrain.Jan 15, 2020 · N235LS · Substantial damageNTSB ERA20LA077Accident · No injuriesClass 3 · LimitedFinal reportVelocity Elite RG · St. Petersburg, FLA failure of the propeller pitch change electric motor, which resulted in an improper setting for takeoff and a subsequent runway overrun. Also causal was the inadequate maintenance and inspection of the propeller system and the pilot’s failure to follow the…Jan 14, 2020 · N78BM · Substantial damageNTSB ERA20CA081Accident · Minor injuriesData collectionFinal reportPereyra Aventura · East Palatka, FLThe pilot's failure to properly configure the amphibious airplane for a water landing, which resulted in it flipping over.Jan 14, 2020 · N366RC · Substantial damageNTSB WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.Jan 13, 2020 · N805M · Substantial damageNTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.Jan 12, 2020 · N736YU · DestroyedNTSB WPR20CA087Accident · No injuriesData collectionFinal reportPiper PA28 · Santa Barbara, CAThe pilot's failure to maintain clearance from a parked airplane during taxi operations at night.Jan 12, 2020 · N8408E · Substantial damageNTSB ERA20FA074Accident · 2 fatalClass 3 · FieldFinal reportRobinson R66 · Mechanicsburg, PAA severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter.Jan 10, 2020 · N450MC · DestroyedNTSB WPR20CA066Accident · No injuriesData collectionFinal reportPiper PA 23 · Helena, MTThe pilot's improper decision to attempt an off-airport departure from rough terrain without inspecting the takeoff area, which resulted in a collision with a shallow rut during takeoff and the nose landing gear collapsing.Jan 8, 2020 · N1428P · Substantial damageNTSB ERA20CA140Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot's failure to allow adequate separation when passing the parked airplane, which resulted in a ground collision.Jan 8, 2020 · N536ND · 2 aircraft · Substantial damageNTSB DCA20CA049Accident · No injuriesData collectionFinal reportBoeing 737 · New York, NYfailure of the deicing truck driver to maintain appropriate clearance from the airplane.Jan 8, 2020 · N929NN · Substantial damageNTSB ERA20CA072Accident · Minor injuriesData collectionFinal reportBeech 23 · Norfolk, VAThe pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.Jan 7, 2020 · N24690 · Substantial damageNTSB ANC20CA012Accident · Minor injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Kapolei, HIThe student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.Jan 7, 2020 · N779LB · Substantial damage