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 ERA15LA258Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Oneonta, NYThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB ENG15WA029Incident · No injuriesForeign investigationEmbraer ERJ170 - 200STD · Niigata, JapanOn July 7, 2015, an Embraer ERJ170 experienced a bleed system failure during climb after take-off from New Chitose Airport (RJCC), Chitose, Japan. The aircraft diverted to Niigata Airport (RJSN). No one on board the aircraft was injured. The incident is being…NTSB CEN15LA298Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXMaintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.NTSB GAA15CA173Accident · No injuriesData collectionFinal reportCessna 182 · Athens, TNThe failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.NTSB ERA15WA260Accident · No injuriesForeign investigationQuest Kodiac 100 · Pskov, RussiaOn July 6, 2015, about 1312 universal coordinated time, Quest Kodiak 100, U.S. registration N642RM, was substantially damaged by collision with terrain during a forced landing following a loss of engine power after takeoff from Pskov Airport, Pskov, Russia.…NTSB WPR15WA225Incident · No injuriesForeign investigationBoeing 737-800 · TamuningOn July 5, 2015, about 0210 local time, a Boeing 737-800, HL8224, Korean Airlines Flight 2115, had a runway excursion at A. B. Won Pat Guam International Airport. Tamuning, Guam. Korean Airlines was operating the airplane under the provisions of the Korean…NTSB GAA15CA176Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar SL · Montgomery, NYThe pilot's improper pitch control which resulted in a hard landing. A factor contributing to the accident was the pilot's improper recovery from a bounced landing.NTSB CEN15WA299Accident · 1 fatalForeign investigationRockwell International 112TCA · Kempten (Allgäu), GermanyNTSB CEN15LA303Accident · No injuriesLimited investigationFinal reportAviat A-1C-180 · Cincinnati, OHThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN15LA296Accident · Serious injuriesLimited investigationFinal reportColonial C 1 · Chico, TXA loss of engine power due to fuel exhaustion. Contributing to the accident was the unsnapped fuel bladder, which resulted in an inaccurate fuel quantity indication, and the pilot's inadequate preflight fuel planning, during which he relied solely on the fuel…NTSB CEN15CA293Accident · Serious injuriesData collectionFinal reportCessna A188B · Crawfordsville, INThe pilot's failure to maintain clearance from the powerline during an aerial application operations.NTSB ANC15LA046Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat.NTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.NTSB GAA15CA186Accident · No injuriesData collectionFinal reportPiper J3C · Arcadia, FLThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA178Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Newton, KSThe failure of the right main landing gear down-lock micro switch, which resulted in a landing gear collapse during landing, and the pilot/owner's unfamiliarity with the emergency landing gear extension procedure. Contributing to the accident was the flight…NTSB GAA15CA165Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Comanche, OKThe pilot's failure to maintain proper pitch control during touchdown, which resulted in a nose over and impact with terrain.NTSB CEN15FA291Accident · 2 fatalField investigationFinal reportChampion 7BCM · Portland, TXThe pilot’s ostentatious low-altitude aerobatic display, which resulted in an aerodynamic stall/spin when he exceeded the airplane’s critical angle of attack. Contributing to the accident was the pilot’s impairment due to alcohol and drugs.NTSB GAA15CA182Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Llano, TXThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB GAA15CA177Accident · Minor injuriesData collectionFinal reportCentrair 101A · Hartford, WIThe glider pilot's failure to connect the elevator to the elevator control rod during the assembly process, resulting in a loss of control, and a collision with terrain during takeoff.NTSB GAA15CA164Accident · Minor injuriesData collectionFinal reportPiper PA 18-135 · Twin Falls, IDThe pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.NTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.NTSB CEN15MA290Accident · 1 fatalClass 1 · MajorFinal reportAirbus Helicopters AS350B3E · Frisco, COAirbus Helicopters' dual-hydraulic AS350 B3e helicopter's (1) preflight hydraulic check, which depleted hydraulic pressure in the tail rotor hydraulic circuit, and (2) lack of salient alerting to the pilot that hydraulic pressure was not restored before…NTSB CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.NTSB CEN15CA312Accident · No injuriesData collectionFinal reportEurocopter EC 130 B4 · Somerset, COThe pilot's decision to fly at a low altitude when he was aware that there were wires in the area which resulted in the helicopter contacting a wire.NTSB ANC15LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA206Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Carey, IDUndetermined because examination of the airplane wreckage did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA205Accident · 2 fatalField investigationFinal reportSchweizer 269C · Newberg, ORThe loss of translation/rotational power between the engine and the transmission due to the severe wear of the forward spline portion of the lower coupling drive shaft. The reason for the severe wear of the forward spline could not be definitively determined…NTSB GAA15CA196Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Forest City, SDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.NTSB GAA15CA170Accident · No injuriesData collectionFinal reportCessna T182T · Oak Island, NCThe pilot's improper level off and flare, which resulted in a bounced landing and firewall damage.NTSB GAA15CA157Accident · Minor injuriesData collectionFinal reportBalloon Works FIREFLY8 - 24 · Provo, UT**This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…NTSB CEN15LA300Accident · Serious injuriesLimited investigationFinal reportBalony Kubicek Spol BB60Z · Fort Carson, COThe pilot’s improper burner control, which allowed the balloon’s envelope to cool, and the balloon’s subsequent encounter with a drop in wind velocity during a high wind landing approach, both of which resulted in the balloon’s descent rate increasing too…NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB WPR15FA204Accident · 2 fatalField investigationFinal reportHughes 269C · Asotin, WAThe pilot's failure to maintain adequate clearance from power lines while maneuvering in a canyon.NTSB GAA15CA168Accident · No injuriesData collectionFinal reportCessna A188B · Saratoga, WYThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion, and a ground loop.NTSB GAA15CA153Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Mackay, IDThe student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.NTSB ERA15LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Galax Hillsville, VAThe pilot's failure to maintain adequate airspeed while turning onto the final approach leg of the traffic pattern, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…NTSB WPR15LA203Accident · No injuriesLimited investigationFinal reportBeech C 99 · Salt Lake City, UTThe airplane’s unmanageable right yaw during takeoff for reasons that could not be determined because postaccident examination of the rudder and rudder assembly did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA202Accident · No injuriesLimited investigationFinal reportShort Bros SD3 60 · Kapolei, HIThe pilots’ failure to extend the landing gear before landing. Contributing to the accident was the pilots’ failure to complete the Before Landing checklist.NTSB WPR15LA201Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Oak Harbor, WAThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA15CA183Accident · No injuriesData collectionFinal reportCessna 180 · Cahokia, ILThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop.NTSB GAA15CA150Accident · Minor injuriesData collectionFinal reportCessna TR182 · Rio Vista, CAThe pilot's use of improper procedures during an aborted landing, resulting in a runway excursion and a collision with a canal.NTSB ERA15CA256Accident · No injuriesData collectionFinal reportCessna 170 · Raymond, MSThe flight instructor's inadequate preflight inspection of the fuel system resulting in a total loss of engine power due to fuel contamination.NTSB DCA15WA147Incident · No injuriesForeign investigationBoeing 737 · Tanegashima, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of JTSB's investigation under the…NTSB DCA15CA145Accident · Serious injuriesData collectionFinal reportBoeing 737 832 · Salt Lake City, UTinadvertent contact by beverage cart during cabin service.NTSB GAA15CA158Accident · No injuriesData collectionFinal reportCessna 337 · Blanding, UTThe pilot's selection of a departure runway of inadequate length for the density altitude, resulting in the airplane not gaining sufficient lift, departing the runway, and impacting terrain.NTSB GAA15CA147Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor's decision to conduct a high altitude pinnacle landing without adequate power, which resulted in the helicopter impacting terrain during the approach. Contributing to the accident was the density altitude at the high altitude pinnacle…NTSB DCA15CA152Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Boston, MAan inadvertent fall by the passenger while exiting the lavatory when the seat belt light was illuminated.