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 NYC89FA135Accident · 2 fatalField investigationFinal reportCessna 172M · Bradford, VTFailure of the rated pilots in both aircraft to see and avoid a midair collison.May 21, 1989 · N1272U · 2 aircraft · Minor damageNTSB MKC89LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ramsey, MNThe passengers interference with the flight controls and the pilot's failure to maintain control of the aircraft. Contributing to the severity of the accident was the ditch located short of the runway which the aircraft contacted.May 21, 1989 · N2746K · Substantial damageNTSB MIA89FA151Accident · 1 fatalField investigationFinal reportCessna TU206F · Immokalee, FLThe pilot's failure to establish the descent angle which would attain the proper touchdown point. Consequently, the airplane collided, in flight, with the airport boundary fence.May 21, 1989 · N8720Q · DestroyedNTSB LAX89LA200Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Bakersfield, CAThe loss of engine power due to fuel exhaustion. The pilot did not adequately plan for the flight in that he did not calculate the fuel consumption accurately, failed to provide for adequate fuel reserves, and also failed to land at airports short of his…May 21, 1989 · N18515 · Substantial damageNTSB LAX89LA197Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350D · Waialae Falls, HIImproper maintenance/adjustment of the engine fuel control unit by company maintenance personnel, which resulted in a slight loss of engine power, and failure of the pilot to maintain rotor RPM, while turning and taking off from a hover with a relatively…May 21, 1989 · N6003S · Substantial damageNTSB FTW89LA095Accident · Serious injuriesLimited investigationFinal reportAeronca 65-TAC · Pryor, OKThe failure of the pilot to maintain airspeed during a low pass over the airport after pulling up to clear wires which resulted in a stall.May 21, 1989 · N39304 · Substantial damageNTSB DEN89LA122Accident · No injuriesLimited investigationFinal reportCessna 175 · Sheridan, WYBinding (stuck) #4 exhaust valve. High vegetation (hay) and a hidden obstruction (ditch) were contributing factors.May 21, 1989 · N7557M · Substantial damageNTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.May 21, 1989 · N8267Z · Substantial damageNTSB CHI89DET05Accident · 2 fatalFinal reportBillings/White Avid Flyer · Niles, MILoose carburetor(s) due to improper maintenance/installation, which resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and…May 21, 1989 · N305BJ · DestroyedNTSB CHI89DCA01Accident · Minor injuriesFinal reportZengel RV-4 · Columbia, ILThe improper routing of engine fuel lines resulting in over temperature of the lines which resulted in the fuel flow to carburetor to fluctuate and cause over rich condition and loss of engine power.May 21, 1989 · N371FZ · Substantial damageNTSB ATL89FA150Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Jamestown, TNThe pilot failed to maintain adequate airspeed to avoid an inadvertent stall. The stall occurred at an altitude which precluded recovery prior to ground impact. Contributing to the accident was the pilot's lack of proficiency in the airplane.May 21, 1989 · N5003M · Substantial damageNTSB NYC89LA133Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N · Canaan, CTA loss of power due to contamination of the fuel system.May 20, 1989 · N4742C · Substantial damageNTSB MIA89LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco, FLFailure of the pilot to control the approach speed which resulted in a bounced landing. No recovery was made from the bounced landing, and the airplane was allowed to stall. The airplane then landed on the nose landing gear, which resulted in its overload…May 20, 1989 · N5313B · Substantial damageNTSB LAX89LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAThe collapse of the right main landing gear due to a bent rod end which prevented the landing gear drag link to lock over center.May 20, 1989 · N6545P · Substantial damageNTSB LAX89LA199Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Arcata, CAThe pilots inaccurate fuel consumption calculations and improper fuel tank selector position. These resulted in fuel starvation to both engines when the aux tanks ran dry and the mains had fuel remaining in them. A factor in this accident was the rough…May 20, 1989 · N35479 · Substantial damageNTSB FTW89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Decatur, TXInadequate inspection of the exhaust system by the maintenance personnel during the latest annual inspection.May 20, 1989 · N5874P · Substantial damageNTSB FTW89DRG07Accident · No injuriesFinal reportCessna A188B · La Coste, TXThe pilot's failure to attain sufficient airspeed for flight at departure.May 20, 1989 · N731ST · Substantial damageNTSB FTW89DQG03Accident · Minor injuriesFinal reportWeatherly 201B · Miami, TXThe pilot's failure to maintain adequate clearance from a known obstacle during agricultural spray flight operations,May 20, 1989 · N1271W · Substantial damageNTSB DEN89DQA01Accident · No injuriesFinal reportMccoy BD-5 · Farmington, NMThe malfunction of the aircraft electrical system due to a faulty circuit breaker. The subsequent failure of the electrical system resulted in failure of the engine ignition system and loss of engine power.May 20, 1989 · N71HM · Substantial damageNTSB BFO89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Warrenton, VAThe failure of the glider pilot to maintain a proper climb rate during takeoff and the delay in releasing from the towplane after realizing that he was climbing well above the towplane. Contributing to the accident was the updraft encountered after takeoff…May 20, 1989 · N9489P · Substantial damageNTSB ATL89FA149Accident · 1 fatalField investigationFinal reportBeech S35 · Russellville, KYImproper planning/decision by the pilot, his continued flight into an area of known adverse weather, and his failure to maintain control of the aircraft. Contibuting factors were: the dark night, the adverse weather conditions, and the pilot's overconfidence…May 20, 1989 · N6863Q · Substantial damageNTSB ANC89LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Tok Junction, AKThe pilot's failure to lower the landing gear for landing. A factor related to the accident was his failure to use a checklist.May 20, 1989 · N87TS · Substantial damageNTSB NYC89LA134Accident · No injuriesLimited investigationFinal reportMaule M-4 · Csttltn-Hdsn, NYThe pilot's selection of unsuitable terrain. A contributing factor was the wet, soft grass.May 19, 1989 · N4713T · Substantial damageNTSB LAX89LA198Accident · No injuriesLimited investigationFinal reportCessna 140 · Placerville, CATotal failure of the landing gear tire. A major factor was the unsuitability of the terrain at the side of the runway.May 19, 1989 · N76675 · Substantial damageNTSB FTW89LA094Accident · No injuriesLimited investigationFinal reportCessna 177B · Harrah, OKFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve; and his improper planning/decision (indecision) concerning an attempted go-around. The pilot's lack of experience in the type of aircraft…May 19, 1989 · N1275C · Substantial damageNTSB FTW89DRA05Accident · Minor injuriesFinal reportBoeing A75 · East Bernard, TXWater in fuel from improper servicing of the aircraft and improper preflight by the pilot. The tailwind & soft/wet terrain were contributing factors.May 19, 1989 · N1722B · DestroyedNTSB DEN89LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Miles City, MTThe pilot's improper decision to land and attempt to taxi at an airport where strong winds would not permit safe ground handling of the aircraft.May 19, 1989 · N2774F · Substantial damageNTSB CHI89FA092Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Marion, ILFailure of the pilot to maintain directional control of the aircraft. Contributing to the accident was lack of crew coordination and inappropriate remedial action on the part of the aircrew, and improper maintenance modification by the operator.May 19, 1989 · N232AM · Substantial damageNTSB BFO89LA034Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Indian Head, MDPilot failed to maintained directional control during recovery from a hard landing.May 19, 1989 · N85715 · Substantial damageNTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.May 18, 1989 · N24984 · Substantial damageNTSB MIA89LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe instructors decision to attempt a takeoff in a high density altitude situation, with a quartering tailwind.May 18, 1989 · N29241 · Substantial damageNTSB FTW89DRG06Accident · 1 fatalFinal reportHughes 269C · Rocksprings, TXThe pilot diverted his attention from operation of the helicopter, failed to maintian proper rotor RPM, and failed to maintain altitude (clearance) above the ground, while maneuvering at low altitude. A contributing factor was his impairment from use of a…May 18, 1989 · N58228 · DestroyedNTSB ATL89LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Hinckley, OHThe pilots failure to calculate proper fuel consumption for the flight which resulted in fuel exhaustion.May 18, 1989 · N24334 · Substantial damageNTSB ANC89LA074Accident · No injuriesLimited investigationFinal reportGrumman G21 · Togiak, AKInadequate compensation for wind conditions by the pilot, which resulted in a loss of directional control. A factor related to the accident was: the gusty crosswind condition.May 18, 1989 · N4763C · Substantial damageNTSB ANC89LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Harding Lake, AKThe pilot's failure to adequately compensate for the existing wind conditions. A factor related to the accident was: the gusty/variable wind condition.May 18, 1989 · N7761D · Substantial damageNTSB ANC89LA072Accident · No injuriesLimited investigationFinal reportCessna 182H · White Mountain, AKThe pilot's selection of the wrong runway, which was closed. A factor related to the accident was: the snow crusted runway.May 18, 1989 · N1997X · Substantial damageNTSB SEA89LA088Accident · Serious injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKThe pilot misjudging clearance from trees during a hover descent.May 17, 1989 · N614RM · Substantial damageNTSB SEA89LA087Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDThe pilot's improper use of the helicopter's flight controls. Contributing to the accident was the pilot's misjudgement of the external load characteristics.May 17, 1989 · N5013C · Substantial damageNTSB DEN89LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Colorado Spgs, COInadequate compensation for the wind conditions by the pilot. The high density altitude and wind conditions were contributing factors.May 17, 1989 · N624H · Substantial damageNTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.May 17, 1989 · N4240N · DestroyedNTSB ANC89IA071Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · Anchorage, AKFailure of tires on the right inside main gear truck. A related factor was: failure of operator/management personnel to follow proper loading procedures, which resulted in an improper lateral weight and balance situation.May 17, 1989 · N818FT · Minor damageNTSB MIA89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Gainesville, FLPilot's inability to properly flare due to a high sink rate as a result of insufficient airspeed which resulted in a hard landing short of and off of the runway.May 16, 1989 · N43797 · Substantial damageNTSB DEN89LA125Accident · No injuriesLimited investigationFinal reportChampion 7EC · St George, UTInadequate compensation for the wind conditions by the pilot. The gusty crosswind, soft terrain, and ditch were contributing factors.May 16, 1989 · N7525E · Substantial damageNTSB CHI89LA090Accident · No injuriesLimited investigationFinal reportCessna 150 L · Eureka, MIStudent pilot's improper aircraft control during the takeoff roll, and the subsequent aborted takeoff was performed with insufficient runway remaining to successfully stop the aircraft before the departure end of the runway.May 16, 1989 · N7531G · Substantial damageNTSB SEA89LA089Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Copalis Beach, WAThe pilot's failure to perform the necessary preflight planning and preparation which resulted in the selection of unsuitable terrain for landing. Contributing to the accident was the soft sand bar.May 15, 1989 · N8978R · Substantial damageNTSB MKC89FA110Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Winslow, ARThe pilot flying into adverse weather conditions which resulted in the in-flight separation of a portion of the right wing. Contributing to the accident was the pilot's lack of total experience.May 15, 1989 · N8199P · DestroyedNTSB LAX89LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Glendale, AZThe pilot's failure to execute a go around in a timely manner. The delay in aborting the landing precluded the airplane from accelerating to a climb airspeed before colliding with a fence.May 15, 1989 · N2335Z · DestroyedNTSB BFO89IA036Incident · No injuriesIncident investigationFinal reportNorthrop T-38A · Washington, DCFailure of the T-38 pilot (in the other aircraft) to follow the ATC clearance and to maintain the proper altitude. Factors related to the incident were: failure of air traffic control (ATC) personnel to recognize the T-38'S improper altitude in a timely…May 15, 1989 · N920NS · 2 aircraft · No damageNTSB NYC89LA132Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTInadequate compensation for wind conditions by the pilot which resulted in not maintaining proper alignment with the runway. The crosswind and soft/wet terrain were contributing factors.May 14, 1989 · N11789 · Substantial damageNTSB LAX89LA194Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Young, AZThe pilots decision to land at the restricted airport which had a tree located 20 feet from the centerline of the runway and his failure to maintain proper alignment with the centerline once he made the decision to land there.May 14, 1989 · N88778 · Substantial damage