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 WPR13FA343Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Thompson Falls, MTThe pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB ERA13LA343Accident · No injuriesLimited investigationFinal reportCessna 175 · Willimantic, CTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.NTSB DCA13CA172Accident · No injuriesData collectionFinal reportNasa Ames Research Center Sierra · Beaufort Sea, AKcontinued operation into engine intake system icing conditions resulting in a loss of power; due to schedule pressure and an insufficient risk management process.NTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.NTSB CEN13FA438Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Lake Michigan, WIAn encounter with wake turbulence, which resulted in the pilot’s loss of control of the airplane and its subsequent in-flight breakup. Contributing to the accident was the approach controller’s failure to issue a wake turbulence advisory to the pilot.NTSB CEN13CA449Accident · No injuriesData collectionFinal reportDean David E Kitfox Classic 4 · Grinnell, IAThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB ANC13CA070Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Fairbanks, AKThe pilot's inadequate evaluation of his landing area, which resulted in contact with terrain.NTSB WPR13CA352Accident · No injuriesData collectionFinal reportCessna 180J · Hungry Horse, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR13CA348Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZA substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.NTSB ERA13LA339Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Farmingdale, NJThe airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.NTSB CEN13LA437Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Danbury, TXThe loss of collective control for reasons that could not be determined due to extensive fire damage.NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.NTSB WPR13CA342Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Hilo, HIA loss of engine power due to the pilot's improper planning and mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB WPR13CA341Accident · No injuriesData collectionFinal reportCessna A185F · Pocatello, IDThe pilot's failure to maintain directional control during landing with gusting wind and a quartering tailwind.NTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.NTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.NTSB CEN13FA432Accident · 1 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.NTSB CEN13CA452Accident · No injuriesData collectionFinal reportCessna 172N · Tell City, INThe pilot's failure to maintain adequate clearance from an obstruction while taxiing.NTSB CEN13CA434Accident · No injuriesData collectionFinal reportDavid W Oakes RV-7A · Charlottesville, INThe improper landing attitude which damaged the nosewheel and a resulted in a hard landing.NTSB WPR13WA340Accident · 2 fatalForeign investigationBell 407 · Kedaranath, India, IndiaIn July 24, 2013 at 1005 universal coordinated time, a Bell 407, VT-TBE, crashed under unknown circumstances near Kedaranath, India. The helicopter was substantially damaged and the pilot and passenger were fatally injured. The helicopter was operating under…NTSB CEN13LA436Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Champaign, ILThe pilot’s failure to maintain control of the helicopter during an aerial application maneuver.NTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.NTSB ANC13LA068Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 · Thorne Bay, AKThe failure of the No. 1 linkrod bushing or the bottom portion of the linkrod, which resulted in a total loss of engine power.NTSB ANC13LA067Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot’s loss of directional control of the airplane during a wheel landing.NTSB WPR13GA338Accident · 1 fatalFinal reportBell HH-1H · Mount Charleston, NVThe premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.NTSB WPR13CA337Accident · No injuriesData collectionFinal reportHughes 269B · Lewiston, IDThe pilot's incorrect application of the cyclic control during the landing.NTSB CEN13WA483Accident · 3 fatalForeign investigationPiper PA-28-161 · Kagiswil, Canton of Obwalden, SwitzerlandOn July 23, 2013, at 1525 universal coordinated time, a Piper PA-28-161, HB-PNR, impacted terrain during a go-around from runway 21 at Kaegiswil Airport (LSPG), Kagiswil, Canton of Obwalden, Switzerland. The airplane was destroyed. Two pilots and one…NTSB CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.NTSB ANC13LA089Accident · No injuriesLimited investigationFinal reportHoward M. Shepherd Supercub · Hoonah, AKThe pilot’s selection of an unsuitable off-airport landing site and his subsequent landing at too high of an airspeed, which resulted in his excessive use of brakes during the landing roll and resulted in a nose-over.NTSB WPR13LA336Accident · No injuriesLimited investigationFinal reportWester/Steiger Glastar · Independence, ORThe total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA334Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Las Vegas, NVThe pilot receiving instruction's failure to maintain control of the helicopter in a hover, which resulted in a tail rotor ground strike.NTSB WPR13FA335Accident · 1 fatalField investigationFinal reportMooney M20C · South Lake Tahoe, CAThe pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.NTSB ERA13LA347Accident · Serious injuriesLimited investigationFinal reportDurfee Fred Quicksilver MXL · Lexington, TNThe student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…NTSB ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.NTSB ERA13CA335Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna Beach, FLThe student pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB DCA13FA131Accident · Minor injuriesField investigationFinal reportBoeing 737 7H4 · Flushing, NYThe captain's attempt to recover from an unstabilized approach by transferring airplane control at low altitude instead of performing a go-around. Contributing to the accident was the captain's failure to comply with standard operating procedures.NTSB CEN13WA577Incident · No injuriesForeign investigationCessna Cessna 525B · Paris, FranceOn July 22, 2013, at 0610 UTC, a Cessna 525B Citation CJ3, French registration F-HCIC, experienced smoke in the cabin and cockpit while passing FL 140 during an enroute climb southeast of Paris, France. The number one engine was shut down, the crew declared…NTSB ERA13LA328Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Tappahannock, VAA failure of the engine crankshaft top rear trailing forward counterweight retaining plate, which resulted in a total loss of engine power. The reason for the retaining plate’s failure could not be determined during postaccident examination.NTSB ERA13CA333Accident · Minor injuriesData collectionFinal reportMillhouse D Scott Kitfox II · Logan, WVThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose over. Contributing to the accident was the flight instructor’s inadequate supervision of the student.NTSB ENG13WA039Incident · No injuriesForeign investigationBoeing 777 - 340ER · Moscow, RussiaThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…NTSB CEN13WA427Accident · 1 fatalForeign investigationCirrus Design SR22 · English Channel, United KingdomNTSB CEN13LA428Accident · 1 fatalLimited investigationFinal reportCooper, David W. Challenger II · Mill Creek, INThe noncertificated pilot's improper fuel planning, which led to fuel exhaustion and a loss of engine power. Contributing to the accident was the pilot's failure to obtain adequate instruction or an endorsement to solo in the accident airplane model, which…NTSB ANC13WA071Accident · Serious injuriesForeign investigationGulfstream AG-5B · Tajima, JapanOn July 21, 2013, about 1256 Japan standard time, a Gulfstream Aerospace AG-5 (Tiger) airplane, Japanese registration JA4175, sustained substantial damage during a forced landing following a loss of engine power. The accident occurred as the pilot was making…NTSB ANC13LA066Accident · Minor injuriesLimited investigationFinal reportCessna T207A · King Salmon, AKThe pilot’s inadequate visual lookout while departing from a multiple-use waterway, which resulted in a collision with a drifting boat. Contributing to the accident were the lack of visual conspicuity of the boat and the limited amount of time the boat…NTSB WPR13CA333Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider encountered atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off airport landing on rough terrain.NTSB ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN13LA426Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Shannon, ILThe pilot’s inability to maintain an adequate climb rate after encountering a sudden wind shift during takeoff.NTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.