NTSB investigations

12,339 cases where NTSB found Aircraft oper/perf/capability.

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
  WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
  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.

NTSB 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.Jun 5, 2025 · N75FW · Substantial damageNTSB 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.Jun 5, 2025 · N755SD · Substantial damageNTSB ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.Jun 3, 2025 · N3994Z · Substantial damageNTSB CEN25LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Charlevoix, MIThe pilot’s failure to maintain pitch control during the takeoff that resulted in multiple bounces and substantial damage to the fuselage.Jun 2, 2025 · N71149 · Substantial damageNTSB CEN25LA191Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Hamlet, NEThe pilot's failure to maintain clearance from the power lines during low altitude maneuvering.Jun 2, 2025 · N60057 · Substantial damageNTSB CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.Jun 1, 2025 · N9839E · Substantial damageNTSB WPR25LA165Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620B · Lewiston, MTThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.May 30, 2025 · N90393 · Substantial damageNTSB WPR25LA164Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Tucson Estates, AZThe pilot’s improper landing flare, which resulted in a hard landing.May 29, 2025 · N6419B · Substantial damageNTSB CEN25LA190Accident · Minor injuriesClass 4 · LimitedFinal reportNelson Special · Hope, ARThe pilot’s failure to maintain airplane control during the landing roll.May 29, 2025 · N873YD · Substantial damageNTSB ANC25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Snohomish, WAThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun and collision with a fence.May 28, 2025 · N2155Q · Substantial damageNTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.May 26, 2025 · N6132G · Substantial damageNTSB ERA25LA212Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Fremont, OHThe pilot’s inadequate takeoff performance planning, which resulted in a runway overrun and collision with terrain.May 25, 2025 · N260LA · Substantial damageNTSB CEN25LA187Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Goudeau, LAThe pilot’s inadvertent encounter with soft terrain conditions during the landing which resulted in a loss of directional and a subsequent nose-over.May 23, 2025 · N216TA · Substantial damageNTSB ANC25LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Susitna, AKThe pilot’s encounter with shifting winds during landing, which resulted in a loss of airspeed and altitude, and subsequent contact with water.May 23, 2025 · N1364C · Substantial damageNTSB ANC25LA040Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · San Luis Obispo, CAThe pilot's failure to maintain directional control during takeoff.May 23, 2025 · N797CK · Substantial damageNTSB ANC25LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Trapper Creek, AKThe pilot’s improper flare while landing on glassy water, which resulted in a hard landing.May 21, 2025 · N3308S · Substantial damageNTSB WPR25LA160Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47 · Henderson, NVThe pilot’s failure to maintain directional control while landing with a quartering tailwind.May 18, 2025 · N220JP · Substantial damageNTSB ANC25LA039Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Willow, AKThe pilot's inadvertent application of brakes during landing, which resulted in a nose over.May 18, 2025 · N44473 · Substantial damageNTSB ERA25LA203Accident · Serious injuriesClass 3 · LimitedFinal reportSeamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…May 17, 2025 · N154RL · Substantial damageNTSB CEN25LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Wahoo, NEThe pilot’s failure to maintain clearance from an obstacle during taxi operations.May 16, 2025 · N2614V · Substantial damageNTSB CEN25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen-Schneider LS-6B · Hinckley, ILThe pilot’s failure to maintain control of the glider during takeoff.May 14, 2025 · N246GC · Substantial damageNTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…May 10, 2025 · N30689 · DestroyedNTSB CEN25LA174Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Saint James, MNThe failure of the left main landing gear tire casing and tube due to excessive wear which resulted in a loss of directional control during the landing.May 10, 2025 · N453MK · Substantial damageNTSB WPR25LA158Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Butte City, CAThe pilot’s use of engine beta prior to ensuring the tailwheel was on the ground during landing roll.May 9, 2025 · N7503L · Substantial damageNTSB ERA25LA198Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Sanford, NCThe mechanic’s re-use of worm drive clamps, which resulted in a separation of the turbocharger air discharge duct and a partial loss of engine power during initial climb.May 7, 2025 · N499BW · Substantial damageNTSB ERA25LA224Accident · No injuriesClass 4 · LimitedFinal reportShoemaker Ronald R Pazmany PL-2 · Reading, PAThe pilot’s failure to maintain a proper descent rate, resulting in a hard landing short of the runway and collapse of the right main landing gear.May 6, 2025 · N289RS · Substantial damageNTSB CEN25LA189Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Luverne, MNThe pilot’s improper landing flare which resulted in a hard landing.May 6, 2025 · N202FD · Substantial damageNTSB WPR25LA151Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Port of Del Bonita, MTThe pilot’s loss of directional control while landing in gusting wind conditions.May 5, 2025 · N108RM · Substantial damageNTSB CEN25LA172Accident · No injuriesClass 4 · LimitedFinal reportGolden Circle Air T-Bird · Dallas Center, IAThe pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.May 5, 2025 · N7192M · Substantial damageNTSB CEN25LA171Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · South Saint Paul, MNThe student pilot’s inadvertent brake application during the touchdown, that resulted in abnormal runway contact and a loss of directional control. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot during the…May 5, 2025 · N7951W · Substantial damageNTSB ERA25LA197Accident · No injuriesClass 4 · LimitedFinal reportArlie L Raber III Challenger 1 · Crestview, FLThe pilot’s decision to take off despite having problems controlling the airplane due to his physical stature.May 4, 2025 · N59BR · Substantial damageNTSB WPR25LA191Accident · No injuriesClass 4 · LimitedFinal reportJeremy S Lezin Just Superstol · Owyhee, ORThe pilot’s failure to maintain directional control during landing.May 3, 2025 · N40JL · Substantial damageNTSB WPR25LA150Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC19-180 · San Diego, CAThe pilot's failure to maintain directional control during landing roll.May 3, 2025 · N508XC · Substantial damageNTSB WPR25LA149Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Mojave, CAThe pilot’s exceedance of the airplane’s critical angle of attack during climb out from an aborted landing.May 2, 2025 · N538EE · Substantial damageNTSB ERA25LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Stevensville, MDThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion.Apr 30, 2025 · N771SL · Substantial damageNTSB CEN25LA167Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Bethany, OKThe pilot’s improper landing technique that allowed the helicopter’s right skid to get caught on the landing platform, which resulted in a dynamic rollover.Apr 30, 2025 · N9TV · Substantial damageNTSB WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.Apr 29, 2025 · N6310N · DestroyedNTSB WPR25LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll.Apr 28, 2025 · N4505R · Substantial damageNTSB WPR25LA144Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26B · Ontario, ORThe pilot's exceedance of the airplane's critical angle of attack during the final approach to land, which resulted in an aerodynamic stall and impact with terrain.Apr 26, 2025 · N8657R · Substantial damageNTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.Apr 25, 2025 · N415DG · Substantial damageNTSB CEN25LA163Accident · Serious injuriesClass 4 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hartford, ILThe pilot’s failure to maintain directional control during the initial climb at night from a confined area landing zone, that resulted in an impact with a tree, a loss of control, and a subsequent impact with terrain.Apr 25, 2025 · N880SL · Substantial damageNTSB ANC25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · North Pole, AKThe pilot's failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. Contributing to the accident was his impairment from the effects of alcohol consumption.Apr 25, 2025 · N9308K · Substantial damageNTSB ERA25LA184Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Zolfo Springs, FLThe pilot’s failure to maintain control of the airplane during the takeoff. Contributing was the flight instructor’s lack of remedial action.Apr 23, 2025 · N28311 · DestroyedNTSB WPR25LA139Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Oakland, CAThe pilot’s failure to maintain airplane control during takeoff with a left quartering crosswind.Apr 20, 2025 · N22QT · Substantial damageNTSB WPR25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Placerville, CAThe pilot’s failure to maintain directional control while landing with a crosswind.Apr 19, 2025 · N6682S · Substantial damageNTSB WPR25LA138Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.Apr 19, 2025 · N5786S · Substantial damageNTSB CEN25LA161Accident · No injuriesClass 4 · LimitedFinal reportChampion Aeronca 7AC · Estherwood, LAThe non-certificated pilot’s failure to maintain altitude while maneuvering at low altitude that resulted in a descent and impact into terrain.Apr 19, 2025 · N83871 · Substantial damageNTSB WPR25LA141Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Placerville, CAThe pilot’s failure to maintain directional control during the landing roll.Apr 18, 2025 · N1286B · Substantial damageNTSB ERA25LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Oxford, METhe flight instructor’s failure to maintain directional control during the landing roll in gusty crosswind conditions.Apr 18, 2025 · N2607V · Substantial damageNTSB ERA25LA183Accident · Serious injuriesClass 4 · LimitedFinal reportFrank Lowell C Pietenpol · Taylorsville, NCThe pilot’s failure to maintain control of the airplane during an attempted go around in gusty tailwind conditions, which resulted in an aerodynamic stall and impact with terrain.Apr 18, 2025 · N497AR · Substantial damage