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 CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.Jun 1, 1989 · N8535Q · Substantial damageNTSB BFO89LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Criders, VAThe pilot failed to maintain directional control of the airplane during the crosswind conditions encountered during the initial takeoff climb.Jun 1, 1989 · N2602L · Substantial damageNTSB BFO89LA039Accident · Minor injuriesLimited investigationFinal reportAircoupe Alon A2A · Sutherland, VALow output of the magnetos which resulted in the loss of full power during the attempted recovery from a simulated forced landing. The pilot ignored indications of an engine problem during start when the engine was hard to start.Jun 1, 1989 · N5488F · Substantial damageNTSB ANC89LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Toksook Bay, AKThe pilot inadvertently landed on water with the gear extended.Jun 1, 1989 · N9360N · Substantial damageNTSB NYC89LA141Accident · No injuriesLimited investigationFinal reportBell 206-L · Wading River, NYThe pilot's failure to control the rate of descent which resulted in a hard landing. Contributing to the accident was a power loss due to a compressor failure.May 31, 1989 · N501RS · Substantial damageNTSB MKC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Scandia, KSImproper planning/decision by the pilot and fuel exhaustion. Contributing factors were the pilot becoming lost/disoriented and small trees.May 31, 1989 · N7450Z · Substantial damageNTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.May 31, 1989 · N85459 · Substantial damageNTSB CHI89FA101Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Bristol, INContinued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…May 31, 1989 · N9114B · DestroyedNTSB SEA89LA095Accident · No injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDA loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.May 30, 1989 · N2756Y · Substantial damageNTSB NYC89LA171Accident · No injuriesLimited investigationFinal reportHughes 369HS · Niagara Falls, NYFailure of the pilot to see and avoid the cables.May 30, 1989 · N9238F · Substantial damageNTSB MKC89LA121Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Snow Lake, ARThe selection of unsuitable terrain to takeoff from by the pilot and the inadequate runway maintenance by airport personnel. Contributing to the accident was the hidden hole which the airplane contacted resulting in the pilot's inability to control the…May 30, 1989 · N3092S · Substantial damageNTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.May 30, 1989 · N4900X · Substantial damageNTSB MIA89LA165Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Keystone Hgts., FLThe tail rotor drive system became disconnected due to a bent tail rotor drive shaft. The trees contributed to the helicopter damage.May 30, 1989 · N53SP · Substantial damageNTSB MIA89LA163Accident · No injuriesLimited investigationFinal reportCessna 150L · Jacksonville, FLThe pilot's failure to have someone operate the airplane's brakes and engine controls during hand propping the engine.May 30, 1989 · N17018 · Substantial damageNTSB MIA89FA164Accident · Serious injuriesField investigationFinal reportAir Tractor AT-401 · Clarksdale, MSThe pilot failed to maintain airspeed resulting in the airplane stalling and descending out of control.May 30, 1989 · N1012H · DestroyedNTSB LAX89LA209Accident · No injuriesLimited investigationFinal reportAeronca 50F · Ontario, CAThe pilot's inability to compensate for existing wind conditions, resulting in the inability to maintain a climb.May 30, 1989 · N23954 · Substantial damageNTSB LAX89LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAThe pilot of the other aircraft displayed poor judgement when he elected to continue taxiing in the runup area when visual lookout could not be maintained.May 30, 1989 · N737WR · 2 aircraft · Minor damageNTSB FTW89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Stratford, TXImproper planning/decision by the pilot, and his inadequate compensation for wind conditions, which resulted in a loss of aircraft control. The wind condition was a related factor.May 30, 1989 · N3279Q · Substantial damageNTSB DEN89FA127Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wilmington, OHThe failure of the pilot to assure an adequate fuel supply and his failure to refuel en route.May 30, 1989 · N8213W · DestroyedNTSB CHI89LA098Accident · No injuriesLimited investigationFinal reportCessna P210N · Wheeling, ILFailure of the pilot to extend the landing gear, which resulted in a wheels-up landing.May 30, 1989 · N4763P · Substantial damageNTSB ATL89LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Trinity, NCThe pilots failure to select a suitable takeoff area based on the weight of the aircraft and the atmospheric conditions at the time of takeoff.May 30, 1989 · N1115T · Substantial damageNTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.May 30, 1989 · N5325N · DestroyedNTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.May 30, 1989 · N2124A · DestroyedNTSB ANC89LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilots failure to maintain directional control of the aircraft during a touch and go landing which resulted in a ground loop.May 30, 1989 · N38582 · Substantial damageNTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.May 29, 1989 · N2770G · Substantial damageNTSB SEA89FA092Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Angoon, AKPilot failed to assure the landing gear on the amphibious floats were retracted for the water landing.May 29, 1989 · N67669 · Substantial damageNTSB MIA89WA167Accident · Minor injuriesForeign investigationCessna R182 · Walker Cay, BahamasMay 29, 1989 · N7367Y · Substantial damageNTSB MIA89LA162Accident · No injuriesLimited investigationFinal reportCessna A152 · Lake Wales, FLImproper planning/decision by the pilot by not properly securing the aircraft or obtaining proper assistance.May 29, 1989 · N4896A · Substantial damageNTSB FTW89LA102Accident · No injuriesLimited investigationFinal reportCessna 150L · Onalaska, TXFuel system exhaustion due to the improper planning/decision by the flight instructor, on the ground, prior to the flight and the improper inflight planning/decision by the student pilot.May 29, 1989 · N17130 · Substantial damageNTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.May 29, 1989 · N5267 · DestroyedNTSB DEN89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rangely, COImproper planning/decision by the pilot. The high wind, gusts, the pilot's lack of recent experience, and his lack of familiarity with the aircraft's new handling characteristics were considered to be contributing factors.May 29, 1989 · N8065D · Substantial damageNTSB DEN89FA123Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Denver, COA right main landing gear vibration of unknown origin, which resulted in a failure of the right main landing gear torque link and side brace.May 29, 1989 · N806NY · Substantial damageNTSB CHI89LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-180 · Frankfort, ILPilot's failure to maintain directional control while attempting to land in cross/tailwind conditions.May 29, 1989 · N4980J · DestroyedNTSB ATL89DKG03Accident · No injuriesFinal reportRotorway Exec · Roswell, GAThe pilots improper use of the tail rotor controls while in a hover. Adding to this was the pilots total lack of experience operating helicopters.May 29, 1989 · N7043T · Substantial damageNTSB ANC89LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Kahiltna Glac, AKThe pilot's decision to commit himself to a landing before completing an evaluation of the weather in the vicinity of the landing site. Contributing to the severity of the accident was the snowbank off the side of the runway with which the aircraft collided.May 29, 1989 · N1047F · Substantial damageNTSB ANC89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKA crack on the left side of the engine crankcase which resulted in a loss of lubricating oil and which forced the pilot to land on a gravel bar which resulted in a nose over during landing.May 29, 1989 · N2828P · Substantial damageNTSB SEA89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Black Diamond, WAPower loss due to magneto failure. Contributing to the accident were lack of suitable terrain for forced landing and the presence of obstacles.May 28, 1989 · N6121D · Substantial damageNTSB NYC89LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oneonta, NYThe pilot lost control of the aircraft while landing in gusty wind conditions.May 28, 1989 · N6470J · Substantial damageNTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.May 28, 1989 · N9646H · Substantial damageNTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.May 28, 1989 · N5543X · DestroyedNTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.May 28, 1989 · N2739C · Substantial damageNTSB LAX89LA207Accident · No injuriesLimited investigationFinal reportCessna A185F · Jackson, CAThe pilot did not establish a climb rate sufficient enough to clear trees before turning towards them during a go-around. Contributing to the accident were gusty crosswinds which changed to a tailwind when the aircraft turned to the right and the pilots…May 28, 1989 · N1042F · Substantial damageNTSB LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…May 28, 1989 · N31277 · Substantial damageNTSB DEN89LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Angel Fire, NMThe pilot's failure to properly evaluate the existing weather conditions and the subsequent takeoff into adverse conditions which degraded the airplane's climb capability. The pilot performed an intentional gear up landing.May 28, 1989 · N9421N · Substantial damageNTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.May 28, 1989 · N17184 · Substantial damageNTSB CHI89LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Crandon, WIImproper inflight planning/decision by the pilot which resulted in loss of control & subsequent wingtip collision with the ground during the landing. The crosswind and turbulence were contributing factors.May 28, 1989 · N4734L · Substantial damageNTSB BFO89LA037Accident · Serious injuriesLimited investigationFinal reportSchweizer I-26E · Churchville, MDThe pilot's failure to maintain adequate airspeed during the turn from base to final approach which resulted in the wing contacting the ground and the glider cartwheeling.May 28, 1989 · N1124S · DestroyedNTSB NYC89LA138Accident · No injuriesLimited investigationFinal reportHughes 269A · Swanton, VTThe pilot failed to maintain directional control.May 27, 1989 · CFBMF · Substantial damageNTSB NYC89LA136Accident · No injuriesLimited investigationFinal reportMaule M5 · Kutztown, PAAn off airport landing in unsuitable terrain due to a power loss for undetermined reasons.May 27, 1989 · N5669Y · DestroyedNTSB MKC89LA118Accident · No injuriesLimited investigationFinal reportBeech V35 · Strong, AREngine failure due to fuel starvation.May 27, 1989 · N18307 · Substantial damage