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 FTW99FA100Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain control of the helicopter while maneuvering. A factor was the pilot's impairment due to his use of a prescription narcotic.Mar 26, 1999 · N2323V · DestroyedNTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.Mar 26, 1999 · N8968B · Substantial damageNTSB NYC99IA079Incident · No injuriesIncident investigationFinal reportCessna 550 · State College, PAImproper assembly of the left main landing gear (LMLG) actuator by the airplane manufacturer, which resulted in an incorrect 'locked' indication on the LMLG switch, and the subsequent collapse of the LMLG during taxi.Mar 25, 1999 · N37MH · Minor damageNTSB MIA99LA113Accident · No injuriesLimited investigationFinal reportDryer Fisher 404 · Homestead, FLThe pilots improper in-flight planning/decision of an available forced landing area. This resulted in a subsequent in-flight collision with trees. Contributing to the accident was a total loss of engine power due to an inoperative generator coil.Mar 25, 1999 · N82435 · Substantial damageNTSB MIA99FA114Accident · 1 fatalField investigationFinal reportGrumman G-21A · Lauderdale Lake, FLThe pilots failure to correctly identify an in-flight emergency (fluctuating manifold pressure and rpm due to a disconnected spark plug lead / unscrewed ignition lead shroud) and failure to complete the engine shutdown procedure once it was initiated…Mar 25, 1999 · N5548A · DestroyedNTSB DEN99LA058Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COThe flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.Mar 25, 1999 · N8354Z · Substantial damageNTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…Mar 24, 1999 · N8397G · Substantial damageNTSB MIA99LA111Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Zephyrhills, FLThe student pilot's improper use of flight controls (cyclic and collective) during a takeoff to a hover. This resulted in the helicopter encountering dynamic rollover and rolling over on its right side.Mar 24, 1999 · N4412C · Substantial damageNTSB CHI99LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · New Hudson, MIThe pilot's misjudgment of speed and distance and his failure to execute a go-around. A related factor was the crosswind.Mar 24, 1999 · N75BG · Substantial damageNTSB CHI99LA114Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAthe pilot's failure to maintain directional control.Mar 24, 1999 · N812TB · Substantial damageNTSB CHI99FA120Accident · No injuriesField investigationFinal reportExtra Flugzeugbau 300S · Dow, ILa fatigue failure of the upper left longeron and adjacent diagonal cross member near the horizontal stabilizer attach point. A factor related to the accident was that the manufacturer informed the operator that they were already in compliance with the latest…Mar 24, 1999 · N9K · Substantial damageNTSB LAX99LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Atwater, CAthe failure of the student to extend the landing gear and the flight instructor's inadequate supervision of the flight.Mar 23, 1999 · N6BY · Substantial damageNTSB CHI99FA112Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Duluth, MNthe lack of sufficient aileron-to-wing gap clearance design. Contributing factors were the inadequate oversight of the Federal Aviation Administration of the design and manufacturing and flight test process of Cirrus Design Corporation, the location of the…Mar 23, 1999 · N115CD · DestroyedNTSB LAX99LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Scottsdale, AZThe failure of the local and ground controller to coordinate the clearances of both aircraft and to maintain separation of the traffic in the taxiway movement area.Mar 22, 1999 · N4188E · 2 aircraft · Substantial damageNTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.Mar 22, 1999 · N67821 · DestroyedNTSB IAD99LA035Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Irving, NYwas the pilot's intentional flight into known icing conditions.Mar 22, 1999 · N5878Q · Substantial damageNTSB CHI99LA116Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's misjudged flare and inadvertent stall during landing. A factor was the pilot's inadequate remedial action.Mar 22, 1999 · N757MJ · DestroyedNTSB CHI99LA111Accident · 1 fatalLimited investigationFinal reportCessna A188B · Atwood, KSThe pilot's failure to maintain clearance from obstacles.Mar 22, 1999 · N5706G · DestroyedNTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.Mar 22, 1999 · N600ME · No damageNTSB ATL99LA057Accident · No injuriesLimited investigationFinal reportBeech 23 · Jacksonville, FLThe overload failure of the landing gear attach points during takeoff from a turf airstrip. Factors are rough and uneven terrain.Mar 21, 1999 · N3621Q · Substantial damageNTSB NYC99FA078Accident · 1 fatalField investigationFinal reportDeleeuw Sprint 1000 · Lakewood, NJThe pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.Mar 20, 1999 · UNREG · DestroyedNTSB MIA99FA108Accident · 1 fatalField investigationFinal reportPushkar Hornet · Fort Lauderdale, FLthe pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.Mar 20, 1999 · N4376N · DestroyedNTSB LAX99LA126Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Mesa, AZThe pilot's inadequate compensation for the gusty and variable crosswind condition, which led to a loss of directional control and an inadvertent ground loop.Mar 20, 1999 · N52558 · Substantial damageNTSB LAX99FA128Accident · 2 fatalField investigationFinal reportErcoupe 415E · Kingman, AZThe in-flight loss of airplane control due to rear wing spar attachment fitting failure. The failure resulted from severe corrosion that was undetected during performance of an inspection specified by an airworthiness directive. The airworthiness directive…Mar 20, 1999 · N94818 · DestroyedNTSB LAX99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lytle Creek, CAthe pilot's inadvertent visual flight into instrument meteorological conditions resulting in impact with high terrain.Mar 20, 1999 · N2529W · DestroyedNTSB DCA99WA081Incident · No injuriesForeign investigationBoeing MD80/87 · Geneva, SwitzerlandMar 20, 1999 · ECGRL · Minor damageNTSB CHI99LA113Accident · No injuriesLimited investigationFinal reportDelong Glastar GS-1 · Lapeer, MIThe failure of the pilot to maintain compensation for wind conditions. Factors to the accident were the crosswind condition and the presence of trees along the runway.Mar 20, 1999 · N918V · Substantial damageNTSB ATL99LA058Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot's improper landing flare that resulted in a hard landing.Mar 20, 1999 · N5423F · Substantial damageNTSB ATL99LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bunn Level, NCThe loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.Mar 20, 1999 · N46542 · Substantial damageNTSB LAX99LA124Accident · No injuriesLimited investigationFinal reportBeech D95A · Dillingham, HIThe student's failure to maintain aircraft control in the gusty crosswind conditions due to limited left yaw authority induced by the simulated single engine approach. The flight instructor's inadequate supervision of the flight and his failure to terminate…Mar 19, 1999 · N199Q · Substantial damageNTSB LAX99LA123Accident · No injuriesLimited investigationFinal reportCessna 172M · Reno, NVThe pilot's inadequate compensation for the crosswind condition and his failure to maintain runway alignment during the crosswind landing.Mar 19, 1999 · N5242R · Substantial damageNTSB LAX99LA122Accident · Serious injuriesLimited investigationFinal reportAero Commander 500B · Shelter Cove, CAFuel exhaustion due to the pilot's failure to ensure that an adequate fuel supply was onboard. A contributing factor was the lack of suitable terrain for the forced landing.Mar 19, 1999 · CFBCR · DestroyedNTSB FTW99LA097Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Hobart, OKThe loss of engine power due to an undetermined reason. A factor was the ditch.Mar 19, 1999 · N5647X · DestroyedNTSB DEN99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Agate, COThe development of carburetor ice resulting in a partial loss of engine power. Factors were the weather conditions favorable for carburetor icing, the dark night conditions, and the lack of suitable terrain for landing.Mar 19, 1999 · N1321F · Substantial damageNTSB ATL99LA055Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Bay Springs, MSThe fuel control drive bearing failure at the intermediate gear resulted in fuel starvation and the subsequent loss of engine power.Mar 19, 1999 · N3629T · Substantial damageNTSB FTW99LA095Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARThe pilot's failure to maintain terrain clearance during the downwind departure. Factors were the tailwind and the wet soft grass airstrip.Mar 18, 1999 · N8742H · Substantial damageNTSB CHI99LA110Accident · Serious injuriesLimited investigationFinal reportSocata TB-9C · Cahokia, ILthe in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…Mar 18, 1999 · N508PC · Substantial damageNTSB NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.Mar 17, 1999 · N17321 · No damageNTSB LAX99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Chico, CAThe CFI's inadequate supervision and delayed remedial action to rectify his student's bounced landing. Contributing factors were the short runway and obstructing trees.Mar 17, 1999 · N3406T · Substantial damageNTSB LAX99LA100Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe pilot's misjudged landing flare resulting in a hard touchdown, and, his failure to adequately compensate for the existing crosswind condition and to maintain directional control during rollout on the wet runway.Mar 17, 1999 · N106BM · Substantial damageNTSB FTW99FA094Accident · 2 fatalField investigationFinal reportEurocopter AS-350-B2 · Eugene Is. 193the loss of control as a result of the spring-steel extension becoming entangled with the hatch door handle during takeoff. A contributing factor was the flat design of the spring-steel extension.Mar 17, 1999 · N6100R · DestroyedNTSB ANC99LA036Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Girdwood, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.Mar 17, 1999 · N197EH · Substantial damageNTSB NYC99FA074Accident · 2 fatalField investigationFinal reportCessna 340A · Chesapeake, VAThe pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.Mar 16, 1999 · N13DT · DestroyedNTSB MIA99LA107Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Opp, ALa loss of engine power due to the failure of the engine to transmission drive shaft flex coupling, resulting in an in-flight collision with a vehicle.Mar 16, 1999 · N547FH · Substantial damageNTSB MIA99LA106Accident · No injuriesLimited investigationFinal reportBeech 58 · St CroixThe pilot's failure to extend the landing gear.Mar 16, 1999 · N6CH · Substantial damageNTSB DEN99LA054Accident · No injuriesLimited investigationFinal reportCessna 320D · Broomfield, COA partial loss of power on the left engine for undetermined reasons. A factor was the pilot's failure to maintain directional control of the aircraft during landing flare/touchdown.Mar 16, 1999 · N4127T · Substantial damageNTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.Mar 16, 1999 · N9023L · Substantial damageNTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.Mar 16, 1999 · N8620S · Substantial damageNTSB LAX99LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Truckee, CAThe pilot's failure to obtain and maintain the proper climb airspeed during the initial takeoff climb, including his failure to anticipate the gust factor and density altitude effects in determining a safe airspeed.Mar 15, 1999 · N4796L · Substantial damageNTSB IAD99GA036Accident · 13 fatalFinal reportMil MI-8MTV-1 · Hinche, HaitiThe flightcrew's inability to maintain visual contact with mountainous terrain in night, instrument meteorological conditions. Contributing to the accident was a lack of preparation and support for difficult flight conditions, including lack of coordination…Mar 15, 1999 · RA-25464 · Destroyed