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 GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.Aug 2, 2015 · N5142U · Substantial damageNTSB ERA15CA295Accident · No injuriesData collectionFinal reportStol JA30 Superstol · West Union, SCA loss of engine power while maneuvering due to water contamination in the fuel.Aug 2, 2015 · N556TW · Substantial damageNTSB CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 2, 2015 · N5033U · Substantial damageNTSB CEN15LA334Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Chicago, ILAn encounter with a wind gust during ground maneuvering and the captain’s improper flight control positioning to account for wind conditions, which resulted in the airplane being blown onto its left wing.Aug 2, 2015 · N942AC · Substantial damageNTSB CEN15CA340Accident · Serious injuriesData collectionFinal reportThunder & Colt AX8 105S2 · Albuquerque, NMThe pilot did not properly brace herself during the landing, which resulted in a broken ankle and leg.Aug 2, 2015 · N787TC · No damageNTSB WPR15LA226Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 12-m · Selma, CAThe pilot receiving instruction's use of an excessive pitch attitude during takeoff with the airplane near its maximum gross weight in hot and humid conditions, which degraded the airplane’s climb performance and resulted in a collision with obstacles during…Aug 1, 2015 · N49153 · Substantial damageNTSB WPR15FA227Accident · 1 fatalField investigationFinal reportCessna P337G · Santa Paula, CAThe noninstrument-rated pilot's decision to conduct a visual flight in instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.Aug 1, 2015 · N4CU · Substantial damageNTSB ERA15LA294Accident · No injuriesLimited investigationFinal reportCommander 114 · Reading, PAThe improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.Aug 1, 2015 · N6566D · Substantial damageNTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.Aug 1, 2015 · N502LH · Substantial damageNTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.Aug 1, 2015 · N6007N · Substantial damageNTSB GAA15LA225Accident · Serious injuriesLimited investigationFinal reportUltramagic N250 - NO Series · Peoria, AZThe pilot's failure to ensure that the passengers remained secure in the basket during deflation after landing, which resulted in a passenger falling out of the basket and sustaining a serious injury when a wind gust caught the envelope and tipped the basket…Jul 31, 2015 · N57EX · No damageNTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…Jul 31, 2015 · N963X · Substantial damageNTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…Jul 31, 2015 · N55J · DestroyedNTSB GAA15CA209Accident · No injuriesData collectionFinal reportBellanca 17 30A · Tallahassee, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a forced landing on a road where the left wing impacted vegetation and sustained substantial damage.Jul 30, 2015 · N93582 · Substantial damageNTSB GAA15CA210Accident · No injuriesData collectionFinal reportExperimental Amat Built Kitfox III · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with terrain.Jul 29, 2015 · N991RK · Substantial damageNTSB GAA15CA204Accident · Minor injuriesData collectionFinal reportAirbus AS350-B2 · Tucson, AZThe flight instructor's misperception of the helicopter's altitude in relation to the runway surface during a low altitude maneuver, resulting in ground impact.Jul 29, 2015 · N6095U · Substantial damageNTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…Jul 29, 2015 · N425KJ · DestroyedNTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…Jul 28, 2015 · N3FC · Substantial damageNTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…Jul 27, 2015 · N988RH · DestroyedNTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 27, 2015 · N9CB · DestroyedNTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.Jul 26, 2015 · N299CB · Substantial damageNTSB GAA15CA198Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Eufaula, ALThe pilot's failure to maintain direction control during takeoff, and the pilot's failure to ensure that the canopy of the airplane was secured and locked prior to departure.Jul 26, 2015 · N804EV · Substantial damageNTSB CEN15FA316Accident · 2 fatalField investigationFinal reportBeech V35B · Colbert, OKThe pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…Jul 26, 2015 · N252G · Substantial damageNTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…Jul 25, 2015 · N1650X · Substantial damageNTSB GAA15CA205Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Shelter Island, NYThe pilot's failure to maintain pitch control during the landing roll, resulting in a nose over.Jul 25, 2015 · N5820V · Substantial damageNTSB GAA15CA202Accident · Minor injuriesData collectionFinal reportBell 47G · De Queen, ARThe pilot's failure to conduct helicopter performance planning, which resulted in an uncontrolled descent and impact with a truck and terrain during takeoff from an elevated platform.Jul 25, 2015 · N1420W · Substantial damageNTSB ERA15LA286Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Poughkeepsie, NYA leaking fuel discharge fitting, which resulted in a partial loss of engine power and an off-airport, gear-up landing.Jul 25, 2015 · N6677D · Substantial damageNTSB ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…Jul 25, 2015 · N777EX · Substantial damageNTSB ERA15LA281Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Albertson, NCThe pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.Jul 25, 2015 · N731MB · Substantial damageNTSB ERA15CA307Accident · Minor injuriesData collectionFinal reportJohnny F Anderson Buckeye Dream Machin · Trenton, SCThe non-certificated pilot's inadequate preflight inspection, which resulted in a loss of directional control during takeoff, and collision with trees during the subsequent rejected takeoff.Jul 25, 2015 · N371P · Substantial damageNTSB CEN15LA318Accident · 1 fatalLimited investigationFinal reportPiper PA38 - 112 · Millbury, OHA loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.Jul 25, 2015 · C-GTAO · Substantial damageNTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…Jul 25, 2015 · N9601 · Substantial damageNTSB ERA15LA292Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Baltimore, MDThe flight crew's failure to visually ensure that the cabin door locking pin was in place before takeoff.Jul 24, 2015 · N765A · Substantial damageNTSB ERA15LA287Accident · Minor injuriesLimited investigationFinal reportPiper J3C 65 · Southside, WVThe pilot’s exhaustion of the airplane’s fuel supply, which resulted in a total loss of engine power. Contributing to the outcome was the pilot’s failure to secure the engine before the forced landing.Jul 24, 2015 · N92653 · Substantial damageNTSB CEN15FA325Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Truth or Consequences, NMThe student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.Jul 24, 2015 · N32401 · Substantial damageNTSB ANC15LA057Accident · No injuriesLimited investigationFinal reportFound Acft Canada FBA 2C1 · Cold Bay, AKThe pilot's failure to maintain adequate distance from surrounding terrain during the takeoff sequence, which resulted in the airplane contacting the terrain, prematurely becoming airborne, and subsequently entering an aerodynamic stall.Jul 24, 2015 · N798 · Substantial damageNTSB ANC15CA055Accident · No injuriesData collectionFinal reportChampion 7GCBC · Skweetna, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.Jul 24, 2015 · N3085G · Substantial damageNTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.Jul 23, 2015 · N704SB · Substantial damageNTSB GAA15CA208Accident · No injuriesData collectionFinal reportCessna 172R · North Vernon, INThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.Jul 23, 2015 · N133VU · Substantial damageNTSB GAA15CA203Accident · No injuriesData collectionFinal reportWelch Floyd L Quickie Q 2 · Hazleton, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.Jul 23, 2015 · N518JW · Substantial damageNTSB GAA15CA201Accident · No injuriesData collectionFinal reportAeronca 7BCM · Warsaw, MOThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.Jul 23, 2015 · N81686 · Substantial damageNTSB GAA15CA200Accident · No injuriesData collectionFinal reportRobinson Helicopter R-22 · Corona, CAThe flight instructor's delayed remedial action to arrest the descent rate, which resulted in a running landing, the left skid catching rough terrain, and the main rotor blades impacting the ground.Jul 23, 2015 · N520NS · Substantial damageNTSB ERA15LA282Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · Waynesboro, VAThe pilot's early rotation of the airplane and his failure to attain a positive climb rate during takeoff with the airplane near its aft center of gravity limit from a runway with little margin for error.Jul 23, 2015 · N91418 · Substantial damageNTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.Jul 23, 2015 · N5542M · Substantial damageNTSB ANC15CA052Accident · No injuriesData collectionFinal reportCessna 182 · Wasilla, AKThe pilot's failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.Jul 23, 2015 · N5722B · Substantial damageNTSB GAA15CA194Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Monte Vista, COThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with objects.Jul 22, 2015 · N402KN · Substantial damageNTSB ERA15LA288Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · West Palm Beach, FLThe flight crew's failure to properly use the before start checklist, to monitor the airplane's motion, and to see and avoid objects around the airplane, which resulted in an inadvertent roll into a ground vehicle.Jul 22, 2015 · N613PJ · Substantial damageNTSB ERA15FA277Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Lake Wales, FLA partial loss of engine power due to oil starvation. Contributing was the flight instructor's failure to maintain control of the airplane during an aborted emergency landing, and his delayed decision to deploy the airplane's parachute system.Jul 22, 2015 · N610DA · DestroyedNTSB CEN15LA313Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Perry, OKThe pilot's incapacitation and subsequent loss of airplane control due to heat exhaustion.Jul 22, 2015 · N2789K · Substantial damageNTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…Jul 22, 2015 · N4BP · Substantial damage