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 FTW96LA320Accident · 2 fatalLimited investigationFinal reportQualline Hatz CB-1 · Pipe Creek, TXloss of aircraft control in flight for undetermined reason(s).Jul 27, 1996 · N485D · DestroyedNTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.Jul 27, 1996 · N4630 · Substantial damageNTSB CHI96LA259Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Hazelton, NDinadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…Jul 27, 1996 · N5247M · Substantial damageNTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.Jul 27, 1996 · N1620V · Substantial damageNTSB ANC96LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Dillingham, AKThe pilot's failure to maintain an adequate visual lookout in order to see and avoid all ground personnel, his failure to follow company procedures and directives regarding Public Protection, and his disregard of the unsafe/hazardous conditions created by…Jul 27, 1996 · N4763C · No damageNTSB ANC96FA109Accident · 2 fatalField investigationFinal reportCessna 180B · Iliamna, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and failure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the adverse weather condition (low ceiling and…Jul 27, 1996 · N9141T · DestroyedNTSB SEA96LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Nez Perce, IDthe pilot's improper in-flight decision to turn up a canyon, which the aircraft was unable to out-climb. Factors relating to the accident were: high ambient temperature, high density altitude, blind/box canyon, and trees in the area where the aircraft's climb…Jul 26, 1996 · N61842 · Substantial damageNTSB SEA96FA170Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Libby, MTcollision with rising mountainous terrain for unknown reason(s).Jul 26, 1996 · N3071R · DestroyedNTSB NYC96LA159Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Alexandria, NJfailure of the commercial pilot to ensure that directional control was maintained during takeoff, which led to a ground swerve and collision with a fence.Jul 26, 1996 · N9232E · Substantial damageNTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.Jul 26, 1996 · N8086V · Substantial damageNTSB SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.Jul 25, 1996 · N9624P · Substantial damageNTSB SEA96LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Kettle Falls, WAthe pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.Jul 25, 1996 · N4478L · DestroyedNTSB LAX96FA290Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Mound House, NVthe flight instructor's improper in-flight planning/decision by allowing the student pilot to get too low during a simulated emergency landing before initiating a go-around.Jul 25, 1996 · N57438 · DestroyedNTSB IAD96LA123Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Union Bridge, MDloss of engine power for undetermined reason(s).Jul 25, 1996 · N6169R · Substantial damageNTSB IAD96LA122Accident · 1 fatalLimited investigationFinal reportCessna 150L · Philippi, WVthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from trees, while maneuvering at low altitude. Intentional maneuvering at low altitude was a…Jul 25, 1996 · N21953 · DestroyedNTSB FTW96LA326Accident · No injuriesLimited investigationFinal reportRockwell International S2R · Tahlequah, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 25, 1996 · N4886X · Substantial damageNTSB FTW96LA318Accident · Minor injuriesLimited investigationFinal reportSteward Breezy · Owasso, OKthe pilot's failure to secure his cargo prior to departure. A factor was the lack of suitable terrain available for the forced landing.Jul 25, 1996 · N2343 · Substantial damageNTSB FTW96LA317Accident · Serious injuriesLimited investigationFinal reportRockwell 112TC · Santa Rosa, NMloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.Jul 25, 1996 · N1874J · DestroyedNTSB FTW96LA316Accident · 2 fatalLimited investigationFinal reportKraft AIR Master · Katy, TXthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation, loss of engine power, and a forced landing. The lack of suitable terrain for a forced landing was a related factor.Jul 25, 1996 · N222Y · DestroyedNTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.Jul 25, 1996 · N6106K · Substantial damageNTSB ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.Jul 25, 1996 · N9167T · Substantial damageNTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…Jul 24, 1996 · N750LT · DestroyedNTSB NYC96FA158Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Sea Bright, NJthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane, due to spatial disorientation, which resulted in a collision with water. Factors relating to the accident were the pilot's…Jul 24, 1996 · N84280 · DestroyedNTSB NYC96FA157Accident · 2 fatalField investigationFinal reportCessna 182P · Brewer, MEfailure of the pilot to maintain control of the airplane, during a missed approach, after diverting to an alternate destination, while on his first solo flight in instrument meteorological conditions (IMC).Jul 24, 1996 · N9920E · DestroyedNTSB LAX96LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Kneeland, CAthe pilot's misjudgment of distance and speed, during the landing, and his failure to execute a go-around, when a proper touchdown point was not attained.Jul 24, 1996 · N48DH · Substantial damageNTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.Jul 24, 1996 · N9743C · Substantial damageNTSB FTW96FA319Accident · 2 fatalField investigationFinal reportChester Glasair RG · Lafayette, LAfailure of the pilot to maintain proper altitude (and clearance above wooded terrain), while diverting to an alternate destination. Factors relating to the accident were: the loss of the comm/nav equipment as a result of an electrostatic discharge, darkness,…Jul 24, 1996 · N127E · DestroyedNTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.Jul 24, 1996 · N303Y · Substantial damageNTSB CHI96LA246Accident · Minor injuriesLimited investigationFinal reportElliot Steen Skybolt · Belleville, ILthe inadequate weld on the landing gear by the builder/pilot.Jul 24, 1996 · N596E · Substantial damageNTSB ANC96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nikiski, AKThe pilot's failure to maintain directional control during takeoff.Jul 24, 1996 · N2831F · Substantial damageNTSB SEA96LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stehekin, WAthe pilot's improper planning/decision, and his failure to ensure that the airplane would remain clear of trees during the takeoff. Factors relating to the accident were: high density altitude, and the proximity of trees to the runway.Jul 23, 1996 · N49794 · Substantial damageNTSB SEA96FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Yellow Pine, IDfailure of the pilot to maintain adequate airspeed, while maneuvering in mountainous terrain, which resulted in a stall/spin and collision with terrain.Jul 23, 1996 · N2161D · DestroyedNTSB NYC96LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Turner, MEthe pilot's inadequate preflight inspection, by failing to remove the pitot tube cover, which resulted in false airspeed indications, and his failure to maintain adequate obstacle clearance from a utility pole.Jul 23, 1996 · N3269J · Substantial damageNTSB MIA96LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Brewton, ALa loss of engine power for undetermined reasons.Jul 23, 1996 · N4223U · Substantial damageNTSB LAX96LA288Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Weed, CAThe pilot's improper fuel management. A factor was the lack of suitable terrain for the forced landing.Jul 23, 1996 · N8787X · Substantial damageNTSB LAX96LA287Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Lost Hills, CAimproper installation of the carburetor air box.Jul 23, 1996 · N7885S · Substantial damageNTSB LAX96LA286Accident · Serious injuriesLimited investigationFinal reportBeech J-35 · Lovelock, NVfuel starvation.Jul 23, 1996 · N8399J · Substantial damageNTSB IAD96LA121Accident · Minor injuriesLimited investigationFinal reportCorben Baby Ace C-1 · Portsmouth, OHthe pilot's inadequate preflight inspection, which resulted in a loss of engine power during the initial climb out. A related factor was the rising terrain encountered during the forced landing.Jul 23, 1996 · N75H · Substantial damageNTSB SEA96LA161Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Sunnyside, WAinadequate preflight by the pilot, and subsequent fuel exhaustion. Factors relating to the accident were: darkness, and high vegetation (brush and small trees) in the emergency landing area.Jul 22, 1996 · N6439N · Substantial damageNTSB NYC96LA154Accident · No injuriesLimited investigationFinal reportCessna 172K · West Milford, NJthe pilot's failure in attaining the proper touchdown point, and his delay in initiating a go-around (aborted landing).Jul 22, 1996 · N46700 · Substantial damageNTSB MIA96LA193Accident · No injuriesLimited investigationFinal reportCessna 210L · Fort Myers, FLfailure of the pilot (PIC) to ensure that an adequate preflight inspection was performed; a missing (or loose) fuel cap on the left wing; probable fuel siphoning; and fuel exhaustion, which resulted in a loss of engine power and a subsequent forced landing…Jul 22, 1996 · N1623X · Substantial damageNTSB LAX96LA285Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA-20-A1 · Vacaville, CAimproper planning/decision by the instructor pilot, which resulted in subsequent fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.Jul 22, 1996 · N236BR · Substantial damageNTSB LAX96FA284Accident · 1 fatalField investigationFinal reportCessna 210M · Corning, CAimproper installation of an electrical component, during an alteration of the aircraft electrical system; and subsequent electrical insulation failure, which resulted in electrical shorting, arcing, and an electrical fire. Factors relating to the accident…Jul 22, 1996 · N6002N · DestroyedNTSB FTW96LA314Accident · No injuriesLimited investigationFinal reportBarton Sylkie 1 · Erie, COThe pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.Jul 22, 1996 · N711WB · Substantial damageNTSB ATL96LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Memphis, TNInadequate annual inspection that resulted in the in-flight loss of the fuel system strainer and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.Jul 22, 1996 · N3122C · Substantial damageNTSB LAX96LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder City, NVa loss of directional control due to the student pilot's inadequate compensation for wind conditions and improper remedial action. Factors in the accident were crosswinds, inadvertent brake application, and failure to use the ailerons.Jul 21, 1996 · N6389D · Substantial damageNTSB FTW96LA312Accident · No injuriesLimited investigationFinal reportCessna 182A · Skiatook, OKa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Jul 21, 1996 · N2182G · Substantial damageNTSB CHI96LA252Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · East Troy, WIcorrosion and fracture of the rudder control horn.Jul 21, 1996 · N58712 · Substantial damageNTSB CHI96LA251Accident · No injuriesLimited investigationFinal reportMaule M5-210TC · Olathe, KSthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the uncontrolled porpoise encountered and the pilot's lack of recent experience in tailwheel airplanes.Jul 21, 1996 · N5646N · Substantial damageNTSB ANC96LA103Accident · No injuriesLimited investigationFinal reportCessna 172XP · Kenai, AKThe loss of engine power due to seized piston connecting rod bearings, and subsequent failure of the piston connecting rod cap and fracture of the piston connecting rod. A factor associated with the accident was the rough and uneven emergency landing site.Jul 21, 1996 · N736LB · Substantial damage