Final NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE c.\"completionStatus\" = 'Completed' 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.
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 WHERE c."completionStatus" = 'Completed' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA25MA108Accident · 67 fatalClass 1 · MajorFinal reportBombardier CL-600-2C10 · Washington, DCThe Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…NTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB CEN25LA089Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Brush, COThe failure of the left main landing gear forward strut.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB CEN25LA087Accident · No injuriesClass 4 · LimitedFinal reportEpic E1000 · Arcola, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.NTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.NTSB CEN25LA083Accident · No injuriesClass 4 · LimitedFinal reportRaytheon Hawker 800XP · Minneapolis, MNThe failure of the nose landing gear to extend for undetermined reasons.NTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.NTSB CEN25LA082Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Plainview, TXFuel starvation due to fuel migration during the pilot induced slipping maneuver.NTSB CEN25LA086Incident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe failure of the lower hinge barrel due to fatigue cracking. Contributing to the failure of the lower hinge barrel was increased stress from end face contact likely associated with worn bushings or displaced needle bearings.NTSB CEN25LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Bentonville, ARThe pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA080Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Omaha, NEThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA079Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Tyler, TXAn electrical system surge for a reason that could not be determined that resulted in an overvoltage event, internal damage to electronics equipment, smoke in the cockpit, and a gear up landing.NTSB CEN25LA078Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH750 · Byron, ILThe pilot inadvertently moved the ignition key to the off position and broke the key, which resulted in a loss of engine power and subsequent forced landing.NTSB CEN25LA077Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Addison, TXA partial loss of engine power during takeoff due to the partial blockage of the fuel diaphragm metering stem and the No. 1 cylinder fuel injector nozzle. Contributing to the accident was maintenance that allowed the introduction of debris that resulted in…NTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB ERA25LA099Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Wilmington, NCThe pilot’s improper landing flare, which resulted in a wing strike.NTSB ERA25LA097Accident · No injuriesClass 4 · LimitedFinal reportJonathan C Eggers Challenger II · Conway, SCThe pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.NTSB ERA25LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Fairfield, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.NTSB ERA25LA100Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Orange, MAFailure of the left main landing gear to fully extend and lock for undetermined reasons as a functional test of the landing gear system could not duplicate the anomaly.NTSB CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.NTSB ERA25LA096Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Pompano Beach, FLThe separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.NTSB ERA25LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Newburyport, MAThe flight instructor’s delayed decision to initiate a go-around, which resulted in the airplane colliding with an obstacle during approach.NTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.NTSB DCA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Atlanta, GASubstantial injury to a passenger sustained during evacuation.NTSB ANC25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot’s failure to recognize that an automated taxiway gate was closing, and the pilot’s failure stop for the closing gate.NTSB WPR25LA077Incident · No injuriesClass 4 · LimitedFinal reportBombardier Inc., Canadair CL-215-6B11 · Los Angeles, CAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.NTSB DCA25LA102Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Ojai, CAAn encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.NTSB CEN25LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Harvard, ILThe pilot’s failure to control the airplane during the engine start which resulted in a collision with the hangar.NTSB WPR25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Red Rock, MTThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with deep snow and vegetation.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB ERA25LA091Accident · No injuriesClass 3 · LimitedFinal reportHelio HT-295 · Marion, OHThe failure of the right main landing gear spring due to intergranular stress-corrosion cracking that progressed into fatigue. Contributing to the accident was the improper rework of the spring at an undetermined time.NTSB ERA25LA090Accident · No injuriesClass 4 · LimitedFinal reportHinson Melvin J Velocity · Norfolk, VAA landing gear collapse during landing in gusty crosswind conditions.NTSB CEN25LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · McKinney, TXThe flight instructor’s inadequate supervision and delayed remedial action and the student pilot’s failure to maintain a proper landing flare, which resulted in a nose down impact with the runway.NTSB CEN25LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Spearfish, SDThe pilot’s failure to land on the centerline of the snow-covered runway at night, which resulted in the left wing impacting a snowbank, a subsequent loss of directional control, and runway excursion.NTSB ANC25LA015Accident · No injuriesClass 4 · LimitedFinal reportGippsaero PTY GA8 · Nightmute, AKThe pilot’s loss of directional control while taxiing in gusting wind conditions.NTSB CEN25LA070Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Stringtown, MSBird strike.NTSB CEN25LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lubbock, TXThe loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees.NTSB WPR25LA080Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-300 · Round Mountain, NVImpact with mountainous terrain for reasons that could not be determined due to a lack of available evidence.NTSB WPR25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Los Alamos, NMThe pilot’s failure to maintain airplane control while landing in gusty crosswind conditions.NTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.NTSB ANC25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Anchorage, AKThe student pilot’s failure to maintain directional control of the airplane during touch-and-go operations on an ice-covered runway during her first solo flight.NTSB DCA25LA091Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Gulf of America (Gulf of Mexico)An encounter with an area of clear air turbulence during cruise, which resulted in a serious injury to a flight attendant.NTSB WPR25LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Gallup, NMThe pilot’s improper fuel management, which resulted in a total loss of engine power.NTSB CEN25LA066Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Monticello, IAThe on-ground collision with a deer on the runway during the landing roll.