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 WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA046Accident · Minor injuriesClass 4 · LimitedFinal reportMichael W Verzwyvelt SS-7 Super Sport · Boise, IDThe pilot’s operation of the airplane while intoxicated, resulting in its impact with obstacles while on approach.NTSB WPR26LA042Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Marana, AZThe pilot’s improper starting procedure which resulted in the airplane’s unexpected movement and subsequent impact with an airport fence.NTSB WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB ERA26LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · Southern Pines, NCThe pilot’s failure to maintain directional control during takeoff at night, while distracted by an animal approaching the runway, which resulted in collision with a runway light.NTSB GAA26WA044Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · Campo Novos dos Parecis, BrazilNTSB ERA26FA035Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Lebanon, TNOn November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was…NTSB ERA26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportExtra Flugzeugproduktions EA 300/SC · Keystone Heights, FLOn November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26WA044Incident · No injuriesClass 5 · ForeignBoeing 737 · Riyadh, Saudi ArabiaNTSB DCA26WA038OccurrenceClass 5 · ForeignEmbraer ERJ170 · Toronto, CanadaNTSB CEN26LA040Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Lakeview, ARThe pilot’s decision to continue an approach that resulted in a long landing and inability to stop prior to the end of the runway. Contributing to the accident were the light conditions and a road with vehicles on it immediately adjacent to the end of the…NTSB ANC26LA006Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-14 · Talkeetna, AKOn November 8, 2025 about 1300 Alaska standard time, a Piper PA-14 airplane, N5188H, was substantially damaged when it was involved in an accident near Talkeetna, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA041Accident · No injuriesClass 3 · LimitedPreliminary reportBessler Duane Lynn Savannah · Pacific, WAOn November 7, 2025 at 1331 Pacific standard time, an experimental amateur-built ICP Savannah amphibious airplane, N358D, was substantially damaged when it was involved in an accident near Pacific, Washington. The pilot and the passenger were not injured. The…NTSB ERA26LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Cuthbert, GAThe pilot’s failure to maintain clearance from trees and terrain while maneuvering for a precautionary landing, at low altitude and at night.NTSB DCA26WA027IncidentClass 5 · ForeignBoeing 777 · Al-Dajeej, KuwaitNTSB CEN26LA039Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Pineville, MOThe change in wind direction during landing, which resulted in a tailwind condition and runway overrun.NTSB GAA26WA021Accident · No injuriesClass 5 · ForeignPiper PA32RT · Contamana, PeruNTSB ERA26LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxford, CTThe pilot’s failure to compensate for gusty crosswind conditions, which resulted in a loss of control of the airplane and subsequent collision with terrain.NTSB ERA26LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Suffolk, VAThe pilot’s failure to maintain control of the airplane during landing, which resulted in a nose over.NTSB ENG26WA010OccurrenceClass 5 · ForeignDe Havilland DHC3 · Lake Rotorua, New ZealandNTSB ENG26WA007OccurrenceClass 5 · ForeignAirbus A321 · Mexico City, MexicoNTSB DCA26WA050Incident · No injuriesClass 5 · ForeignBoeing 737 · Heliopolis, EgyptNTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN26LA036Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gueydan, LAThe pilot’s failure to maintain situational awareness and clearance from terrain while maneuvering to avoid birds.NTSB CEN26LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Grantsburg, WIThe collision with a white-tail deer during the landing in dark night visual conditions.NTSB GAA26WA020Accident · No injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB ERA26LA031Accident · Minor injuriesClass 3 · LimitedPreliminary reportProctor E Ray Exec 162F · Athens, TNOn November 04, 2025, at about 1400 eastern standard time, an amateur built experimental Rotorway 162F, N162RW, was destroyed when it was involved in an accident near Athens, Tennessee. The commercial pilot received minor injuries. The airplane was operated…NTSB DCA26WA034IncidentClass 5 · ForeignBoeing 787 · Pasay City, PhilippinesNTSB DCA26WA029Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD88 · Mashhad, IranNTSB DCA26MA024Accident · 14 fatalClass 1 · MajorPreliminary reportMcdonnell Douglas MD-11F · Louisville, KYOn November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…NTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB WPR26LA038Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · San Andreas, CAThe pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.NTSB WPR26LA036Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Sedona, AZOn November 3, 2025, about 0830 mountain standard time, a Cirrus SR-22, N237RJ, sustained substantial damage when it was involved in an accident near Sedona, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB DCA26WA022IncidentClass 5 · ForeignBoeing 737 · Bogotá, ColombiaNTSB CEN26LA032Accident · Serious injuriesClass 3 · LimitedPreliminary reportJust Highlander · Delta, COOn November 2, 2025, about 1630 mountain standard time, an experimental amateur-built Just Highlander airplane, N622SC, was substantially damaged when it was involved in an accident near Delta, Colorado. The flight instructor and student pilot were seriously…NTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB WPR26LA035Accident · No injuriesClass 3 · LimitedPreliminary reportMaule M-7-235A · Friday Harbor, WAOn October 31, 2025, at about 1227 Pacific daylight time, a Maule M-7-235A, N9234N, was substantially damaged when it was involved in an accident at Friday Harbor Airport (FHR), Friday Harbor, Washington. The pilot was not injured. The airplane was operated…NTSB ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.NTSB ERA26FA027Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20E · Ballston Spa, NYOn October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was…NTSB WPR26LA037Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5B · Santa Ynez, CAOn October 29, 2025, about 1820 Pacific daylight time, a Grumman American AA-5B, N74323, was substantially damaged when it was involved in an accident near Santa Ynez, California. The commercial pilot was not injured. The airplane was operated as a Title 14…NTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB ENG26LA004Incident · Minor injuriesClass 3 · LimitedPreliminary reportAirbus A320-232 · Gulf of America (Gulf of Mexico)On October 30, 2025 at 1748 UTC, JetBlue Airways Flight 1230 (N605JB) experienced a pitch excursion while cruising at 35,000 feet in smooth air and clear weather over the Gulf of America. The pitch excursion resulted in an approximate altitude loss of 100…NTSB CEN26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Lakeview, ARThe pilot’s failure to maintain a proper approach path during landing which resulted in a collision with terrain short of the runway. Contributing to the accident was the improper flap position during landing, and the pilot being fatigued.NTSB WPR26LA034Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · La Verne, CAOn October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB OPS26LA001IncidentClass 4 · LimitedInvestigation openEurocopter Deutschland MBB-BK 117 C-2 · Cleveland, OHNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileNTSB ANC26LA020Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182Q · Mapleton, IAOn October 29, 2025, at about 1200 Central daylight time, a Cessna 182Q, N735ZD, was substantially damaged when it was involved in an accident near Mapleton, Iowa. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code…NTSB GAA26WA046Incident · No injuriesClass 5 · ForeignCirrus SF50 · Oberweningen, SwitzerlandNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaNTSB ERA26LA030Accident · No injuriesClass 4 · LimitedFinal reportHugh Nunnally Farrior Cozy MK IV · McRae-Helena, GAThe pilot’s failure to extend the nose landing gear, which resulted in a nose gear up landing. Contributing to the accident was the pilot’s inappropriate decision to continue to fly with known delamination damage to the propeller.