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 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.NTSB ANC94LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Skwenta, AKThe failure of the pilot-in-command to maintain adequate clearance from an object (tree).NTSB 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.NTSB SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.NTSB 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…NTSB LAX94T#A08Accident · No injuriesClass 3Final reportBell 206B-III · Yreka, CANTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.NTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.NTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.NTSB CHI94LA275Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 120A · Bloomington, ILthe unforcast, unanticipated adverse wind conditions and thermal activity. A factor was the powerlines.NTSB BFO94LA137Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Stewartsville, NJThe loss of engine power for undetermined reason.NTSB 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…NTSB 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.NTSB 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.NTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.NTSB 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.NTSB 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.NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB 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.NTSB 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.NTSB CHI94LA279Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Houghton, MIfailure of the pilot to maintain control of the aircraft.NTSB 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.NTSB 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.NTSB SEA94LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Redmond, WAFailure of an exhaust valve. A factor to the accident was: wet grass.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB ANC94LA107Accident · No injuriesLimited investigationFinal reportHelio H-700 · Tok, AKThe partial failure of the airplane's normal brake system.NTSB 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.NTSB 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…NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.NTSB 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.