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 NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.Mar 6, 1989 · N45861 · Substantial damageNTSB MIA89FA098Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Lauderdale, FLInstructor pilots failure to maintain control of the aircraft resulting in a collision with terrain.Mar 6, 1989 · N47115 · DestroyedNTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.Mar 6, 1989 · N777ML · Substantial damageNTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.Mar 6, 1989 · N24236 · DestroyedNTSB ANC89FA049Accident · Minor injuriesField investigationFinal reportCessna A-185-F · Puntilla Lake, AKThe pilot's failure to obtain an adequate airspeed, the turn to reverse course maneuver performed at the reduced airspeed and poor preflight planning. Contributing to the accident were the mountainous terrain and the downdraft conditions.Mar 6, 1989 · N1292F · Substantial damageNTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.Mar 5, 1989 · N79PK · Substantial damageNTSB NYC89FA095Accident · 1 fatalField investigationFinal reportPiper PA-28 · Douglas Twsp, PAPoor judgement of the student pilot by flying while under the influence of alcohol, and his VFR flight in instrument meteorological conditions (IMC) without the required qualification or training. Factors factors related to the accident were: failure of the…Mar 5, 1989 · N5348S · DestroyedNTSB MKC89LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Cresco, IAFailure of the pilot to maintain control of the airplane during the landing on a closed runway.Mar 5, 1989 · N5371D · Substantial damageNTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.Mar 5, 1989 · N25620 · Substantial damageNTSB LAX89FA120Accident · 4 fatalField investigationFinal reportCessna 170B · Casa Grande, AZThe pilot in command's performance of aerobatic maneuvers, while flying in formation, and his failure to maintain proper clearance.Mar 5, 1989 · N2766C · 2 aircraft · DestroyedNTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.Mar 5, 1989 · N5315D · Substantial damageNTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.Mar 5, 1989 · N9044L · Substantial damageNTSB ATL89LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blountville, TNCarburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.Mar 5, 1989 · N25524 · Substantial damageNTSB SEA89FA053Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lakeview, ORFailure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…Mar 4, 1989 · CFHGH · DestroyedNTSB MKC89LA072Accident · No injuriesLimited investigationFinal reportCessna 310 · Cedar Rapids, IAThe proper touchdown point was not attained by the pilot and the crankshaft failure on one engine. Contributing to the accident were the weather conditions and the approach lights which were contacted.Mar 4, 1989 · N98934 · Substantial damageNTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.Mar 4, 1989 · N42859 · Substantial damageNTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.Mar 4, 1989 · N601RF · Substantial damageNTSB ATL89FA095Accident · 1 fatalField investigationFinal reportBeech 95-B55 · St Marys Island, GAThe pilot continued into IMC conditions where he collided with trees.Mar 4, 1989 · N9299Q · DestroyedNTSB SEA89LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forrest Grove, ORThe pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.Mar 3, 1989 · N7505Y · Substantial damageNTSB MKC89LA071Accident · No injuriesLimited investigationFinal reportCessna 310 · Des Moines, IAThe failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.Mar 3, 1989 · N5119C · Substantial damageNTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.Mar 3, 1989 · N3243B · DestroyedNTSB FTW89LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Bastrop, TXInadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.Mar 3, 1989 · N7407T · Substantial damageNTSB FTW89LA062Accident · No injuriesLimited investigationFinal reportCessna 421B · San Antonio, TXThe failure of the pilot to follow the proper procedures/directives by not following the glideslope which resulted in not being able to attain the proper touchdown point.Mar 3, 1989 · N5999M · DestroyedNTSB FTW89LA061Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Robstown, TXThe pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…Mar 3, 1989 · N735EZ · DestroyedNTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.Mar 3, 1989 · N27FH · DestroyedNTSB ANC89FA048Accident · No injuriesField investigationFinal reportCessna U-206G · Anchorage, AKThe pilot's and company's disregard of hazardous weather conditions and the pilot's failure to maintain control of the airplane. Contributing to the accident were the gusty crosswind conditions.Mar 3, 1989 · N9992Z · Substantial damageNTSB NYC89FA093Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Toms River, NJFailure of the pilot to maintain airspeed and control of the aircraft, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: autoplt malfunction due to improper installation by maintenance personnel and the pilot's…Mar 2, 1989 · N40978 · Substantial damageNTSB MKC89LA073Accident · No injuriesLimited investigationFinal reportCessna 310Q · Norfolk, NEThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadequate flare. Contributingto the accident were the icing conditions and ice accumulation of the wings of the airplane.Mar 2, 1989 · N69806 · Substantial damageNTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.Mar 2, 1989 · N6610Q · Substantial damageNTSB FTW89TL#01Accident · No injuriesClass 3Final reportAeromot Aura · Austin, TXMar 2, 1989 · N11AU · Substantial damageNTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.Mar 1, 1989 · N1729Q · DestroyedNTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.Mar 1, 1989 · N5329B · Substantial damageNTSB MKC89LA068Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Harrisburg, ARThe failure of the hydraulic line which rendered the brake system inoperative.Mar 1, 1989 · N3627D · Substantial damageNTSB MIA89FA096Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · Isla Verde, PRThe failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.Mar 1, 1989 · N28PR · Substantial damageNTSB LAX89DVA06Accident · Serious injuriesFinal reportGrumman G-164A · Riverdale, CAInadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.Mar 1, 1989 · N8547H · DestroyedNTSB FTW89IA064Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Houston, TXFailure of the TRACON final approach controller to assure radar separation between the aircraft. Factors related to the accident were: inadequate supervision by the ATC supervisor, excessive workload for the controller, unclear instructions by the controller,…Mar 1, 1989 · N820NY · 2 aircraft · No damageNTSB DEN89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Evanston, WYThe failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.Mar 1, 1989 · N11009 · Substantial damageNTSB MKC89LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Rapids, MNThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the gusty crosswind conditions.Feb 28, 1989 · N6418D · Substantial damageNTSB BFO89LA023Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2B-20F · San Diego, CAPilot incapacitation for an unknown reason.Feb 28, 1989 · N701DM · DestroyedNTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.Feb 28, 1989 · N2805S · Substantial damageNTSB NYC89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Delmont, NJFailure of the #6 connecting rod.Feb 27, 1989 · N8471P · Substantial damageNTSB NYC89FA092Accident · Minor injuriesField investigationFinal reportCessna S550 · Poughkeepsie, NYThe pilot's improper use of the powerplant controls, which resulted in actuation (tripping) of the reverse load limiters on the thrust reversers and subsequent reduction of available power in both engines. Factors related to the accident were: the pilot's…Feb 27, 1989 · N29X · DestroyedNTSB LAX89LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Yuba City, CAInadequate supervision by the instructor (CFI) which resulted in a delayed go-around, inadequate airspeed, and a stall/mush into the ground. A poor approach by the student pilot was a contributing factor.Feb 26, 1989 · N2377Y · Substantial damageNTSB FTW89LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksboro, TXFailure of the pilot to go around, when she did not attain the proper touchdown point (landed long) and had excessive airspeed to stop on the runway. A factor related to the accident was the unfavorable wind condition (sudden wind shift).Feb 26, 1989 · N8643U · Substantial damageNTSB FTW89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Temple, TXImproper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.Feb 26, 1989 · N5010D · Substantial damageNTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.Feb 26, 1989 · N734DR · Substantial damageNTSB FTW89DQA03Accident · No injuriesFinal reportBurkhart Grob G109B · El Paso, TXPilot in command's loss of control due to overcontrolling the aircraft. The situation was proceeded by a high sink rate that resulted in a hard landing with an inadequate recovery from a bounced landing. Contributing to the accident was the pilot's…Feb 26, 1989 · N224BG · Substantial damageNTSB FTW89DQA02Accident · Serious injuriesFinal reportI.C.A. Brasov IS-28B2 · El Paso, TXThe failure of the pilot to maintain adequate airspeed, while maneuvering to land in turbulent weather, which resulted in a stall/spin and subsequent collision with a tree and the ground. Turbulence was a factor.Feb 26, 1989 · N91363 · Substantial damageNTSB FTW89DQA01Accident · Minor injuriesFinal reportIntermountain Mfg. Callair A-9B · El Paso, TXEngine failure due to the pilot's failure to select the fullest tanks and, failure to maintain adequate flying speed.Feb 26, 1989 · N375MC · Substantial damageNTSB BFO89LA018Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Fort Washington, MDThe passenger failed to maintain adequate clearance from the propeller as she attempted to board the aircraft. Both the pilot failure to supervise the boarding of the passenger and the night light conditions are contributing factors to the accident.Feb 26, 1989 · N8359L · No damage