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 LAX89DUJ11Accident · No injuriesFinal reportGrumman G-164 · Mohave Valley, AZA loss of engine power for undetermined reasons.Sep 23, 1989 · N8790H · Substantial damageNTSB FTW89DRD16Accident · Serious injuriesFinal reportSours/Midget Mustang SM-1 · Franklinton, LAA total loss of engine power for undetermined reasons. Trees in the emergency landing area were a related factor.Sep 23, 1989 · N2AT · DestroyedNTSB DEN89LA223Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Carlsbad, NMThe pilot failed to refuel the airplane in a timely manner which resulted in fuel exhaustion.Sep 23, 1989 · N6633G · Substantial damageNTSB LAX89LA320Accident · Minor injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAImproper planning/decision by the instructor pilot (CFI), which resulted in a loss of control as the gyroplane went into ground resonance.Sep 22, 1989 · N6101S · Substantial damageNTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.Sep 22, 1989 · N3654N · Substantial damageNTSB FTW89FA171Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Elgin, TXThe pilot's inadvertent closure (deactivation) of the mixture control, which resulted in a loss of engine power, and his failure to maintain sufficient airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the gusty wind, and…Sep 22, 1989 · N4329A · DestroyedNTSB CHI89LA193Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Medina, OHThe pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…Sep 22, 1989 · N9332L · Substantial damageNTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.Sep 22, 1989 · N43804 · DestroyedNTSB ANC89LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Near Talkeetna, AKThe passenger's inadvertent interference with the throttle control, and lack of appropriate remedial action by the pilot.Sep 22, 1989 · N2460A · Substantial damageNTSB MKC89LA198Accident · No injuriesLimited investigationFinal reportBeech 80 · Littlefork, MNTotal failure of the electrical system during IFR operations & the aircraft's collision with a rock fence during the subsequent gear-up precautionary landing.Sep 21, 1989 · N132BA · Substantial damageNTSB MKC89FA197Accident · Serious injuriesField investigationFinal reportCessna 172N · Hyannis, NEFailure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.Sep 21, 1989 · N733FY · Substantial damageNTSB MIA89LA255Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Lexington, MSFatigue failure of the linear actuator lug. A related factor was: trees in the emergency landing area.Sep 21, 1989 · N9318F · Substantial damageNTSB MIA89FA252Accident · 2 fatalField investigationFinal reportCessna 152 · Ochopee, FLFailure of the pilot to maintain altitude/clearance over the terrain. Related factors were: dark night, spatial disorientation of the pilot, and his lack of experience in the type of operation (night flying).Sep 21, 1989 · N47009 · DestroyedNTSB LAX89LA317Accident · No injuriesLimited investigationFinal reportCessna 182 · Zenia, CAFailure of the pilot to realize that the flaps did not extend, which resulted in excessive airspeed. The seized flap actuator was a related factor.Sep 21, 1989 · N8579M · Substantial damageNTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.Sep 21, 1989 · N714VX · 2 aircraft · Substantial damageNTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.Sep 21, 1989 · N5511S · DestroyedNTSB DCA89MA074Accident · 2 fatalClass 1 · MajorFinal reportBoeing 737-400 · Flushing, NYThe captain's failure to exercise his command authority in a timely manner to reject the takeoff or take sufficient control to continue the takeoff, which was initiated with a mistrimmed rudder. Also causal was the captain's failure to detect the mistrimmed…Sep 21, 1989 · N416US · DestroyedNTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.Sep 21, 1989 · N5450E · Substantial damageNTSB SEA89FA176Accident · 2 fatalField investigationFinal reportCessna 150M · Cave Junction, ORThe pilot's improper handling of the aircraft due to the lack of recurrent training and recent experience which resulted in a loss of airspeed and a resultant stall. Contributing to the accident was the pilot's over-confidence in his ability to attempt flight…Sep 20, 1989 · N704TF · Substantial damageNTSB NYC89LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Montague, NJImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.Sep 20, 1989 · N2467A · Substantial damageNTSB NYC89FA220Accident · 1 fatalField investigationFinal reportMBB BO-105CB-4 · Tuckerton, NJThe pilot's delay in remedial action by delaying the pull-up from a descending maneuver.Sep 20, 1989 · N5353V · DestroyedNTSB LAX89LA316Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Winkelman, AZImproper in-flight planning/decision by the pilot, after he became lost/disoriented, which resulted in fuel exhaustion, before he was able to complete a precautionary landing. Factors related to the accident were: darkness, the pilot's lack of visual cues at…Sep 20, 1989 · N3015Z · Substantial damageNTSB ANC89LA170Accident · No injuriesLimited investigationFinal reportCessna 185 · Mulchatna River, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: loss of fuel that had siphoned (leaked) from the aircraft before takeoff and tree(s) overhanging the fast…Sep 20, 1989 · N4443R · Substantial damageNTSB ANC89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKInadequate visual lookout by the pilot due to his diverted attention. The vehicles (tractor & truck) were considered to be related factors.Sep 20, 1989 · N7577D · Substantial damageNTSB ANC89LA167Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Nenana River, AKImproper planning/decision by the pilot. A factor related to the accident was: the adverse weather condition.Sep 20, 1989 · N79SC · Substantial damageNTSB LAX89FA319Accident · 2 fatalField investigationFinal reportCessna 310K · Ojai, CAThe pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…Sep 19, 1989 · N6958L · DestroyedNTSB FTW89LA169Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TXThe pilot's improper use of carburetor heat resulting in a partial, non-mechanical power loss from carburetor icing conditions.Sep 19, 1989 · N8256F · Substantial damageNTSB CHI89LA191Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Chicago, ILA hard landing caused by the pilot not being able to judge his altitude above or his closure rate to terrain because of high vegetation in the area available for a forced landing. An engine faulure caused by material failure of the compressor section is a…Sep 19, 1989 · N9229X · Substantial damageNTSB CHI89LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot landed long and failed to make a go around.Sep 19, 1989 · N714XG · Substantial damageNTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.Sep 19, 1989 · N7124K · Substantial damageNTSB ANC89LA168Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Sleepy Bay, AKSelection of unsuitable terrain (water condition) by the pilot. The rough water condition was a related factor.Sep 19, 1989 · N851TB · Substantial damageNTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.Sep 18, 1989 · N83111 · DestroyedNTSB LAX89LA324Accident · 2 fatalLimited investigationFinal reportHughes 269A · AganaInadequate visual lookout by the pilot, which resulted in his failure to see-and-avoid the power line. The power line was a related factor.Sep 18, 1989 · N8134Y · DestroyedNTSB FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…Sep 18, 1989 · N566B · DestroyedNTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.Sep 18, 1989 · N3456X · DestroyedNTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…Sep 18, 1989 · N739XX · DestroyedNTSB DEN89FA219Accident · 2 fatalField investigationFinal reportCessna 182 · Concord, CALoss of engine power due to an unknown reason, and failure of the pilot to maintain adequate airspeed, which resulted in a stall.Sep 18, 1989 · N92651 · DestroyedNTSB CHI89LA188Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wash Courthouse, OHImproper flare by the student pilot. Factors related to the accident were: the student's selection of the wrong runway, and the tailwind.Sep 18, 1989 · N6172K · Substantial damageNTSB CHI89DEC08Accident · 1 fatalFinal reportWesley Striplin Ranger · Smith Creek, MIThe improper installation of the wingtip fuel tank which resulted in its inflight separation and the subsequent loss of control.Sep 18, 1989 · N46WW · DestroyedNTSB SEA89LA174Accident · Serious injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kapowsin, WAAn undetermined loss of engine power.Sep 17, 1989 · N5163G · Substantial damageNTSB NYC89LA216Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Andreas, PAFailure of the pilot to maintain airspeed, which resulted in a stall.Sep 17, 1989 · N46216 · Substantial damageNTSB NYC89DHM06Accident · Serious injuriesFinal reportMaxair XP-503 Drifter · Warwick, NYFailure of an engine piston wrist pin bearing.Sep 17, 1989 · N13WR · DestroyedNTSB MIA89LA254Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Fort Myers, FLThe pilot's improper flare and improper recovery from a bounced landing. Darkness was a related factor.Sep 17, 1989 · N8371H · Substantial damageNTSB LAX89WA326Accident · 1 fatalForeign investigationCessna 175 · Muiege, MexicoSep 17, 1989 · N6650E · Substantial damageNTSB LAX89LA313Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mammoth Lakes, CAThe pilot's improper compensation for the existing wind condition and his failure to maintain airspeed. Factors that related to the accident were: the gusty & cross-winds and high density altitude.Sep 17, 1989 · N3929F · Substantial damageNTSB FTW89LA167Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Brenham, TXImproper maintenance, improperly secured oil line to the propeller governor, failure of the propeller governor oil line, and subsequent loss of oil, which resulted in oil exhaustion. Factors related to the accident were: failure of maintenance personnel to…Sep 17, 1989 · N9462V · Substantial damageNTSB FTW89LA165Accident · No injuriesLimited investigationFinal reportCessna 172N · Waxahachie, TXFailure of the #3 exhaust valve due to exposure to overtemperature operating conditions.Sep 17, 1989 · N738BB · Substantial damageNTSB DEN89LA220Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COThe pilot failed to extend the landing gear. The pilot's anxiety and/or apprehension about a suspected loss of electrical power, and his attention being diverted by other traffic were contributing factors.Sep 17, 1989 · N7346X · Substantial damageNTSB DEN89FA218Accident · 2 fatalField investigationFinal reportCessna 310I · Hesperia, CAThe non-instrument rated pilot continued VFR flight into instrument meteorological conditions (IMC) and misjudged his altitude above the terrain. Contributing factors were: the pilot's lack of instrument experience, pressure induced by his wife (the…Sep 17, 1989 · N8087M · DestroyedNTSB CHI89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Delphi, INThe pilot-in-command's failure to properly compensate for the high sink rate that developed on final approach to land. Factors related to the accident were: the downdraft and the student pilot's failure to maintain a proper rate of descent on final approach.Sep 17, 1989 · N9816C · Substantial damage