NTSB investigations
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CEN25LA094Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 58P · Pine Bluff, AROn February 5, 2025, about 1848 central standard time, a Beech 58P airplane, N138TL, was substantially damaged when it was involved in an accident near Pine Bluff, Arkansas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…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 GAA25WA084Accident · 1 fatalClass 5 · ForeignBell 206 · Polokwane Civil Aerodrome, South AfricaNTSB 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 DCA25WA153IncidentClass 5 · ForeignEmbraer 190LR · Olympic Dam, AustraliaNTSB DCA25WA122Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Olympic Dam, AustraliaNTSB GAA25WA108Accident · No injuriesClass 5 · ForeignCessna U206 · Novo Progresso, BrazilNTSB GAA25WA082Accident · 1 fatalClass 5 · ForeignPiper PA-34-220T · Braunschweig, GermanyNTSB GAA25WA076AccidentClass 5 · ForeignRobinson R22 · Workingham, Berkshire, United KingdomNTSB 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 GAA25WA078AccidentClass 5 · ForeignRobinson R44 · San Miguel, PhilippinesNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorNTSB CEN25LA090Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Sparta, ILAn onboard fire for unknown reasons.NTSB GAA25WA079Accident · Serious injuriesClass 5 · ForeignCessna 188 · Santa Cruz, BoliviaNTSB ERA25MA106Accident · 7 fatalClass 2 · MajorPreliminary reportLearjet 55 · Philadelphia, PAOn January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two…NTSB GAA25WA083Accident · 1 fatalClass 5 · ForeignCessna C185F · Naivasha, KenyaNTSB ERA25LA108Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Ravenswood, WVThe pilot’s distraction during taxi, which resulted in a taxiway excursion.NTSB ERA25LA107AccidentClass 3 · LimitedPreliminary reportAviat Pitts S-2B · Fellsmere, FLOn January 30, 2025, at 1034 eastern standard time, an Aviat Inc Pitts S-2B, N8ZT, was substantially damaged when it was involved in an accident near Fellsmere, Florida. The private pilot was seriously injured. The airplane was operated as a Title 14 Code of…NTSB DCA25MA108Accident · 67 fatalClass 1 · MajorFinal reportBombardier CL-600-2C10 · Washington, DCThe Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…NTSB WPR25LA085Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Santa Barbara, CAOn January 29, 2025, about 1417 Pacific standard time, a Cirrus Design Corp SR22T, N124LZ, was destroyed when it was involved in an accident near Santa Barbara, California. The two pilots were seriously injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA073Accident · 3 fatalClass 3 · ForeignCessna 550 · Baruta, VenezuelaNTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB DCA25WA118Accident · 20 fatalClass 5 · ForeignBeech 1900 · Juba, SudanNTSB DCA25WA125OccurrenceClass 5 · ForeignBoeing 737 · Kano, NigeriaNTSB GAA25WA098Accident · 3 fatalClass 5 · ForeignRobinson R44 · Cruzilia, BrazilNTSB ENG25WA018Incident · No injuriesClass 3 · ForeignBoeing 737 · Cochabamba, BoliviaNTSB DCA25WA106Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB CEN25LA089Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Brush, COThe failure of the left main landing gear forward strut.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB GAA25WA070Accident · 2 fatalClass 3 · ForeignCessna 182 · Región del Bio Bio, ChileNTSB GAA25WA247Accident · Serious injuriesClass 3 · ForeignEmbraer EMB203 · Correntina, BrazilNTSB GAA25WA087Accident · No injuriesClass 5 · ForeignCessna 172 · Pará De Minas - Minas Gerais, BrazilNTSB ERA25FA103Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35B · Charlottesville, VAOn January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ENG25WA020Incident · No injuriesClass 5 · ForeignAirbus A320 · Monterrey, MexicoNTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA25WA192AccidentClass 5 · ForeignCirrus SR22 · Nyngan, AustraliaNTSB DCA25LA093Accident · Serious injuriesClass 3 · LimitedPreliminary reportBoeing 787-8 · Dabouzra, Côte d’IvoireOn January 24, 2025, about 00:31 universal coordinated time (UTC), United Airlines (UAL) flight 613, a Boeing 787-8, experienced altitude excursions during cruise flight while transitioning over Cote d’Ivoire airspace at 36,000 feet. Of the 11 crew members…NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB GAA25WA080Accident · 1 fatalClass 5 · ForeignCessna 188 · Canarana, Brazil