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 CEN21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Spearfish, SDThe snowplow driver’s failure to see the airplane which resulted in a collision with the airplane.Oct 18, 2020 · N97875 · Substantial damageNTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.Oct 18, 2020 · N31136 · Substantial damageNTSB CEN21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Columbus, MSThe pilot’s failure to maintain directional control during a touch-and-go landing.Oct 17, 2020 · N26481 · Substantial damageNTSB WPR21LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson R44 · Pahrump, NVThe pilot’s failure to maintain helicopter control while hovering low over a body a water while facing into the sun, which resulted in a loss of visual reference and subsequent impact with the lake surface.Oct 16, 2020 · N500DL · Substantial damageNTSB ERA21LA023Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Zephyrhills, FLImproper torquing of the “B” nut at the fuel control unit, which led to a total loss of engine power and subsequent autorotation that resulted in substantial damage.Oct 16, 2020 · N777CP · Substantial damageNTSB CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2020 · N15608 · Substantial damageNTSB WPR21LA015Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · South Hill, WAThe pilot’s failure to ensure that the fuel supply had been completely drained of water, which resulted in a partial loss of engine power during takeoff due to water contamination.Oct 15, 2020 · N6585L · Substantial damageNTSB ERA21LA022Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moneta, VAThe fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.Oct 14, 2020 · N7532E · Substantial damageNTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.Oct 14, 2020 · N631PF · Substantial damageNTSB ERA21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Williston, FLThe pilot’s improper landing flare, which resulted in a hard landing.Oct 13, 2020 · N6158G · Substantial damageNTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…Oct 13, 2020 · N47KC · DestroyedNTSB ERA21LA018Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH801 · Apison, TNA total loss of engine power due to fuel starvation, as a result of an incorrectly placarded fuel selector.Oct 12, 2020 · N801TP · Substantial damageNTSB WPR21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Bishop, CAA loss of engine power due to the pilot’s inadvertent closure of the mixture control which starved the engine of fuel and resulted in a hard landing and collision with terrain.Oct 11, 2020 · N22963 · Substantial damageNTSB ERA21LA017Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Navion · Palmetto, FLThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions, which led to a runway excursion.Oct 11, 2020 · N8698H · DestroyedNTSB ERA21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportEnstrom 480 · Woodstock, CTThe pilot’s failure to maintain control of the helicopter while attempting to land on a trailer in gusting wind conditions, which resulted in a dynamic rollover.Oct 10, 2020 · N899RT · Substantial damageNTSB ERA21LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Friendly, MDThe pilot’s failure to maintain control of the airplane during an aborted landing and the flight instructor’s inadequate remedial action.Oct 10, 2020 · N155TE · Substantial damageNTSB CEN21LA014Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA32R · Kimberling City, MOThe pilot’s inadequate preflight inspection, which resulted in his inadvertent departure with the tow bar connected to the nose wheel, and the low approach while returning to the airport, which allowed the tow bar to contact trees.Oct 10, 2020 · N3445Q · DestroyedNTSB ANC21LA001Accident · No injuriesClass 4 · LimitedFinal reportDouglas C54 · Yakataga, AKThe pilots’ decision to land on a wet, soft runway, which resulted in the loss of braking action upon landing and a subsequent runway overrun and nose landing gear collapse.Oct 10, 2020 · N96358 · Substantial damageNTSB WPR21LA013Accident · No injuriesClass 4 · LimitedFinal reportRalph C Kimball Sea Rey · Parker Dam, CAThe inadvertent encounter with water wake during the takeoff sequence that degraded the airplane’s airspeed and resulted in the pilot’s failure to maintain clearance from obstacles during the initial climb.Oct 9, 2020 · N32RK · Substantial damageNTSB ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.Oct 8, 2020 · N227PF · Substantial damageNTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.Oct 8, 2020 · N8788D · Substantial damageNTSB ERA21LA011Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · West Palm Beach, FLThe pilot’s inadequate preflight inspection during which he failed to detect a flight control abnormality, and his failure to expediently abort the takeoff, which resulted in the co-pilot performing a delayed aborted takeoff and the subsequent runway overrun.Oct 8, 2020 · N8132Q · Substantial damageNTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.Oct 7, 2020 · N251SC · Substantial damageNTSB CEN21LA033Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe improper installation of a clevis pin in the rudder system which led to a loss of directional control during landing.Oct 7, 2020 · N790L · Substantial damageNTSB CEN21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportKjostad Jorgen A Wagabond · New Richmond, WIThe pilot's failure to maintain directional control on landing, which resulted in a runway excursion and subsequent nose-over. Contributing was the pilot’s lack of experience in the accident airplane.Oct 7, 2020 · N744K · Substantial damageNTSB WPR21LA033Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Minden, NVThe student pilot’s improper application of the airbrakes during final approach, which resulted in a landing area undershoot and subsequent hard, bounced landing.Oct 6, 2020 · N684KS · Substantial damageNTSB WPR21LA011Accident · 1 fatalClass 3 · LimitedFinal reportRans S-7 · Spirit Lake, IDThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 6, 2020 · N55893 · Substantial damageNTSB CEN21LA008Accident · 2 fatalClass 3 · LimitedFinal reportStephens William E Quicksilver MXL-2 Sport · Mount Vernon, INThe pilot’s exceedance of the airplane’s critical angle of attack during an aerobatic maneuver, which resulted in an aerodynamic stall and spin and loss of control. Contributing to the accident was the pilot’s decision to perform aerobatic maneuvers in an…Oct 6, 2020 · N2942A · Substantial damageNTSB WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.Oct 5, 2020 · N22979 · Substantial damageNTSB ERA21LA007Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 8KCAB · Ellijay, GAThe pilot's improper landing flare which resulted in a bounced landing and a subsequent noseover.Oct 5, 2020 · N787AC · Substantial damageNTSB CEN21LA050Accident · No injuriesClass 4 · LimitedFinal reportBellanca 1730 · San Saba, TXThe student pilot’s improper decision-making, which resulted in a total loss of engine power due to fuel starvation.Oct 5, 2020 · N7333V · Substantial damageNTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.Oct 5, 2020 · N3370E · Substantial damageNTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.Oct 5, 2020 · N4444K · Substantial damageNTSB WPR21LA006Accident · No injuriesClass 4 · LimitedFinal reportCapella XLS · Firth, IDThe pilot's failure to maintain adequate airspeed during the landing flare which resulted in an aerodynamic stall and collision with the ground.Oct 4, 2020 · N7143A · Substantial damageNTSB WPR21LA003Accident · 1 fatalClass 3 · LimitedFinal reportEvolution Revo · Hawthorne, CAThe pilot’s failure to maintain aircraft control during takeoff.Oct 4, 2020 · N449WB · Substantial damageNTSB ERA21LA006Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Fulton, NYThe mechanic’s improper maintenance, which resulted in the crankshaft expansion plug dislodging in flight and a subsequent forced landing.Oct 4, 2020 · N6179U · Substantial damageNTSB ERA21LA004Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Beechhurst, NYThe pilot’s selection of a landing area that provided inadequate distance from obstacles and his subsequent decision to abort the landing with inadequate takeoff distance available, which resulted in a high-speed collision with a concrete bulkhead.…Oct 4, 2020 · N6506M · Substantial damageNTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.Oct 4, 2020 · N912RE · Substantial damageNTSB CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.Oct 4, 2020 · N5196S · Substantial damageNTSB ERA21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 23 · Spruce Pines, NCThe pilot's failure to familiarize himself with the wind conditions at the destination airport and his failure to attain the proper touchdown point during landing, which resulted in a long, tailwind landing and subsequent runway overrun.Oct 3, 2020 · N8783M · Substantial damageNTSB ERA21LA008Accident · No injuriesClass 3 · LimitedFinal reportExperimental Quad City Challenger II · Northfield, NHA total loss of engine power due to oil starvation of the No. 1 cylinder. Contributing to the accident was the pinched No. 1 cylinder oil injection line.Oct 3, 2020 · N129AY · Substantial damageNTSB WPR21LA008Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Princeton, ORThe pilot’s failure to enrichen the mixture, which resulted in a partial loss of engine power.Oct 2, 2020 · N8678X · Substantial damageNTSB ERA21LA003Accident · 2 fatalClass 3 · LimitedFinal reportSocata TBM700 · Corfu, NYThe pilot’s failure to maintain control of the airplane for undetermined reasons during the descent to the destination airport.Oct 2, 2020 · N965DM · DestroyedNTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.Oct 2, 2020 · N656V · Substantial damageNTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.Oct 2, 2020 · N4540F · Substantial damageNTSB ANC20LA100Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Tok, AKThe mechanic’s failure to properly repair the tailwheel, which resulted in a malfunction of the tailwheel and a loss of directional control.Oct 1, 2020 · N926LL · Substantial damageNTSB WPR20LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Oregon City, ORThe pilot’s improper landing flare which resulted in a bounced landing, loss of directional control and subsequent collision with a hangar.Sep 30, 2020 · N5397S · Substantial damageNTSB CEN20LA427Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Hinckley, ILThe pilot’s improper control input during a bounced landing that resulted in the glider impacting terrain.Sep 29, 2020 · N721WC · Substantial damageNTSB CEN20LA425Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Spring, TXThe student pilot’s failure to maintain airplane control during climb and subsequent impact with terrain.Sep 29, 2020 · N75634 · Substantial damageNTSB CEN20LA421Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Lago Vista, TXThe pilot’s mismanagement of the fuel system which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to maintain airspeed which resulted in the airplane exceeding its critical angle of attack…Sep 28, 2020 · N104RK · Substantial damage