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 WPR25LA034Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Durkee, ORThe pilot's inadequate performance planning, which resulted in insufficient engine power to transition into an out-of-ground-effect hover at a high gross weight.NTSB WPR25LA032Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Prescott, AZThe flight instructor’s failure to maintain clearance from a fence during taxi. Contributing to the accident was the low light conditions and obstacles adjacent to the deice bay.NTSB ERA25LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Ball Ground, GAThe pilot and the flight instructor’s failure to maintain control of the airplane during a simulated loss of engine power during takeoff, which resulted in a runway excursion, and collision with a taxiway sign.NTSB WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.NTSB ERA25LA045Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G58 · Fairfield Township, NJThe pilot’s failure to properly configure the landing gear for landing.NTSB CEN25LA035Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC-1 · East Troy, WIThe pilot’s inadequate fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inaccurate fuel gauge.NTSB ERA25LA040Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 369D · Waycross, GAAn encounter with a foreign object, which resulted in a loss of control and collision with terrain.NTSB ERA25LA038Accident · No injuriesClass 4 · LimitedFinal reportDeneal Daniel W Vans RV6A · Taylorsville, KYA nose landing gear collapse following a bounced landing.NTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.NTSB ERA25LA041Accident · Minor injuriesClass 3 · LimitedFinal reportAnderson Kitfox 4 · New Castle, PAA partial loss of engine power due to a split fuel line that resulted in a fuel leak and reduced fuel supply to the aft carburetor.NTSB ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…NTSB ERA25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195A · Bethel, PAThe pilot’s failure to maintain directional control during landing.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB DCA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAirbus A300 F4-622R · Louisville, KYThe pilot’s incorrect pitch attitude during a bounced landing which resulted in a tailstrike.NTSB WPR25LA027Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · St. George, UTA partial loss of power for reasons that could not be determined due to postimpact fire damage.NTSB ERA25LA027Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Canal Winchester, OHAn in-flight collision with a bird while in cruise flight.NTSB ERA25LA025Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairmont, WVThe student pilot’s improper flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB ERA25LA023Accident · 2 fatalClass 3 · LimitedFinal reportBuckeye Dream Machine · Nicholasville, KYThe pilot’s loss of control in flight, which resulted in a collision with terrain.NTSB CEN25LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Pineville, LAThe airplane’s collision with a stake on a closed runway. Contributing to the accident was the pilot’s inadequate preflight planning and failure to see the closed runway markings.NTSB CEN25LA031Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Pearland, TXThe pilot’s failure to maintain control of the helicopter during lift off.NTSB CEN25LA029Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters Carbon CUB · Ogallala, NEThe improper installation of the elevator control cable hardware, which resulted in the separation of the elevator control cable and a loss of pitch control in flight.NTSB ANC25LA007Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Seward, AKThe pilot’s improper landing flare which resulted in a hard landing, loss of directional control, and nose-over.NTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.NTSB ERA25LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · St. Agatha, MEA partial loss of engine power due to carburetor ice as a result of the pilot’s delayed use of carburetor heat while operating in environmental conditions conducive to serious carburetor icing.NTSB CEN25LA030Accident · No injuriesClass 4 · LimitedFinal reportStinson L-5 · Pleasanton, TXThe pilot’s failure to maintain control of the airplane during the landing.NTSB WPR25LA028Accident · No injuriesClass 4 · LimitedFinal reportDierenfield Devin RV-6A · Lancaster, CAThe pilot’s failure to maintain a stablized approach, which resulted in a hard landing.NTSB WPR25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Aberdeen, IDThe pilot’s failure to maintain back pressure on the control stick during a landing attempt on gravel, which resulted in a nose over.NTSB ERA25LA032Accident · Serious injuriesClass 4 · LimitedFinal reportAero SP Z O O AT-4 LSA · South Charleston, WVThe pedestrian’s inadequate visual lookout while walking next to an active runway, which resulted in the airplane striking him during taxi.NTSB ANC25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Talkeetna, AKThe mechanical failure of the left main landing gear leg due to corrosion, resulting in substantial damage to the left struts.NTSB ANC25LA005Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Lanai City, HIA partial loss of engine power due to the formation of carburetor ice as a result of the pilot’s improper use of carburetor heat.NTSB ERA25LA026Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sebring, FLA birdstrike during descent to the destination airport.NTSB DCA25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Houston, TXBrake application before all three landing gears were on the ground, which caused the failure of the right main landing gear tires and resulted in tire fragments impacting the fuselage.NTSB CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.NTSB ERA25LA024Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Williamsburg, VAThe pilot’s failure to maintain directional control on landing.NTSB CEN25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Willis, MIThe pilot’s failure to maintain a stabilized approach, that resulted in a runway excursion and subsequent collision with trees. Contributing to the accident, was the pilot’s decision to attempt to land to a closed runway.NTSB CEN25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Denton, TXThe partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind.NTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.NTSB WPR25LA022Accident · No injuriesClass 4 · LimitedFinal reportSeifert Dale E Highlander · Elko, NVThe pilot’s failure to maintain direction control during a go-around, which resulted in a ground loop.NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.NTSB ANC25LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Wasilla, AKThe pilot’s failure to maintain directional control during the landing roll, resulting in a ground loop.NTSB WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB CEN25LA032Accident · No injuriesClass 4 · LimitedFinal reportRyan Navion A · Belleville, ILThe pilot’s failure to maintain airplane control during the takeoff.NTSB CEN25LA024Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2A · Stoughton, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN25LA022Accident · No injuriesClass 4 · LimitedFinal reportMagniflight M24 Orion · Valmeyer, ILThe pilot’s loss of control due to flight control interference by the passenger during takeoff.NTSB ERA25LA019Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Gainesville, GAThe pilot’s sudden incapacitation due to an in-flight cardiac arrest, which necessitated a landing by a non-pilot passenger and resulted in a hard landing and collapse of the nose landing gear.NTSB WPR25LA023Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons US A-275 · Wittmann, AZThe pilot’s failure to maintain clearance from a power line during an approach.NTSB ERA25LA034Accident · No injuriesClass 4 · LimitedFinal reportHunt Exec 162F · North East, PAThe pilot’s failure to maintain control of the helicopter during landing following an encounter with an unanticipated wind gust, which resulted in a dynamic rollover.