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 ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…NTSB ANC13CA083Accident · Minor injuriesData collectionFinal reportPiper PA-18A · Talkeetna, AKThe pilot's failure to maintain directional control during takeoff.NTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…NTSB DCA13WA143Incident · No injuriesForeign investigationBoeing 757 · Gatwick, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757-2Y0, which occurred on August 23, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB CEN14WA225Accident · 4 fatalForeign investigationAirbus Helicopters 332L2 · Shetland Islands, United KingdomOn August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and…NTSB WPR13LA383Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madera, CAThe pilots' inadequate fuel planning, which resulted in the airplane departing with insufficient fuel to complete the planned flight, and their failure to recognize that discrepancy en route, which resulted in a total loss of engine power due to fuel…NTSB WPR13LA382Accident · No injuriesLimited investigationFinal reportCessna 206 · Boise, IDThe mechanical failure of the nose landing gear for reasons that could not be determined because impact damage prevented a complete examination.NTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.NTSB DCA13WA173Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe Spainish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC). has notified the NTSB of an accident involving a BOEING 737 that occurred on August 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN13LA504Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's failure to properly set the engine power for takeoff, which resulted in the airplane subsequently settling into terrain.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB CEN13CA498Accident · No injuriesData collectionFinal reportCessna 172S · Indianapolis, INThe pilot's inadequate monitoring on the airplane's airspeed during the go-around, resulting in a stall.NTSB ANC13LA081Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe pilot’s failure to maintain adequate airspeed during initial climb after takeoff, which resulted in a subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a slight tailwind.NTSB WPR13CA381Accident · Minor injuriesData collectionFinal reportCessna 172E · Meeteetse, WYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.NTSB ERA13LA370Accident · No injuriesLimited investigationFinal reportBeech C23 · Bingham, METhe pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.NTSB DCA13WA137Accident · No injuriesForeign investigationFairchild SA227 · Sucre, BoliviaThe Direccion General De Aeronautica Civil (DGAC) has notified the NTSB of an incident involving a Fairchild SA227-DC, registration CP-2655, which occurred on August 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…NTSB CEN13LA497Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · Zanesville, OHThe pilot’s loss of directional control during landing.NTSB WPR13FA380Accident · 1 fatalField investigationFinal reportNelson KR-2 · Cataldo, IDThe pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.NTSB WPR13LA378Accident · No injuriesLimited investigationFinal reportCessna 172B · Sisters, ORA loss of engine power during cruise flight for reasons that could not be determined because the engine was not properly preserved to prevent corrosion after the wreckage was recovered from the lake.NTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.NTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…NTSB CEN13CA575Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Mariner · Lee's Summit, MOThe student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.NTSB CEN13CA499Accident · No injuriesData collectionFinal reportBeech 35 · Wheeling, ILThe pilot’s loss of control due to the passenger’s inadvertent application of left rudder during the takeoff roll.NTSB CEN13CA495Accident · No injuriesData collectionFinal reportCessna 172 · Kankakee, ILThe airplane struck a deer during takeoff. Contributing to the accident was the perimeter fence being less than FAA's recommended 10 feet high.NTSB CEN13CA494Accident · No injuriesData collectionFinal reportGlobe GC-1B · Santa Teresa, NMThe pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devilNTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…NTSB ERA13WA367Accident · 4 fatalForeign investigationCessna 172 · Bolzano, ItalyOn August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…NTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB ERA13LA365Accident · No injuriesLimited investigationFinal reportFetterman Lanny R Firestar II · Numidia, PAA fatigue failure of the right main landing gear wheel axle attachment bracket, which resulted in a nose-over during a precautionary landing.NTSB ERA13LA364Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Indian Trail, NCThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.NTSB CEN13LA493Accident · Serious injuriesLimited investigationFinal reportTrick Trikes Storm Trooper · Covert, MIThe student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.NTSB ANC13CA082Accident · No injuriesData collectionFinal reportCessna 185 · Sleetmute, AKThe pilot's failure to maintain directional control during landing.NTSB WPR13CA373Accident · Minor injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NVThe pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.NTSB DCA13WA157Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 777 that occurred on August 15, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB ANC13CA080Accident · Minor injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection.NTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.NTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB CEN13LA490Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Eastport, MIA fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB CEN13LA519Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer Gulfstream AM G 164B · Eagle Lake, TXThe failure of one of the engine cylinders, which resulted in the total loss of engine power and subsequent forced landing.NTSB CEN13FA491Accident · Minor injuriesField investigationFinal reportBell 407 · Ship Shoal 208H (Gulf of Mexico)The ingestion of vented methane gas into the helicopter’s engine during takeoff, which caused an engine compressor surge that led to a total loss of engine power.NTSB CEN13CA489Accident · No injuriesData collectionFinal reportBeech 58P · Peoria, ILThe pilot did not attain the proper touchdown point during landing, which resulted in a runway excursion and impact with a perimeter fence.NTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.NTSB WPR13GA374Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Burns, ORThe total loss of engine power during cruise flight due to the separation of one of the 4th-stage turbine wheel blades due to low-cycle fatigue cracking that had progressed to high-cycle fatigue cracking, which ultimately led to the overload failure of the…NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB ERA13CA362Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Fredericksburg, VAThe pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…NTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.