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 SEA89LA130Accident · Serious injuriesLimited investigationFinal reportCushing C2 · John Day, ORThe pilot improperly changed the design of the airplane by elongating holes at the wing attachment. The change was not inspected by a qualified individual. As a result of the change, the wing separated at the spar.Jul 9, 1989 · N129C · Substantial damageNTSB NYC89LA159Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Akron, NYImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: soft terrain in the emergency landing area.Jul 9, 1989 · N3154T · DestroyedNTSB NYC89LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beverly, MACollision with trees during an aborted landing and attempted go-around with insufficient remaining runway.Jul 9, 1989 · N2752M · DestroyedNTSB MKC89LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal, MNAircraft control was not maintained by the pilot in command, due to an improper landing flare which resulted in several bounces. The landing gear failed in overload during the bounced landing.Jul 9, 1989 · N6938H · Substantial damageNTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.Jul 9, 1989 · N5379P · DestroyedNTSB MIA89LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.Jul 9, 1989 · N4680P · Substantial damageNTSB MIA89LA188Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Kissimmee, FLThe failure of the carburetor throttle cable because of an inadequate annual inspection conducted 4.6 flight hours and one month before the accident.Jul 9, 1989 · N6199B · Substantial damageNTSB LAX89LA234Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hollister, CAFlight instructor's failure to take corrective action in sufficient time to prevent the airplane from striking the ground.Jul 9, 1989 · N23916 · Substantial damageNTSB LAX89LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Los Angeles, CAAn undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.Jul 9, 1989 · N609AC · DestroyedNTSB LAX89LA232Accident · No injuriesLimited investigationFinal reportRyan SCW-145 · Santa Paula, CATotal loss of engine power for undetermined reasons.Jul 9, 1989 · N46207 · Substantial damageNTSB FTW89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Blanco, TXInadequate in-flight planning/decisions by not identifying the wind direction along with the failure to maintain airspeed. Contributing to the accident was the tailwind, wires and trees.Jul 9, 1989 · N758AN · Substantial damageNTSB FTW89LA130Accident · No injuriesLimited investigationFinal reportStinson V77 · El Paso, TXPilot's failure to maintain directional control during landing roll in a high crosswind environment.Jul 9, 1989 · N65345 · Substantial damageNTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…Jul 9, 1989 · N6342G · DestroyedNTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.Jul 9, 1989 · N2165J · DestroyedNTSB CHI89IA145Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the citabria.Jul 9, 1989 · N265MC · No damageNTSB CHI89IA144Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the baron.Jul 9, 1989 · N263MC · No damageNTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.Jul 9, 1989 · N939ML · No damageNTSB BFO89LA056Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bealeton, VAWater in the fuel, which resulted in a momentary loss of power during an inverted low pass, and the pilot's failure to plan the maneuver to allow for appropriate remedial action.Jul 9, 1989 · N56940 · DestroyedNTSB ATL89DLT04Accident · Minor injuriesFinal reportPitts S-1 · Butler, TNThe failure of the pilot to maintain clearance from the surface during an impromptu acrobatic maneuver.Jul 9, 1989 · N8336 · Substantial damageNTSB NYC89LA168Accident · No injuriesLimited investigationFinal reportMooney M20C · Stormville, NYFailure of the pilot to maintain airspeed which resulted in an inadvertent stall.Jul 8, 1989 · N6872N · Substantial damageNTSB MKC89LA155Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Wymore, NEThe pilot's failure to maintain airspeed and altitude during climbout. Contributing to the accident was the high density altitude.Jul 8, 1989 · N1286W · Substantial damageNTSB MIA89IA187Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Naples, FLLeft main gear collapsed due to poor maintenance.Jul 8, 1989 · N8422Y · Minor damageNTSB LAX89LA265Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58T · Susanville, CAThe pilot's inflight decision to enter a descent when he lost yaw control of the aircraft. Turbulent weather conditions and an abrupt touchdown were factors in the accident.Jul 8, 1989 · N6306 · Substantial damageNTSB LAX89LA237Accident · No injuriesLimited investigationFinal reportCessna 150K · Woodland, CAThe pilot's poor judgement in not assuring an adequate fuel supply was on board for the flight.Jul 8, 1989 · N6352G · Substantial damageNTSB FTW89DPJ08Accident · Serious injuriesFinal reportGrumman G-164 · Guymon, OKFailure of the upper right engine mount (firewall attach bolt) due to fatigue, and failure of the lower right mounting bolt for an unknown reason, which allowed overload failure of the two remaining mounting bolts and separation of the engine.Jul 8, 1989 · N788Y · Substantial damageNTSB DEN89LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenwood Spgs, COInadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.Jul 8, 1989 · N2720E · Substantial damageNTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.Jul 8, 1989 · N4069H · Substantial damageNTSB DEN89LA160Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Holden, UTThe pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.Jul 8, 1989 · N6754Q · Substantial damageNTSB CHI89FA129Accident · 2 fatalField investigationFinal reportPiper PA-18 · Roscommon, MILoss of control in flight while maneuvering and the failure to perform remedial action by the PIC.Jul 8, 1989 · N2336J · DestroyedNTSB ATL89LA176Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Holly Hill, SCPilot misjudged his landing approach path and crossed the runway threshold too high to safely complete the landing. He also flared the airplane at too high an altitude resulting in a stall to a hard touchdown on the nose wheel exceeding the structural…Jul 8, 1989 · N4594T · Substantial damageNTSB ATL89FA175Accident · 2 fatalField investigationFinal reportBeech A45 · Troy, ALThe pilot's improper use of the airplane flight controls during a aerobatic maneuver at low altitude due to his lack of aerobatic experience. A contributing factor was the pilot's overconfidence in his ability to perform the maneuver.Jul 8, 1989 · N7973A · DestroyedNTSB ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.Jul 8, 1989 · N6941Z · DestroyedNTSB ANC89LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKLoss of engine power for an unknown reason. A factor related to the accident was: rough terrain in the emergency landing area.Jul 8, 1989 · N7029K · Substantial damageNTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.Jul 7, 1989 · N53W · Substantial damageNTSB LAX89LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Venice, CAThe improper installation and inspection of the carburetor throttle linkage arm.Jul 7, 1989 · N704YY · Substantial damageNTSB DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.Jul 7, 1989 · N2802J · Substantial damageNTSB DEN89LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Tierra Amarilla, NMThe failure of the pilot to maintain rotor RPM during the premature lift-off which resulted in a forced landing. Contributing to the accident was the high density altitude conditions, and unsuitable terrain.Jul 7, 1989 · N8132J · Substantial damageNTSB DEN89LA158Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Bountiful, UTThe pilot failed to maintain adequate speed for the turning maneuver (to avoid an obstacle) and inadvertently allowed the aircraft to stall. Contributing factors were: improper uuse of the flaps, high density altitude, and a high obstruction.Jul 7, 1989 · N6318K · DestroyedNTSB CHI89FA128Accident · 3 fatalField investigationFinal reportBeech 58 · Battle Creek, MIThe flight crew inadvertently shut down the left engine after the right engine lost power, and the copilot failed to maintain control of the aircraft while maneuvering the aircraft back toward the runway. Factors related to the accident were: improper…Jul 7, 1989 · N9253A · DestroyedNTSB BFO89LA055Accident · Serious injuriesLimited investigationFinal reportHughes 500D · Williamson, WVPilot's failure to see and avoid the wire which crossed the end of the field in which he was taking off.Jul 7, 1989 · N51516 · Substantial damageNTSB MIA89LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLThe inadequate pre-flight examination by the pilot, after refueling, which failed to detect water in the fuel.Jul 6, 1989 · N9473N · Substantial damageNTSB MIA89IA186Incident · No injuriesIncident investigationFinal reportBell 206L-1 · Chiefland, FLEngine failure due to failure of the first stage turbine wheel disk.Jul 6, 1989 · N2137U · No damageNTSB LAX89LA231Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Sacramento, CAThe partial blockage of the engine induction system which resulted from improper maintenance.Jul 6, 1989 · N747JR · Substantial damageNTSB LAX89LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Merced, CAThe pilot's inadequate preflight planning/preparation, resulting in fuel exhaustion.Jul 6, 1989 · N8212Y · Substantial damageNTSB LAX89DUG05Accident · No injuriesFinal reportSalmon KR-2 · Chino, CAThe pilot's overcontrolling of the aircraft. A factor in the accident was that this was the pilot's first flight in the aircraft.Jul 6, 1989 · N1033A · Substantial damageNTSB ANC89LA117Accident · No injuriesLimited investigationFinal reportCessna 206 · Eureka, AKThe pilot failed to maintain control of the airplane during a hard landing a subsequent go-around attempt.Jul 6, 1989 · N60529 · Substantial damageNTSB ANC89LA116Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Killey River, AKThe pilot failed to assure sufficient alt was obtained to compensate for the downdrafts near the ridge line.Jul 6, 1989 · N88273 · Substantial damageNTSB ANC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Queens Cannery, AKThe pilot misjudged his altitude and distance to the runway during the approach and failed to attain the proper touchdown point. The gusty crosswind and berm were contributing factors.Jul 6, 1989 · N2585M · Substantial damageNTSB MKC89DPG02Accident · 1 fatalFinal reportRockwell S-2R · Reyno, ARImproper in-flight planning/decision by the pilot which resulted in a tight maneuver at inadequate airspeed and a subsequent stall. A contributing factor was the presence of high obstructions (trees).Jul 5, 1989 · N4931X · DestroyedNTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.Jul 5, 1989 · N5295H · Destroyed