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 CEN15IA230Incident · No injuriesIncident investigationFinal reportCessna 152 · Pilot Point, TXThe loss of engine power due to the separation of the distributor gear arm on the left magneto.NTSB CEN15FA211Accident · 1 fatalField investigationFinal reportHoffman Zenith 701 · Trinidad, COThe noncertificated pilot's failure to maintain airspeed following a loss of engine power while maneuvering at a low altitude, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the…NTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.NTSB DCA15WA122Incident · No injuriesForeign investigationAirbus A321 - 211 · Barcelona, SpainThe Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) has notified the NTSB of an incident involving an Airbus A321 and a Boeing 737-400 which occurred on April 28, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN15FA210Accident · 1 fatalField investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Austin, TXThe helicopter rescue specialist was not properly attached to the hoist system, which resulted in a fall during a night hoist operation.NTSB ERA15LA200Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Sylacauga, ALA partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.NTSB GAA15CA051Accident · No injuriesData collectionFinal reportPiper PA 32R-300 · Gatlinburg, TNThe pilot's encounter with extreme turbulence during descent over mountainous terrain, which resulted in a loss of control, and structural damage in flight.NTSB ERA15WA211Accident · Minor injuriesForeign investigationBell 430 · Aydin, TürkiyeOn April 26, 2015, at 1322 coordinated universal time, a Bell 430, Turkish-registered TC-HSZ, was substantially damaged following a hard landing near Aydin, Turkey. The pilot and co-pilot were not injured. Two passengers sustained minor injuries, and three…NTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…NTSB WPR15LA154Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Van Nuys, CABoth pilots’ failure to see and avoid each other, which resulted in an on ground collision while taxiing. Contributing to the accident was the ground controller’s failure to notify either pilot about the presence of the other airplane on the taxiway.NTSB GAA15CA049Accident · No injuriesData collectionFinal reportCessna 172M · Clearwater, FLThe pilot's excessive airspeed during landing, which resulted in abnormal runway contact, a runway excursion, and substantial damage to the airplane.NTSB ERA15LA202Accident · No injuriesLimited investigationFinal reportBeech D95 · Jacksonville, FLThe pilot's failure to properly configure the airplane for landing. Contributing to the accident were pilot fatigue, distraction, and complacency and the failure of the landing gear warning horn to sound for reasons that could not be determined based on the…NTSB DCA15WA123Incident · No injuriesForeign investigationBoeing 737 - 8B6 · Madrid, SpainThe Director General of Civil Aviation of Morocco has notified the NTSB of an incident involving a Boeing 737-800 airplane, which occurred on April 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Director General of Civil…NTSB ANC15LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe failure of the left main landing gear leg for reasons that could not be determined based on the available evidence.NTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.NTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA15LA197Accident · Serious injuriesLimited investigationFinal reportJames Kilroy Pitts Model 12 · LaGrange, GAA 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 DCA15WA115Accident · 2 fatalForeign investigationBell UH1H - NO Series · Bainskloof, South AfricaThe government of South Africa has notified the NTSB of an accident involving a BELL UH-1H helicopter that occurred on April 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB CEN15WA208Accident · 1 fatalForeign investigationEdge 360 · Norfolk, United KingdomOn April 22, 2015, about 1340 coordinated universal time, an Edge 360 airplane, G-EDGJ, impacted terrain while performing aerobatic maneuvers near Norfolk, United Kingdom. The pilot was fatally injured. The accident investigation is under the jurisdiction and…NTSB GAA15CA054Accident · No injuriesData collectionFinal reportBellanca 1730 - A · Campbellsville, KYThe pilot's improper landing flare which resulted in a hard landing.NTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.NTSB ENG15RA023Incident · No injuriesForeign investigationBoeing 400 · Islamabad, Pakistan, PakistanOn April 21, 2015, a Shaheen Air International (SAI) Boeing 737-400, powered by CFMI CFM56-3C1 turbofan engines, experienced a No. 1 (left engine) failure while climbing through 3,200 feet. The flight crew heard a loud band and high exhaust gas temperature…NTSB GAA15CA048Accident · No injuriesData collectionFinal reportCessna 180J · Boise, IDThe pilot's failure to maintain directional control during landing.NTSB ERA15WA195Accident · 7 fatalForeign investigationPiper PA-32-300 · Punta Cana, Dominican RepublicNTSB ERA15FA191Accident · Serious injuriesField investigationFinal reportMooney M20TN · Lakeland, FLThe total loss of engine power for reasons that could not be determined due to thermal damage and because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB GAA15CA046Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain airplane control, resulting in a hard landing.NTSB ERA15LA192Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Fort Myers, FLThe pilot's improper decision to land the airplane with a quartering, gusting tailwind and his subsequent failure to flare the airplane and maintain directional control after it bounced, which resulted in a runway excursion.NTSB ANC15CA022Accident · Serious injuriesData collectionFinal reportPiper PA 18A 150 · Nondalton, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB WPR15LA167Accident · No injuriesLimited investigationFinal reportBeech F33A · Puyallup, WAA total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…NTSB WPR15LA150Accident · 1 fatalLimited investigationFinal reportCessna 206H · Redding, CAThe pilot's intentional descent into terrain.NTSB GAA15CA055Accident · No injuriesData collectionFinal reportBeech C 50 · Honesdale, PAThe pilot's failure to stop the airplane on the runway during landing, resulting in an overrun, landing gear collapse and substantial damage to the airplane.NTSB GAA15CA045Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Newport, RIThe pilot's failure to maintain directional control during landing.NTSB GAA15CA044Accident · No injuriesData collectionFinal reportCessna 150M · Slate Hill, NYThe pilot's failure to maintain an adequate descent rate, resulting in a hard landing.NTSB GAA15CA042Accident · Minor injuriesData collectionFinal reportCessna 140 · Mize, MSThe pilot's failure to maintain clearance from obstacles during an off airport precautionary landing roll.NTSB ERA15LA190Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Winchester, TNThe pilot's inadequate weight and balance and performance planning, including his decision to take off with more passengers than permitted, and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an…NTSB ERA15LA189Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Titusville, FLAn inflight fire and a total loss of engine power due to oil starvation, after separation of the No. 3 cylinder exhaust valve rocker box cover for reasons that could not be determined based on the available information.NTSB CEN15LA212Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Smithville, TXThe noncertificated pilot's loss of directional control during takeoff, which resulted in impact with a utility pole and hangar. Contributing to the accident was the pilot's failure to obtain flight instruction before attempting to fly the aircraft.NTSB CEN15LA205Accident · Minor injuriesLimited investigationFinal reportPitts Model 12 · Burneyville, OKThe partial loss of engine power due to contamination of the fuel system.NTSB CEN15CA203Accident · No injuriesData collectionFinal reportCessna 195A · Independence, IAThe pilot's attempt to land in strong crosswind conditions, resulting in his on-ground loss of control. Contributing to the accident was the crosswind that exceeded the crosswind limits of the airplane.NTSB WPR15LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · La Quinta, CAMaintenance personnel’s failure to properly repair a propeller deformation, which resulted in a fatigue crack, separation of a propeller blade tip, and forced landing onto uneven terrain.NTSB GAA15CA058Accident · No injuriesData collectionFinal reportCessna 172P · TamuningThe student pilot's failure to maintain pitch control, resulting in a hard landing.NTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.NTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.NTSB CEN15LA202Accident · No injuriesLimited investigationFinal reportFairchild SA227 AC · Rifle, COThe uncontained engine failure due to the fatigue failure of the second-stage turbine rotor disk.NTSB CEN15LA199Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Diboll, TXThe total loss of engine power due to the use of an improper fuel type. Contributing to the accident were the servicing of the airplane with the improper fuel, noncompliance with an airworthiness directive, and the fuel nozzle installed on the fueling truck.NTSB GAA15CA043Accident · No injuriesData collectionFinal reportShort Bros SD 360-300 · Greer, SCThe fuel truck driver's inattention, which resulted in backing over a warning cone and into the horizontal stabilizer of the airplane.NTSB ERA15LA201Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Macon, MSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA15IA198Incident · No injuriesClass 2 · IncidentFinal reportDassault-Breguet Mystere Falcon 900 · Orlando, FLUnknown maintenance personnel’s inadequate securing of a wiring bundle during a maintenance, repair, or modification event, which led to chafing of the wiring bundle, an electrical short and arcing, and a subsequent in-flight fire.NTSB ERA15CA188Accident · Minor injuriesData collectionFinal reportP&M Pulsr · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in a collision with the ground.NTSB ERA15LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, NYThe loss of engine power during takeoff for reasons that could not be determined during postaccident examination of the engine or testing of the carburetor.