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 ANC13CA055Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Juneau, AKThe pilot did not maintain directional control while attempting to recover from a bounced landing.NTSB WPR13CA268Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Truckee, CAThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions.NTSB CEN13LA346Accident · No injuriesLimited investigationFinal reportRogers T-51 Mustang KIT · St Francis, KSForeign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.NTSB CEN13LA340Accident · Serious injuriesLimited investigationFinal reportVans RV12 · Chadron, NEThe pilot’s failure to properly secure the latch to the tip-up canopy before flight, which resulted in the canopy opening on takeoff and a subsequent loss of airplane control while attempting to land the airplane.NTSB CEN13LA339Accident · Serious injuriesLimited investigationFinal reportYoungs William D T211 · Festus, MOFuel exhaustion due to the pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power.NTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB CEN13FA338Accident · 1 fatalField investigationFinal reportPipistrel Alpha Trainer · Pampa, TXThe loss of engine power due to fuel exhaustion as a result of the manufacturer providing the incorrect Pilot’s Operating Handbook to the owner, which prevented the pilot from accurately calculating the fuel requirements before the flight. Contributing to the…NTSB DCA13WA107Incident · No injuriesForeign investigationBoeing 737-800 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on June 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…NTSB CEN13WA477Accident · Minor injuriesForeign investigationBeech 100 · Saint-Mathieu-de-Beloeil, CanadaOn June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),…NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN13CA343Accident · No injuriesData collectionFinal reportCessna 150G · Franklin, OHThe pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA276Accident · No injuriesLimited investigationFinal reportCessna 170 · Plainville, CTThe pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.NTSB DCA13WA104Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 747-400 that occurred on June 9, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB CEN13LA341Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Farnsworth, TXThe partial loss of engine power for reasons that could not be determined because the postaccident engine examination revealed no anomalies.NTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.NTSB WPR13LA266Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Grand Canyon, AZA loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…NTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…NTSB ERA13CA284Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Ozark, ALThe student pilot’s failure to maintain control of the airplane during the aborted landing.NTSB CEN13LA356Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Golden, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13LA347Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Arvada, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13IA350Incident · Minor injuriesIncident investigationFinal reportUltramagic M-105 · Louisville, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13IA349Incident · Minor injuriesIncident investigationFinal reportUltramagic T210 · Boulder, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13FA331Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B3 · Grand Prairie, TXThe pilot receiving instruction's failure to maintain adequate airspeed during a simulated hydraulics failure training maneuver, which resulted in his loss of control of the helicopter and its subsequent impact with terrain, and the flight instructor's…NTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13CA337Accident · No injuriesData collectionFinal reportStiegelmeyer John R Vans RV-7A · Vinton, IAThe inadvertent collision with a deer during landing.NTSB WPR13LA267Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORThe pilot’s unstabilized approach and use of an excessive speed at touchdown, which resulted in a loss of directional control during the landing and a subsequent runway excursion.NTSB WPR13CA278Accident · No injuriesData collectionFinal reportCessna 180 · Nervino, CAThe pilot’s decision to takeoff from an area off the runway surface which resulted in a collision with an object.NTSB WPR13CA263Accident · Minor injuriesData collectionFinal reportGarland Avipro Bearhawk · Sheridan, WYThe pilot's failure to maintain airspeed, which resulted in a stall and a loss of aircraft control during the initial takeoff.NTSB ERA13WA306Accident · 1 fatalForeign investigationPiper PA34 · Envira, BrazilOn June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…NTSB ERA13FA273Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Manchester, KYThe pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.NTSB DCA13WA123Incident · No injuriesClass 5 · ForeignEmbraer 145 · Shanghai, ChinaNTSB CEN13WA329Accident · 4 fatalForeign investigationBell 206B · San Luis Potosí, MexicoNTSB CEN13WA328Accident · 2 fatalForeign investigationCessna 182R · Micoxtla, MexicoOn June 7, 2013, about 1755 hours central daylight time, a Cessna 182R, United States registration N6241H, impacted terrain near Micoxtla, Mexico. The pilot and passenger were fatally injured, and the airplane was destroyed. The accident investigation is…NTSB CEN13FA326Accident · 1 fatalField investigationFinal reportHawker Beechcraft B200GT · Baker, LAThe pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.NTSB CEN13FA324Accident · 1 fatalField investigationFinal reportWeatherly 620B · Ludlow, SDThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was task- and/or work-related fatigue.NTSB CEN13CA345Accident · Minor injuriesData collectionFinal reportCessna 140 · Minot, NDThe pilot's failure to maintain aircraft control during takeoff.NTSB WPR13FA264Accident · Minor injuriesField investigationFinal reportRobinson Helicopter R44 II · Los Angeles, CAThe pilot’s loss of helicopter control following a precautionary landing, which resulted in a dynamic rollover.NTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomNTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB CEN13LA322Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Covington, OKThe airplane’s failure to climb after takeoff for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA321Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Abbeville, LAFailure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.NTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.NTSB ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA13CA271Accident · No injuriesData collectionFinal reportFlight Design Ctls · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.NTSB ANC13CA109Accident · No injuriesData collectionFinal reportPiper PA 16 · Glennallen, AKThe pilot's loss of control during the initial climb after takeoff, resulting in a collision with trees.NTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.NTSB ERA13LA269Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Elkton, KYThe pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.NTSB DCA13WA171Accident · No injuriesForeign investigationBeech E90 · Rustenburg, South Africa