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 DEN89LA225Accident · No injuriesLimited investigationFinal reportCessna 170 · Cortez, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop.Sep 10, 1989 · N170LF · Substantial damageNTSB DEN89LA213Accident · No injuriesLimited investigationFinal reportCessna 188B · Sunland Park, NMUndetermined. A factor related to the accident was the crop in the emergency landing area.Sep 10, 1989 · N9342R · Substantial damageNTSB CHI89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · South Haven, MIImproper flare by the pilot, which resulted in a hard landing.Sep 10, 1989 · N3633P · Substantial damageNTSB BFO89FA079Accident · Serious injuriesField investigationFinal reportBell 206B-III · White Plains, MDThe pilot's failure to follow procedures in that he delayed his climb during a night takeoff from a confined area. Contributing factor(s) was: the dark night and surrounding obstructions.Sep 10, 1989 · N3195B · Substantial damageNTSB ATL89LA211Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Screven, GAFailure of maintenance personnel to correct right brake adjustment problems during brake repairs which led to a failure of the right brake, and the pilot's delay in taking remedial action to correct the veering initiated by the brake failure.Sep 10, 1989 · N82705 · Substantial damageNTSB SEA89LA170Accident · No injuriesLimited investigationFinal reportHughes 369D · Petersburg, AKThe pilot failed to obtain clearance over trees. Contributing to the accident was: the aircraft being above its maximum certificated gross weight limitation and the trees.Sep 9, 1989 · N1088N · Substantial damageNTSB SEA89LA167Accident · No injuriesLimited investigationFinal reportRobinson R22 · Kent, WAThe instructor pilot's failure to take timely corrective action to recover from a low rotor RPM condition, resulting in impact with the ground.Sep 9, 1989 · N8034J · DestroyedNTSB NYC89LA214Accident · No injuriesLimited investigationFinal reportCessna 172N · Bayport, NYThe pilot's misjudging speed and distance resulting in his overshooting the landing and running off the end of the runway.Sep 9, 1989 · N734UG · Substantial damageNTSB LAX89DVG10Accident · No injuriesFinal reportMinicab Hawk · Montaque, CAThe failure of the pilot to maintain directional control after landing.Sep 9, 1989 · N5671 · Substantial damageNTSB FTW89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe pilot's loss of control during an attempted go around.Sep 9, 1989 · N5316U · Substantial damageNTSB DEN89DTM03Accident · Serious injuriesFinal reportHarris-Hafen VARI-EZE · Payson, UTThe airplane collided with high obstruction (s).Sep 9, 1989 · N30EZ · DestroyedNTSB DCA89IA071Incident · No injuriesClass 1 · IncidentFinal reportBoeing 737-200A · Kansas City, MOThe flightcrew's failure to adequately prepare for and execute a nonprecision approach and their subsequent premature descent below minimum descent altitude. Contributing to the cause of the incident was the inadequate and deficient services provided to the…Sep 9, 1989 · N283AU · Minor damageNTSB ANC89LA161Accident · No injuriesLimited investigationFinal reportCessna 180 · Yakataga, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop. The tailwind was a contributing factor.Sep 9, 1989 · N2355C · Substantial damageNTSB SEA89LA166Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics LAKE-LA-4-200 · Klawock, AKThe pilot misjudged the aircraft height above water while attempting to land on a lake. A contributing factor was the smooth, glassy water surface conditions on the lake.Sep 8, 1989 · N2582P · DestroyedNTSB NYC89LA213Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Boston, MAFailue of pilot to maintain control of the helicopter when a passenger inadvertently pushed the cyclic control. The fence (near the helipad) was considered to be a factor.Sep 8, 1989 · N203Q · Substantial damageNTSB LAX89LA306Accident · No injuriesLimited investigationFinal reportCessna A185F · Big Bear City, CAThe pilot's inadequate compensation for the unfavorable wind conditions.Sep 8, 1989 · N252W · Substantial damageNTSB LAX89DVG09Accident · 1 fatalFinal reportClatti FOCKE-WULF-190 · Placerville, CAThe wing failed due to delamination caused by adhesive separation.Sep 8, 1989 · N34FW · DestroyedNTSB FTW89DRD14Accident · No injuriesFinal reportGrumman G-164A · Franklin, LAFatigue failure of the propeller blade, which resulted in separation of the blade's tip and severe engine vibration. The soft terrain was a related factor.Sep 8, 1989 · N7498 · Substantial damageNTSB DEN89LA224Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Monument Valley, UTThe pilot's failure to adequately compensate for windshear.Sep 8, 1989 · N3554P · Substantial damageNTSB ATL89LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rowland, NCThe pilot's failure to recognize and prevent carburetor icing prior to take off.Sep 8, 1989 · N4386J · Substantial damageNTSB LAX89LA310Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZFailure of the pilot to obtain or maintain sufficient airspeed, which resulted in an inadvertent stall.Sep 7, 1989 · N758HB · Substantial damageNTSB LAX89LA305Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Marble Canyon, AZThe pilot selected the wrong runway and landed downwind.Sep 7, 1989 · N5434V · Substantial damageNTSB LAX89FA303Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Los Angeles, CAThe fuel truck driver's improper operation of the vechicle on the airport. Factors were the driver's diverted attention and the inadequate supervision by company management.Sep 7, 1989 · N27283 · Substantial damageNTSB FTW89LA160Accident · No injuriesLimited investigationFinal reportCessna 210P · Bethany, OKA loose fuel line connection, due to inadequate maintenance, which resulted in fuel starvation. Factors related to the accident were: darkness and the obstructions (hay bale & approach light pole) in the emergency landing area.Sep 7, 1989 · N732XW · Substantial damageNTSB DEN89LA212Accident · No injuriesLimited investigationFinal reportCessna 172N · Burlington, COImproper use of the rudder by the pilot, which resulted in a loss of directional control. The soft terrain was a related factor.Sep 7, 1989 · N734VH · Substantial damageNTSB DEN89FA209Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lk Havasu City, CAPilot's attention diverted outside the airplane. This diversion resulted in the pilot failing to monitor his altitude while in a descending turn and inadvertently flying the airplane into the water.Sep 7, 1989 · N3999W · DestroyedNTSB DEN89FA208Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Grantsville, UTImproper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.Sep 7, 1989 · N7835P · DestroyedNTSB ANC89FA160Accident · 1 fatalField investigationFinal reportCessna 185 · Tanacross, AKPoor judgement by the pilot by buzzing the airport and his failure to maintain sufficient altitude/clearance above the terrain. The pilot's use of abrupt maneuvers was a contributing factor.Sep 7, 1989 · N4838C · DestroyedNTSB MKC89LA192Accident · Minor injuriesLimited investigationFinal reportPietenpol AIR Camper B4A · Horatio, ARImproper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.Sep 6, 1989 · N10GF · Substantial damageNTSB LAX89LA302Accident · No injuriesLimited investigationFinal reportCessna 180 · Santa Ana, CAThe pilot's improper in-flight planning after being advised of possible wake turbulence.Sep 6, 1989 · N1739C · Substantial damageNTSB LAX89LA297Accident · No injuriesLimited investigationFinal reportBell 206B · Murrieta, CAA partial loss of engine power due to contaminates in the fuel control unit. The origin of the contaminates was not determined. Contributing factor(s) was: the helicopter was not equipped with floats.Sep 6, 1989 · N111JG · Substantial damageNTSB LAX89FA296Accident · 1 fatalField investigationFinal reportGrumman AA-5B · California City, CAFailure of the student pilot to maintain a proper airspeed while maneuvering for an emergency landing. Factors in the accident were the partial engine power loss, which was due to improper maintenance procedures, the student pilot's inexperience, the strong…Sep 6, 1989 · N28493 · DestroyedNTSB FTW89DPA04Accident · 1 fatalFinal reportNorth American F-51 · Denton, TXThe pilot's failure to detect water in the fuel system during the preflight which subsequently resulted in a loss of power.Sep 6, 1989 · N51VP · DestroyedNTSB SEA89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lester, WAThe pilot's loss of control of the aircraft due to his improper use of the aircraft flight controls. Contributing factors in the accident were the moderate turbulence and trace mixed icing in clouds.Sep 5, 1989 · N44888 · DestroyedNTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.Sep 5, 1989 · N8068C · Substantial damageNTSB FTW89LA162Accident · No injuriesLimited investigationFinal reportCessna 172K · Midlothian, TXThe failure of the pilot to compensate for the crosswind condition, which resulted in a loss of directional control and collision with a tree.Sep 5, 1989 · N736YG · Substantial damageNTSB FTW89LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Carmin, TXLoss of power for an unknown reason. Factors related to the accident were the ditch & fence.Sep 5, 1989 · N94777 · DestroyedNTSB FTW89DQG06Accident · Minor injuriesFinal reportCessna T188C · Levelland, TXA partial brake system failure due to a leak in the left brake master cylinder.Sep 5, 1989 · N9957J · Substantial damageNTSB DEN89LA207Accident · No injuriesLimited investigationFinal reportCessna C-150 · Platteville, COPilot's failure to compensate for the wind conditions and his failure to maintain directional control during the landing roll. Contributing to the accident was the gusting crosswind.Sep 5, 1989 · N7979E · Substantial damageNTSB CHI89IA179Incident · Minor injuriesIncident investigationFinal reportBoeing 767-231 · Knox, INThe radar controlller's failure to maintain radar separation. Factors contributing to the incident were: misunderstanding of an ATC instruction by the pilot of the incident airplane, and unclear phraseology used in the instructions issued by the radar…Sep 5, 1989 · N608TW · No damageNTSB SEA89LA162Accident · No injuriesLimited investigationFinal reportCessna TU206G · Moore, IDFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Contributing to the accident was a fence.Sep 4, 1989 · N666HS · Substantial damageNTSB SEA89LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Alderwood Manor, WAImproper planning/decision by the pilot. The tailwind and high obstructions were related factors.Sep 4, 1989 · N98354 · Substantial damageNTSB NYC89LA210Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · South Harpswell, MEA delay by the pilot in aborting a late go-around. Factors related to the accident were: the pilot's improper flare for landing, his improper recovery from the subsequent bounced landing, and tree(s) near the runway.Sep 4, 1989 · N4554L · Substantial damageNTSB LAX89LA301Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise. A factor related to the accident was: the lack of training in recovery from bounced landings from her instructor pilot (CFI).Sep 4, 1989 · N25649 · Substantial damageNTSB LAX89DUG07Accident · 1 fatalFinal reportMonett Monarai · Yermo, CAThe pilot failed to maintain airspeed and inadvertently entered into a stall/spin.Sep 4, 1989 · UNREG · Substantial damageNTSB DEN89LA206Accident · No injuriesLimited investigationFinal reportCessna T210M · Rangely, COForced landing in unsuitable terrain as a result of an engine crankshaft failure.Sep 4, 1989 · N761RP · Substantial damageNTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.Sep 4, 1989 · N9335R · DestroyedNTSB CHI89DEM08Accident · No injuriesFinal reportMooney M20 · West Branch, MIThe pilot's decision to hand prop the engine with a non-pilot at the controls and the passenger's application to full throttle. A factor related to the accident was panic of the passenger.Sep 4, 1989 · N5292B · Substantial damageNTSB CHI89DEC07Accident · Serious injuriesFinal reportRayne VARI-EZE · Clinton, MIUndetermined loss of engine power during initial climbout. The lack of suitable terrain for an emergency landing was a related factor.Sep 4, 1989 · N20VR · Substantial damageNTSB ANC89LA157Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igushik, AKThe pilot selected unsuitable terrain for a landing. Soft terrain was a contributing factor.Sep 4, 1989 · N4760M · Substantial damage