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 ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.Aug 12, 1989 · N25805 · DestroyedNTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.Aug 12, 1989 · N1211V · DestroyedNTSB MKC89LA178Accident · No injuriesLimited investigationFinal reportBell 206B · Marys Home, MOThe failure of the pilot to maintain control of the helicopter.Aug 11, 1989 · N43BL · Substantial damageNTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.Aug 11, 1989 · N4072X · Substantial damageNTSB FTW89LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Terrell, TXThe pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.Aug 11, 1989 · N5794E · Substantial damageNTSB FTW89DQG05Accident · No injuriesFinal reportSchweizer G-164A · Sunray, TXA total power loss for undetermined reasons. A factor was the rough uneven terrain in which the pilot had to make the forced landing.Aug 11, 1989 · N7903 · Substantial damageNTSB DEN89LA193Accident · Serious injuriesLimited investigationFinal reportAerofab Lake LA-250 · Bullfrog, UTA submerged object in the landing area.Aug 11, 1989 · N84164 · Substantial damageNTSB ATL89DMG06Accident · 1 fatalFinal reportDammann N3-2 · Hendersonville, NCEngine failure due to carburetor ice.Aug 11, 1989 · N70406 · DestroyedNTSB ANC89LA138Accident · Serious injuriesLimited investigationFinal reportCessna 207-A · Tanana, AKPilot-in-command's improper inflight planning and decisions. He flew into weather that was known to be adverse, and the environmental conditions adversely affected his ability to safely complete the flight.Aug 11, 1989 · N6370H · Substantial damageNTSB NYC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Nanuet, NYInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Aug 10, 1989 · N16929 · Substantial damageNTSB NYC89LA187Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Mount Joy, PAThe pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.Aug 10, 1989 · N1611R · Substantial damageNTSB NYC89IA185Incident · Minor injuriesIncident investigationFinal reportBoeing 727-254 · Boston, MAThe failure of the landing gear drag brace to unlock during landing. Contributing was the failure of pacific southwest airlines to catch the incorrect assembly. An additional factor was the use of faulty information by eastern airlines and their decision to…Aug 10, 1989 · N915TS · Minor damageNTSB LAX89LA251Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproperly use of the flight controls by the pilot and his failure to maintain control of the helicopter.Aug 10, 1989 · N8477B · Substantial damageNTSB LAX89IA315Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Los Angeles, CAA fatigue crack in the right gear wheel well.Aug 10, 1989 · N88709 · Minor damageNTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.Aug 10, 1989 · N5703B · Substantial damageNTSB DCA89IA066Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Denver, COFatigue failure and separation of a first-stage compressor fan blade.Aug 10, 1989 · N133JC · Minor damageNTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.Aug 10, 1989 · N3680Y · Substantial damageNTSB ATL89FA194Accident · 1 fatalField investigationFinal reportBeech E55 · Raleigh, NCThe pilot's loss of control due to spatial disorientation while operating in instrument weather conditions.Aug 10, 1989 · N55TP · DestroyedNTSB ANC89LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Nebesna Glacier, AKThe pilot allowed the aircraft to inadvertently touch down, he delayed making a go-around, and he did not maintain sufficient speed to continue the go-around. Contributing factors were: the pilot's selection of unsuitable terrain, high vegetation in the…Aug 10, 1989 · N5644W · Substantial damageNTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.Aug 10, 1989 · N1118D · Substantial damageNTSB MKC89DCQ01Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M-18-A · Ingalls, KSImproper preflight planning by the pilot and his failure to attain inadequate airspeed, which resulted in a stall/spin. As he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind and the…Aug 9, 1989 · N7032M · Substantial damageNTSB LAX89LA270Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bakersfield, CAThe loss of engine power due to the helicopter being flown in exhaust gases emanating from a cogeneration plant chimney stack that exceeded the certification standards of the powerplant. Contributing to the accident was invisible nature of the exhaust gases…Aug 9, 1989 · N90296 · DestroyedNTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…Aug 9, 1989 · N44516 · DestroyedNTSB MKC89LA175Accident · Minor injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Indianola, IAFailure of the pilot to maintain clearance from the tv tower due to improper in-flight planning/decision. Unfavorable wind/windshear and the tall tower were contributing factors.Aug 8, 1989 · N2210H · Substantial damageNTSB LAX89LA269Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Chandler, AZAn engine power loss for undetermined reasons.Aug 8, 1989 · N514A · Substantial damageNTSB LAX89LA267Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Terminal Island, CAThe fatigue failure of an exhaust valve due to excessive wear of the respective valve guide. Factors related to the accident were: the fence & cars in the emergency landing area.Aug 8, 1989 · N28565 · Substantial damageNTSB LAX89FA268Accident · 1 fatalField investigationFinal reportPiper PA-601P · Ramona, CAThe pilot's VFR flight in instrument meteorologial conditions (IMC) and spatial disorientation, which resulted in an inadvertent descent into the ground. Factors related to the accident were: darkness, low ceiling, and the pilot's lack of a preflight weather…Aug 8, 1989 · N6067Z · DestroyedNTSB DEN89LA189Accident · Serious injuriesLimited investigationFinal reportBell 206B · Georgetown, COImproper inflight planning/decision by the pilot. The high density altitude, tail wind, gusts, and terrain were related factors.Aug 8, 1989 · N12DY · Substantial damageNTSB CHI89DEM06Accident · No injuriesFinal reportCessna 152 · Manistee, MIThe partial loss of power during initial climbout, and the aircraft's subsequent nose over during the forced landing roll.Aug 8, 1989 · N96863 · Substantial damageNTSB SEA89LA148Accident · No injuriesLimited investigationFinal reportBell 206B · Boulder City, NVPilot displayed poor inflight planning while maneuvering. The pilot did not identify the wind conditions resulting in a loss of directional control. The pilot's corrective action was inadequate and as result, the helicopter collided with the terrain.Aug 7, 1989 · N9916K · Substantial damageNTSB NYC89LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…Aug 7, 1989 · N22179 · DestroyedNTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.Aug 7, 1989 · N3893J · Substantial damageNTSB DEN89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTMisjudgement of the proper touchdown point by the pilot, which resulted in an overrun of the landing area and collision with a post. The downhill terrain condition and location of the fence post were related factors.Aug 7, 1989 · N1322A · Substantial damageNTSB ANC89FA137Accident · 1 fatalField investigationFinal reportCessna 402 · Nome, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his improper in-flight planning/decision. The weather and terrain conditions were considered to be contributing factors.Aug 7, 1989 · N12333 · DestroyedNTSB SEA89LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Mollala, ORPilot displayed poor judgement and did not adequately plan for the flight. The pilot was unfamiliar with the area and terrain conditions. As a result, the airplane was not able to attain sufficient altitude for the conditions to clear the terrain.Aug 6, 1989 · N95099 · Substantial damageNTSB NYC89LA191Accident · No injuriesLimited investigationFinal reportCessna 421C · Waterville, MEImproper planning/decision by the pilot, his failure to obtain NOTAMS, and failure of the approach controller to provide a safety advisory about the runway condition.Aug 6, 1989 · N211PB · Substantial damageNTSB NYC89FA183Accident · 2 fatalField investigationFinal reportBeech B24R · Wiscasset, METhe pilot's loss of control of the airplane and uncontrolled descent during attempted flight in instrument meteorological conditions.Aug 6, 1989 · N2175W · DestroyedNTSB MKC89LA174Accident · No injuriesLimited investigationFinal reportStinson L-5 · Minneapolis, MNThe pilot selected the wrong runway and failed to maintain directional control. The crosswind was a contributing factor.Aug 6, 1989 · N68591 · Substantial damageNTSB MKC89DPG04Accident · Serious injuriesFinal reportRockwell S-2R · Moscow, ARInadequate visual lookout by the pilot. The guy wire was a contributing factor.Aug 6, 1989 · N4943X · DestroyedNTSB MIA89LA216Accident · No injuriesLimited investigationFinal reportCessna 195B · Hollywood, FLThe failure of the left main landing gear spring due to low cycle fatigue, resulting in the loss of control of the ground.Aug 6, 1989 · N841DP · Substantial damageNTSB LAX89LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Monica, CAThe student pilot's improper flare and recovery from a bounced landing.Aug 6, 1989 · N95693 · Substantial damageNTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.Aug 6, 1989 · N2667L · DestroyedNTSB LAX89FA276Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Toms Place, CAFailure of the pilot to attain sufficient altitude to clear terrain obstructions before entering a high elevation basin. Contributing to the accident was a high density altitude which reduced the aircraft's climb performance to less than the rate of climb of…Aug 6, 1989 · N6274W · DestroyedNTSB DEN89LA188Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper planning/decision by the pilot. The wind condition was considered to be a contributing factor.Aug 6, 1989 · N9823X · Substantial damageNTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.Aug 6, 1989 · N9661Y · Substantial damageNTSB DEN89LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Louisville, COThe pilot's failure to adequately evaluate the weather prior to takeoff. High winds developed during the Balloon flight which resulted in a rough landing.Aug 6, 1989 · N74191 · No damageNTSB DEN89FA184Accident · 1 fatalField investigationFinal reportCessna 172M · Albuquerque, NMThe pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.Aug 6, 1989 · N64263 · DestroyedNTSB DEN89DTG01Accident · 1 fatalFinal reportCessna 188A · Valley City, NDInadequate visual lookout by the pilot. The power line was a related factor.Aug 6, 1989 · N188TV · DestroyedNTSB CHI89LA162Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Garrettsville, OHThe pilot did not maintain adequate airspeed and allowed the aircraft to inadvertently enter a stall/spin. Turbulence was considered to be a contributing factor.Aug 6, 1989 · N5131M · DestroyedNTSB CHI89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe pilot-in-command failed to properly compensate for unfavorable wind conditions.Aug 6, 1989 · N1157H · Destroyed