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 SEA96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDcorrosion in the left main landing gear cluster, which resulted in a failure of the left main landing gear. Inadequate inspection by undetermined maintenance personnel was a related factor.Aug 13, 1996 · N7507D · Substantial damageNTSB SEA96LA190Accident · No injuriesLimited investigationFinal reportAviat A-1 · Worland, WYoverload failure of the landing gear axle, after its design stress limits had been exceeded at some undetermined time.Aug 13, 1996 · N56LG · Substantial damageNTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…Aug 13, 1996 · N8109Y · Substantial damageNTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…Aug 13, 1996 · N9913K · Substantial damageNTSB NYC96FA163Accident · 1 fatalField investigationFinal reportBeech A36 · Roanoke, VAthe pilot's failure to follow the published instrument approach procedures, and his delayed missed approach, which resulted in an inflight collision with mountainous terrain.Aug 13, 1996 · N1795W · DestroyedNTSB FTW96LA344Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Port Isabel, TXpilot impairment of judgment and performance due to alcohol and drugs, and failure of the pilot(s) to maintain obstacle clearance, during an intentional low altitude flight manueuver (low pass under a bridge).Aug 13, 1996 · N6316T · DestroyedNTSB SEA96LA188Accident · Minor injuriesLimited investigationFinal reportJonas Exec 90 · Hermiston, ORslippage of the drive belts, while hover taxiing in ground effect, which resulted in loss of power to the rotor system; and inadequate remedial action by the pilot, which led to a roll over during touch down (forced landing). A factor relating to the accident…Aug 12, 1996 · N6183P · Substantial damageNTSB SEA96FA187Accident · Serious injuriesField investigationFinal reportGarlick UH-1H · Coeur D'Alene, IDFatigue fracture of the left forward vertical stabilizer spar, resulting in loss of the vertical stabilizer and tail rotor and subsequent loss of control. A factor was insufficient applicability (by make and model) of an existing FAA airworthiness directive…Aug 12, 1996 · N97NW · Substantial damageNTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…Aug 12, 1996 · N8121K · Substantial damageNTSB LAX96LA305Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Rosamond, CAThe pilot's inadequate preflight planning and his delayed decision to reverse the airplane's direction.Aug 12, 1996 · N5616L · DestroyedNTSB FTW96LA341Accident · No injuriesLimited investigationFinal reportAyres S-2R · Wharton, TXtotal loss of engine power due to a fractured torque sensor shaft. Factors relating to the accident were: the obstructions (fence and trees) in the emergency landing area.Aug 12, 1996 · N3084X · Substantial damageNTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.Aug 12, 1996 · N1797S · DestroyedNTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.Aug 12, 1996 · N31774 · Substantial damageNTSB ANC96FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman G21-G · Dutch Harbor, AKUndetermined.Aug 12, 1996 · N660PA · DestroyedNTSB SEA96FA186Accident · 1 fatalField investigationFinal reportLet L-13 · Shelton, WAfailure of the operator to provide its pilots with information essential for an accurate determination of the glider's weight and balance, the resultant operation of the glider with a center-or-gravity that exceeded the aft limit, and the pilot's inadvertent…Aug 11, 1996 · N90865 · Substantial damageNTSB SEA96FA185Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Marsing, IDloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with terrain.Aug 11, 1996 · N2836E · Substantial damageNTSB MIA96LA210Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Adel, GAthe pilot's misjudgment of clearance between the helicopter and the antenna. A factor relating to the accident was the pilot's use of a drug (medication) that had sedative effects.Aug 11, 1996 · N9472G · DestroyedNTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.Aug 11, 1996 · N2598G · Substantial damageNTSB IAD96FA132Accident · 3 fatalField investigationFinal reportCessna 172P · Summersville, WVThe pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees.Aug 11, 1996 · N65632 · DestroyedNTSB FTW96LA346Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Hatch, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Aug 11, 1996 · N8992Q · Substantial damageNTSB FTW96FA339Accident · 1 fatalField investigationFinal reportBeech 23 · Wimberley, TXThe pilot's failure to maintain airspeed. Factors were the high density altitude, the tail wind, and the pilot's failure to adhere to the limitations prescribed by his flight instructor.Aug 11, 1996 · N2382Z · DestroyedNTSB CHI96LA292Accident · No injuriesLimited investigationFinal reportCessna 210E · Clarksville, MOfuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.Aug 11, 1996 · N4963U · Substantial damageNTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.Aug 11, 1996 · N4053G · Substantial damageNTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.Aug 10, 1996 · N5067C · Substantial damageNTSB NYC96LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Worcester, MAthe pilot's improper recovery from a bounced landing, and his failure to maintain control of the airplane, which resulted in a nose over. His improper flare was a related factor.Aug 10, 1996 · N5431Q · Substantial damageNTSB MIA96LA209Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Cottondale, FLimproper assembly of the main rotor blade dampners by a mechanic which resulted in the helicopter being damaged by ground resonance.Aug 10, 1996 · N8784F · Substantial damageNTSB LAX96LA304Accident · No injuriesLimited investigationFinal reportCessna 172N · Fullerton, CAthe pilot's misjudged glide path and delayed remedial action by not promptly initiating a go-around. A contributing factor was the pilot's lack of experience flying the airplane.Aug 10, 1996 · N42ES · Substantial damageNTSB LAX96LA303Accident · No injuriesLimited investigationFinal reportCessna 182B · Santa Ana, CAImproper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.Aug 10, 1996 · N2487G · Substantial damageNTSB IAD96LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Greenfld Twnshp, PAloss of engine power for undetermined reason(s). A high obstruction in the forced landing area was a related factor.Aug 10, 1996 · N6984F · DestroyedNTSB FTW96LA340Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Hudson, COthe pilot's delay in initiating a go-around and failure to attain sufficient airspeed to clear obstructions at the departure end of the runway, which resulted in an inadvertent stall and collision with the ground. Factors relating to the accident were: the…Aug 10, 1996 · N9862M · DestroyedNTSB CHI96LA289Accident · Minor injuriesLimited investigationFinal reportMrotek Minicab GY20 · Albion, INthe pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.Aug 10, 1996 · N263AM · Substantial damageNTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.Aug 10, 1996 · N1823Q · DestroyedNTSB ANC96LA122Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Northway, AKThe pilot's inadequate in-flight planning during a low pass of a remote airstrip and his inadequate compensation for wind conditions. A factor in the accident was unfavorable wind conditions.Aug 10, 1996 · N2502B · Substantial damageNTSB SEA96LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAfailure of the engine magneto drive, which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.Aug 9, 1996 · N738PM · Substantial damageNTSB MIA96LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Farmville, NCThe pilot's inadequate fuel consumption calculations which resulted in loss of engine power do to fuel exhaustion and a hard landing during a forced landing in a field.Aug 9, 1996 · N82313 · Substantial damageNTSB MIA96LA208Accident · 1 fatalLimited investigationFinal reportBeech A36 · Atlantic Ocean (Atlantic Ocean)an inflight collision with the terrain (water) for undetermined reason(s). Factors relating to the accident were: failure of the pilot to obtain a preflight weather briefing, his failure to obtain in-flight weather avoidance assistance, and his resultant…Aug 9, 1996 · N976WL · DestroyedNTSB LAX96LA302Accident · No injuriesLimited investigationFinal reportBeech B23 · Modesto, CAfuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.Aug 9, 1996 · N6087N · DestroyedNTSB IAD96LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Gaithersburg, MDthe unexpected appearance of a deer on the runway.Aug 9, 1996 · N1439T · Substantial damageNTSB FTW96LA343Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Midlothian, TXmaintenance personnel's improper engine overhaul procedures resulting in the installation of the rocker arms in reversed positions, which led to improper lubrication and binding of the exhaust valves. A related factor was the lack of suitable terrain for the…Aug 9, 1996 · N2559R · Substantial damageNTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.Aug 9, 1996 · N6966K · DestroyedNTSB CHI96FA290Accident · 2 fatalField investigationFinal reportAeronca 11AC · Charlotte, MIthe pilot's improper use of engine controls (carburetor heat and/or throttle), while making a relatively high speed approach, low pass, and pull-up, which resulted in partial loss of engine power; and failure of the pilot to maintain sufficient airspeed after…Aug 9, 1996 · N85825 · DestroyedNTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.Aug 9, 1996 · N5291E · Substantial damageNTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.Aug 8, 1996 · N28765 · Substantial damageNTSB SEA96FA182Accident · 1 fatalField investigationFinal reportCessna 182P · St. Anthony, IDThe pilot's failure to maintain directional control during a landing attempt. Factors included: probable dusk lighting conditions and no lights on the airstrip. Conributing to the pilot's injury severity was his failure to fasten his seat belt and shoulder…Aug 8, 1996 · N9136M · Substantial damageNTSB MIA96LA207Accident · Minor injuriesLimited investigationFinal reportStout Glasair III · Boynton Beach, FLinadequate preflight by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.Aug 8, 1996 · N340 · Substantial damageNTSB LAX96LA299Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caruthers, CAthe loss of engine power due to the failure of a cylinder. The road's soft surface was a factor.Aug 8, 1996 · N8598H · Substantial damageNTSB LAX96IA300Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Honolulu, HIImproper installation of a flexible hydraulic hose by company maintenance personnel and inadequate inspection of the work by company inspectors which resulted in the loose hose becoming entangled in the nose gear linkage, preventing complete extension of the…Aug 8, 1996 · N420EA · Minor damageNTSB CHI96LA291Accident · No injuriesLimited investigationFinal reportCessna 150 · Plattsmouth, NEfailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Aug 8, 1996 · N3510L · Substantial damageNTSB CHI96LA277Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Fargo, NDthe pilot's failure to maintain clearance from a wire, while crossing under a transmission line. The proximity of wires to the work area was a related factor.Aug 8, 1996 · N1282W · Substantial damageNTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.Aug 8, 1996 · N9137N · Destroyed