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 CEN25LA126Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Engelwood, COOn March 16, 2025, at 1741 mountain daylight time, a Beech V35 airplane, N7987R, was substantially damaged when it was involved in an accident near Englewood, Colorado. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC25LA025Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172A · Fairbanks, AKThe pilot’s decision to initiate the flight despite identifying a malfunction in the carburetor heat system during the pre-takeoff engine run-up, which led to a partial loss of engine power during climb out. Contributing to the accident was maintenance…NTSB WPR25LA112Accident · Serious injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Waterford, CAThe pilot’s failure to maintain clearance from water while operating at a low altitude.NTSB GAA25WA125Accident · No injuriesClass 5 · ForeignTomark Viper SD4 · Newcastle, IrelandNTSB ERA25LA150Accident · No injuriesClass 4 · LimitedFinal reportTextron T240 · Midland, VAThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25FA124Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Danville, VAOn March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ERA25LA145Accident · 1 fatalClass 3 · LimitedPreliminary reportWild Sky Goat · Chester, CTOn March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal…NTSB ERA25LA144Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C · Mogadore, OHThe pilot’s decision to fly at low altitude, at night, and over water, which resulted in the helicopter’s collision with power lines.NTSB ERA25FA143Accident · 2 fatalClass 3 · FieldFinal reportRaytheon A36 · Greenville, NCThe pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).NTSB CEN25LA122Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Dallas, TXOn March 14, 2025, about 0738 central daylight time, a Cessna 208B airplane, N9471B, sustained substantial damage when it was involved in an accident at the Dallas-Fort Worth International Airport (DFW), Dallas, Texas. The pilot was not injured. The airplane…NTSB ENG25WA034OccurrenceClass 5 · ForeignAirbus A321 · Ciudad de México, MexicoNTSB DCA25FA159Accident · Minor injuriesClass 3 · FieldPreliminary reportBoeing 737-823 · Denver, COOn March 13, 2025, about 1759 mountain daylight time, American Airlines flight 1006, Boeing 737-823, N885NN, experienced engine vibrations during takeoff from Colorado Springs Airport (COS), Colorado Springs, Colorado. The flight crew continued the takeoff,…NTSB CEN25LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Lakeview, ARThe pilot landed short of the runway.NTSB CEN25LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCaldwell C W 162F · Mounds, OKThe student pilot’s failure to maintain control of the helicopter during a precautionary landing, which resulted in a dynamic roll over and postimpact fire.NTSB CEN25FA119Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 525 · Mesquite, TXOn March 13, 2025, about 0733 central daylight time, a Cessna 525A airplane, N525CZ, was destroyed when it was involved in an accident near Mesquite, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB ERA25LA142Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206G · Wedgefield, FLA total loss of engine power as a result of an excessively rich fuel-to-air ratio due to the pilot’s failure to properly lean the engine’s fuel air mixture and the inadvertent activation of the auxiliary fuel pump.NTSB ERA25LA141Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Hollywood, FLA total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…NTSB ENG25WA028IncidentClass 5 · ForeignAirbus A320 · Tijuana, MexicoNTSB CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.NTSB WPR25LA111Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Roswell, NMOn March 11, 2025, at 1340 mountain daylight time, a Cessna P210N, N711HE, was substantially damaged when it was involved in an accident near Roswell, New Mexico. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA110Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Las Vegas, NVThe pilot’s loss of helicopter control after the door opened during takeoff. Contributing to the accident was the pilot’s failure to confirm that the door was properly closed before departure.NTSB GAA25WA113Accident · 1 fatalClass 5 · ForeignMooney M20R · Velika Planina, SloveniaNTSB CEN25MA115Accident · 3 fatalClass 2 · MajorPreliminary reportEurocopter Deutschland EC 135 P2+ · Canton, MSOn March 10, 2025, about 1237 central daylight time, an Airbus Helicopters (formerly Eurocopter Deutschland) EC135 P2+ helicopter, N835CS, operated as AirCare 3, was destroyed when it was involved in an accident near Canton, Mississippi. The commercial pilot,…NTSB CEN25LA117Accident · No injuriesClass 3 · LimitedFinal reportVans RV-7A · Plainview, TXThe improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality…NTSB CEN25LA116Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Chicago, ILOn March 10, 2025, about 18:30 central daylight time, a Robinson Helicopter R44 II, N128AF was substantially damaged when it was involved in an accident near Chicago, Illinois. The pilot and both passengers were not injured. The helicopter was operated under…NTSB CEN25LA114Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A23-19 · Rochester, MNOn March 9, 2025, about 2215 central daylight time, a Beech A23-19, N4784J, was substantially damaged when it was involved in an accident near Rochester, Minnesota. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ANC25LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cantwell, AKThe pilot’s failure to maintain altitude during a low-altitude maneuver which resulted in inadvertent ground contact and a nose over.NTSB GAA25WA114Accident · 1 fatalClass 5 · ForeignCessna 150 · Peruibe, BrazilNTSB ERA25LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB GAA25WA116Accident · 1 fatalClass 5 · ForeignCessna 152 · Voi, KenyaNTSB GAA25WA105AccidentClass 5 · ForeignSievers KS-206-A (OH58) · Chiquimula, GuatemalaNTSB GAA24WA320IncidentClass 5 · ForeignCessna 525A · Shizuoka, JapanNTSB DCA25WA165OccurrenceClass 5 · ForeignEmbraer 190 · The Granites, AustraliaNTSB ANC25LA032Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Redding, CAThe pilot's failure to maintain a stabilized approach and his delayed action to perform a go-around, resulting in a collision with the runway surface.NTSB ANC25LA027Accident · No injuriesClass 3 · LimitedPreliminary reportPilatus PC-12/45 · Sleetmute, AKOn March 7, 2025, about 1740 Alaska standard time, a Pilatus PC-12 airplane, N304PT, sustained substantial damage when it was involved in an accident near Sleetmute, Alaska. The pilot and nine passengers were not injured. The airplane was operated as a Title…NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB ANC25LA030Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKMaintenance personnel’s reuse of worn hardware during the installation of the landing gear assembly and the hardware’s failure and subsequent separation of the gear leg from the landing gear box assembly during taxi.NTSB ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Pearland, TXOn March 6, 2025, about 1145 central standard time, a Piper PA-28-140 airplane, N54479, was substantially damaged when it was involved in an accident near Pearland, Texas. One pilot sustained minor injuries, and the other pilot was not injured. The airplane…NTSB GAA25WA117Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Balsas, BrazilNTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.NTSB WPR25FA108Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A150L · Renslow, WAOn March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB GAA25WA100Accident · No injuriesClass 5 · ForeignGrumman AA5 · Zell am See, AustriaNTSB ERA25LA208Accident · No injuriesClass 4 · LimitedFinal reportWagoner Richard Searey · Zellwood, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing.NTSB CEN25LA109Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · San Antonio, TXThe pilot’s failure to maintain directional control during a gusty crosswind landing.NTSB GAA25WA121Accident · No injuriesClass 5 · ForeignPiper PA46 · Aarhus, DenmarkNTSB ERA25LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Knoxville, TNThe student pilot’s failure to maintain clearance from a truck while taxiing.