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 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 DCA25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Ebro, FLThe airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…NTSB CEN25LA349AccidentClass 4 · LimitedFinal reportCessna 650 · Westplains, COThe pilot’s improper judgment to circumnavigate convective activity which resulted in extensive hail damage to the airplane.NTSB ANC25LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Modesto, CAThe pilot’s failure to properly configure the airplane for landing.NTSB ANC25LA052Accident · Minor injuriesClass 3 · LimitedPreliminary reportStinson 108 · Cantwell, AKOn June 14, 2025, about 1415 Alaska daylight time, a Stinson 108 airplane, N2101Q, was substantially damaged when it was involved in an accident near Cantwell, Alaska. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB ANC25LA051Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s failure to maintain clearance from trees during a go-around with a tailwind.NTSB WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB WPR25LA173Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Bountiful, UTThe pilot’s improper decision to depart with inadequate clearance from a hangar door.NTSB ERA25LA234Accident · Minor injuriesClass 3 · LimitedPreliminary reportSteven Scott Grasley RV-7A · Interlachen, FLOn June 13, 2025, about 15:31 eastern daylight time, an experimental, amateur built RV-7A, N783RV, was substantially damaged when it was involved in an accident near Interlachen, Florida. The commercial pilot received minor injuries. The airplane was operated…NTSB ANC25LA053Accident · No injuriesClass 4 · LimitedFinal reportFrederick Joseph Shiple Kitfox SS7 · Yellow Pine, IDThe pilot's excessive application of the airplane’s wheel brakes during the landing roll, which resulted in a nose over.NTSB ERA25LA229Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Valparaiso, FLOn June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…NTSB ERA25LA227Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Hartsville, TNOn June 12, 2025, about 1750 central daylight time, a Cirrus SR22, N312DA, was substantially damaged when it was involved in an accident near Hartsville, Tennessee. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA25WA236Incident · No injuriesClass 5 · ForeignBoeing 737 · Pusan City, South KoreaNTSB DCA25WA232AccidentClass 2 · ForeignBoeing 787 · Ahmedabad, IndiaNTSB DCA25LA233Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 747-47UF · Guayaquil, EcuadorNTSB CEN25LA205Accident · No injuriesClass 3 · LimitedPreliminary reportLancair 360 · Fort Stockton, TXOn June 11, 2025, about 2145 central daylight time, a Lancair 360 airplane, N77LH, was destroyed when it was involved in an accident near Fort Stockton, Texas. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen Schneider LS-7WL · Tonasket, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB GAA25WA200Accident · No injuriesClass 5 · ForeignRobinson R44 · Venn, AustraliaNTSB GAA25WA183Accident · 1 fatalClass 5 · ForeignRobinson R66 · Chalfont St Peter, Buckinghamshire, United KingdomNTSB ANC25LA050Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD3-60 · Honolulu, HIThe pilots’ failure to extend the landing gear prior to landing. Contributing to the accident was the pilots’ failure to complete the Before Landing checklist.NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB DCA25WA235AccidentClass 5 · ForeignBoeing 787 · near waypoint DAGAG, SingaporeNTSB ANC25LA047Accident · No injuriesClass 4 · LimitedFinal reportBrian Peck RV-14 · Camas, WAThe pilot’s failure to maintain directional control during landing roll which resulted in a runway excursion.NTSB ERA25LA273Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · New Port Richey, FLThe pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.NTSB ENG25WA041Incident · No injuriesClass 5 · ForeignAirbus A320 · Pudahuel, ChileNTSB WPR25FA169Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 414 · San Diego, CAOn June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA187AccidentClass 5 · ForeignPiper PA28 · Ladysmith, South AfricaNTSB GAA25WA181Accident · No injuriesClass 5 · ForeignPulsar XP · Bromsgrove, United KingdomNTSB ERA25LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Knoxville, TNA collision with a deer during the landing roll.NTSB ERA25LA232Accident · No injuriesClass 4 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel XP · Geneva, FLThe airplane’s collision with a submerged object during landing, which resulted in substantial damage to the fuselage/hull.NTSB ERA25LA222Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6 Twin Otter · Tullahoma, TNOn June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…NTSB DCA25LA230Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Phoenix, AZThe abrupt application of brakes during taxi, which resulted in a sudden stop and caused a flight attendant to sustain a serious injury.NTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB ANC25LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Flagstaff, AZThe pilot’s failure to maintain directional control during takeoff in variable and gusty wind, which resulted in a ground loop.NTSB ANC25LA048Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Mojave, CAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25LA171Accident · Minor injuriesClass 3 · LimitedPreliminary reportYakovlev YAK-50 · Hayward, CAOn June 7, 2025, about 1252 Pacific daylight time, a Yakovlev YAK-50, N150YK, was substantially damaged when it was involved in an accident near Hayward, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA374Accident · No injuriesClass 4 · LimitedFinal reportFlying Cloud AL18 · Ridgeland, SCThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ERA25LA223Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Hebron, OHThe airplane owner and pilot’s intentional allowance of unapproved maintenance and maintenance personnel’s failure to adequately maintain or service the brake system, which resulted in a total loss of brake pressure.NTSB CEN25LA201Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Pawhuska, OKThe pilot’s failure to properly configure the airplane for landing.NTSB CEN25FA198Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Waterman, ILOn June 7, 2025, about 1459 central daylight time, an Aeronca 7AC airplane, N1846E, sustained substantial damage when it was involved in an accident near Waterman, Illinois. The pilot was fatally injured, and the passenger was seriously injured. The airplane…NTSB WPR25LA170Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150M · Phoenix, AZOn June 6, 2025, about 0530 mountain standard time, a Cessna 150M, N45659, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane was operated as a…NTSB CEN25LA204Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Pembine, WIThe pilot’s improper flare during landing which resulted in a bounced landing.NTSB CEN25FA197Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502 · Grady, AROn June 6, 2025, about 1830 central daylight time, an Air Tractor AT-502 airplane, N9185F, was substantially damaged when it was involved in an accident near Grady, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA197Incident · No injuriesClass 5 · ForeignPiper PA31 · Meekatharra, AustraliaNTSB GAA25WA186Accident · 1 fatalClass 4 · ForeignCessna 210 · Lanseria, South AfricaNTSB ERA25LA219Accident · No injuriesClass 4 · LimitedFinal reportFred L Wellman CH 750 Cruzer · Medina, OHThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in a runway excursion.NTSB CEN25LA206Accident · No injuriesClass 3 · LimitedPreliminary reportXag P100 PRO · Pontiac, ILOn June 5, 2025, at 1155 central daylight time, a XAG P100 Pro, N231CU, was substantially damaged when it was involved in an accident near Pontiac, Illinois. The unmanned aerial system (UAS) was operated under Title 14 Code of Federal Regulations as a Part…NTSB CEN25LA200Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gibson, ARThe pilot’s loss of control during takeoff due to an encounter with a sudden wind shift.NTSB CEN25LA196Accident · Minor injuriesClass 4 · LimitedFinal reportGallow Daniel A Kitfox Classic IV · Waupaca, WIThe pilot’s failure to maintain adequate air speed during final approach, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.