NTSB investigations

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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
  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 ERA16WA039Incident · No injuriesForeign investigationCessna 650 · Corlu, TürkiyeOn August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…Aug 1, 2015 · N692BE · Minor 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 CEN15LA333Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Watertown, WIThe total loss of engine power due to carburetor icing.Aug 1, 2015 · N1685R · 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 ENG15WA035Incident · No injuriesForeign investigationEmbraer EMB120 · Moscow, RussiaThe government of Russia has notified the NTSB of an accident involving a Embraer EMB-120ER airplane that occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…Jul 31, 2015 · VQ-BBX · Minor damageNTSB DCA15WA163Incident · No injuriesForeign investigationBoeing 737 - 4Q8 · St Georges sur Meuse, BelgiumThe Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…Jul 31, 2015 · TC-TLE · Minor damageNTSB CEN15WA420Accident · 4 fatalForeign investigationEmbraer EMB505 · Blackbushe Airport, United KingdomOn July 31, 2015, at 1408 universal coordinated time (UTC), a Embraer EMB-505, Phenom 300, airplane, registered HZ-IBN, impacted a terrain during landing at the Blackbushe Airport (EGLK), United Kingdom. The pilot and three passengers were fatally injured.…Jul 31, 2015 · HZ-IBN · DestroyedNTSB 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 ERA15LA291Accident · No injuriesLimited investigationFinal reportSontonastaso Mosquito · Winchendon, MAA partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.Jul 29, 2015 · N285XE · Substantial damageNTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…Jul 29, 2015 · N8806B · 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 DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…Jul 27, 2015 · B-HUL · Minor damageNTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…Jul 27, 2015 · PK-GRC · No damageNTSB 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 WPR15LA234Accident · No injuriesLimited investigationFinal reportCessna 180J · Dixie, IDThe failure of the right brake hydraulic line during taxi due to fatigue, which caused a loss of hydraulic fluid and rendered the brake inoperative.Jul 26, 2015 · N52095 · Substantial damageNTSB 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 ERA15LA283Accident · Minor injuriesLimited investigationFinal reportCessna 195A · Iuka, MSA total loss of engine power for reasons that could not be determined because a postaccident examination of the engine and fuel system found no mechanical anomalies that would have precluded normal operation.Jul 26, 2015 · N195AP · 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 ANC15WA061Accident · 1 fatalForeign investigationCessna 182 · Seibert Lake, CanadaOn July 26, 2015, about 1738 mountain daylight time, a Cessna 182 airplane, C-FWVQ, impacted terrain shortly after takeoff from Seibert Lake, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…Jul 26, 2015 · C-FWVQNTSB ANC15WA060Accident · 3 fatalForeign investigationPiper PA46 - 350P · Tokyo, JapanOn July 26, 2015, at 0200 coordinated universal time, a Japanese registered Piper PA46-350P airplane, JA4060, operated by a private individual, impacted a residential area shortly after takeoff from Chofu Airfield, Tokyo, Japan. The pilot, one passenger, and…Jul 26, 2015 · JA4060 · DestroyedNTSB WPR15LA223Accident · No injuriesLimited investigationFinal reportStinson 108 - 3 · North Las Vegas, NVThe partial loss of engine power due to a degraded cylinder exhaust valve seal, which resulted in low cylinder compression.Jul 25, 2015 · N6152M · 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 CEN15WA358Incident · No injuriesForeign investigationRobinson Helicopter Robinson R44 · Leixlip, IrelandJul 25, 2015 · G-OCON · 2 aircraft · No damageNTSB CEN15WA317Accident · 1 fatalForeign investigationCox Bede BD-5G · Garranbane, IrelandOn July 25, 2015, at 1745 universal coordinated time (UTC), a Cox model Bede BD-5G amateur-built airplane, Irish registration EI-DNN, serial number HJC4523, was destroyed during a postimpact fire following a forced landing near Garranbane, Ireland. The pilot,…Jul 25, 2015 · EI-DNN · DestroyedNTSB 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 ERA15LA280Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369FF · Vega Baja, PRA total loss of engine power due to insufficient lubrication to the engine's No. 2 bearing, which resulted in the failure of the bearing and a subsequent forced landing.Jul 24, 2015 · N5842Z · Substantial damageNTSB CEN15RA446Incident · No injuriesForeign investigationCessna 525 · Geneva, SwitzerlandJul 24, 2015 · N990FV · 2 aircraft · No damageNTSB CEN15LA322Accident · No injuriesLimited investigationFinal reportBell 47G 4A · Gilbert, IAThe total loss of engine power due to fuel starvation because the available fuel shifted within the tanks due to an abrupt nose-low maneuver to avoid an obstacle, which resulted in a hard forced landing.Jul 24, 2015 · N1396X · 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 damage