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 SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.Aug 30, 1989 · N49231 · 2 aircraft · DestroyedNTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…Aug 30, 1989 · N2841P · DestroyedNTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.Aug 30, 1989 · N65843 · 2 aircraft · DestroyedNTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…Aug 30, 1989 · N4423Z · Substantial damageNTSB DEN89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dutch John, UTInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during the takeoff ground run. Factors related to the accident were: the unfavorable (variable/gusty) wind condition, and the high vegetation and tree beside the…Aug 30, 1989 · N7111W · Substantial damageNTSB NYC89FA204Accident · 1 fatalField investigationFinal reportCessna U206F · West Point, NYContinued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…Aug 29, 1989 · N8559Q · DestroyedNTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.Aug 29, 1989 · N8802M · DestroyedNTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…Aug 29, 1989 · N7593J · DestroyedNTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.Aug 28, 1989 · N132SH · DestroyedNTSB BFO89FA075Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · Lynchburg, VAPilot's failure to maintain clearance from obstructions because of improper IFR operation. Contributing to the accident was descent below decision height, delay in initiating the missed approach, and fog conditions.Aug 28, 1989 · N234J · DestroyedNTSB SEA89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Independence, ORFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop and subsequent overload failure of the left main gear. A factor related to the accident was: improper flare by the pilot.Aug 27, 1989 · N4549H · Substantial damageNTSB SEA89FA157Accident · 1 fatalField investigationFinal reportBeech C35 · Sandy, ORThe loss of engine power due to the separation of the bolt connecting the throttle rod to the carburetor throttle arm and an inadequate annual inspection performed 5 flight hours prior to the occurrence. Contributing factors were obstructions in and around…Aug 27, 1989 · N5916C · Substantial damageNTSB MKC89LA189Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Kansas City, MOInadequate control tower service provided by tower personnel, and inadequate remedial action by the vehicle driver. The pilot's lack of visual lookout was considered to be a contributing factor.Aug 27, 1989 · N63884 · Substantial damageNTSB MIA89LA236Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Milton, FLFlight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.Aug 27, 1989 · N5699J · Substantial damageNTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.Aug 27, 1989 · N5215E · Substantial damageNTSB LAX89WA293Accident · 1 fatalForeign investigationBeech BE-24 · Mexicali, MexicoAug 27, 1989 · N5039M · DestroyedNTSB FTW89LA154Accident · 1 fatalLimited investigationFinal reportCessna 150M · Hearne, TXThe failure of the pilot to maintain control of the airplane and his lack of experience/training. A factor was the pilot's poor physical condition.Aug 27, 1989 · N16090 · DestroyedNTSB DEN89LA201Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Watkins, COFailure of the left brake assembly, and subsequent loss of directional control by the pilot.Aug 27, 1989 · N2369Q · Substantial damageNTSB DEN89FA200Accident · Serious injuriesField investigationFinal reportCessna 172 · Tremonton, UTThe pilot failed to maintain obstruction clearance while making a low pass over a newly constructed highway. The powerline was considered a contributing factor.Aug 27, 1989 · N4129F · DestroyedNTSB CHI89LA176Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Eau Claire, WIInadvertent retraction of the landing gear by the pilot. His habit interference and lack of experience in the type of aircraft were contributing factors.Aug 27, 1989 · N8886 · Substantial damageNTSB CHI89DEM07Accident · Minor injuriesFinal reportBradley S-1D · Mt Pleasant, MIThe tail wheel spring becoming disconnected resulting in the pilot's inability to maintain directional control of the airplane.Aug 27, 1989 · N787PA · Substantial damageNTSB BFO89LA077Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Leonardtown, MDInadequate preflight planning/preparation by the pilot by not assuring that the acft was properly secured, or that someone was at the controls while he was hand propping the engine. A related factor was the pilot's improper adjustment of the throttle cable.Aug 27, 1989 · N24463 · Substantial damageNTSB BFO89FA074Accident · 2 fatalField investigationFinal reportBeech C50 · Hagerstown, MDThe pilot's failure to maintain control of the airplane as a result of spatial disorientation after intentionally flying into instrument flight conditions. Contributing to the accident was the pilot's over confidence in his ability and the obscured weather…Aug 27, 1989 · N4917B · DestroyedNTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.Aug 27, 1989 · N5684S · Substantial damageNTSB ANC89LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Bainbridge, AKContinued flight by the pilot into known adverse weather conditions, and his subsequent selection of unsuitable terrain for landing. Factors related to the accident were: adverse weather conditions and terrain conditions in the precautionary landing area.Aug 27, 1989 · N4605T · Substantial damageNTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.Aug 26, 1989 · N5451B · Substantial damageNTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.Aug 26, 1989 · N10103 · Substantial damageNTSB MKC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Park Rapids, MNThe pilot misjudged the clearance between the helicopter and the power line. The power line (transmission wire) was considered to be a contributing factor.Aug 26, 1989 · N2168S · Substantial damageNTSB MIA89LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · Jacksonville, FLInadequate visual lookout by the pilot. Factors related to the accident were: dark night, light pole with an inoperative light, and the lack of visual perception concerning the pilot's ability to see the pole at night.Aug 26, 1989 · N738WM · Substantial damageNTSB LAX89LA290Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, CAThe pilot's improper recovery from a bounced landing and loss of directional control.Aug 26, 1989 · N4152N · Substantial damageNTSB LAX89LA289Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Tracy, CADual student's failure to properly flare the helicopter during the autorotation power recovery and the cfi's failure to adequately supervise the dual student's performace during a critical phase of flight.Aug 26, 1989 · N80040 · Substantial damageNTSB LAX89LA288Accident · Minor injuriesLimited investigationFinal reportRyan ST3KR · Hawthorne, CAOil starvation of the engine due to the pilot's failure to turn the oil tank supply valve on prior to flight.Aug 26, 1989 · N59466 · Substantial damageNTSB LAX89LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Williams, AZFailure of the pilot to maintain his visual lookout and flying low. Contributing to the accident was the one inch diameter telephone cable.Aug 26, 1989 · N7172R · DestroyedNTSB FTW89LA153Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Jonesboro, LAThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control, which resulted in a porpoise off the side of the runway. The tree was a related factor.Aug 26, 1989 · N7872Z · DestroyedNTSB CHI89DEI03Accident · Minor injuriesFinal reportBrumbaugh/Hubin Long EZE · West Salem, OHInadequate visual outlook and attention diversion by the pilot. Factor(s) related to the accident was: the presence of the wires.Aug 26, 1989 · N42WT · Substantial damageNTSB CHI89DEC06Accident · 1 fatalFinal reportFeil BD-5 · Pontiac, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall/spin. Contributing to the accident was the excessive pull-up maneuver and the pilot's lack of total experience in the aircraft.Aug 26, 1989 · N9BD · DestroyedNTSB BFO89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Gaithersburg, MDAn undetermined problem with the ignition system. A factor related to the accident was: the pilot's failure to properly secure the airplane or obtain proper assistance.Aug 26, 1989 · N6840G · Substantial damageNTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.Aug 26, 1989 · N465SR · Substantial damageNTSB NYC89LA202Accident · No injuriesLimited investigationFinal reportCessna 150H · Northeast, PAA power loss due to an over-rich engine for undetermined reasons. The combination of an over-rich running engine and the pilot's pumping of the throttle during the recovery attempt caused the engine to flood.Aug 25, 1989 · N50294 · Substantial damageNTSB NYC89LA200Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, NYThe pilot's improper flare during landing.Aug 25, 1989 · N92323 · Substantial damageNTSB NYC89LA199Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Deer Isle, METhe pilot's inadequate preflight in determining the adequacy of the takeoff environment under the existing adverse wind conditions.Aug 25, 1989 · N4840C · DestroyedNTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.Aug 25, 1989 · N53327 · Substantial damageNTSB MIA89LA231Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLInadequate visual look-out by the pilot and his failure to maintain control of the helicopter, while maneuvering to avoid obstructions. The transmission lines were considered to be factors.Aug 25, 1989 · N9014N · Substantial damageNTSB MIA89FA233Accident · 4 fatalField investigationFinal reportBeech C23 · Barranquitas, PRImproper in-flight planning/decision by the pilot and his failure to maintain adequate flying speed, which resulted in a stall and subsequent impact with the terrain. Contributing factors were: operation of the aircraft by the pilot with excessive gross…Aug 25, 1989 · N6573R · DestroyedNTSB FTW89IA152Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Kenner, LAInaccurate operators procedures/directives and the improper takeoff performance data computed by the captain. Poor flight crew coordination was considered a factor as well a wrong runway selection for the computed takeoff data.Aug 25, 1989 · N52309 · Minor damageNTSB BFO89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Selbyville, DEExcessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.Aug 25, 1989 · N67803 · Substantial damageNTSB ATL89LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe pilot's misjudgement of the airplane fuel supply during preflight inspection, and his subsequent failure to monitor in-flight fuel consumption, which led to an engine power loss due to fuel exhaustion. Contributing to the accident were the pilot's…Aug 25, 1989 · N2487N · Substantial damageNTSB ANC89LA149Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Fairbanks, AKThe pilot was taxiing too fast to negotiate a bend in the river. Trees & the river bank were contributing factors.Aug 25, 1989 · N9114E · Substantial damageNTSB LAX89FA287Accident · 2 fatalField investigationFinal reportCessna 180J · Tracy, CAInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: the lack of a conflict alert system for the stockton arts ii radar.Aug 24, 1989 · N42695 · 2 aircraft · DestroyedNTSB DEN89LA199Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Englewood, COA failure in the hyrdraulic power unit, which prevented operation of either the normal or emergency gear extension systems. The raised runway lip contributed to aircraft damage and pilot injury.Aug 24, 1989 · N6121R · Substantial damage