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 ATL90FA081Accident · 2 fatalField investigationFinal reportCessna 172N · Montezuma, GAThe failure of the pilot to maintain sufficient airspeed during the takeoff.NTSB ANC90LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Sulatna Cross, AKThe pilot failed to adequately assess the existing snow conditions and surrounding terrain (preflight planning) prior to takeoff. Contributing factors were: the lighting conditions, the pilot's over confidence in the airplane's performance capabilities and…NTSB MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.NTSB MKC90LA068Accident · No injuriesLimited investigationFinal reportMaule M4 · Creston, IASelection of the wrong runway by the pilot, and his failure to go-around while he had sufficient speed and runway to do so. Factors related to the accident were: the gusty tailwind and wet runway condition.NTSB MKC90LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Herington, KSFailure of the #2 exhaust valve, and improper flare by the pilot during the forced landing.NTSB MIA90FA090Accident · Minor injuriesField investigationFinal reportButler Aerostar 601 · Lake Butler, FLInflight failure of the left engine which was caused by inadequate maintenance and inspection by company maintenance personnel resulting in heat damaged magneto leads as a result of a missing exhaust flange-to-turbocharger seal. In addition, the inflight…NTSB LAX90LA120Accident · No injuriesLimited investigationFinal reportCessna 414 · Ramona, CARight main gear scissors assemlby becoming disconnected during landing roll, allowing the right run landing gear to collapse; scissor assembly washers not being replaced as recommended in Cessna aircraft service bulletin ME83-37..NTSB LAX90LA119Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paso Robles, CAThe dual student pilot failed to maintain proper rotor/engine power and to relinquish the throttle control when the CFI attempted to reduce the power.NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB CHI90LA097Accident · No injuriesLimited investigationFinal reportCessna C172N · Rock Falls, ILAn encounter with wind conditions which exceeded the capability of the student pilot.NTSB ATL90LA080Accident · Serious injuriesLimited investigationFinal reportLearjet 24 · Anderson, SCElectrical arcing which resulted from a short in the pilot's map light circuit; a chafted wire contacted the oxygen supply line at the oxygen control panel in the cockpit. A factor in the accident was the inadequate design of the oxygen panel plumbing and…NTSB ANC90FA039Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Almautlak, AKThe pilot's loss of control of the airplane because of spatial disorientation. The weather conditions prevailing at the time were factors relating to the accident.NTSB SEA90LA052Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ashland, ORPilot displayed poor inflight planning and decisions by allowing the airplane's speed to deteriorate to the point that the airplane stalled. The pilot could not fully correct the situation due to a loss of altitude and insufficient clearance from the terrain.NTSB MIA90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Margate, FLLoss of power in both engines due to fuel exhaustion, resulting in a forced landing. A factor in the accident was that the pilot did not follow the flight manual to ensure that the fuel tanks were filled to capacity.NTSB LAX90LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Redding, CAThe pilot's decision not to use full flaps which resulted in a long landing on a wet runway.NTSB ATL90LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ocilla, GAThe aircraft's encounter with low level windshear resulting in an uncontrollable descent.NTSB NYC90LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Philadelphia, PAThe failure of the pilot to ensure sufficient fuel was on board for the intended flight, resulting in a power loss due to fuel exhaustion. Factors related to the accident were unsuitable terrain, and the failure of the pilot to divert in a timely manner.NTSB NYC90FA077Accident · 2 fatalField investigationFinal reportCessna 177 · Forty Fort, PALoss of engine power for an unknown reason, and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB MKC90LA064Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Elaine, ARImproper planning/decision by the pilot and his failure to maintain directional control. Factors related to the accident were: the unfavorable weather conditions, runway condition, and the pilot's overconfidence in himself and the aircraft.NTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.NTSB LAX90LA116Accident · 1 fatalLimited investigationFinal reportBoeing 727-227 · Phoenix, AZThe unauthorized intrusion onto the runway environment by a pedestrian.NTSB ATL90IA076Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate servicing of the airplane by operator maintenance personnel which resulted in the burst tire. Factors in the accident were hydraulic system lines which were fractured by debris from the burst tire and a total failure of the airplane hydraulic…NTSB LAX90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sonoma Valley, CAThe pilots inability to maintain aircraft control during a critical phase of flight after experienceing a shift in wind.NTSB DEN90LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Hurricane, UTThe engine oil leak induced connecting rod failure and subsequent total power loss.NTSB SEA90TL#01Accident · No injuriesClass 3Final reportBell 206 · Cougar, WANTSB SEA90LA051Accident · No injuriesLimited investigationFinal reportCessna 150J · Graham, WALoss of engine power due to fuel exhaustion and inadequate remedial action after bouncing/ballooning during the forced landing. The pilot's inadequate preflight planning/preparation was a factor related to the accident.NTSB MIA90LA087Accident · No injuriesLimited investigationFinal reportAir & Space 18-A · Brandon, FLImproper preflight planning/decision by the pilot. A factor related to the accident was: wire(s) near the end of the runway.NTSB MIA90GA088Accident · Serious injuriesFinal reportCessna 172P · Tampa, FLPilots failure to maintain airspeed (vs), which resulted in an inflight loss of control (stall/spin), and in flight collision with terrain.NTSB MIA90IA086Incident · No injuriesIncident investigationFinal reportStinson AT-19 · Titusville, FLTotal loss of engine power was undetermined.NTSB LAX90LA117Accident · 3 fatalLimited investigationFinal reportCessna T210L · Mesa, AZThe failure of the pilot to follow the airplane checklist and properly configure the airplane for takeoff. Contributing to the accident was the pilot's poor preflight preparation and the failure of the pilot to compute the aircraft weight before takeoff.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB LAX90FA113Accident · 4 fatalField investigationFinal reportPiper PA28-161 · Malibu, CAThe pilot's decision to turn into an area of known high terrain after inadvertently encountering instrument meteorological conditions.NTSB FTW90LA082Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Leesville, LALoss of engine power for undetermined reasons. Contributing to the accident were the rough tree covered terrain in which the forced landing was performed and the bright night conditions.NTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.NTSB DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.NTSB LAX90LA114Accident · No injuriesLimited investigationFinal reportPiper J3 · Palo Alto, CAThe failure of the pilot to maintain directional control by not compensating for changing wind conditions.NTSB LAX90FA112Accident · 1 fatalField investigationFinal reportCessna 150J · Pine Valley, CAThe decision of the pilot to continue VFR flight into instrument meteorological conditions, spatial disorientation and inadvertent stall/spin. Factors were: obscuration, low ceiling, and over-confidence in ability.NTSB LAX90FA111Accident · Serious injuriesField investigationFinal reportAmerican AA-1 · Borego Springs, CAImproper in-flight planning/decision by the pilot, and his failure to maintain sufficient airspeed and altitude, which resulted in a stall/mush into rising mountainous terrain. Factors related to the accident were: the terrain and weather conditions, and…NTSB FTW90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bastrop, LAFailure of the pilot to maintain adequate airspeed for a go-around, which resulted in an inadvertent stall. Factors related to the accident were: the unfavorable wind condition and turbulence.NTSB FTW90LA080Accident · No injuriesLimited investigationFinal reportCessna 172N · Arlington, TXInstructor pilot's inadequate preflight procedures and failure to assure an adequate fuel supply for the proposed flight which led to the ensuing engine failure due to fuel exhaustion. Factors in the accident were the left fuel gauge's erroneous quantity…NTSB DEN90LA073Accident · No injuriesLimited investigationFinal reportBeech B-60 · Calhan, COFuel starvation induced power loss due to improper inflight planning and decisions.NTSB CHI90FA096Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Bartonville, ILThe pilot allowed the aircraft to exceed its design stress limits after encountering adverse weather. Factors related to the accident were: the pilot's improper evaluation of the weather and the adverse weather condtions.NTSB ATL90LA079Accident · No injuriesLimited investigationFinal reportCessna 182N · Tuscaloosa, ALPilot's failure to maintain an adequate fuel supply, which resulted in fuel exhaustion and engine stoppage.NTSB NYC90LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Glens Falls, NYPilot factor in that he lost directional control during takeoff and subsequently collided with a snowbank.NTSB MKC90LA063Accident · No injuriesLimited investigationFinal reportCessna 310G · O'Neill, NEFailure of the pilot to select the proper runway or go around. Factors related to the accident were: inadequate wind indicator, tailwind, failure of the pilot to attain the proper touchdown point, and the ditch.NTSB MIA90FA085Accident · 3 fatalField investigationFinal reportCessna 152 · Miramar, FLThe failure of the local controller to provide adequate traffic advisories to N7510H, the local controller's improper clearance to N7510H to descend through the traffic pattern, and the failure of the pilots of both aircraft to see and avoid each other.…NTSB ATL90LA078Accident · No injuriesLimited investigationFinal reportNorth American T-6 G · Albany, GAA locked brake which prevented the pilot from maintaining directional control during the landing roll. The brake material expanded after becoming water soaked while taxiing.NTSB ATL90FA075Accident · 1 fatalField investigationFinal reportSikorsky HSS-1N · Cross, SCImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to fly the helicopter in such a manner that would have assured sufficient rotor RPM for an autorotation.NTSB ATL90FA070Accident · 2 fatalField investigationFinal reportBeech 58 · Demorest, GAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions. Contributing factors were: the pilot's overconfidence, lack of recent flight experience, and the weather conditions.NTSB ANC90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-11 · King Salmon, AKPilot-in-command's failure to maintain airplane control.