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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA15FA076Accident · 1 fatalField investigationFinal reportTitan Tornado II · Catlett, VAThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA15LA077Accident · No injuriesLimited investigationFinal reportThomas R Wade Revelation · Ellisville, MSThe failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…NTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.NTSB DCA15CA037Accident · No injuriesData collectionFinal reportBoeing 737 · Baltimore, MDan inadvertent encounter with birds during approach to land that resulted in substantial damage.NTSB WPR15CA059Accident · Serious injuriesData collectionFinal reportCessna 182T · Wendover, UTThe pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.NTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB CEN15IA085Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Shreveport, LAA short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.NTSB CEN15IA079Incident · No injuriesIncident investigationFinal reportCessna T182T · Cahokia, ILThe mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.NTSB DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.NTSB WPR15LA058Accident · No injuriesLimited investigationFinal reportMcholland Glastar · Sheridan, WYA loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.NTSB CEN15IA076Incident · No injuriesIncident investigationFinal reportCessna 182S · Springfield, ILThe improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.NTSB WPR15CA057Accident · Minor injuriesData collectionFinal reportCessna P210 - N · Jeffrey, WYThe pilot's inadequate approach and excessive airspeed, which resulted in a long landing, the subsequent runway overrun, and impact with terrain. Contributing to the accident was the pilot's delay in aborting the landing.NTSB DCA15WA031Accident · No injuriesForeign investigationBeech F33 - A · Krugersdorp, South AfricaNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…NTSB CEN15LA084Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Fort Lupton, COThe loss of engine power during cruise flight for reasons that could not be determined based on the available information.NTSB CEN15CA095Accident · No injuriesData collectionFinal reportCessna 152 · Mount Pleasant, TXThe pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.NTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.NTSB CEN15CA071Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Minocqua, WIThe pilot did not maintain directional control of the airplane during the landing flare when a sudden wind shift occurred.NTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.NTSB ERA15WA078Accident · 2 fatalForeign investigationCessna U206F · Campo Grande, BrazilNTSB ENG15WA005Incident · No injuriesForeign investigationBoeing 757 - 236 · Magadan, RussiaOn December 6, 2014, at approximately 10:30 UTC, a Yakutia Airlines Boeing 757-236PCF, registration VQ-BPY experienced a decompression and cargo door opening approximately 4 minutes after takeoff from Magadan, Russian Federation. The Department for Inspection…NTSB CEN15CA073Accident · No injuriesData collectionFinal reportCessna 152 · Berrien Springs, MIThe pilot's failure to maintain aircraft control during the landing and his poor decision not to abort the landing before the airplane traveled off the end of the airstrip.NTSB CEN15CA072Accident · Minor injuriesData collectionFinal reportCubcrafters CC11-160 · Middleton, WIThe pilot's failure to maintain control of the airplane while braking during landing rollout.NTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.NTSB ERA15CA074Accident · No injuriesData collectionFinal reportCessna R182 · Vero Beach, FLThe pilot's improper landing flare, resulting in a hard landing.NTSB CEN15WA070Accident · 2 fatalForeign investigationSchweizer 269C - 1 · Ponte de Sôr, PortugalOn December 4, 2014, at 1045 coordinated universal time, a Schweizer 269C-1 helicopter, Portuguese registered CS-HFD, impacted terrain under unknown circumstances near Ponte de Sôr, Portugal, during an instructional flight. The instructor pilot and the…NTSB WPR15CA053Accident · No injuriesData collectionFinal reportStafford Wayne H Glastar · Monroe, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and encounter with terrain.NTSB ERA15WA070Accident · 10 fatalForeign investigationPiper PA-31-350 · Mariquita, ColombiaNTSB WPR15WA065Accident · 2 fatalForeign investigationAyres Thrush S2R-T34 · Manado, Indonesia, IndonesiaOn December 2, 2014, about 0250 universal coordinated time, an Ayres Trush, S2R-T34, PK-ELR, ditched in the sea under unknown circumstances. A tail wheel tire, elevator, both main landing gears, and some personal equipment were located 1 mile from the…NTSB WPR15LA052Accident · Minor injuriesLimited investigationFinal reportNanchang CJ-6 · Mesa, AZThe total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA051Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Bountiful, UTThe pilot/mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and a subsequent loss of control.NTSB ERA15WA067Accident · No injuriesForeign investigationPiper PA-31-350 · Nassau, BahamasOn December 2, 2014, about 0845 eastern standard time, a Piper PA-31-350, Bahamian registration C6-REV, operated as Southern Air Flight 302, was destroyed after ditching and submerging in the ocean after a loss of engine power on its right engine while…NTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…NTSB ERA15CA069Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Wachula, FLThe pilot's improper recovery from a bounced landing during gusty crosswind conditions.NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.NTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.NTSB ENG15RA003Incident · No injuriesForeign investigationATR ATR72 - 212A · Visby, SwedenOn November 30, 2014, an ATR72-212A airplane, SE-MDB, experienced excessive vibration during approach to Visby Airport(ESSV), Gotland, Sweden. The right engine was shut down and a single-engine landing was performed. Post-incident inspection found damage to…NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.NTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…NTSB ERA15LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Hartford, CTThe partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.NTSB DCA15WA030Accident · 4 fatalForeign investigationRobinson R44 - II · Dar es Salaam, TanzaniaNTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.NTSB ERA15LA062Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Hampton, SCThe pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…NTSB CEN15LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Berrien Springs, MIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15CA061Accident · No injuriesData collectionFinal reportAmerican Champion 7EC · Colorado Springs, COThe loss of airplane control after encountering windshear.