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 ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.NTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.NTSB ERA25LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Mayo, MDA total loss of engine power at low altitude due to an accumulation of carburetor ice while in a cruise-power descent, which resulted in a forced landing.NTSB WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.NTSB ANC25LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKA total loss of engine power for undetermined reasons.NTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.NTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.NTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB CEN25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Farlinville, KSA loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.NTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.NTSB WPR25LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxnard, CAThe student pilot’s failure to maintain directional control during landing roll.NTSB CEN25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · Greenville, MSThe pilots’ inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing into wooded terrain. Contributing to the accident was the flight…NTSB WPR25LA095Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver Aeronautics L-S2S · Geyserville, CAThe pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.NTSB ERA25LA129Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC135T2 · Philadelphia, PAThe sUAS operator’s failure to see and avoid a helicopter, resulting in a midair collision between the helicopter and the sUAS.NTSB CEN25LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Breckenridge, TXThe mechanic’s failure to properly install the throttle cable hardware resulting in a separation of the cable and loss of engine throttle control.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR25LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Minersville, UTThe failure of the propeller blade due to fatigue that originated from an impact pit sustained at an unknown time. Contributing to the accident was the failure of unknown maintenance personnel to detect and repair the impact pit before painting the propeller,…NTSB CEN25LA098Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Cookville, MOThe pilot’s failure to maintain adequate clearance from a tree during the low altitude operation.NTSB ERA25LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Culpeper, VAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll, resulting in a runway excursion.NTSB ERA25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Syracuse, NYThe truck driver’s to see and avoid the airplane, which resulted in a collision.NTSB ERA25FA119Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Pierson, FLThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.NTSB WPR25LA093Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Moab, UTThe inflight collision with debris during takeoff.NTSB ERA25LA115Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Hampton, NHThe pilot’s failure to maintain adequate airspeed while maneuvering to land, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.NTSB WPR25FA090Accident · No injuriesClass 3 · FieldFinal reportBeech B24R · Skull Valley, UTThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were multiple distractions that diverted the flight instructor’s attention from the proper monitoring and…NTSB ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.NTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.NTSB WPR25LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Shafter, CAA total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.NTSB WPR25LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Auburn, CAThe pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.NTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.NTSB WPR25LA107Accident · No injuriesClass 4 · LimitedFinal reportCessna T207A · Tusayan, AZAn encounter with wind gusts, which resulted in a loss of control and a collapse of the nose landing gear.NTSB CEN25LA093Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Spearman, TXImproperly torqued intake manifold bolts that allowed unmetered air to enter the engine, resulting in an overly lean fuel-air mixture, eventual failure of the No. 3 cylinder intake valve, and a total loss of engine power.NTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.NTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.NTSB ANC25MA018Accident · 10 fatalClass 1 · MajorFinal reportTextron 208B · Nome, AKThe National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…NTSB ERA25LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fort Myers, FLThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ERA25LA111Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · New Lexington, OHThe pilot’s flight into previously forecasted freezing rain, which resulted in ice accretion, reduced forward visibility, and a subsequent landing undershoot.NTSB ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.NTSB DCA25LA117Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-832 · Seattle, WAThe Japan Airlines flight crew’s failure to maintain adequate clearance from the parked Delta Air Lines aircraft while taxiing in congested ramp conditions.NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB WPR25LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Ramona, CAAn in-flight collision with a bird in the airport traffic pattern.NTSB DCA25LA120Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Chicago, ILThe tug driver’s failure to ensure the taxiway was clear of aircraft prior to crossing, resulting in a collision with the left wing of the taxiing aircraft. Contributing to the accident was the limited visibility of the aircraft due to ambient lighting…NTSB DCA25LA114Occurrence · No injuriesClass 3 · LimitedFinal reportAirbus Industrie A319 · Houston, TXThe failure of the cabin crew to activate the evacuation alarm and to maintain coordinated communication with the flight crew following the cabin crew’s decision to command an evacuation, which resulted in an engine running during the initial evacuation.…NTSB CEN25LA091Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Ennis, TXThe pilot’s improper fuel planning which resulted in the total loss of engine power due to fuel exhaustion.NTSB ANC25LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 182F · Anchorage, AKThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.NTSB WPR25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportLockheed C-130A · Daggett, CAAn inflight upset due to an improperly secured load that resulted in serious injuries.NTSB WPR25LA087Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Upland, CAThe pilot’s failure to maintain adequate separation during landing, which resulted in a runway collision with another airplane.NTSB CEN25LA090Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Sparta, ILAn onboard fire for unknown reasons.NTSB ERA25LA108Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Ravenswood, WVThe pilot’s distraction during taxi, which resulted in a taxiway excursion.