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 ATL90FA081Accident · 2 fatalField investigationFinal reportCessna 172N · Montezuma, GAThe failure of the pilot to maintain sufficient airspeed during the takeoff.Mar 17, 1990 · N734JE · DestroyedNTSB 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…Mar 17, 1990 · N4659C · Substantial damageNTSB MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.Mar 16, 1990 · N7555M · Substantial damageNTSB 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.Mar 16, 1990 · N12010 · Substantial damageNTSB 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.Mar 16, 1990 · N8285N · Substantial damageNTSB 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…Mar 16, 1990 · N7443S · DestroyedNTSB 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..Mar 16, 1990 · N711AG · DestroyedNTSB 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.Mar 16, 1990 · N8079Q · Substantial damageNTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.Mar 16, 1990 · N4590P · Substantial damageNTSB CHI90LA097Accident · No injuriesLimited investigationFinal reportCessna C172N · Rock Falls, ILAn encounter with wind conditions which exceeded the capability of the student pilot.Mar 16, 1990 · N737GN · Substantial damageNTSB 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…Mar 16, 1990 · N100VQ · Substantial damageNTSB 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.Mar 16, 1990 · N8290T · DestroyedNTSB 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.Mar 15, 1990 · N39205 · Substantial damageNTSB 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.Mar 15, 1990 · N7114Y · Substantial damageNTSB 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.Mar 15, 1990 · N13317 · Substantial damageNTSB ATL90LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ocilla, GAThe aircraft's encounter with low level windshear resulting in an uncontrollable descent.Mar 15, 1990 · N733BV · Substantial damageNTSB 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.Mar 14, 1990 · N6513Z · Substantial damageNTSB 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.Mar 14, 1990 · N29578 · DestroyedNTSB 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.Mar 14, 1990 · N28625 · Substantial damageNTSB 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.Mar 14, 1990 · N66949 · Substantial damageNTSB LAX90LA116Accident · 1 fatalLimited investigationFinal reportBoeing 727-227 · Phoenix, AZThe unauthorized intrusion onto the runway environment by a pedestrian.Mar 14, 1990 · N271AF · Minor damageNTSB 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…Mar 14, 1990 · N8951E · Minor damageNTSB 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.Mar 13, 1990 · N3765Z · Substantial damageNTSB DEN90LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Hurricane, UTThe engine oil leak induced connecting rod failure and subsequent total power loss.Mar 13, 1990 · N1530V · Substantial damageNTSB SEA90TL#01Accident · No injuriesClass 3Final reportBell 206 · Cougar, WAMar 12, 1990 · N678KG · Substantial damageNTSB 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.Mar 12, 1990 · N5559G · Substantial damageNTSB 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.Mar 12, 1990 · N6158S · Substantial damageNTSB 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.Mar 12, 1990 · N9899L · DestroyedNTSB MIA90IA086Incident · No injuriesIncident investigationFinal reportStinson AT-19 · Titusville, FLTotal loss of engine power was undetermined.Mar 11, 1990 · N69996 · Minor damageNTSB 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.Mar 11, 1990 · N94302 · DestroyedNTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.Mar 11, 1990 · N759KM · Substantial damageNTSB 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.Mar 11, 1990 · N2951S · DestroyedNTSB 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.Mar 11, 1990 · N30327 · DestroyedNTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.Mar 11, 1990 · N35485 · Substantial damageNTSB DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.Mar 11, 1990 · N2879G · Substantial damageNTSB LAX90LA114Accident · No injuriesLimited investigationFinal reportPiper J3 · Palo Alto, CAThe failure of the pilot to maintain directional control by not compensating for changing wind conditions.Mar 10, 1990 · N21677 · Substantial damageNTSB 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.Mar 10, 1990 · N152EZ · DestroyedNTSB 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…Mar 10, 1990 · N5655L · DestroyedNTSB 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.Mar 10, 1990 · N3530E · Substantial damageNTSB 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…Mar 10, 1990 · N5193F · Substantial damageNTSB DEN90LA073Accident · No injuriesLimited investigationFinal reportBeech B-60 · Calhan, COFuel starvation induced power loss due to improper inflight planning and decisions.Mar 10, 1990 · N6025S · Substantial damageNTSB 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.Mar 10, 1990 · N410HC · DestroyedNTSB ATL90LA079Accident · No injuriesLimited investigationFinal reportCessna 182N · Tuscaloosa, ALPilot's failure to maintain an adequate fuel supply, which resulted in fuel exhaustion and engine stoppage.Mar 10, 1990 · N92785 · Substantial damageNTSB NYC90LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Glens Falls, NYPilot factor in that he lost directional control during takeoff and subsequently collided with a snowbank.Mar 9, 1990 · N46725 · Substantial damageNTSB 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.Mar 9, 1990 · N2919R · Substantial damageNTSB 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.…Mar 9, 1990 · N48977 · 2 aircraft · DestroyedNTSB 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.Mar 9, 1990 · N96143 · Substantial damageNTSB 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.Mar 9, 1990 · N4875M · DestroyedNTSB 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.Mar 9, 1990 · N7233R · DestroyedNTSB ANC90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-11 · King Salmon, AKPilot-in-command's failure to maintain airplane control.Mar 9, 1990 · N42239 · Substantial damage