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 SEA96MA043Accident · 8 fatalMajor investigationFinal reportMitsubishi MU-2B-36 · Malad City, IDcontinued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…Jan 15, 1996 · N693PA · DestroyedNTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.Jan 15, 1996 · N714JV · Substantial damageNTSB FTW96FA092Accident · 1 fatalField investigationFinal reportKrueter KR-2 · Watkins, COFailure by the pilot to maintain control of the aircraft. Factors were a lack of familiarity with the aircraft and lack of experience in the make and model.Jan 15, 1996 · N8019C · DestroyedNTSB CHI96LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Pleasant, MIthe student pilot's inadequate preflight and the loose oil filler cap, which resulted in oil starvation and failure of the #1 cylinder connecting rod. A factor relating to this accident was the snow covered terrain.Jan 15, 1996 · N8375U · Substantial damageNTSB NYC96LA050Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHthe pilot's inadequate crosswind compensation during the go-around.Jan 14, 1996 · N61765 · Substantial damageNTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.Jan 14, 1996 · N68172 · Substantial damageNTSB MIA96LA062Accident · No injuriesLimited investigationFinal reportCessna 310C · Irvington, ALThe pilot's failure to maintain adequate airspeed during the landing flare, which resulted in a hard landing.Jan 14, 1996 · N700YA · Substantial damageNTSB FTW96LA093Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Houston, TXa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 14, 1996 · N1111Z · Substantial damageNTSB CHI96LA078Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Mount Horeb, WIfailure of the pilot to see-and-avoid the pedestrian. Factors relating to the accident were: the pilot's inadequate preflight preparation, his landing on a closed airstrip, and the snow covered terrain.Jan 14, 1996 · N1412N · No damageNTSB CHI96LA076Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe pilot misjudged the flare and performed an improper recovery from a bounced landing. A factor was the inadequate ground instruction concerning recovery from a bounced landing.Jan 14, 1996 · N24311 · DestroyedNTSB CHI96FA073Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hallam, NEimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.Jan 14, 1996 · N98254 · DestroyedNTSB BFO96LA038Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Hurlock, MDinadequate inspection by maintenance personnel which failed to detect a fatigue crack, and resulted in an in-flight crankshaft fracture and propeller assembly separation. A related factor was the deep snow encountered during the subsequent forced landing.Jan 14, 1996 · N87424 · Substantial damageNTSB ATL96FA035Accident · 1 fatalField investigationFinal reportCessna 150G · Social Circle, GAThe flight instructor's inadequate supervision, and his delay in aborting the takeoff.Jan 14, 1996 · N3751J · Substantial damageNTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.Jan 13, 1996 · N7498P · Substantial damageNTSB LAX96FA095Accident · 1 fatalField investigationFinal reportPiper J2 · Lancaster, CAfailure of the pilot to maintain adequate airspeed, while maneuvering from crosswind to downwind after takeoff, which resulted in an inadvertent stall/spin and collision with terrain.Jan 13, 1996 · N17261 · DestroyedNTSB FTW96LA106Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Belen, NMprevious damage, looseness of the main landing gear, and inadequate maintenance.Jan 13, 1996 · N4109B · Substantial damageNTSB FTW96LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control during the landing. The soft terrain was a related factor.Jan 13, 1996 · N111UF · Substantial damageNTSB FTW96FA089Accident · 1 fatalField investigationFinal reportCessna A150M · Vinita, OKFailure of the pilot to recover from a spin. Factors relating to the accident were: the pilot's ostentatious display and the lack of altitude (terrain clearance) for recovery from the aerobatic maneuver and subsequent spin.Jan 13, 1996 · N8125V · DestroyedNTSB FTW96FA088Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Wichita Falls, TXThe inadvertent stall by the pilot in command. Factors were the impeded airplane takeoff performance, the rudder trim not corrected by the pilot, and the pilot's failure to comply with the checklist.Jan 13, 1996 · N8894E · DestroyedNTSB CHI96LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zionsville, INthe pilot's failure to maintain directional control of the airplane on the ground. A factor relating to this accident is the snowbank.Jan 13, 1996 · N80029 · Substantial damageNTSB ATL96LA034Accident · No injuriesLimited investigationFinal reportCessna 150L · Sun City, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion. Darkness was a related factor.Jan 13, 1996 · N18181 · Substantial damageNTSB SEA96LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Grantsville, UTthe failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.Jan 12, 1996 · N91130 · Substantial damageNTSB LAX96LA093Accident · 1 fatalLimited investigationFinal reportBell 47-G5 · Pope Valley, CAthe pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.Jan 12, 1996 · N1309X · DestroyedNTSB LAX96FA094Accident · 2 fatalField investigationFinal reportCessna 150 · Suisun, CAthe pilot's continued flight into known adverse weather conditions which eventually led to a loss of control due to spatial disorientation. Factors in the accident were: the pilot's inadequate preflight planning, his impairment due to medication, the foggy…Jan 12, 1996 · N18106 · DestroyedNTSB FTW96LA095Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Ygnacio, TXFailure of the rotor drive system clutch assembly (separation of the swedge ball from the end of the clutch control cable), which resulted in disengagement of the rotor drive system, while the helicopter was in lateral movement at low altitude.Jan 12, 1996 · N3623T · Substantial damageNTSB FTW96LA094Accident · No injuriesLimited investigationFinal reportCessna A188B · Enid, OKThe pilot's failure to maintain sufficient airspeed during the forced landing and to jettison the aircraft's load for a forced landing. A factor was the engine's failure due to a disconnected fuel line which was the result of improper maintenance.Jan 12, 1996 · N4744Q · Substantial damageNTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.Jan 12, 1996 · N2132J · Substantial damageNTSB CHI96LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · West Liberty, IAthe pilot's inadequate preflight planning/preparation and an intentional ground loop/swerve. A factor in the accident was the wet grass runway.Jan 12, 1996 · N8221W · Substantial damageNTSB CHI96LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Forks, NDthe pilot's failure to maintain control of the airplane while taxiing. Factors in the accident were the icy condition of the taxiway and the high gusting wind.Jan 12, 1996 · N6338D · Substantial damageNTSB BFO96LA036Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Louisville, KYthe pilot's misjudgment of the fuel supply, which resulted in a loss of engine power due to fuel exhaustion during final approach to the destination airport. Factors relating to the accident were: terrain conditions and vehicles in the emergency landing area.Jan 12, 1996 · N5218A · DestroyedNTSB MIA96LA061Accident · No injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLImproper flare by the rated student pilot, and inadequate supervision by the flight instructor.Jan 11, 1996 · N33HF · Substantial damageNTSB FTW96FA119Accident · 2 fatalField investigationFinal reportBeech 35 · Allenspark, COAircraft control not maintained by the pilot in command for reasons undetermined.Jan 11, 1996 · N3052V · DestroyedNTSB ATL96LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Myers, FLthe student pilot's improper flare to touchdown.Jan 11, 1996 · N93103 · Substantial damageNTSB CHI96LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Des Moines, IAthe pilot not using the airplane's deice system which resulted in an accumulation of empennage ice and a tailplane stall. Factors relating to this accident were the pilot's intentional flight into known icing conditions, and the icing conditions.Jan 10, 1996 · N3679M · Substantial damageNTSB SEA96FA040Accident · 3 fatalField investigationFinal reportCessna 401A · Spokane, WAfailure of the pilot to follow proper IFR procedures, by failing to maintain proper alignment with the localizer course during the ILS approach and/or by failing to follow the proper missed approach procedure. Factors relating to the accident were: darkness;…Jan 9, 1996 · N117AC · DestroyedNTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.Jan 9, 1996 · N627WB · Substantial damageNTSB LAX96FA091Accident · 1 fatalField investigationFinal reportPartenavia AF68TP Spartacus · El Segundo, CAloss of control for undetermined reasons.Jan 9, 1996 · N3116C · DestroyedNTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.Jan 9, 1996 · N9840T · Substantial damageNTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.Jan 9, 1996 · N2916F · Substantial damageNTSB BFO96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Coshocton, OHloss of engine power for an undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.Jan 9, 1996 · N9248K · Substantial damageNTSB MIA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lantana, FLLoss of engine power for an undetermined reason, while over water, which resulted in a forced landing/ditching at sea.Jan 8, 1996 · N800PB · Substantial damageNTSB FTW96LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Decatur, TXthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.Jan 8, 1996 · N5505W · Substantial damageNTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…Jan 8, 1996 · N86S · DestroyedNTSB MIA96WA058Accident · 5 fatalForeign investigationCessna 172 · Nassau, BahamasJan 7, 1996 · N55475 · Substantial damageNTSB MIA96FA059Accident · Minor injuriesClass 1 · FieldFinal reportDouglas DC-9-32 · Nashville, TNthe flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…Jan 7, 1996 · N922VV · Substantial damageNTSB LAX96LA085Accident · 1 fatalLimited investigationFinal reportKlingberg Miniplane DSA-1 · El Cajon, CAthe pilot's intentional operation of the aircraft with known mechanical deficiencies in the engine, and his failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall/spin.Jan 7, 1996 · N66TD · DestroyedNTSB IAD96LA109Accident · 1 fatalLimited investigationFinal reportMooney M20F · Cape Charles, VAThe pilot's improper in-flight planning/decision making by continuing flight into known adverse weather conditions. Related factors were the dark night and the winter storm (snow and fog).Jan 7, 1996 · N9199V · DestroyedNTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.Jan 7, 1996 · N424WA · Substantial damageNTSB SEA96LA041Accident · No injuriesLimited investigationFinal reportCessna 172K · Park City, MTInadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.Jan 6, 1996 · N172NS · Substantial damageNTSB MIA96LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Port Richey, FLFailure of the pilot to maintain directional control of the airplane, while landing with a crosswind, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the pilot's lack of recent flying experience.Jan 6, 1996 · N60647 · Substantial damage