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 WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.NTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA185Accident · No injuriesData collectionFinal reportCessna 172N · Bally, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN13FA213Accident · 2 fatalField investigationFinal reportSchleicher Alexander · Littlefield, TXThe pilot’s improper decision to conduct aerobatic maneuvers in a glider not approved for such maneuvers. Contributing to the accident was the degradation of the adhesive holding the wing together, which should have been detected either during the last annual…NTSB CEN13CA215Accident · No injuriesData collectionFinal reportCessna 310Q · Willoughby, OHA bird strike during a practice instrument approach in visual conditions.NTSB WPR13WA177Accident · 2 fatalForeign investigationBeech G58 · Kawhia, New ZealandNTSB ERA13LA183Accident · 1 fatalLimited investigationFinal reportAndrews Zodiac · Collegedale, TNThe pilot's failure to ensure that his seatbelt was fastened and the pilots' failure to ensure that the canopy was latched properly, which resulted in the pilot's ejection from the cockpit following the opening of the canopy and the subsequent in-flight upset.NTSB ENG13IA020Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-145 · Houston, TXThe uncommanded left deflection of the airplane's nose wheel due to a malfunction of the electrohydraulic servo valve (EHSV) within the nose wheel steering manifold assembly. The reason for the malfunction could not be determined; however, a foreign substance…NTSB CEN13LA218Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Cleveland, OHThe pilot’s improper flare with a high descent rate, which resulted in a hard landing.NTSB CEN13LA212Accident · Minor injuriesLimited investigationFinal reportCirrus SR22T · Alexandria, MNThe failure of maintenance personnel to install a safety wire during reinstallation of the right flap, which led to the separation of the right flap rod from the right flap actuation fitting during flap extension. Contributing to the accident were inadequate…NTSB CEN13FA214Accident · 1 fatalField investigationFinal reportCessna 152 · Hawley, MNThe noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.NTSB CEN13CA223Accident · No injuriesData collectionFinal reportCessna 180 · Roswell, NMThe pilot's failure to maintain directional control on the landing roll after encountering a gust of wind, which resulted in a ground loop.NTSB WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…NTSB WPR13CA170Accident · No injuriesData collectionFinal reportDiamond DA 20-C1 · Provo, UTThe student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.NTSB WPR13WA197Accident · No injuriesForeign investigationCirrus SR22 · Zhuhai Sanzao Airport, ChinaOn March 27, 2013 about 1445 Beijing time, a Cirrus SR-22, Chinese registration B-9592, experienced a loss of engine power and subsequently ditched near Zhuhai Sanzao Airport, Guangdong Province, China. The airplane was operated as an instructional flight by…NTSB WPR13LA167Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDA total loss of engine power 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 DCA13WA093Incident · No injuriesForeign investigationBoeing 737 · Valencian, SpainThe Spanish Civil Aviation Accidents and Incidents Investigation Commission (CIAIAC) has notified the NTSB of an incident involving a B737-800 that occurred on March 27, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…NTSB DCA13WA087Incident · No injuriesForeign investigationBoeing Boeing 757-300 · Gran Canaria, SpainNTSB CEN13LA211Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe student pilot's improper decision to fly in night visual meteorological conditions and his failure to maintain altitude and clearance from obstacles.NTSB CEN13LA208Accident · No injuriesLimited investigationFinal reportCessna 421C · Amarillo, TXMaintenance personnel's failure to detect the misadjustment of the left landing gear actuator's switch after recent maintenance, which prevented the landing gear from locking in the extended position and resulted in the landing gear collapsing during landing.NTSB CEN13CA207Accident · No injuriesData collectionFinal reportBeech A36 · Fort Stockton, TXThe student pilot inadvertently switching the fuel selector to the OFF position and the flight instructor's failure to monitor the student pilot's actions.NTSB ERA13WA304Accident · Minor injuriesForeign investigationEurocopter BO-105 · Granville, Cedros, Trinidad & TobagoOn March 26, 2013, about 1300 universal coordinated time, a Eurocopter BO-105 helicopter, Trinidad and Tobago registry 9Y-TIC, was substantially damaged during a forced landing to a forested area in Granville, Cedros, Trinidad and Tobago. The pilot sustained…NTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.NTSB CEN13FA205Accident · 1 fatalField investigationFinal reportHughes OH-6A · Caddo, TXThe pilot’s failure to maintain control of the helicopter during landing.NTSB ANC13CA037Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane while taxiing on a snow-covered taxiway.NTSB WPR13WA176Accident · 2 fatalForeign investigationCessna T210N · Roma, Australia, AustraliaOn March 25, 2013, at 0550 universal coordinated time, a Cessna T210N, VH-MEQ, collided with terrain shortly after takeoff near Roma, Australia. The airplane was operated under the pertinent civil regulations of Australia. The airplane was substantially…NTSB WPR13LA161Accident · No injuriesLimited investigationFinal reportOwens Velocity 173 · Maricopa, AZA loss of engine power for reasons that could not be determined because postaccident examination of the throttle body revealed no anomalies that would have precluded normal operation.NTSB WPR13CA160Accident · No injuriesData collectionFinal reportHughes 269C · Rialto, CAThe student pilot’s failure to maintain helicopter control while maneuvering in a hover.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB ENG13RA018Incident · No injuriesForeign investigationBoeing · Jeddah, Saudi ArabiaOn March 23, 2013 at 1806 UTC, a Boeing B747-4H6 airplane, 9M-MPM, experienced an explosion and fire while starting the No. 4 engine at Jeddah, Saudi Arabia (JED). The GACA reported that, after pushback and during the No. 4 engine start, a loud explosion was…NTSB ANC13CA035Accident · No injuriesData collectionFinal reportEurocopter AS350B3 · Stevens Village, AKThe pilot’s inadvertent cyclic control input after landing, which resulted in the main rotor blades striking the ground.NTSB WPR13CA165Accident · No injuriesData collectionFinal reportCessna 150 · Bellingham, WAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor's delayed remedial action.NTSB WPR13CA164Accident · No injuriesData collectionFinal reportPiper PA-30 · Fullerton, CAThe pilot receiving instruction’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action.NTSB CEN13LA204Accident · No injuriesLimited investigationFinal reportBeech A36 · Cordova, ILA partial loss of engine power for reasons that could not be determined because a postaccident test run of the engine revealed no mechanical failures or malfunctions that would have precluded normal operation.NTSB CEN13CA224Accident · No injuriesData collectionFinal reportAeronca 65C · Grand Rapids, MNThe student pilot’s failure to adequately lock the primer before takeoff and the flight instructor's failure to verify that the primer was adequately locked.NTSB WPR13CA163Accident · Minor injuriesData collectionFinal reportCessna 172G · Temecula, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR13WA157Accident · 4 fatalForeign investigationRobinson R44 · Bulli Tops, Australia, AustraliaOn March 21, 2013, about 1207 local time, a Robinson Helicopter R44, VH-HWQ, collided with terrain near Bulli Tops, Australia. The pilot was operating the helicopter under the provisions of the Australian Civil Aviation Regulations. The pilot and three…NTSB WPR13CA168Accident · Serious injuriesData collectionFinal reportCessna 170 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Perry, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN13CA203Accident · No injuriesData collectionFinal reportAviat A-1B · Dumas, TXThe pilot’s failure to maintain control of the airplane while taking off in gusty crosswind conditions. Contributing to the accident was the pilot’s decision to takeoff instead of waiting to ensure that the wind velocity had decreased.NTSB WPR13CA158Accident · No injuriesData collectionFinal reportCessna 172 · Gila Bend, AZThe student pilot’s failure to maintain clearance from an above-ground fuel tank while taxiing.NTSB WPR13CA162Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA13LA180Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Titusville, FLAn engine failure due to the separation of the engine crankcase, which resulted from the lateral movement of the center main bearing and the subsequent blocking of the oil feed hole that supplied oil to the No. 2 connecting rod, which then led to its failure…NTSB WPR13LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Hillsboro, ORA runway overrun due to an insufficient stopping distance due to the downsloping runway during a rejected takeoff. Contributing to the accident was a cabin door that inadvertently opened during the takeoff roll.NTSB WPR13CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chino Valley, AZThe pilot receiving instruction’s failure to maintain rotor rpm during the pinnacle landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR13CA153Accident · No injuriesData collectionFinal reportAndre Kostrzewa Mustang 2 · Bountiful, UTThe pilot’s failure to maintain airplane control during the landing flare in tailwind conditions, which resulted in a hard landing.NTSB ERA13LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City, FLA loss of preload to the crankshaft gear attachment bolt, resulting in rotation of the crankshaft gear and a subsequent total loss of engine power. The root cause for the loss of preload could not be determined during a postaccident examination of the…NTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.NTSB ERA13LA173Accident · Serious injuriesLimited investigationFinal reportNew Piper PA32-301FT · Stafford, VAThe pilot's improper placement of the fuel tank selector handle during approach, which resulted in a total loss of engine power due to fuel starvation.