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 FTW97LA353Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · San Marcos, TXThe pilot's loss of control while performing aerobatics resulting in an inadvertent stall/spin. A factor was the lack of altitude available for recovery.Sep 20, 1997 · N73EW · DestroyedNTSB ATL97LA139Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mcgee, MSfuel starvation, while in maneuvering flight, due to the pilot's improper planning/decision.Sep 20, 1997 · N90485 · Substantial damageNTSB ATL97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bennettsville, SCfailure of the pilot to properly plan his approach, and his failure to attain a proper touchdown point for landing.Sep 20, 1997 · N9643K · Substantial damageNTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.Sep 19, 1997 · N6879Y · Substantial damageNTSB MIA97LA250Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Miami, FLThe failure of the pilot to properly plan his descent and approach for a forced landing following partial loss of engine power resulting in the aircraft landing short of the intended landing runway. A factor in the accident was improper inspection of the…Sep 19, 1997 · N4315X · Substantial damageNTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.Sep 19, 1997 · N2562V · DestroyedNTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).Sep 19, 1997 · N70747 · DestroyedNTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.Sep 19, 1997 · N88314 · Substantial damageNTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.Sep 18, 1997 · N8509 · DestroyedNTSB IAD97LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Danbury, CTThe pilot's improper planning/decision to not use actual occupant weights and compute takeoff data, which resulted in an overweight takeoff towards rising terrain.Sep 18, 1997 · N3102R · DestroyedNTSB FTW97FA352Accident · Minor injuriesField investigationFinal reportBell 407 · Grand Isle S108The tail rotor blade strike(s) that severed the aft portion of the tailboom, subsequently rendering the pilot with no tail rotor control while in cruise flight. A factor was the lack of suitable terrain for the forced autorotative landing.Sep 18, 1997 · N467PH · Substantial damageNTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.Sep 18, 1997 · N6421R · Substantial damageNTSB ANC97TA152Accident · No injuriesFinal reportPiper PA-18 · Coldfoot, AKThe overservicing/pressurizing of the hydraulic brake system by maintenance personnel that locked the brake system and prevented directional control.Sep 18, 1997 · N2355H · Substantial damageNTSB MIA97TA246Accident · No injuriesFinal reportHughes 269A · Tarpon Springs, FLthe loss of engine power for undetermined reasons.Sep 17, 1997 · N6786M · Substantial damageNTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.Sep 17, 1997 · N3985P · Substantial damageNTSB MIA97LA245Accident · No injuriesLimited investigationFinal reportLouttit Celebrity · Ridgeland, SCthe in-flight failure of the upper wing spar wood resulting in a forced landing in swampy terrain.Sep 17, 1997 · N729BL · Substantial damageNTSB FTW97GA350Accident · 2 fatalFinal reportBell OH-58A · Newark, TXThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of aircraft control.Sep 17, 1997 · N149SD · DestroyedNTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.Sep 17, 1997 · N43DR · Substantial damageNTSB CHI97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fargo, NDthe pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.Sep 17, 1997 · N2680Q · Substantial damageNTSB FTW97LA351Accident · Serious injuriesLimited investigationFinal reportBrashears MONERAI-S · Artesia, NMthe pilot's improper handling of the aircraft during takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the pilot's lack of recent flight experience in the make and model of aircraft.Sep 16, 1997 · N5575S · Substantial damageNTSB ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.Sep 16, 1997 · N5840Z · Substantial damageNTSB ANC97LA150Accident · No injuriesLimited investigationFinal reportCessna 402C · Kivalina, AKAn overstress fracture of the nose landing gear attachment. A factor associated with the accident was the rough landing area.Sep 15, 1997 · N2649Z · Substantial damageNTSB ANC97LA149Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Bethel, AKThe pilot's abrupt application of brakes during the landing roll.Sep 15, 1997 · N9804M · Substantial damageNTSB SEA97LA210Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · The Dalles, ORthe pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.Sep 14, 1997 · N357DA · Substantial damageNTSB NYC97LA181Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Geneseo, NYThe failure of both pilots to see and avoid the other aircraft.Sep 14, 1997 · N64604 · 2 aircraft · Substantial damageNTSB MIA97LA244Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Louisville, MSThe failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.Sep 14, 1997 · N5662S · Substantial damageNTSB LAX97LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Long Beach, CAthe student pilot's misjudged landing flare which led to a balloon and subsequent hard landing.Sep 14, 1997 · N61913 · Substantial damageNTSB FTW97LA349Accident · No injuriesLimited investigationFinal reportAS+ AC-4B · Sundance, WYimproper planning/decision by the pilot, which led to a snag and sudden slack in the tow rope, and necessitated an aborted launch (emergency landing) after initial liftoff. This in turn led to an inadvertent stall, a wing drop, and the left wing tip dragging…Sep 14, 1997 · N3021 · Substantial damageNTSB FTW97FA348Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Telluride, COfailure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…Sep 14, 1997 · N86708 · DestroyedNTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.Sep 14, 1997 · N175UA · No damageNTSB CHI97FA308Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · St. Ignaces, MIThe noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.Sep 14, 1997 · N9399W · DestroyedNTSB ANC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gulkana, AKThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.Sep 14, 1997 · N4116D · Substantial damageNTSB ANC97LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel tanks. Factors were the worn gaskets on the fuel tank caps, and the pilot's decision to abort the partial power precautionary landing.Sep 14, 1997 · N7894H · Substantial damageNTSB SEA97LA209Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Winlock, WAthe pilot's failure to attain proper alignment during touchdown and failure to maintain directional control. A wet runway was a factor.Sep 13, 1997 · N6004A · Substantial damageNTSB NYC97LA182Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Crimora, VAThe pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..Sep 13, 1997 · N5272X · Substantial damageNTSB MIA97LA253Accident · No injuriesLimited investigationFinal reportCessna 411 · Williston, FLthe pilot-in-command's excessive taxi speed.Sep 13, 1997 · N12WT · Substantial damageNTSB MIA97LA243Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Oxford, NCfatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…Sep 13, 1997 · N9385C · Substantial damageNTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.Sep 13, 1997 · N56474 · Substantial damageNTSB LAX97LA326Accident · Minor injuriesLimited investigationFinal reportLampert M500 · San Carlos, CAloss of engine power for undetermined reasons, and the pilot's improper use of the flight controls following the loss of power. The pilot's lack of training/certification in rotorcraft operations was a factor in this accident.Sep 13, 1997 · N800GL · Substantial damageNTSB FTW97LA346Accident · 1 fatalLimited investigationFinal reportReilly Thorp T-18 · Wagoner, OKthe pilot's failure to maintain airspeed.Sep 13, 1997 · N16LE · DestroyedNTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.Sep 13, 1997 · N14255 · Substantial damageNTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.Sep 13, 1997 · N66547 · Substantial damageNTSB ANC97TA148Accident · No injuriesFinal reportPiper PA-18-150 · Saint Mary'S, AKThe excessive pressure in the brake system resulting from heating of the recently serviced hydraulic fluid in the brake master cylinders, and the resultant locked brakes and inability to maintain directional control of the airplane.Sep 13, 1997 · N7054 · Substantial damageNTSB LAX97LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-180 · Reno, NVThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush. Factors in the accident were: the pilot's lack of qualification in the aircraft; the FAA pilot certification system's failure to transfer the…Sep 12, 1997 · N69645 · Substantial damageNTSB LAX97LA323Accident · No injuriesLimited investigationFinal reportNewberg PL-4A · Placerville, CAfailure of the pilot to maintain directional control of the aircraft during the rollout phase of the landing sequence, which resulted in a gound swerve.Sep 12, 1997 · N44PN · Substantial damageNTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damageNTSB LAX97GA325Accident · 3 fatalFinal reportBell 205A-1 · Sequim, WAthe pilot's intentional flight into known adverse weather conditions in mountainous terrain.Sep 12, 1997 · N90HJ · DestroyedNTSB FTW97LA347Accident · No injuriesLimited investigationFinal reportHughes MDL-369HS · Brinkley, ARThe in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…Sep 12, 1997 · N107CW · Substantial damageNTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.Sep 12, 1997 · N79DK · Substantial damageNTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.Sep 12, 1997 · N18562 · Destroyed