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.

NTSB MIA95FA117Accident · Serious injuriesField investigationFinal reportBeech 95-B55 · Plant City, FLInadequate maintenance and inspection, and the pilot's failure to attain VMC.Apr 23, 1995 · N6855Z · Substantial damageNTSB LAX95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Los Banos, CAfuel exhaustion due to the pilot's inadequate preflight planning and preparation.Apr 23, 1995 · N4928A · Substantial damageNTSB 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.Apr 23, 1995 · N26991 · Substantial damageNTSB 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.Apr 22, 1995 · N39SD · Substantial damageNTSB 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.Apr 22, 1995 · N773G · Substantial damageNTSB 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.Apr 22, 1995 · N4711G · Substantial damageNTSB 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.Apr 22, 1995 · N214D · DestroyedNTSB 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.Apr 22, 1995 · N20971 · Substantial damageNTSB 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.Apr 22, 1995 · N9104X · Substantial damageNTSB 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.Apr 22, 1995 · N3220E · Substantial damageNTSB 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.Apr 21, 1995 · N2101X · Substantial damageNTSB 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.Apr 21, 1995 · N252DX · Substantial damageNTSB 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…Apr 21, 1995 · N3995R · DestroyedNTSB 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.Apr 21, 1995 · N319DR · DestroyedNTSB 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.Apr 21, 1995 · N9740P · Substantial damageNTSB 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.Apr 21, 1995 · N711PS · DestroyedNTSB 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.Apr 21, 1995 · N202GT · Substantial damageNTSB FTW95LA176Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · Utopia, TXClear air turbulence encountered.Apr 20, 1995 · N83872 · No damageNTSB 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.Apr 20, 1995 · N9418D · Substantial damageNTSB 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.Apr 20, 1995 · N5208D · Substantial damageNTSB SEA95LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cashmere, WALoss of engine power due to undetermined reasons. A factor contributing to the accident was rough terrain.Apr 19, 1995 · N60886 · Substantial damageNTSB 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.Apr 19, 1995 · N55EE · Substantial damageNTSB 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.Apr 19, 1995 · N1664X · Substantial damageNTSB 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…Apr 19, 1995 · N49696 · Substantial damageNTSB 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.Apr 19, 1995 · N2198U · Substantial damageNTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.Apr 19, 1995 · N1967W · Substantial damageNTSB 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.Apr 19, 1995 · N4KP · DestroyedNTSB 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.Apr 18, 1995 · N188AV · Substantial damageNTSB 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.Apr 18, 1995 · N7054W · Substantial damageNTSB LAX95WA168Accident · 1 fatalForeign investigationCessna 402B · Pohnpei, Marshall IslandsApr 18, 1995 · N2NB · DestroyedNTSB 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.Apr 18, 1995 · N85DK · DestroyedNTSB 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.Apr 18, 1995 · N360BJ · DestroyedNTSB 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.Apr 17, 1995 · N7011Q · Substantial damageNTSB NYC95WA090Accident · 1 fatalForeign investigationCessna T337G · Portimao, PortugalApr 17, 1995 · N6CY · DestroyedNTSB MIA95WA110Accident · No injuriesForeign investigationBeech B95A · Freeport, BahamasApr 17, 1995 · N961Q · DestroyedNTSB LAX95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yolo, CAthe pilot's improper preflight preparation which led to fuel exhaustion.Apr 17, 1995 · N80187 · Substantial damageNTSB 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.Apr 17, 1995 · N898AL · Substantial damageNTSB 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.Apr 16, 1995 · N385PH · Minor damageNTSB 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.Apr 16, 1995 · N3835R · Substantial damageNTSB 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.Apr 16, 1995 · N729CH · Substantial damageNTSB 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.Apr 16, 1995 · N8397Y · DestroyedNTSB 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.Apr 16, 1995 · N9331X · Substantial damageNTSB 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.Apr 16, 1995 · N7025S · Substantial damageNTSB 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.Apr 16, 1995 · N418EZ · DestroyedNTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.Apr 15, 1995 · N180WH · Substantial damageNTSB 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…Apr 15, 1995 · N41767 · Substantial damageNTSB 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…Apr 15, 1995 · N19901 · Substantial damageNTSB 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…Apr 15, 1995 · N577M · DestroyedNTSB 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.Apr 15, 1995 · N228PP · Substantial damageNTSB 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.Apr 15, 1995 · N301SH · Destroyed