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 CEN25LA404Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR20 · Watertown, WIThe flight instructor’s failure to maintain control of the airplane following the student pilot’s bounced landing. Contributing to the accident was the flight instructor’s delayed remedial action which resulted in diminished airplane performance during the…NTSB WPR25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Avalon, CAThe pilot’s decision to land with a tailwind and a downslope to the runway.NTSB ERA25LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Punxsutawney, PAThe airplane’s collision with a deer on a runway during landing roll.NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB ERA25LA379Accident · No injuriesClass 4 · LimitedFinal reportMccaa Robert T Avid/Kitfox Flyer · Oakland, PAThe pilot/owner’s failure to accurately determine the airplane’s weight and performance limitations before initiating the takeoff. Contributing to the outcome was the flight instructor’s improper engine power management and landing flare, which resulted in a…NTSB ERA25LA376Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · West Milford, NJThe pilot’s improper landing flare and subsequent failure to recover from a hard bounced landing, which resulted in a loss of directional control and runway excursion.NTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB CEN25LA399Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · Stephenville, TXThe pilot’s failure to ensure the canopy and the cockpit were properly secured during the hand prop sequence.NTSB ANC25LA116Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Alpine, WYThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off airport landing.NTSB WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Okeechobee, FLCollision with a bird during cruise flight.NTSB CEN25LA398Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Del Norte, COThe loss of directional control during landing roll due to a flat tire.NTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB CEN25LA396Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Archer City, TXThe pilot’s failure to maintain clearance from power lines while herding livestock.NTSB ANC25LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Morgan, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC25LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Los Banos, CAThe pilot’s failure to maintain directional control during the landing roll with a crosswind, resulting in a ground loop and nose over.NTSB WPR25LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hayden, IDThe student pilot’s inability to maintain control of the airplane during a sudden wind gust resulting in the airplane coming to rest inverted.NTSB CEN25LA402Accident · No injuriesClass 4 · LimitedFinal reportTextron 525C · Baton Rouge, LAThe improper installation of the trunnion pin, which resulted in a failure of the right main landing gear. Contributing to the accident was the failure of maintenance personnel to follow the aircraft manufacturer’s maintenance procedures.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN25LA393Accident · No injuriesClass 4 · LimitedFinal reportFloyd G Halderman JR RV-6 · Cambridge, MNThe pilot’s continued operation of the faulty fuel selector valve which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the degraded operation of the fuel selector valve and the pilot’s poor decision to operate the…NTSB WPR25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Lake Havasu City, AZThe pilot’s failure to extend the landing gear before landing due to distraction and failure to conduct the before landing checklist.NTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB CEN25LA400Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Rush City, MNThe pilot’s failure to properly monitor the airplane glide path which resulted in the inadvertent descent below the approach minimum descent altitude and the impact with trees.NTSB ANC25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Healy, AKThe pilot’s failure to maintain directional control during the departure roll resulting in a collision with a tractor/loader.NTSB ANC25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Yakataga, AKThe total loss of engine power due to carburetor icing and the pilot’s failure to effectively use carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Linden, NJAn in-flight collision with a bird while on approach.NTSB ERA25LA359Accident · No injuriesClass 4 · LimitedFinal reportEdwin Miller Calidus · Hopkinsville, KYThe pilot’s failure to maintain control of the gyroplane, which resulted in dynamic rollover and impact with terrain.NTSB ERA25LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Blue Ridge, GAThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB CEN25LA391Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Seagoville, TXThe pilot’s inadequate fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC25LA111Accident · No injuriesClass 4 · LimitedFinal report217whiskeymike SQ12 · McGrath, AKThe pilot’s failure to maintain clearance from a hole in the tundra, which resulted in impact with terrain.NTSB ERA25LA356Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Plymouth, MAThe low wing airplane pilot’s failure to maintain an adequate visual lookout and his decision to activate the portable ADS-B receiver while taxiing, which resulted in a ground collision.NTSB ERA25LA355Accident · No injuriesClass 4 · LimitedFinal reportLamphere David A Wittman Buttercup · Monterey, VAThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB CEN25LA389Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Decatur, TXThe pilot’s loss of control during an off-airport, pinnacle landing, and the flight instructor’s inadequate supervision of the instructional flight.NTSB ANC25LA118Accident · No injuriesClass 4 · LimitedFinal reportToci Gabe C G Supa · Palmer, AKThe pilot’s failure to maintain airplane control during the go-around.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB CEN25LA387Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Oxford, MSThe pilot’s exceedance of the airplane’s critical angle of attack during the initial takeoff climb, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.NTSB WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB WPR25LA280Accident · No injuriesClass 4 · LimitedFinal reportWeaver Harmon Rocket · Hayden, IDThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA25LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Smyrna, TNThe pilot’s failure to extend the landing gear before landing.NTSB ANC25LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain clearance from an object during takeoff, which resulted in a collision and ground loop. Contributing was the pilot’s selection of an unsuitable takeoff area.NTSB ERA25LA349Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Virus 912 LSA · Lincoln Park, NJThe pilot’s inadequate compensation for variable wind conditions, which resulted in a hard landing and loss of directional control.NTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.NTSB CEN25LA380Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Decatur, TXThe instructor candidate’s erroneous operation of the throttle during an autorotation from altitude with power recovery, which resulted in a hard landing.NTSB ANC25LA109Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Kotlik, AKThe pilot’s failure to maintain airplane control during a go-around in variable wind conditions.NTSB ANC25LA107Accident · No injuriesClass 4 · LimitedFinal reportDavid Hunter Danchini CUB · Tyonek, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, in gusting crosswind conditions.NTSB WPR25LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon pilot’s improper landing, which resulted in serious injury to a passenger. Contributing to the accident was the pilot’s failure to brief the proper landing procedure.NTSB ANC25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St Mary's, AKThe pilot’s improper decision to takeoff with a tailwind, from a short off-airport strip, which degraded the climb performance of the airplane and led to impact with trees at the end of the strip.