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 ANC94LA139Accident · No injuriesLimited investigationFinal reportCessna 182B · Ketchikan, AKThe failure of the pilot to maintain directional control of the airplane during a hard landing. The pilot's improper recovery from a bounced landing and a downdraft were factors in the accident.Aug 19, 1994 · N2791G · Substantial damageNTSB ANC94LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Skwenta, AKThe failure of the pilot-in-command to maintain adequate clearance from an object (tree).Aug 19, 1994 · N1785R · Substantial damageNTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.Aug 18, 1994 · N7789P · Substantial damageNTSB SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.Aug 18, 1994 · N2732K · Substantial damageNTSB MIA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-23 · San Juan, PRThe failure of the pilot-in-command to maintain directional control following loss of engine power during takeoff. Contributing to the accident was the pilot-in-commands improper aircraft preflight inspection and draining of fuel tanks and his lack of…Aug 18, 1994 · N556PR · Substantial damageNTSB LAX94T#A08Accident · No injuriesClass 3Final reportBell 206B-III · Yreka, CAAug 18, 1994 · N8NU · DestroyedNTSB LAX94LA326Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Chinle, AZthe pilot's premature liftoff, and his failure to attain the appropriate airspeed during a takeoff attempt under high density altitude conditions.Aug 18, 1994 · N5765R · Substantial damageNTSB FTW94FA273Accident · 3 fatalField investigationFinal reportCessna 310 · Pryor, OKFailure of the pilot to maintain minimum control airspeed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: an oil leak from a fatigue crack in the engine crankcase, and inadequate maintenance.Aug 18, 1994 · N5319A · DestroyedNTSB FTW94FA272Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Van Horn, TXThe uncorrected descent by the pilot. A factor was the lack of total experience in type aircraft.Aug 18, 1994 · N435FH · DestroyedNTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.Aug 18, 1994 · N74AW · Substantial damageNTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.Aug 18, 1994 · N3376R · Substantial damageNTSB ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.Aug 18, 1994 · N9928J · Substantial damageNTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.Aug 18, 1994 · N78428 · Substantial damageNTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.Aug 17, 1994 · N8339A · Substantial damageNTSB MIA94LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe inadvertent encounter with a water puddle on the runway during takeoff roll which resulted in the pilot losing directional control and running off the side of the runway.Aug 17, 1994 · N6115Q · Substantial damageNTSB CHI94LA286Accident · No injuriesLimited investigationFinal reportSnow S2C · Leslie, MOthe separation of the cylinder and subsequent oil leak. A factor to the accident was the pilot's restricted visual outlook.Aug 17, 1994 · N9498R · Substantial damageNTSB NYC94FA160Accident · 4 fatalField investigationFinal reportCessna 320C · Waynesboro, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall/spin and his lack of qualification to conduct flight in type aircraft. A factor is the loss of engine power for undetermined reasons.Aug 16, 1994 · N85WM · DestroyedNTSB LAX94LA324Accident · No injuriesLimited investigationFinal reportCessna 150M · Mettler, CAa loss of engine power due to inadequate and improper maintenance procedures and practices. A factor in the accident was the dark night lighting conditions which inhibited the pilot's ability to select a suitable forced landing area.Aug 16, 1994 · N714GV · Substantial damageNTSB LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.Aug 16, 1994 · N65678 · Substantial damageNTSB CHI94LA275Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 120A · Bloomington, ILthe unforcast, unanticipated adverse wind conditions and thermal activity. A factor was the powerlines.Aug 16, 1994 · N416TC · Substantial damageNTSB BFO94LA137Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Stewartsville, NJThe loss of engine power for undetermined reason.Aug 16, 1994 · N13CM · Substantial damageNTSB BFO94FA144Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Front Royal, VAThe pilot's failure to maintain adequate clearance, his improper in-flight decision and his inadvertent flight into instrument meteorological conditions (IMC) which resulted in in-flight collision with terrain. The high terrain and weather conditions were…Aug 16, 1994 · N3701W · DestroyedNTSB ANC94FA109Accident · 2 fatalField investigationFinal reportCessna 172 · Big Lake, AKThe pilot's failure to maintain airspeed. Factors in the accident were the fog, and the pilot becoming lost/disoriented.Aug 16, 1994 · N5198A · DestroyedNTSB SEA94LA212Accident · No injuriesLimited investigationFinal reportAvid Magnum · Woodland, WAInadequate in-flight planning/decision and clearance from trees was not maintained. A factor to the accident was trees.Aug 15, 1994 · N180AB · Substantial damageNTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.Aug 15, 1994 · N6429B · Substantial damageNTSB BFO94FA163Accident · 4 fatalField investigationFinal reportPiper PA-601P · Sea Isle City, NJthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the presence of a level 6 thunderstorm, loss of gyro's for an undetermined reason, and the pilot's poor weather evaluation.Aug 15, 1994 · N3642A · DestroyedNTSB SEA94LA213Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Nehalem, ORThe separation of the landing gear transmission assembly from its attach bracket rivets due to undetermined reasons. It was not possible for the landing gear to be locked down during the landing roll due to this separation.Aug 14, 1994 · N5063P · Substantial damageNTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.Aug 14, 1994 · N3736V · Substantial damageNTSB SEA94LA210Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-109B · Rock Springs, WYAircraft control was not maintained. Factors to the accident were: high density altitude and wind gusts.Aug 14, 1994 · N45GF · Substantial damageNTSB MIA94LA195Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Merritt Island, FLFailure of the pilot to visually verify that the tow rope was not wrapped around any flight control surface and the inadvertent stall/spin. Contributing to the accident was the entanglement of the tow equipment with the rudder horn, rudder movement was…Aug 14, 1994 · N9669S · Substantial damageNTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.Aug 14, 1994 · N98909 · Substantial damageNTSB FTW94LA269Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Eagle Lake, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 14, 1994 · N1315J · Substantial damageNTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.Aug 14, 1994 · N2501K · Substantial damageNTSB CHI94LA281Accident · No injuriesLimited investigationFinal reportBeech B-35 · Boyceville, WIThe pilot-in-command's inadequate compensation for the existing wind conditions during the landing flare/touchdown. A factor was the gusty wind conditions.Aug 14, 1994 · N5095C · Substantial damageNTSB CHI94LA280Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIno thermal lift available, and the lack of suitable terrain for landing. A factor related to the accident was the high wind condition.Aug 14, 1994 · N6514M · Substantial damageNTSB CHI94LA279Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Houghton, MIfailure of the pilot to maintain control of the aircraft.Aug 14, 1994 · N20SD · Substantial damageNTSB ATL94FA156Accident · 2 fatalField investigationFinal reportCessna 172RG · Atlanta, GAThe pilot's inadequate preflight planning in that he operated the aircraft at a weight which exceeded the maximum takeoff weight and his improper use of flaps during takeoff.Aug 14, 1994 · N9340D · Substantial damageNTSB ANC94FA106Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Kenai, AKInadequate engine maintenance and/or inspection, and fatigue cracking of the engine case, which resulted in eventual damage to the #3 cylinder studs/engine through-bolts, subsequent separation of the #3 cylinder and piston, and an in-flight fire.Aug 14, 1994 · N4839S · DestroyedNTSB SEA94LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Redmond, WAFailure of an exhaust valve. A factor to the accident was: wet grass.Aug 13, 1994 · N95285 · Substantial damageNTSB LAX94LA320Accident · No injuriesLimited investigationFinal reportBeech 77 · Salinas, CAthe pilot's failure to raise the flaps prior to takeoff, and subsequent loss of directional control. A lack of total experience was a factor.Aug 13, 1994 · N6702Y · Substantial damageNTSB LAX94FA323Accident · 3 fatalField investigationFinal reportLockheed C-130A · Pearblossom, CAthe inflight failure of the right wing due to fatigue cracking in the underside right wing skin and overlying doubler. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.Aug 13, 1994 · N135FF · DestroyedNTSB FTW94LA268Accident · No injuriesLimited investigationFinal reportCessna 150M · Glen Rose, TXThe pilot's failure to maintain flying speed and the passenger's interference with the controls during the attempted recovery.Aug 13, 1994 · N704RK · Substantial damageNTSB CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.Aug 13, 1994 · N39762 · Substantial damageNTSB CHI94FA282Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Humphrey, NEthe pilot's failure to maintain control of the airplane. A factor associated with the accident is the pilot's buzzing of the passenger's brother-in-law's house.Aug 13, 1994 · N7565F · DestroyedNTSB BFO94FA135Accident · 3 fatalField investigationFinal reportBell 206L-4 · Whiting, NJThe pilot's improper in-flight planning/decision, flight into instrument meteorological conditions (IMC), and subsequent spatial disorientation, which resulted in loss of aircraft control. Factors related to the accident were: darkness, the adverse weather…Aug 13, 1994 · N124NH · DestroyedNTSB ANC94LA107Accident · No injuriesLimited investigationFinal reportHelio H-700 · Tok, AKThe partial failure of the airplane's normal brake system.Aug 13, 1994 · N4059H · Substantial damageNTSB LAX94LA319Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · El Cajon, CAThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the aircraft. The unfavorable wind was a factor.Aug 12, 1994 · NC731Y · Substantial damageNTSB LAX94FA318Accident · 4 fatalField investigationFinal reportCessna 177RG · So. Lake Tahoe, CAThe pilot's decision to take off from a high density altitude airport at an over allowable gross weight condition. Factors in the accident were the high density altitude, down drafts, and the pilot's lack of familiarity operting from high density altitude…Aug 12, 1994 · N217AF · DestroyedNTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.Aug 12, 1994 · N48664 · DestroyedNTSB CHI94LA278Accident · No injuriesLimited investigationFinal reportCessna 120 · Manitowoc, WIthe private pilot's improper use of brakes during the landing roll. A related factor is his lack of total experience.Aug 12, 1994 · N1987V · Substantial damage