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 MIA95FA117Accident · Serious injuriesField investigationFinal reportBeech 95-B55 · Plant City, FLInadequate maintenance and inspection, and the pilot's failure to attain VMC.NTSB LAX95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Los Banos, CAfuel exhaustion due to the pilot's inadequate preflight planning and preparation.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB SEA95LA078Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Walla Walla, WATotal failure of the freewheeling sprag unit. A factor to the accident was: suitable terrain was not available for landing.NTSB MIA95LA125Accident · No injuriesLimited investigationFinal reportFabre Searay Bombadier · Orlando, FLThe abrupt use of the flight controls,by the pilot-in-command while taxiing on water that resulted in the airplane capsizing.NTSB MIA95LA116Accident · 1 fatalLimited investigationFinal reportKorzep Bumble BEE 500 · Titusville, FLThe failure of the pilot to maintain rotor RPM, resulting in the subsequent in flight loss of control. The pilot's lack of qualification was a factor.NTSB LAX95LA169Accident · 1 fatalLimited investigationFinal reportRyan ST-3-KR · Apple Valley, CAthe failure of the pilot to maintain airspeed, and entering into an inadvertent stall while flying close to the ground.NTSB LAX95LA166Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Chino, CAfailure of the attachment link for the master cylinder return spring, which allowed the left brake to lock.NTSB FTW95LA178Accident · No injuriesLimited investigationFinal reportCessna 182D · Overbrook, OKThe pilot's failure to maintain flying speed, resulting in an inadvertent stall. A factor was the crosswinds.NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB SEA95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Tacoma, WAFuel starvation due to an unlocked mixture control that had not been properly rigged. A factor was the ditch in the emergency landing area.NTSB NYC95LA091Accident · No injuriesLimited investigationFinal reportMooney M20K · Marshfield, MAthe pilot misjudged the flare, resulting in a bounced landing and impact with the terrain. A factor in this accident was an improper recovery from a bounced landing.NTSB MIA95FA115Accident · 5 fatalField investigationFinal reportPiper PA-28-180 · Quincy, FLAn undetermined fuel system problem that resulted in a fuel leak, an engine compartment fire, and a partial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a forced landing. An exhaust leak from the fracture of an…NTSB MIA95FA114Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Sebastian, FLThe failure of the pilot-in-command to maintain airspeed while maneuvering for a forced landing following loss of engine power.NTSB FTW95LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · San Antonio, TXThe loss of engine power due to fuel exhaustion as result of a fuel line connector leak. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95FA177Accident · 1 fatalField investigationFinal reportBeech 60 · Cheyenne, WYThe pilot's failure to maintain aircraft control. Factors were the instrument weather conditons and the excessive workload imposed on the solo pilot attempting to deal with an emergency situation while flying in instrument meteorological conditions.NTSB BFO95LA049Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mount Sterling, KYthe pilot's failure to maintain aircraft control during landing. The gusty, crosswind condition and the pilot's inadequate compensation for the wind condition were factors.NTSB FTW95LA176Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · Utopia, TXClear air turbulence encountered.NTSB CHI95LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Rock Falls, ILthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's poor preflight planning/preparation.NTSB CHI95LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit, MIthe student pilot's failure to maintain directional control during the takeoff ground run. A factor associated with the accident was the soft terrain.NTSB SEA95LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cashmere, WALoss of engine power due to undetermined reasons. A factor contributing to the accident was rough terrain.NTSB FTW95LA175Accident · No injuriesLimited investigationFinal reportBriggs Glasair III · Crescent, OKTotal non-mechanical power loss due to a fuel system vapor lock. A factor was the uneven terrain on which the forced landing was made.NTSB FTW95LA174Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Estancia, NMThe loss of engine power due to exhaust valve separation resulting from inadequate maintenance. A factor was the dark night and the lack of suitable terrain for the forced landing.NTSB FTW95LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakgrove, ARThe student pilot's failure to maintain clearance from power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. Factor's were the instructor's decision to allow the simulation to continue to such a low altitude and…NTSB CHI95LA130Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winfield, KSThe total failure of the rotor drive system clutch assembly due to excessive wear of the clutch assembly. A factor in this accident was the soft ground in the emergency landing area.NTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.NTSB CHI95FA128Accident · 3 fatalField investigationFinal reportCessna T337G · Coffeyville, KSthe pilot's failure to abort the takeoff during an excessive takeoff roll. Factors were the loss of power on the number two engine which occurred for an undetermined reason, the pilot's disregard of the takeoff checklist, and the 25 degree flap setting.NTSB NYC95LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering off the left side of the runway. A factor was the pilot's failure to abort the takeoff.NTSB MIA95LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Myers, FLThe pilot's failure to maintain a proper rate of descent on approach for landing, resulting in a hard landing.NTSB LAX95WA168Accident · 1 fatalForeign investigationCessna 402B · Pohnpei, Marshall IslandsNTSB LAX95FA173Accident · 4 fatalField investigationFinal reportCessna 182P · Jerome, AZthe pilot's improper in-flight decision to continue the daytime flight into known adverse weather conditions at an inadequate altitude to clear mountainous terrain.NTSB ATL95FA087Accident · 1 fatalField investigationFinal reportDuke, Clarence E. Lancair 360 · Hampton, GAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of recent flying experience.NTSB SEA95LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wheatland, WYThe pilot's continued flight into known adverse weather conditions. A factor in the accident was the airframe icing encountered during the flight.NTSB NYC95WA090Accident · 1 fatalForeign investigationCessna T337G · Portimao, PortugalNTSB MIA95WA110Accident · No injuriesForeign investigationBeech B95A · Freeport, BahamasNTSB LAX95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yolo, CAthe pilot's improper preflight preparation which led to fuel exhaustion.NTSB ANC95LA046Accident · No injuriesLimited investigationFinal reportDouglas C54GDC · Kivalina, AKThe pilot's failure to identify a hazardous landing area. Factors in the accident are the presence of snow banks/berms on the runway, and the inadequate snow removal by airport personnel.NTSB SEA95IA082Incident · No injuriesIncident investigationFinal reportFairchild SA-227 · Pasco, WAImproper installation of the rudder trim actuator rod by company maintenance personnel which resulted in binding and fracture of the rod.NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.NTSB CHI95LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Horseshoe Bend, MOthe pilot's failure to untie the main rotor tie-down strap prior to starting the helicopter.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB ATL95LA086Accident · No injuriesLimited investigationFinal reportCessna 182R · Conyers, GAThe pilot's failure to maintain a proper touchdown point during the landing, and his failure to perform a go around when a long landing was imminent. Factors were the sudden windshift resulting in a tailwind condition, and the downhill landing conditions.NTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.NTSB ATL95LA084Accident · No injuriesLimited investigationFinal reportSwant Varieze · Tullahoma, TNThe pilot's inadequate preflight, which resulted in a takeoff with an unsecured canopy, and his failure to maintain aircraft control during the initial climb.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB NYC95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westminister, MDthe failure of the flight instructor to take timely remedial action during an approach, resulting in an inadvertent stall, hard landing and subsequent collapse of the landing gear. A factor related to the accident was the flight instructor's lack of…NTSB MIA95LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Panacea, FLThe pilot's failure to attain the proper touchdown point during a forced landing to a runway. This resulted in the airplane rolling off the departure end of the runway, and subsequent on ground collision with a fence and a telephone booth. Contributing to the…NTSB MIA95FA107Accident · 2 fatalField investigationFinal reportBeech 55-E55 · Daytona Beach, FLThe failure of the pilot-in-command to manage the fuel available in flight by improperly selecting the fuel selectors to fuel available in other tanks, resulting in both engines losing power. Contributing to the accident was the lack of suitable terrain for…NTSB LAX95LA167Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palo Alto, CAinadequate compensation for wind conditions by the private pilot, and failure of the flight instructor (CFI) to ensure that directional control of the aircraft was maintained. The gusty/crosswind (weather) condition was a related factor.NTSB LAX95LA162Accident · 1 fatalLimited investigationFinal reportPitts S-1E · Auburn, CAThe pilot's poor judgment in performing a roll at an altitude insufficient to assure a safe completion.