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 CHI95LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ann Arbor, MIthe failure of the mechanic to close the drain valve after changing oil, resulting in complete loss of engine oil. A factor was the soft terrain, which resulted in the nose wheel digging in and the airplane nosing over.Mar 19, 1995 · N4385M · Substantial damageNTSB BFO95LA035Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Middle River, MDthe pilot's inadequate recovery from a bounced landing, which resulted in the nosegear collapsing. The pilot's improper landing flare was a factor in the accident.Mar 19, 1995 · N79TH · Substantial damageNTSB ATL95LA067Accident · No injuriesLimited investigationFinal reportWente Kitfox III · Moncks Corner, SCThe pilot's selection of the wrong runway relative to the wind conditions and his failure to maintain alignment with the runway during the balked landing.Mar 19, 1995 · N803BW · Substantial damageNTSB ATL95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Cleveland, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion during the final approach for landing.Mar 19, 1995 · N4618Q · Substantial damageNTSB SEA95LA069Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Bozeman, MTThe pilot misjudged his altitude and distance from the runway. A factor was the pilot's failure to obtain the current altimeter setting.Mar 18, 1995 · N5924 · Substantial damageNTSB MIA95WA088Accident · Minor injuriesForeign investigationConvair 440 · Cap Haitien, HaitiMar 18, 1995 · N137CA · Substantial damageNTSB MIA95LA096Accident · No injuriesLimited investigationFinal reportCessna 150K · Hattiesburg, MSThe failure of the pilot-in-command to perform a recovery from a bounced landing, resulting in a hard landing and subsequent collapsing of the nose gear.Mar 18, 1995 · N6055G · Substantial damageNTSB MIA95FA089Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Staley, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering during a forced landing, resulting in an in-flight loss of control (inadvertent stall), and subsequent in flight collision with terrain. Contributing to the accident was the pilot's inadequate…Mar 18, 1995 · N7545D · DestroyedNTSB FTW95LA140Accident · Serious injuriesLimited investigationFinal reportBeecher Polliwagen PW-1 · New Waverly, TXThe pilot's failure to abort the takeoff. Factors were his failure to obtain engine performance data, the resulting improper red line marking on the tachometer, and the improper adjustment of the propeller.Mar 18, 1995 · N192EB · Substantial damageNTSB FTW95LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Devine, TXA power loss due to the inadvertent opening of an unapproved quick oil drain installed by maintenance personnel. A factor was the lack of suitable terrain for the forced landing.Mar 18, 1995 · N47839 · Substantial damageNTSB BFO95LA034Accident · No injuriesLimited investigationFinal reportCessna 182K · Gretna, VAThe pilot's improper flare which resulted in a hard landing.Mar 18, 1995 · N2439Q · Substantial damageNTSB ATL95FA065Accident · 1 fatalField investigationFinal reportPiper J-3L-65 · Tallassee, ALThe student pilot's failure to see and avoid the utility line while performing unwarranted low altitude maneuvers.Mar 18, 1995 · N27120 · DestroyedNTSB ANC95LA035Accident · No injuriesLimited investigationFinal reportCessna 150M · Glennallen, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were a soft, snow covered runway, and the pilot's lack of total aeronautical experience.Mar 18, 1995 · N88808 · Substantial damageNTSB NYC95LA074Accident · Serious injuriesLimited investigationFinal reportBeech T-34B · Jackson, NJthe flight instructor's attempt to maintain visual reference with the ground, and his delayed remedial action to the dual student's actions, which resulted in an inadvertent tree strike. Factors were the lack of recent night experience for both pilots, the…Mar 17, 1995 · N1440L · DestroyedNTSB MIA95LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Miami, FLThe pilot-in-command's/CFI improper supervision of the dual student during a simulated short field approach for landing. This resulted in an in-flight loss of control (inadvertent stall), and subsequent hard landing.Mar 17, 1995 · N3470T · Substantial damageNTSB MIA95FA087Accident · 2 fatalField investigationFinal reportCessna 337F · Vero Beach, FLThe pilot's failure to avoid a thunderstorm. The thunderstorm was a factor.Mar 17, 1995 · N1842M · DestroyedNTSB LAX95LA138Accident · No injuriesLimited investigationFinal reportBell 47 · Harmon Fieldan engine failure due to oil exhaustion from a missing oil pressure relief valve as the result of an improper maintenance inspection.Mar 17, 1995 · N6569H · Substantial damageNTSB LAX95IA142Incident · No injuriesIncident investigationFinal reportBeech 1900C · Los Angeles, CAAn axial shift of the outer bearing roller for an undetermined reason, resulting in erosion and failure of the flap track hinge bracket/bearing assembly. Factors relating to the incident were: the roller bearing and associated bracket assembly within the…Mar 17, 1995 · N1568W · Minor damageNTSB DCA95RA024Accident · No injuriesForeign investigationMcDonnell Douglas DC-9-15 · Barranquilla, ColombiaMar 17, 1995 · HK354NTSB CHI95LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Baudette, MNan encountered with a hidden obstruction during taxi. A factor was the ski assembly not having been installed.Mar 17, 1995 · N714MX · Substantial damageNTSB ATL95LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Nashville, TNThe pilot's improper use of the flight controls during takeoff which resulted in the inflight collision with the ground.Mar 17, 1995 · N1815X · Substantial damageNTSB NYC95LA075Accident · No injuriesLimited investigationFinal reportCumberland-Pitts Special S1C · New Windsor, MDthe failure of the fuel pump diagram which resulted in fuel starvation and a subsequent forced landing.Mar 16, 1995 · N4T · Substantial damageNTSB LAX95LA137Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Honolulu, HIIntentional ditching due to the flightcrew's failure to properly manage the fuel system, and operation of the airplane in an excessively overweight condition.Mar 16, 1995 · N37ST · DestroyedNTSB LAX95LA136Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Van Nuys, CAthe operation of the helicopter with improper adjustment of the landing gear and main rotor dampers due to the inadequate maintenance inspection of the helicopter by maintenance personnel and an inadequate preflight inspection by the pilot.Mar 16, 1995 · N8873F · DestroyedNTSB CHI95LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Alma, MIthe flight instructor's inadequate remedial action during the approach to landing/landing roll. Related factors are the flight instructor's inadequate supervision, the dual student's wrong runway selection, the tailwind, and the dual student's failure to…Mar 16, 1995 · N65490 · Substantial damageNTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.Mar 16, 1995 · N2928A · Substantial damageNTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.Mar 16, 1995 · N8078L · Substantial damageNTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.Mar 16, 1995 · N295WA · No damageNTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.Mar 15, 1995 · N3605V · Substantial damageNTSB NYC95LA073Accident · No injuriesLimited investigationFinal reportBeech 23 · Plymouth, NHThe pilot's failure to maintain runway alignment during the aborted takeoff. Factors related to the accident were: the adverse runway conditions and snowbank beside the runway.Mar 15, 1995 · N9305S · Substantial damageNTSB MIA95WA083Accident · No injuriesForeign investigationBell 206-B3 · San Nicholas, ArgentinaMar 15, 1995 · LVWFZ · DestroyedNTSB LAX95LA135Accident · 2 fatalLimited investigationFinal reportCessna 180 · Winslow, AZThe pilot's poor judgement by intentionally deciding to buzz.Mar 15, 1995 · N1520C · DestroyedNTSB FTW95FA134Accident · 1 fatalField investigationFinal reportHinshaw, Keith T. BD5TP · Byers, COFailure by the pilot in command to maintain control of the aircraft. Factors were: lack of experience in type of aircraft and lack of experience in type of operation.Mar 15, 1995 · N777TK · DestroyedNTSB CHI95LA109Accident · No injuriesLimited investigationFinal reportBeech 58 · Grand Rapids, MIthe failure of the landing gear bushing for the actuator worm gear which resulted in both the normal and emergency gear extension systems being inoperative.Mar 15, 1995 · N930DP · Substantial damageNTSB CHI95LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · West Fargo, NDthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.Mar 15, 1995 · N60564 · Substantial damageNTSB CHI95LA101Accident · No injuriesLimited investigationFinal reportCessna 150 · Ann Arbor, MIthe pilot's failure to maintain directional control of the airplane during the aborted landing. Factors associated with the accident were the airport sign and the night lighting conditions.Mar 15, 1995 · N63671 · Substantial damageNTSB BFO95FA033Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Cambridge, MDthe commercial/instrument rated pilot's failure to obtain/maintain adequate altitude/clearance during the initial climb after takeoff. Related factors are the pilot's poor planning/decision making, and the fog.Mar 15, 1995 · N166CP · DestroyedNTSB ATL95LA061Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Collegedale, TNThe mechanic's failure to follow approved engine overhaul procedures which resulted in the separation of the oil return line, and the complete loss of engine power.Mar 15, 1995 · N35138 · DestroyedNTSB NYC95LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Kingston, NYThe pilot's failure to assure that the fuel selector was positioned to a tank containing ample fuel.Mar 14, 1995 · N3665R · DestroyedNTSB FTW95LA138Accident · No injuriesLimited investigationFinal reportCessna 340 · Santa Fe, NMWorn landing gear assembly due to inadequate maintenance by maintenance personnel and delayed maintenance by operators.Mar 14, 1995 · N5432M · Substantial damageNTSB SEA95LA070Accident · 2 fatalLimited investigationFinal reportQuicksilver MXL2 · Hildale, UTThe pilot's failure to maintain adequate airspeed while banking the airplane. This led to an unrecoverable aerodynamic stall in close proximity to the ground. Factors contributing to the accident are the pilot exceeding the airplane's weight and balance…Mar 13, 1995 · UNREG · DestroyedNTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.Mar 13, 1995 · N4359Y · Substantial damageNTSB NYC95FA068Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Suffolk, VAThe pilot's inadequate preflight and improper in-flight planning/decision, which resulted in fuel exhaustion. Darkness was a factor related to the improper planning/decision-making for the emergency landing.Mar 13, 1995 · N57326 · DestroyedNTSB LAX95LA131Accident · No injuriesLimited investigationFinal reportCessna 150E · Visalia, CAthe pilot's misjudged landing flare and his improper bounced landing recovery technique.Mar 13, 1995 · N6277T · Substantial damageNTSB FTW95LA137Accident · No injuriesLimited investigationFinal reportCessna 140 · Fentress, TXThe sudden movement of an animal into the path of the aircraft during takeoff roll. Factors were the inability of the pilot to establish a visual lookout down the runway due to the runway's 'crowned' midpoint.Mar 13, 1995 · N76981 · Substantial damageNTSB CHI95LA112Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Norton, KSthe reason for the loss of engine power was undetermined. The rough, uneven terrain encountered during the forced landing was a factor.Mar 13, 1995 · N78103 · Substantial damageNTSB SEA95LA065Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe dual student pilot's failure to maintain directional control of the helicopter during the practice hover autorotation to landing, and the flight instructor's failure to adequately supervise the dual student during the landing. Contributing to the accident…Mar 12, 1995 · N721HH · Substantial damageNTSB NYC95LA072Accident · No injuriesLimited investigationFinal reportCessna 120 · Skaneateles, NYThe student pilot's failure to maintain directional control and his improper use of the brakes.Mar 12, 1995 · N77467 · Substantial damageNTSB MIA95LA086Accident · No injuriesLimited investigationFinal reportLockheed L-1011-385 · San Juan, PRThe tug operator of another airplane commencing pushback procedures without clearance to do so from the dispatching agent, resulting in an on-ground collision between both airplanes.Mar 12, 1995 · N724DA · 2 aircraft · Minor damageNTSB LAX95LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAfuel exhaustion due to the pilot's inattention to the fuel supply.Mar 12, 1995 · N172ET · Substantial damage