NTSB investigations
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 ERA26LA201Accident · No injuriesClass 4 · LimitedFinal reportSky Ranger SKY Ranger 1 · Front Royal, VAThe pilot’s inadequate preflight inspection, which resulted in him taking off with the fuel selector in the OFF position, and the subsequent total loss of engine power due to fuel starvation.NTSB DCA26WA198Incident · No injuriesClass 5 · ForeignBoeing 737 · Salvador, BrazilNTSB CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB DCA26WA228Incident · No injuriesClass 5 · ForeignBombardier CL600 2E25 · Manises, SpainNTSB ANC26LA040Accident · No injuriesClass 4 · LimitedInvestigation openDouglas DC3C · Anchorage, AKNTSB GAA26WA229Accident · No injuriesClass 5 · ForeignCessna 172 · Munnekezijl, NetherlandsNTSB GAA26WA188Incident · No injuriesClass 5 · ForeignHawker Beechcraft B300 · Augsburg, GermanyNTSB ERA26LA202Accident · No injuriesClass 4 · LimitedFinal reportSherry Grobstein LSA-8X · Hyannis, MAThe pilot’s failure to maintain control of the airplane while landing, which resulted in a ground loop and subsequent nose over.NTSB CEN26LA181Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Durango, COThe flight instructor’s inadequate supervision of the pilot receiving the instruction and the pilot’s improper recovery from a practice autorotation in shifting wind conditions, which resulted in a hard landing.NTSB ANC26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 182T · Armistead, CAOn May 7, 2026, about 1055 pacific daylight time (PDT), a Cessna 182T airplane, N227TF, was destroyed when it was involved in an accident near Armistead, California. The flight instructor and the pilot receiving instruction were fatally injured. The airplane…NTSB DCA26WA207Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Lahore, PakistanNTSB ANC26LA037Accident · Serious injuriesClass 3 · LimitedPreliminary reportTundrair King · Palmer, AKOn May 5, 2026, about 1950 Alaska daylight time (AKDT), an experimental Tundrair King airplane, N62TK, was destroyed when it was involved in an accident near Palmer, Alaska. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB ANC26LA038Accident · No injuriesClass 4 · LimitedFinal reportTextron B300C · Salcha, AKAn in-flight collision with a bird during cruise flight.NTSB GAA26WA187Accident · Serious injuriesClass 5 · ForeignMD Helicopter 369 · Haast, New ZealandNTSB ERA26LA197Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Lancaster, OHOn May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ENG26WA028IncidentClass 5 · ForeignAirbus A321 · Ciudad de México, MexicoNTSB DCA26LA196Accident · No injuriesClass 4 · LimitedInvestigation openSkydweller S L Solar Impulse SI2 · Gulf of America (Gulf of Mexico)NTSB CEN26LA179Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421C · Kirksville, MOOn May 4, 2026, about 1759 central daylight time, a Cessna 421C airplane, N6161X, was substantially damaged during an accident near Kirksville, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US C-80 · Rio Rancho, NMThe passenger’s improper hand placement on the basket upright during landing, which resulted in injury when the upright fractured during the basket’s bounce and drag sequence.NTSB GAA26WA183Accident · 1 fatalClass 5 · ForeignCessna 182 · Santa Cruz Barillas, GuatemalaNTSB DCA26FA194Accident · Minor injuriesClass 3 · FieldPreliminary reportBoeing 767-424ER · Newark, NJOn May 3, 2026, about 13:50 eastern daylight time (EDT), United Airlines flight 169, Boeing B767-424ER, N77066, struck a light pole on the New Jersey turnpike while on final approach to runway 29 at Newark Liberty International Airport (EWR), Newark, New…NTSB CEN26LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-236 · Glenwood Springs, COThe pilot’s failure to maintain clearance from a fuel farm fence while taxiing.NTSB ANC26LA036Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180A · Russellville, ARNTSB WPR26LA175Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Prineville, ORThe pilot's inability to maintain directional control during the landing roll due to a flat tire.NTSB WPR26LA174Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Big Water, UTThe pilot’s failure to maintain adequate airspeed and exceedance of the airplanes critical angle of attack while maneuvering at a low altitude, which resulted in a subsequent stall and impact with trees during stall recovery.NTSB GAA26WA195Incident · No injuriesClass 5 · ForeignPiper PA32R · Victoria, AustraliaNTSB GAA26WA185Accident · No injuriesClass 5 · ForeignVans RV10 · Carmo do Rio Verde, BrazilNTSB ERA26LA198Accident · Minor injuriesClass 3 · LimitedPreliminary reportNorth American Navion · New Salem, MAOn May 1, 2026, about 1910 eastern daylight time, a North American Navion, N8618H, was substantially damaged when it was involved in an accident near New Salem, Massachusetts. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA196Accident · No injuriesClass 3 · LimitedPreliminary reportBeech C23 · Bangor, MEOn May 01, 2026, at 1604 eastern daylight time, a Beechcraft C23 airplane, N18516, was substantially damaged when it was involved in an accident near Bangor, Maine. The private pilot and flight instructor were uninjured. The airplane was operated as a Title…NTSB ERA26LA195Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Bealeton, VAOn May 1, 2026, at 1230 eastern daylight time, an Air Tractor AT-602, N602RH, was substantially damaged when it was involved in an accident near Bealeton, Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN26FA174Accident · 5 fatalClass 3 · FieldPreliminary reportCessna 421 · Wimberley, TXOn April 30, 2026, about 2303 central daylight time, a Cessna 421C airplane, N291AN, was destroyed when it was involved in an accident near Wimberley, Texas. The private pilot and four passengers were fatally injured. The airplane was operated under the…NTSB ERA26LA194Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Chapmansboro, TNFailure of the volunteer fire department personnel to properly monitor and secure a stretcher, which resulted in it rolling into the helicopter’s tail rotor.NTSB DCA26WA204Incident · No injuriesClass 5 · ForeignBoeing 737 · São Paulo, BrazilNTSB CEN26LA175Accident · No injuriesClass 3 · LimitedPreliminary reportHiller UH-12E · Chickasha, OKOn April 30, 2026, about 1730 central daylight time, a Hiller UH-12E, N22SP, was substantially damaged when it was involved in an accident near Chickasha, Oklahoma. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ANC26LA035Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7EC · Hollis, OKNTSB ANC26LA034Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18S-150 · Palmer, AKNTSB WPR26LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Young, AZThe pilot’s failure to maintain clearance from a tree stump during landing in mountainous terrain.NTSB GAA26WA181Incident · No injuriesClass 5 · ForeignPiper PA-23-250 · Cumayasa, La Romana, Dominican RepublicNTSB GAA26WA180Incident · Minor injuriesClass 5 · ForeignCostruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican RepublicNTSB GAA26WA179Accident · 2 fatalClass 5 · ForeignDiamond DA42 · Parafield, AustraliaNTSB GAA26WA319Accident · 1 fatalClass 5 · ForeignShark Aero Shark · Oldenburg Hatten, GermanyNTSB GAA26WA196Incident · No injuriesClass 5 · ForeignRobinson R44 · Tindal, AustraliaNTSB WPR26LA170Accident · No injuriesClass 4 · LimitedFinal reportBalony Kubicek Spol Sro BB100Z · Elk Grove, CAThe pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…NTSB GAA26WA178Accident · 14 fatalClass 5 · ForeignCessna 208 · Jubasu, SudanNTSB GAA26WA175Accident · No injuriesClass 5 · ForeignCessna 140 · Región de Antofagasta, ChileNTSB ERA26LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Enterprise, ALThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.NTSB DCA26WA192IncidentClass 5 · ForeignBoeing 777 · London, United KingdomNTSB CEN26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportJust JA-30 · Hartville, MOThe pilot’s failure to maintain clearance from a power line after takeoff.NTSB WPR26LA178Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 162 · Everett, WAOn April 25, 2026, at 1026 Pacific daylight time, a Cessna 162, N162HA, sustained substantial damage when it was involved in an accident near Everett, Washington. The flight instructor and student pilot were not injured. The airplane was operated as a Title…