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 WPR14LA343Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Rimrock, AZThe pilot's failure to maintain control of the airplane during the landing roll on a wet sloping runway and his decision to go around before the airplane was configured for takeoff.Aug 13, 2014 · N7786M · Substantial damageNTSB WPR14CA344Accident · No injuriesData collectionFinal reportCessna 177 · Pine Bluffs, WYThe pilot's inadequate flare and failure to maintain aircraft control while landing.Aug 13, 2014 · N2830X · Substantial damageNTSB CEN14LA432Accident · No injuriesLimited investigationFinal reportCessna 188 - Undesignat · Columbus, NMThe pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…Aug 13, 2014 · N9849V · Substantial damageNTSB CEN14LA425Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Braithwaite, LAThe pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.Aug 13, 2014 · N2272X · Substantial damageNTSB CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.Aug 13, 2014 · N9071Z · Substantial damageNTSB CEN14CA426Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Lancaster, WIThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during an aerial application flight.Aug 13, 2014 · N8343P · Substantial damageNTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Aug 12, 2014 · N18GH · Substantial damageNTSB ERA14LA383Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S · Sarasota, FLA total loss of engine power due to fuel exhaustion, which resulted from the flight instructor's inadequate preflight fuel planning.Aug 12, 2014 · N50XV · Substantial damageNTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.Aug 12, 2014 · N7089J · Substantial damageNTSB WPR14LA340Accident · No injuriesLimited investigationFinal reportHughes 269C · Darrington, WAMaintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.Aug 11, 2014 · N7432F · Substantial damageNTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.Aug 11, 2014 · N178SB · Substantial damageNTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.Aug 11, 2014 · N214EV · Substantial damageNTSB ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.Aug 11, 2014 · N8979D · Substantial damageNTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…Aug 10, 2014 · N214MJ · Substantial damageNTSB ERA14CA438Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Block Island, RIA loss of control during the attempted go-around, which resulted in an aerodynamic stall and impact with trees.Aug 10, 2014 · N2149F · Substantial damageNTSB CEN14LA431Accident · Serious injuriesLimited investigationFinal reportAeronca S11AC · Boulder Junction, WIThe pilot’s improper runway selection, which resulted in a tailwind landing, and his subsequent failure to maintain directional control.Aug 10, 2014 · N4240E · Substantial damageNTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.Aug 10, 2014 · N4690 · DestroyedNTSB CEN14CA482Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Bremond, TXMismanagement of fuel, which resulted in a total loss of power due to fuel starvation.Aug 10, 2014 · N5812K · Substantial damageNTSB ANC14FA062Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Big Lake, AKThe pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from trees.Aug 10, 2014 · N5158P · Substantial damageNTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.Aug 9, 2014 · N910MK · Substantial damageNTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.Aug 9, 2014 · N7968Z · DestroyedNTSB ERA14CA400Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Stow, MAThe flight instructor/pilot's failure to recover from a bounced landing, which resulted in a hard landing and the subsequent collapse of the nose landing gear. Contributing to the accident was the flight instructor's lack of total experience in the make and…Aug 9, 2014 · N497PA · Substantial damageNTSB ERA14CA379Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Lakeville, NYThe pilot's decision to favor the right side of the relatively narrow turf runway while landing, resulting in inadvertent contact with tall grass and a berm.Aug 9, 2014 · N893DC · Substantial damageNTSB CEN14LA430Accident · No injuriesLimited investigationFinal reportBombardier CL600 2D24 - 900 · San Antonio, TXFailure of the tow bar shear pin, which resulted in the tug operator’s loss of control of the airplane during pushback operations. Contributing to the accident was the tug operator’s inability to communicate to the flight crew to apply the airplane’s brakes.Aug 9, 2014 · N943LR · Substantial damageNTSB CEN14LA424Accident · 2 fatalLimited investigationFinal reportBarger Steve M RV-7A · Russell, IAThe noninstrument-rated pilot’s inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.Aug 9, 2014 · N92BF · DestroyedNTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…Aug 9, 2014 · N3509M · Substantial damageNTSB WPR14CA339Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Lysite, WYThe pilot's failure to ensure the airplane was configured for takeoff.Aug 8, 2014 · N1765P · Substantial damageNTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.Aug 8, 2014 · N526FL · Substantial damageNTSB WPR14CA332Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Apple Valley, CAThe pilot's failure to adequately secure the airplane while hand-starting the engine.Aug 8, 2014 · N12DF · Substantial damageNTSB CEN14TA421Accident · Minor injuriesFinal reportPiper PA 28-180 · Sulphur, LAThe pilot’s failure to properly manage the airplane’s fuel supply, which led to fuel starvation and a total loss of engine power.Aug 8, 2014 · N4286T · Substantial damageNTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.Aug 6, 2014 · N212RW · Substantial damageNTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…Aug 6, 2014 · N9400E · Substantial damageNTSB CEN14CA413Accident · Minor injuriesData collectionFinal reportPhantom Phantom X 1 · Three Rivers, MIThe pilot did not maintain adequate airspeed while flying a visual pattern, which resulted in an aerodynamic stall and subsequent loss of control.Aug 6, 2014 · N2552S · Substantial damageNTSB CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.Aug 6, 2014 · N1615 · Substantial damageNTSB ANC14CA060Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Anderson, AKThe pilot's inadequate compensation for wind conditions, which resulted in a hard landing.Aug 6, 2014 · N3502W · Substantial damageNTSB WPR14LA329Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S 2B · Oceanside, CAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate fuel planning.Aug 5, 2014 · N88EW · Substantial damageNTSB WPR14LA327Accident · Serious injuriesLimited investigationFinal reportDavid L Thompson Challenger II · Winterhaven, CAA total loss of engine power during cruise for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s loss of control during the forced landing.Aug 5, 2014 · N518DT · Substantial damageNTSB WPR14FA330Accident · 2 fatalField investigationFinal reportDavid Fitzgerald Zenith · Warren, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.Aug 5, 2014 · N32FZ · DestroyedNTSB CEN14LA446Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 - D · Burnet, TXThe flight instructor’s failure to adequately supervise the student pilot and his decision to conduct training in an airplane without dual brakes, which resulted in the student pilot’s loss of directional control during initial taxi and subsequent impact with…Aug 5, 2014 · N44335 · Substantial damageNTSB ERA14CA385Accident · No injuriesData collectionFinal reportCote James Rans S 6S · New Berlin, PAThe passenger's inadvertent interference with the rudder controls during the takeoff.Aug 4, 2014 · N502CW · Substantial damageNTSB WPR14CA326Accident · No injuriesData collectionFinal reportPiper PA20 - Undesignat · Dayton, ORThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.Aug 3, 2014 · N7462K · Substantial damageNTSB CEN14CA428Accident · Minor injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Frankfort, MIThe pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.Aug 3, 2014 · N80AM · Substantial damageNTSB WPR14CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and failure to maintain aircraft control during taxi, which resulted in a loss of tail rotor effectiveness and subsequent impact with the taxiway and a parked fuel truck.Aug 2, 2014 · N110JC · Substantial damageNTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.Aug 2, 2014 · N1DZ · DestroyedNTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.Aug 2, 2014 · N472ST · Substantial damageNTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.Aug 2, 2014 · N4118X · Substantial damageNTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.Aug 2, 2014 · N6257W · Substantial damageNTSB ANC14CA059Accident · No injuriesData collectionFinal reportSteven R Mcneese Airborne Edge X · Palmer, AKThe non-certificated pilot's failure to maintain directional control while performing a high speed taxi test and inadvertent lift-off, which resulted in an inflight collision with trees and terrain.Aug 2, 2014 · N821AK · Substantial damageNTSB WPR14LA323Accident · No injuriesLimited investigationFinal reportRans S-16 · Fort Bridger, WYThe fuel flow divider inlet line’s B-nut coming loose during takeoff, resulting in a total loss of engine power. Contributing to the accident was the pilot's failure to adequately tighten the B-nut during recent maintenance.Aug 1, 2014 · N116GS · Substantial damageNTSB WPR14LA322Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Tulelake, CAThe pilot's failure to maintain clearance from power lines while maneuvering during low-altitude operations.Aug 1, 2014 · N3627R · Destroyed