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 LAX96LA182Accident · No injuriesLimited investigationFinal reportCessna 402C · St Johns, AZthe pilot's inadequate compensation for the wind conditions, his use of an overly excessive approach speed, and his misjudged distance/altitude relationship to the runway. The wind was a factor.Apr 11, 1996 · N172VB · Substantial damageNTSB LAX96LA165Accident · No injuriesLimited investigationFinal reportCessna T210N · Paradise, CAthe pilot's failure to follow landing gear extension procedures by not confirming that the gear was fully extended prior to touchdown. A contributing factor was the interference/alteration of the pilot's customary habit pattern due to his response to a…Apr 11, 1996 · N9820Y · Substantial damageNTSB ANC96LA046Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Anchorage, AKThe pilot's failure to select the proper fuel tank prior to takeoff resulting in fuel starvation. A factor in the accident was the pilot's failure to follow the checklist.Apr 11, 1996 · N235C · Substantial damageNTSB MIA96LA113Accident · 2 fatalLimited investigationFinal reportSnowbird 636D4 · Okeechobee, FLthe failure of the main rotor control connecting rod, which rendered the control stick unusable and led to a loss of control.Apr 10, 1996 · N7047J · DestroyedNTSB MIA96LA111Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Plains, GAthe pilot misjudging distance and speed during the approach, and his failure to obtain the proper touchdown point on landing.Apr 10, 1996 · N725V · Substantial damageNTSB IAD96LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot's failure to maintain control of the accident aircraft during the landing roll. Factors were the wet portion of the grass runway and the pilot's selection of a landing runway with a 10 knot quartering tailwind.Apr 10, 1996 · N8510L · Substantial damageNTSB FTW96LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Silver City, NMthe student pilot's failure to maintain directional control. A Factor was the crosswind.Apr 10, 1996 · N7559S · Substantial damageNTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.Apr 10, 1996 · N2385C · Substantial damageNTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…Apr 10, 1996 · N7713Q · Substantial damageNTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.Apr 10, 1996 · N7479G · Substantial damageNTSB FTW96LA173Accident · No injuriesLimited investigationFinal reportAeronca 65-TAF · Roanoke, TXthe pilot's failure to maintain directional control during landing.Apr 9, 1996 · N36953 · Substantial damageNTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.Apr 9, 1996 · N46139 · Substantial damageNTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…Apr 9, 1996 · N6689G · Substantial damageNTSB LAX96LA163Accident · No injuriesLimited investigationFinal reportCessna 185F · Placerville, CAthe CFI's failure to take adequate remedial action to preclude the loss of direction control during landing rollout.Apr 8, 1996 · N61905 · Substantial damageNTSB IAD96LA058Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlantic Ocean (Atlantic Ocean)the in-flight encounter with unforecast, unexpected turbulence.Apr 8, 1996 · N653A · No damageNTSB FTW96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Boerne, TXThe pilot's improper planning/decision, and his failure to use all of available runway. Factors relating to the accident were: the pilot's overconfidence in the ability of the airplane, the high density altitude, the tailwind, and trees at the departure end…Apr 8, 1996 · XBCHP · Substantial damageNTSB MIA96WA110Accident · Minor injuriesForeign investigationde Havilland DH6 · Virgin Gorda, British Virgin IslandsApr 7, 1996 · N143SA · Substantial damageNTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.Apr 7, 1996 · N7623 · Substantial damageNTSB LAX96LA159Accident · Serious injuriesLimited investigationFinal reportGage VARI-EZE · Chino, CAthe pilot's excessive initial climb attitude and his failure to maintain adequate airspeed. The pilot's diverted attention to the unlatched canopy warning light, and his lack of familiarity with the aircraft were factors.Apr 7, 1996 · N88VE · Substantial damageNTSB FTW96LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bellville, TXthe pilot's excessive approach/landing airspeed and his failure to perform a go-around.Apr 7, 1996 · N6882P · Substantial damageNTSB FTW96LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Midlothain, TXthe pilot's failure to maintain obstacle clearance.Apr 7, 1996 · N7440H · Substantial damageNTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…Apr 7, 1996 · N310MA · Substantial damageNTSB SEA96LA078Accident · Minor injuriesLimited investigationFinal reportSport Flight Talon · Salem, ORloss of engine power for undetermined reason(s), and failure of the pilot to properly flare the aircraft during the emergency landing.Apr 6, 1996 · UNREG · Substantial damageNTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.Apr 6, 1996 · N67562 · Substantial damageNTSB NYC96FA084Accident · 1 fatalField investigationFinal reportPitts S-2B · Freehold Twsp, NJthe pilot's improper fuel management which resulted in a power loss due to fuel exhaustion, and his failure to maintain airspeed during a forced landing which resulted in an inadvertent stall.Apr 6, 1996 · N917JD · DestroyedNTSB LAX96LA158Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Jean, NVthe pilot's poorly planned approach. The flight's encounter with a downdraft is a factor in this accident.Apr 6, 1996 · N65379 · Substantial damageNTSB LAX96LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Sedona, AZthe pilot misjudged the flare.Apr 6, 1996 · N62038 · Substantial damageNTSB LAX96LA156Accident · 1 fatalLimited investigationFinal reportTwibell Tangent 65 · Lucerne Valley, CAthe pilot's failure to maintain altitude. Factors in the accident were: the pilot's decision to buzz the area and his ostentatious display.Apr 6, 1996 · N4309M · DestroyedNTSB LAX96FA155Accident · Serious injuriesField investigationFinal reportCessna 182RG · Beaver Dam, AZan engine failure due to oil starvation resulting from the pilot's improper aircraft preflight. A factor relating to the accident was: failure of the operator to ascertain that proper maintenance was performed after the airplane's high oil consumption rate…Apr 6, 1996 · N600CT · DestroyedNTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…Apr 6, 1996 · N6234E · DestroyedNTSB ATL96LA077Accident · No injuriesLimited investigationFinal reportCessna 210M · Everglades City, FLthe pilot's excessive airspeed and misjudgment of the landing distance. A factor was the right brake not working due to a hydraulic leak.Apr 6, 1996 · N700RP · Substantial damageNTSB ANC96LA045Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas H-369 · Delta Junction, AKloss of engine power for an undetermined reason.Apr 6, 1996 · N58268 · Substantial damageNTSB ANC96LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.Apr 6, 1996 · N1692M · Substantial damageNTSB LAX96LA161Accident · No injuriesLimited investigationFinal reportVan Dyke GVD1 · Sacramento, CAthe pilot's failure to maintain adequate airspeed during a low altitude turn after takeoff.Apr 5, 1996 · N94GV · Substantial damageNTSB FTW96LA162Accident · No injuriesLimited investigationFinal reportCessna T210R · Albuquerque, NMthe pilot's failure to extend the landing gear. Factors were his failure to follow the checklist and his diverted attention due to other traffic.Apr 5, 1996 · N7659U · Substantial damageNTSB CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.Apr 5, 1996 · N6179M · Substantial damageNTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.Apr 5, 1996 · N9600B · DestroyedNTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.Apr 4, 1996 · N51380 · Substantial damageNTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.Apr 4, 1996 · N6166R · Substantial damageNTSB NYC96GA083Accident · 2 fatalFinal reportBell 206L-1 · Charleston, WVthe helicopter manufacturer's inadequate maintenance service bulletin inspection interval which failed to provide timely detection of preexisting fatigue cracks in the tail boom. Factors were: the manufacturer's failure to develop a modification of the failed…Apr 4, 1996 · N79SP · DestroyedNTSB LAX96LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Palm Springs, CAthe pilot's inadequate compensation for the crosswind condition and subsequent failure to maintain directional control. The crosswind was a factor.Apr 4, 1996 · N7561R · Substantial damageNTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.Apr 4, 1996 · N5730T · DestroyedNTSB FTW96LA161Accident · 1 fatalLimited investigationFinal reportBensen Gyroplane · Carthage, TXthe pilot's inadequate coordination with the spectator, concerning the spectator's need to remain clear of the takeoff area, and the spectator's failure to remain clear of the takeoff area. A factor relating to the accident was: the spectator's distorted…Apr 4, 1996 · NONE · Minor damageNTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.Apr 3, 1996 · N45043 · Substantial damageNTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.Apr 3, 1996 · N84262 · Substantial damageNTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.Apr 3, 1996 · N2159K · DestroyedNTSB DCA96RA046Accident · 33 fatalForeign investigationBoeing CT-42A · Dubrovnik, CroatiaApr 3, 1996 · N1149NTSB CHI96LA124Accident · No injuriesLimited investigationFinal reportCessna 210 · Marshall, MIA deer that wandered onto the runway. Darkness was a related factor.Apr 3, 1996 · N2586S · Substantial damageNTSB CHI96IA125Incident · No injuriesIncident investigationFinal reportATR 42 · Traverse City, MIimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…Apr 3, 1996 · N421MQ · Minor damageNTSB ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.Apr 3, 1996 · N14MQ · Substantial damage