NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 LAX07IA014Incident · No injuriesIncident investigationFinal reportBoeing 737-790 · Los Angeles, CAA complete failure and depressurization of both hydraulic systems due to two separate events: 1) the failure of a engine driven pump on the 'A' system, and 2) the fatigue fracture and failure of a hydraulic line on the 'B' system.NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.NTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…NTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.NTSB DEN07WA012Accident · 4 fatalForeign investigationBeech 90 · Besancon, FranceNTSB DFW07WA005Accident · 3 fatalForeign investigationPiper PA-32 · Alava, SpainNTSB CHI07TA015Accident · No injuriesFinal reportCessna 182R · Dexter, MOThe pilot's improper runway selection for landing and the pilot's inadequate flare. A factor was the tailwind.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB NYC07LA008Accident · 1 fatalLimited investigationFinal reportFlynn William Pazmany PL-4 · Fredricksburg, VAThe pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.NTSB LAX07CA010Accident · No injuriesData collectionFinal reportMonocoupe 110 Special · Chandler, AZthe failure of the forward left main landing gear attach point resulting in loss of control.NTSB DFW07FA004Accident · 4 fatalField investigationFinal reportAero Commander 690A · Antlers, OKThe pilot's failure to reduce airspeed while operating in an area of moderate turbulence, resulting in an in-flight break up. Contributing factors were the pilot's decision to exceed the maximum takeoff weight, and the prevailing turbulence.NTSB DFW07CA012Accident · No injuriesData collectionFinal reportCessna 182 · Vicksburg, MSThe structural damage to the firewall during a suspected hard landing.NTSB DEN07CA011Accident · Minor injuriesData collectionFinal reportAdams A55S · Albuquerque, NMthe pilot's improper in-flight planning/decision. A contributing factor was the unfavorable wind.NTSB DEN07CA009Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Hope, NMthe pilot's failure to maintain aircraft control. Contributing factors in this accident included the sudden wind shift and high density altitude, resulting in the helicopter settling with power, and the high vegetation.NTSB NYC07FA007Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau Gmbh 300 · Culpeper, VAThe pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.NTSB ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.NTSB MIA07WA006Accident · 6 fatalForeign investigationPiper PA-34-200 · Victoria, BrazilNTSB LAX07IA008Incident · No injuriesIncident investigationFinal reportGulfstream G1159B · Burbank, CAThe pilot's improper decision to continue to taxi onto an unusable taxi area clearly marked as such. A finding in the accident was the incorrectly depicted EMAS area on the approach chart.NTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DEN07WA010Accident · No injuriesForeign investigationPiper PA-28-140 · Dolsenhain, GermanyNTSB ATL07CA011Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Linden, ALThe pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.NTSB ATL07CA008Accident · No injuriesData collectionFinal reportCessna CE-180-A · Statesville, NCThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with the runway.NTSB ANC07LA003Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKThe pilot's misjudgment of distance/altitude during the landing approach, which resulted in an undershoot and in-flight collision with a river embankment. Factors contributing to the accident were reduced visibility due to rain and mist.NTSB SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB SEA07CA008Accident · Minor injuriesData collectionFinal reportBeech E-55 · Ontario, ORThe dual loss of engine power due to fuel exhaustion as a result of the pilot's failure to adequately determine the amount of fuel aboard the airplane during his preflight preparation. A contributing factor was the pilot's misjudgment of distance/speed during…NTSB NYC07LA006Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Leonardtown, MDThe airplane manufacturer's inadequate landing gear downlock plate maintenance orientation information, and the disengaged main landing gear.NTSB LAX07CA006Accident · No injuriesData collectionFinal reportHarry D. Miller Midget Mustang 1 · Reno, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB DEN07FA008Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COA fractured nose gear assembly spray deflector that blocked the nose gear from extending during landing, and resulted in an intentional nose gear up landing.NTSB CHI07CA008Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Osage Beach, MOThe pilot's inadequate compensation for wind conditions which resulted in the hard landing. The gusting crosswind was a factor.NTSB ATL07CA006Accident · No injuriesData collectionFinal reportMcCullough J-2 · Indian Trail, NCThe pilot's inadequate compensation for gusting wind conditions and his improper landing flare during an emergency landing after takeoff resulting in a hard landing.NTSB SEA07LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lebanon, ORThe pilot's failure to maintain directional control during the landing roll, resulting in the aircraft departing the runway and impacting a Visual Approach Slope Indicator (VASI) standard. The VASI standard near the side of the runway was a factor.NTSB MIA07CA004Accident · No injuriesData collectionFinal reportHughes OH-6A · Key Largo, FLThe pilot's inadvertent encounter with a loss of tail rotor effectiveness during hover in a crosswind wind.NTSB MIA07CA003Accident · No injuriesData collectionFinal reportOlree Robert Spezio Sport DAL-1 · Sarasota, FLThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall / mush and impact with objects (a tree and a fence) before ground impact.NTSB DFW07WA002Accident · 4 fatalForeign investigationRobinson R44 · Sosua, Dominican RepublicNTSB DEN07CA007Accident · Minor injuriesData collectionFinal reportHuff Acro Sport I · Delta, COthe pilot's failure to select a touchdown point a safe distance from the construction crew, and his failure to maintain directional control of the airplane. Contributing factors in this accident included the pilot's limited forward visibility when the…NTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.NTSB ATL07CA007Accident · No injuriesData collectionFinal reportCessna 188B · Belhaven, NCThe pilot's failure to compensate for wind conditions and maintain adequate airspeed, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.NTSB WAS07WA002Accident · 3 fatalForeign investigationBeech V35 · Himeville, South AfricaNTSB DEN07WA006Accident · No injuriesForeign investigationBeech 200 · Courchevel, FranceNTSB DEN07LA040Accident · No injuriesLimited investigationFinal reportBeech A-36 · Great Bend, KSThe pilot's spatial disorientation and subsequent loss of aircraft control while changing radio frequencies and abruptly applying control forces in excess of the design limits of the airframe.NTSB DCA07WA002Accident · 4 fatalForeign investigationBritish Aerospace BAe-146-200A · Stord-Sorstokke, NorwayNTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.NTSB ANC07CA005Accident · No injuriesData collectionFinal reportLetecky Zavody L-23 Super Blanik · Chugiak, AKThe pilot's failure to maintain control of the glider while landing in gusty crosswind conditions, which resulted in a hard landing and structural damage to the fuselage. Factors associated with the accident were turbulence, a crosswind and wind gusts, and…NTSB NYC07FA003Accident · 2 fatalField investigationFinal reportMooney M20F · Brownsville, PAA loss of aircraft control, for unknown reasons, while maneuvering.NTSB ENG07RA001Incident · No injuriesForeign investigationBoeing 747-400 Cargo · Seoul, South KoreaNTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB ANC07LA001Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Alsworth, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control while maneuvering, and an in-flight collision with tree covered terrain. Factors associated with the accident are the pilot's inadequate evaluation of weather…NTSB SEA07FA006Accident · 1 fatalField investigationFinal reportRobinson R44 · Sumner, WAThe complete loss of engine power, for undetermined reasons, while on final approach, and the pilot's loss of control of the helicopter after the power loss. Factors include a lake below the final approach to the private landing pad.