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 NYC89LA126Accident · Minor injuriesLimited investigationFinal reportBell 206A · Bedminster, NJOff airport landing in unsuitable terrain due to an undetermined power loss.Apr 27, 1989 · N273E · Substantial damageNTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.Apr 27, 1989 · N757JS · Substantial damageNTSB MKC89FA099Accident · 3 fatalField investigationFinal reportMaule M-5 · Ainsworth, NEThe pilot continued flight into IFR conditions and the loss of aicraft control due to spatial disorientation. Contributing to the accident were the cloud conditions and fog.Apr 27, 1989 · N20BS · DestroyedNTSB MIA89FA138Accident · No injuriesField investigationFinal reportSwearingen SA-226-AT · Jacksonville, FLThe failure of the pilot in command to use the airplane landing checklist and assure that the landing gear was down and locked prior to landing.Apr 27, 1989 · N39RD · Substantial damageNTSB FTW89LA088Accident · No injuriesLimited investigationFinal reportCessna 182 · Owasso, OKInadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor.Apr 27, 1989 · N5160D · Substantial damageNTSB FTW89LA085Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Jasper, TXThe pilot's misjudgement of his altitude. Factors related to the accident were: light conditions at dawn and ground fog in the area, which resulted in the pilot's lack of visual perception.Apr 27, 1989 · N201TP · DestroyedNTSB CHI89FA078Accident · Minor injuriesField investigationFinal reportCessna 208A · Mt. Zion, ILThe pilot's intentional flight into known adverse weather. Contributing factors were the pilot's poor evaluation of the weather information given him by the air traffic controllers.Apr 27, 1989 · N9637F · Substantial damageNTSB LAX89LA173Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Travis Afb, CAThe left main landing gear failing to fully extend for undetermined reasons resulting in its collapsing during landing.Apr 26, 1989 · N151D · Substantial damageNTSB LAX89DVM02Accident · Minor injuriesFinal reportHiller UH-12E · Salinas, CAThe separation of the torsion coupling in the main rotor drive system.Apr 26, 1989 · N169HA · Substantial damageNTSB FTW89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eufaula, OKThe pilot's improper positioning of the fuel selector, which resulted in a loss of power due to fuel starvation, and his failure to followed the emergency procedure. A factor related to the accident was: rough terrain in the emergency landing area.Apr 26, 1989 · N8654N · Substantial damageNTSB ATL89LA138Accident · No injuriesLimited investigationFinal reportCessna 150 · New Bern, NCThe pilot's improper in-flight planning/decision and a delayed go-around. Turbulence, wet terrain, and a ditch were contributing factors.Apr 26, 1989 · N1595Q · Substantial damageNTSB ATL89LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Jacksonville, NCThe pilot's failure to properly preflight and plan which resulted in a collision with trees. The pilot attempted a takeoff with an over gross weight condition.Apr 26, 1989 · N8260F · DestroyedNTSB ANC89LA066Accident · No injuriesLimited investigationFinal reportCessna 150A · Chisana, AKThe pilot's selection of unsuitable terrain for the landing. The soft/uneven terrain is considred to be a contributing factor.Apr 26, 1989 · N5773E · Substantial damageNTSB MIA89FA137Accident · Serious injuriesField investigationFinal reportCessna 150M · Miramar, FLThe pilot's failure to continue flying the airplane when he noted a vibration of unknown origin. Contributing to the accident was the improper selection of unsuitable terrain to execute a precautionary landing when an airport and a highway median were…Apr 25, 1989 · N3004V · DestroyedNTSB LAX89LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAThe pilot did not adequately preflight the airplane to determine fuel quanity nor did he accurately calculate the fuel consumption. In addition, he failed to position the fuel selector to the fullest tank which resulted in fuel starvation to the engine on…Apr 25, 1989 · N6073W · Substantial damageNTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.Apr 25, 1989 · N98923 · Substantial damageNTSB CHI89LA080Accident · No injuriesLimited investigationFinal reportCessna 411 · Detroit, MIFailure of a bolt in the left main landing gear assembly.Apr 25, 1989 · N444EA · Substantial damageNTSB CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.Apr 25, 1989 · N5498B · Substantial damageNTSB CHI89DEE02Accident · Minor injuriesFinal reportAeronca 7AC · Marseilles, ILPic's overconfidence in the accident aircraft's climb performance as he attempted to take off up hill and over wires.Apr 25, 1989 · N85243 · Substantial damageNTSB BFO89LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing factors were the slight crosswind and the pilot's lack of experience.Apr 25, 1989 · N6558L · Substantial damageNTSB LAX89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Truckee, CAThe improper installation of fuel lines by maintenance personnel who installed the engine.Apr 24, 1989 · N840A · Substantial damageNTSB FTW89LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · San Antonio, TXImproper flare by the pilot, his delay in attempting to abort the landing, and his failure to maintain directional control. A factor related to the accident was: the pilot's failure to attain the proper touchdown point for a landing.Apr 24, 1989 · N63467 · Substantial damageNTSB DEN89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student pilot's improper flare which resulted in a hard landing & separation of the nose landing wheel. Contributing to the accident was the pilot's lack of total experience.Apr 24, 1989 · N49177 · Substantial damageNTSB CHI89LA075Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Watertown, WIThe pilot's improper use of brakes and throttle. A contributing factor was the parked aircraft which was nearby.Apr 24, 1989 · N39868 · Substantial damageNTSB ATL89LA136Accident · No injuriesLimited investigationFinal reportCessna 170 · Orwell, OHThe pilot's decision to takeoff on unsuitable terrain, which resulted in his inability to attain sufficient airspeed to clear the fence(s) near the end of the runway. Factors related to the accident were: the soft runway/terrain conditions & the fence.Apr 24, 1989 · N4409V · Substantial damageNTSB ATL89LA134Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Millersburg, OHThe pilots failure to compensate for the gusty wind conditions during landing.Apr 24, 1989 · N6129C · Substantial damageNTSB ANC89LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.Apr 24, 1989 · N7652A · Substantial damageNTSB NYC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dushore, PACollision with trees during a rejected takeoff from a private turf strip due to the pilots failure to take advantage of the existing wind.Apr 23, 1989 · N2127J · DestroyedNTSB NYC89IA222Incident · No injuriesIncident investigationFinal reportCessna 421C · New York, NYFailure of the liberty sector controller to advise pan am flight 542 of the presence of the Cessna 421 and/or restrict the climb of flight 542 until it had passed the Cessna, and failure of the pan am aircrew to see the Cessna in adequate time to avoid a near…Apr 23, 1989 · N247CB · 2 aircraft · No damageNTSB NYC89IA123Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA-227AC · New York, NYThe failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R.Apr 23, 1989 · N3044J · 2 aircraft · No damageNTSB MKC89FA096Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Wellsville, KSThe failure of the pilot to use carburetor heat during the descent for landing which resulted in a loss of engine power at a critical time in flight, a go-around.Apr 23, 1989 · N4315J · Substantial damageNTSB MIA89LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLFailure of a rocker shaft boss on the number three cylinder. A related factor was the rough terrain in the emergency landing area.Apr 23, 1989 · N704XE · Substantial damageNTSB LAX89LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Long Beach, CAThe pilot's failure to select the proper fuel tank for an adequate fuel supply for the takoeff.Apr 23, 1989 · N8827W · Substantial damageNTSB CHI89LA076Accident · No injuriesLimited investigationFinal reportWaco YMF · Lansing, MIPilot's failure to maintain directional control during the landing roll, and his excessive brake application as the aircraft departed the runway, which resulted in the aircraft nosing over. The pilot's inexperience in taildragger aircraft, and the inadequate…Apr 23, 1989 · N455RT · Substantial damageNTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.Apr 23, 1989 · N642JB · Substantial damageNTSB BFO89LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Laurel, MDThe pilot's failure to obtain adequate airspeed during the attempted short field takeoff for undetermined reasons.Apr 23, 1989 · N1789H · DestroyedNTSB ATL89LA132Accident · No injuriesLimited investigationFinal reportCessna 172F · Elkin Arpt., NCThe failure of the pilot to properly compensate for the gusty wind conditions during takeoff and the delay in his decision to abort the takeoff before colliding with trees. Contributing to the accident were the gusty wind conditions and the pilot's lack of…Apr 23, 1989 · N7908U · Substantial damageNTSB MKC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Brinkley, ARThe pilot's failure to gradually raise the flaps during the go-around and maintain adeqaute airspeed to continue the climbout.Apr 22, 1989 · N2969X · Substantial damageNTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.Apr 22, 1989 · N19220 · Substantial damageNTSB MKC89LA095Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Hot Springs, ARA wheels up landing was performed by the pilot in command, due to the interrupted landing and go-around. A psychological traffic pattern habit interference mind set interfered with the pilots ability to perform the normal functions required by the landing…Apr 22, 1989 · N7739R · Substantial damageNTSB MKC89FA094Accident · 2 fatalField investigationFinal reportPiper J3C · Ashland, NEPoor judgement of the pilot by flying while physically impaired from alcohol consumption, and his failure to maintain adequate airspeed, while flying over a meandering river, which resulted in a stall. A contributing factor was the pilot's inadequate altitude…Apr 22, 1989 · N33066 · Substantial damageNTSB LAX89LA168Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Avalon, CAThe pilot's inadequate compensation for the downdrafts he encountered and the delay in his decision to perform a go-around.Apr 22, 1989 · N97169 · Substantial damageNTSB LAX89LA167Accident · Serious injuriesLimited investigationFinal reportSchweizer T-26E · Fremont, CAThe pilot's failure to maintain sufficient airspeed in an effort to avoid obstacles during an inadequately planned approach.Apr 22, 1989 · N1134S · Substantial damageNTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.Apr 22, 1989 · N2601A · Substantial damageNTSB ATL89LA135Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Brooks, GAClimb not possible because of a downdraft which exceeded the performance capabilities of the airplane. Factors related to the accident were: inadequate location of the wind sock, the adverse wind conditions, and the trees.Apr 22, 1989 · N52652 · Substantial damageNTSB ATL89LA133Accident · No injuriesLimited investigationFinal reportBeech A36 · Macon, GAThe pilot delayed remedial action when the imminent loss of electrical power was observed. Additionally, the pilot's failure to execute the appropriate emergency procedure and manually lower the landing gear, resulted in its collapse upon landing.…Apr 22, 1989 · N6613A · Substantial damageNTSB ANC89LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's continued VFR flight into instrument meteorological conditions and the inadvertant stall/mush of the airplane. Contributing factors are the pilot's overconfidence, self-induced pressure, mountainous terrain and whiteout conditions.Apr 22, 1989 · N1738A · Substantial damageNTSB ANC89LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.Apr 22, 1989 · N90918 · Substantial damageNTSB MKC89LA093Accident · No injuriesLimited investigationFinal reportHuff 1 · Liberty, MOPartial loss of engine power for an unknown reason. The soft terrain (plowed field) was a related factor.Apr 21, 1989 · N59GH · Substantial damageNTSB MIA89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Olive Branch, MSFuel exhaustion caused by the pilot exceeding the fuel endurance of the airplane.Apr 21, 1989 · N51344 · Substantial damage