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 ERA21LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Eufaula, ALA total loss of engine power for reasons that could not be determined based on the available information.Apr 20, 2021 · N91606 · Substantial damageNTSB CEN21LA210Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons 2010 Firefly 12B-010 · Pagosa Springs, COThe pilot’s failure to properly control the balloon during a steep approach that resulted in a hard landing and a serious passenger injury.Apr 20, 2021 · N3016R · No damageNTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.Apr 19, 2021 · N28249 · Substantial damageNTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.Apr 18, 2021 · N83359 · Substantial damageNTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.Apr 17, 2021 · N886T · Substantial damageNTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.Apr 17, 2021 · N51080 · Substantial damageNTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…Apr 17, 2021 · N707PH · Substantial damageNTSB CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.Apr 17, 2021 · N19D · Substantial damageNTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Apr 17, 2021 · N22005 · Substantial damageNTSB WPR21LA166Accident · 2 fatalClass 3 · LimitedFinal reportCessna 140 · Williams, AZThe pilot’s loss of control due to spatial disorientation shortly after takeoff in night visual meteorological conditions.Apr 16, 2021 · N2506N · Substantial damageNTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.Apr 16, 2021 · N797RT · Substantial damageNTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.Apr 16, 2021 · N991AK · Substantial damageNTSB WPR21LA176Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV4 · Oljato-Monument Valley, UTThe pilot’s failure to maintain airplane control while compensating for a downdraft during landing, which resulted in the airplane touching down short of the runway on soft terrain and nosing over.Apr 15, 2021 · N345DL · Substantial damageNTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Apr 15, 2021 · N3551Z · Substantial damageNTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.Apr 15, 2021 · N3023M · Substantial damageNTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.Apr 15, 2021 · N731TB · Substantial damageNTSB CEN21LA190Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Colorado Springs, COThe flight crew’s improper decision to continue the unstabilized approach, which resulted in an aerodynamic stall and impact with the runway during landing.Apr 15, 2021 · N354EF · Substantial damageNTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.Apr 14, 2021 · N51380 · Substantial damageNTSB ERA21FA184Accident · 1 fatalClass 3 · FieldFinal reportCessna A188 · Pineview, GAThe pilot’s inadequate visual lookout, which resulted in collision with powerlines during an aerial application flight.Apr 13, 2021 · N4912Q · DestroyedNTSB WPR21LA174Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Silver City, NMThe pilot’s loss of situational awareness and failure to touchdown on the runway which resulted in a collision with the airport’s perimeter fence.Apr 12, 2021 · N222BM · Substantial damageNTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.Apr 12, 2021 · N7242F · Substantial damageNTSB ERA21LA182Accident · No injuriesClass 4 · LimitedFinal reportRowe Dennis A Highlander · Bluefield, WVThe pilot’s failure to maintain directional control while landing in a gusty crosswind, which resulted in a ground loop.Apr 10, 2021 · N257DR · Substantial damageNTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.Apr 10, 2021 · N439WT · Substantial damageNTSB ERA21LA181Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Stockbridge, GAThe flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.Apr 9, 2021 · N1664H · Substantial damageNTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…Apr 9, 2021 · N421PB · Substantial damageNTSB ERA21FA178Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Great Valley, NYThe pilot’s failure to maintain control during takeoff.Apr 7, 2021 · N24RG · DestroyedNTSB CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.Apr 7, 2021 · N21175 · Substantial damageNTSB ANC21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Lime Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a landing gear collapse.Apr 7, 2021 · N1291D · Substantial damageNTSB ERA21LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Orangeburg, SCThe student pilot’s improper recovery from a bounced landing, which resulted in a hard landing.Apr 6, 2021 · N22467 · Substantial damageNTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.Apr 6, 2021 · N61EF · Substantial damageNTSB ERA21LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Fayetteville, NCThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.Apr 6, 2021 · N5424R · Substantial damageNTSB CEN21LA181Accident · 1 fatalClass 3 · LimitedFinal reportEvolution Revolt · Seminole, TXThe student pilot’s loss of trike control while maneuvering at low altitude in gusting wind conditions, resulting in an impact with terrain.Apr 6, 2021 · N565PK · Substantial damageNTSB ERA21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23-250 · Springfield, TNThe flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…Apr 5, 2021 · N5018Y · Substantial damageNTSB CEN21LA184Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Johnson, KSThe pilot's inadequate pedal application during a transition to hover, which resulted in a loss of yaw control and a subsequent impact with terrain.Apr 5, 2021 · N8348X · Substantial damageNTSB CEN21LA183Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MT7 · Jewett, TXThe pilot’s failure to maintain control of the airplane after it struck a hidden berm during the intentional off-airport landing, which resulted in a hard landing.Apr 5, 2021 · N811SG · Substantial damageNTSB ERA21LA172Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics Phantom II · McBee, SCThe pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.Apr 4, 2021 · UNREG · Substantial damageNTSB CEN21LA179Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny Powered Parachutes 2000 · Saint Paul, NEThe uncertificated pilot’s failure to maintain control of the powered parachute during low altitude flight in gusting wind conditions.Apr 4, 2021 · UNREG · Substantial damageNTSB WPR21LA153Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Sand Point, IDThe student pilot’s improper landing flare which resulted in a hard landing, loss of directional control and subsequent nose over.Apr 3, 2021 · N7616X · Substantial damageNTSB ERA21LA171Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R66 · Palmyra, PAThe pilot’s improper judgment to attempt a flight while impaired by medications, which resulted in the helicopter’s abnormal ground contact, loss of control, and collision with terrain.Apr 3, 2021 · N577DD · Substantial damageNTSB ERA21LA170Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · College Park, MDImproper maintenance of the airplane by its owners and their failure to have qualified maintenance personnel determine the root cause of water infiltration into the fuel system. Also causal was the pilot’s inadequate preflight inspection, which failed to…Apr 3, 2021 · N2953L · Substantial damageNTSB CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.Apr 3, 2021 · N1522C · Substantial damageNTSB CEN21FA177Accident · 1 fatalClass 3 · FieldFinal reportMagnus Fusion 212 · Conifer, COThe pilot’s decision to fly at low altitude toward a mountainous canyon, and his exceedance of the airplane’s critical angle of attack while maneuvering to avoid rising terrain, which resulted in an aerodynamic stall and loss of airplane control.Apr 3, 2021 · N434MA · Substantial damageNTSB CEN21LA182Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Denver, COThe pilot’s loss of situational awareness, and his unintended landing on a soft unimproved dirt road, which resulted in a loss of directional control into soft ground and the airplane to subsequently nose over.Apr 2, 2021 · N4802 · Substantial damageNTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…Apr 1, 2021 · N7274F · Substantial damageNTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.Mar 31, 2021 · N13632 · Substantial damageNTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.Mar 31, 2021 · N3299X · DestroyedNTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.Mar 30, 2021 · N6544G · Substantial damageNTSB WPR21LA149Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Port Townsend, WAThe pilot’s inadequate engine hand propping procedure which resulted in the airplane’s unexpected movement and subsequent impact with a fueling station.Mar 29, 2021 · N28461 · Substantial damageNTSB ERA21FA165Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1 · Cave Spring, GAThe pilot's inadequate visual lookout and failure to maintain clearance from a power line.Mar 29, 2021 · N800MH · Substantial damageNTSB WPR21LA146Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Watsonville, CAThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.Mar 28, 2021 · N656DF · Substantial damage