Final NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB WPR24FA255Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Izee, ORThe pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.NTSB ERA24LA331Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 200 · Valdosta, GAAn insect nest in the right main fuel tank’s vent line, which resulted in an inaccurate fuel level reading, fuel starvation, and a total loss of engine power.NTSB ENG24LA028Incident · No injuriesClass 3 · LimitedFinal reportBell 407 · Oktaha, OKThe loss of engine power due to high cycle fatigue failure of a power turbine stage 3 turbine wheel blade. The resulting engine imbalance caused a decoupling of the gas producer stage 1 and stage 2 turbine wheels leading to a stage 1 turbine overspeed and…NTSB CEN24LA291Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R-G6 · Antioch, NEA total loss of engine power due to fuel contamination from an undetermined source.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB WPR24LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Camarillo, CAThe pilot’s loss of directional control during landing, which resulted in a nose over.NTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB ERA24FA323Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Trenton, METhe pilot’s aggressive pitch and power control inputs while executing a missed approach, which resulted in his spatial disorientation and a loss of airplane control.NTSB WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.NTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.NTSB CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN24LA283Accident · No injuriesClass 4 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Cahokia Heights, ILThe student pilot’s failure to maintain directional control during landing rollout that resulted in a lateral runway excursion and impact with a runway sign.NTSB WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.NTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.NTSB ERA24LA325Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Cuba, NYA separation of the left main landing gear wheel assembly during landing.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…NTSB CEN24FA277Accident · 2 fatalClass 3 · FieldFinal reportLancair ES · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall while maneuvering for traffic spacing.NTSB ERA24LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Rural Retreat, VAA loss of directional control during the landing roll.NTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA24FA310Accident · 1 fatalClass 3 · FieldFinal reportWilliams John Titan T-51 Mustang · Geneva, OHA sudden propeller overspeed and subsequent separation of the propeller blades and hub, while maneuvering at high speed and at low altitude, which resulted in a collision with a tree during the subsequent forced landing attempt.NTSB CEN24LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Rochelle, ILThe pilot’s failure to maintain terrain clearance during a low-level turn, that resulted in an impact with the ground.NTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.NTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB ERA24FA309Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Youngstown, NYThe pilot’s loss of control in flight which resulted in the airplane impacting the ground at a high rate of speed and descent.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB CEN24LA282Accident · No injuriesClass 3 · LimitedFinal reportJust Highlander · Oshkosh, WIThe reported uncommanded retraction of the flaps while on short final for unknown reasons, which resulted in a hard landing.NTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC24LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Pedro Bay, AKThe pilot’s failure to maintain directional control of the airplane during takeoff. Contributing to the accident was sun glare.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA24LA316Accident · 1 fatalClass 3 · LimitedFinal reportSheaffer Leroy B Kitfox Model IV · Palmyra, PAThe pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.NTSB ERA24LA314Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Hegins, PAThe pilot’s inadequate pre-flight and in-flight planning, which resulted in the helicopter striking a wire hazard during an aerial application flight.NTSB ERA24FA308Accident · 3 fatalClass 3 · FieldFinal reportBeech B-60 · Vienna Center, OHThe pilot’s loss of airplane control during a single-engine go-around. Also contributing to the accident was fuel system contamination, which resulted in detonation and a total loss of left engine power.NTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.NTSB WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.NTSB WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.NTSB ERA24LA320Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Port St. Lucie, FLThe pilot’s failure to correctly identify the airport runway, which resulted in a landing on a road and contact with a power line. Contributing to the outcome was the sun glare.NTSB ERA24LA315Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Zephyrhills, FLThe loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.NTSB DCA24LA241Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Orlando, FLThe captain’s inadvertent aggressive application of the brakes during taxi which resulted in a sudden stop. Contributing to the accident was the flight attendants’ failure to notify the flight crew of the unsecure cabin.NTSB CEN24LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Oakland, NEThe pilot’s failure to maintain coordinated flight during aerial-application operations, which resulted in fuel migration between the interconnected wing fuel tanks, and his failure to adequately monitor fuel levels during the flight which resulted in a loss…NTSB CEN24LA273Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Blaine, MNThe airplane’s collision with a deer on the runway during takeoff.NTSB CEN24LA271Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Eagle Lake, TXThe operator’s improper installation of the fuel system, which resulted in fuel starvation, a loss of engine power, and impact with terrain.NTSB CEN24LA269Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-36-375 · Avoca, NEA partial loss of engine power due to the loose left magneto which resulted in erratic engine timing.NTSB CEN24LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Arcola, TXLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection.NTSB WPR24LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Ritzville, WAMaintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.