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 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 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 DCA25WA018Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Alicante, SpainNTSB WPR25LA025Accident · Minor injuriesClass 3 · LimitedPreliminary reportBadlands Vaquero · West Wendover, NVOn October 27, 2024, about 0915 Pacific daylight time, an experimental amateur-built Badlands Vaquero airplane, N510DH, was destroyed when it was involved in an accident near West Wendover, Nevada. The pilot sustained minor injuries. The airplane was operated…NTSB GAA25WA176Accident · 1 fatalClass 5 · ForeignSocata TB 20 · Vaduleni, MoldovaNTSB GAA25WA016Accident · Serious injuriesClass 4 · ForeignCessna 340A · Saint-Denis-de-l'Hôtel, FranceNTSB 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 DCA25WA019IncidentClass 5 · ForeignAirbus A330 · International Waters, South AfricaNTSB 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 GAA25WA025Accident · 1 fatalClass 5 · ForeignCessna 182P · The Oaks, AustraliaNTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaNTSB 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 CEN25LA028Accident · 1 fatalClass 3 · LimitedPreliminary reportCessna 182Q · Rose Hill, KSOn October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title…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 ENG25WA022IncidentClass 5 · ForeignBoeing 737 · Karachi, PakistanNTSB DCA25WA014IncidentClass 5 · ForeignBoeing 787 · Doha, QatarNTSB 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 GAA25WA075OccurrenceClass 5 · ForeignBeech 200 · Pillanesburg, South AfricaNTSB GAA25WA015Accident · 8 fatalClass 5 · ForeignSikorsky S76 · Port Harcourt, NigeriaNTSB 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 GAA25WA024Accident · 1 fatalClass 5 · ForeignCessna 150L · Bacchus Marsh, AustraliaNTSB ENG25WA002OccurrenceClass 5 · ForeignTextron Beech G58 · Okayama, JapanNTSB ERA25LA024Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Williamsburg, VAThe pilot’s failure to maintain directional control on landing.NTSB DCA25WA017Incident · No injuriesClass 5 · ForeignBoeing 737 · Tenerife, SpainNTSB DCA25WA016IncidentClass 4 · ForeignBoeing 787 · Guangzhou, ChinaNTSB 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 ERA25FA020Accident · 2 fatalClass 3 · FieldFinal reportGeisz Gilbert A Lancair 360 · Cross City, FLThe pilot’s exceedance of the critical angle of attack, which resulted in an aerodynamic stall at an altitude too low to recover. Contributing to the accident was the total electrical failure, which likely resulted in a loss of airspeed indication.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 WPR25LA024Accident · No injuriesClass 3 · LimitedPreliminary reportHayden ED RV10 · Beaver Marsh, OROn October 19, 2024, about 1400 Pacific daylight time, an experimental amateur built Vans RV-10, N929EH, was substantially damaged when it was involved in an accident near Beaver Creek, Oregon. The pilot was not injured. The airplane was operated as a Title…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 OPS25LA005IncidentClass 3 · LimitedPreliminary reportBoeing 737-7H4 · Long Beach, CAOn October 19, 2024, at 1450 pacific daylight time (PDT), a Diamond DA40, N895AM, and a Boeing 737-7H4, N250WN, operated as SWA1671, were involved in a runway incursion in Long Beach, CA. There were no injuries reported and none of the aircraft were damaged.…NTSB DCA25WA028Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Ndiass, SenegalNTSB 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.