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 CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.Apr 26, 1992 · N3811W · Substantial damageNTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.Apr 26, 1992 · N59528 · Substantial damageNTSB ATL92FA091Accident · 1 fatalField investigationFinal reportCessna 310R · Gatlinburg, TNThe pilot's continued VFR flight into IMC, and his failure to attain a proper altitude over high, mountainous terrain. Factors were the high terrain, and the fog, clouds, and obscuration at the accident site.Apr 26, 1992 · N3221M · DestroyedNTSB ATL92FA090Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Burnsville, NCThe pilot's failure to adequately evaluate the weather information and his continued visual flight into instrument conditions, which resulted in a collision with high terrain. A factor was the dark night.Apr 26, 1992 · N28110 · DestroyedNTSB MIA92FA115Accident · No injuriesField investigationFinal reportBoeing 707-324C · Miami, FLFailure of the #3 engine pylon inboard midspar support fitting due to fatigue cracking which resulted in the separation of the number three engine and pylon. Contributing to the accident was the inadequate inspection requirements of the manufacturer and the…Apr 25, 1992 · HK360 · Substantial damageNTSB LAX92LA187Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Van Nuys, CAThe inadequate inspection of the airplane's brakes system by maintenance personnel and the maintenance personnel not replacing brake linings that were worn beyond their service limits. The runway lights and fence that were in the airplane's ground path after…Apr 25, 1992 · N55296 · Substantial damageNTSB DEN92FA048Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Elbert, COThe pilot-in-command's failure to maintain control of the glider resulting in separation of the right wing. A contributing factor to the accident was: the pilot's limited experience in the Schweizer sgs 1-34.Apr 25, 1992 · N7642 · DestroyedNTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.Apr 25, 1992 · N7973L · DestroyedNTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.Apr 24, 1992 · N123JH · DestroyedNTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.Apr 24, 1992 · N14690 · Substantial damageNTSB NYC92LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryan, OHThe failure of the student pilot to maintain directional control during landing roll. Factors related to the accident were: the pilot's lack of total experience and lack of recent experience.Apr 23, 1992 · N734KW · Substantial damageNTSB NYC92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tewksbury, MAThe failure of the pilot to compensate for adverse winds, which resulted in a bounced landing, subsequent loss of airspeed and airplane control.Apr 23, 1992 · N6325L · Substantial damageNTSB NYC92LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · New Madison, OHThe pilot's failure to attain a proper touchdown point. Contributing to the accident was the pilot inadequately planned his approach and his failure to perform a go-around.Apr 23, 1992 · N733XP · Substantial damageNTSB NYC92IA086Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · Flushing, NYThe captain's improper aircraft control which resulted in an excessive nosewheel rate of sink and subsequent overload failure of the nose gear tires.Apr 23, 1992 · N721DA · Minor damageNTSB MIA92FA114Accident · 1 fatalField investigationFinal reportCessna 401 · New Port Richey, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering for a forced landing following an in flight left engine fire for undetermined reasons. Contributing to the accident was the pilot in command's inadvertent shutdown of the wrong engine.Apr 23, 1992 · N3271Q · DestroyedNTSB LAX92MA184Accident · 9 fatalClass 1 · MajorFinal reportBeech E18S · Mount Haleakala, HIThe captain's decision to continue visual flight into instrument meteorological conditions that obscured rising mountainous terrain and his failure to properly use available navigational information to remain clear of the island of maui. Contributing to the…Apr 23, 1992 · N342E · DestroyedNTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.Apr 23, 1992 · N7603Z · Substantial damageNTSB FTW92LA119Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brinkley, ARThe pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.Apr 23, 1992 · N3626N · Substantial damageNTSB FTW92LA117Accident · No injuriesLimited investigationFinal reportCessna 310P · Austin, TXThe approach controller's failure to properly sequence arriving traffic, and the tower controller's failure to sequence and separate landing traffic. Factors in the accident were: the pilot's failure to obtain a landing clearance and the night light…Apr 23, 1992 · N5936M · Substantial damageNTSB CHI92LA132Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-8F-55 · Ypsilanti, MIThe pilot-in-command's misjudging of the touchdown point. Factors include (aircraft performance) hydroplaning condition, and the pilot-in-command's poor evaluation of weather conditions.Apr 23, 1992 · N29549 · Substantial damageNTSB CHI92LA131Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Branson, MOInadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.Apr 23, 1992 · N59ND · 2 aircraft · Substantial damageNTSB ATL92LA087Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Rutherfordton, NCThe pilot's failure to maintain directional control during a landing roll which resulted in a collision with trees.Apr 23, 1992 · N6336C · Substantial damageNTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.Apr 22, 1992 · N7252X · Substantial damageNTSB SEA92FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Shaw Island, WAA delayed go-around, and procedures not being followed. Factors include a lack of total experience in this type of operation, trees near the runway, and an uphill runway slope.Apr 22, 1992 · N64156 · Substantial damageNTSB MIA92LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot-in-command's failure to maintain airspeed while buzzing which resulted in the aircraft stalling and entering a spin.Apr 22, 1992 · N13910 · DestroyedNTSB MIA92LA111Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · La Belle, FLImproper preflight by the pilot-in-command, in his failure to identify a crack in a brazed area surrounding an attach point on the air diffuser. Contributing to the accident following the loss of engine power was obstacles that were ahead of the flight path.Apr 22, 1992 · N4028F · Substantial damageNTSB MIA92FA112Accident · 1 fatalField investigationFinal reportNavion NAV-A · Monteverde, FLThe pilot's inadvertent flight into IMC conditions and subsequent loss of control of the airplane in flight.Apr 22, 1992 · N4904E · DestroyedNTSB LAX92MA183Accident · 16 fatalMajor investigationFinal reportde Havilland DHC-6-200 · Perris, CAThe pilot-in-command's inadvertent feathering of the wrong propeller following an engine power loss, and the failure of the operator to assure that the pilot was provided with adequate training in the airplane. Factors related to the accident were: water…Apr 22, 1992 · N141PV · DestroyedNTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.Apr 22, 1992 · N4430S · Substantial damageNTSB ATL92LA086Accident · 1 fatalLimited investigationFinal reportGlaser-Dirks DG-600/18M · Newnan, GAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall at too low of an altitude to effect recovery.Apr 22, 1992 · N107T · Substantial damageNTSB ATL92FA085Accident · 1 fatalField investigationFinal reportRobinson R-22 · Atlanta, GAThe pilot's inadequate evaluation of the weather (wind condition), and the inflight decision to hover with gusting tailwinds, which resulted in a complete loss of tail rotor control. A factor was gusting tailwinds.Apr 22, 1992 · N2589X · DestroyedNTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.Apr 21, 1992 · N60754 · Substantial damageNTSB LAX92LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Oxnard, CAThe pilot's failure to maintain control of the airplane during takeoff as a result of his alcoholic impairment of efficiency and judgement. A factor in the accident was the dark night.Apr 21, 1992 · N6907D · Substantial damageNTSB LAX92LA181Accident · No injuriesLimited investigationFinal reportNavion G · Santa Paula, CAThe pilot's improper aircraft preflight by failing to assure the fuel selector handle was in the proper position. Factors relating to this accident was the engine fuel starvation.Apr 21, 1992 · N2489T · Substantial damageNTSB ANC92LA063Accident · No injuriesLimited investigationFinal reportCessna 170 · Kenai, AKThe pilot's failure to maintain directional control. Factors to the accident were: an inadequate recovery from a bounced landing, and the pilot's lack of familiarity with the modified aircraft.Apr 21, 1992 · N3970V · Substantial damageNTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.Apr 20, 1992 · N519CS · DestroyedNTSB MIA92FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingUndetermined.Apr 20, 1992 · N4319N · DestroyedNTSB LAX92T#A04Accident · No injuriesClass 3Final reportBell 206L-1 · Fort Irwin, CAApr 20, 1992 · N5736N · Substantial damageNTSB ANC92LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's failure to maintain directional control. A factor to the accident was: a crosswind.Apr 20, 1992 · N7077D · Substantial damageNTSB LAX92LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Mesquite, NVThe pilot's poor preflight planning and improper fuel consumption calculations. Factors relating to this accident were fuel exhaustion, and the unsuitable terrain, and lack of understanding of the airplane's fuel system.Apr 19, 1992 · N6582G · Substantial damageNTSB LAX92LA179Accident · No injuriesLimited investigationFinal reportHomebuilt Dragonfly · Parker, AZAn oil leak from an unidentified source. The high vegetation along the forced landing area contributed to this accident.Apr 19, 1992 · N235JS · DestroyedNTSB FTW92DPD01Accident · 1 fatalFinal reportEichblatt X-5 · Fort Worth, TXThe loss of engine power for undetermined reasons and an inadvertent stall. A factor was the pilot's lack of familiarity with the airplane.Apr 19, 1992 · N99747 · Substantial damageNTSB ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.Apr 19, 1992 · N5112P · Substantial damageNTSB ATL92LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Monroe, NCThe pilot's failure to maintain flying speed during climbout which resulted in a stall and subsequent collision with the ground. A factor was reported downdrafts.Apr 19, 1992 · N4978P · Substantial damageNTSB ANC92LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Tolovana, AKThe pilot's failure to use all of the available runway (landing area on the road) for the precautionary landing. Contributing to the accident were the precautionary landing, the pilot's inadequate pre flight and in flight planning/preparation, and the road…Apr 19, 1992 · N3405R · Substantial damageNTSB SEA92LA079Accident · No injuriesLimited investigationFinal reportHughes 269C · Silverton, ORInadequate preflight planning and preparation. A factor to the accident was: visual lookout was not maintained.Apr 18, 1992 · N9675F · Substantial damageNTSB NYC92LA083Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Lexington, KYAttempted suicide by the vehicle driver.Apr 18, 1992 · N27465 · Substantial damageNTSB NYC92LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Columbus, OHThe pilot's improper preflight of the helicopter, which resulted in a tie down strap not being removed prior to attempted flight, and the subsequent roll over and collision with the ramp.Apr 18, 1992 · N104MB · Substantial damageNTSB NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.Apr 18, 1992 · N172DG · DestroyedNTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.Apr 18, 1992 · N46034 · Substantial damage