NTSB investigations

13,694 cases where NTSB found Task performance.

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\", '0206'))
  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 CEN25LA325Accident · No injuriesClass 4 · LimitedFinal reportHelio H-391B · Monroe, MIThe pilot’s failure to maintain directional control during the landing roll with a crosswind.Aug 18, 2025 · N4431U · Substantial damageNTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.Aug 18, 2025 · N4387Z · Substantial damageNTSB ERA25LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Baltimore, MDThe pilot’s inadequate landing flare at night, which resulted in a hard landing.Aug 17, 2025 · N6208C · Substantial damageNTSB ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.Aug 16, 2025 · N99KG · Substantial damageNTSB GAA25WA241Accident · No injuriesClass 5 · ForeignMooney M20M · Innsbruck, AustriaAug 13, 2025 · N42FA · Substantial damageNTSB ERA25LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fordsville, KYThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a subsequent forced landing.Aug 13, 2025 · N9400U · Substantial damageNTSB CEN25LA324Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Cleburne, TXThe student pilot’s failure to maintain airplane directional control during the approach and subsequent go-around.Aug 13, 2025 · N654CD · Substantial damageNTSB WPR25LA251Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Kalispell, MTThe pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.Aug 11, 2025 · N860CA · DestroyedNTSB WPR25LA246Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Fobes Hill, WAThe pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.Aug 11, 2025 · N703WA · Substantial damageNTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…Aug 10, 2025 · N801RA · Substantial damageNTSB ERA25LA296Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Muskeget Island, MAThe pilot’s failure to obtain a proper touchdown point while attempting to land on a very short and rough turf runway, which resulted in a runway overrun and collision with vegetation and terrain.Aug 10, 2025 · N1052T · Substantial damageNTSB CEN25LA314Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Goodland, KSThe pilot’s failure to maintain aircraft control during the landing and go-around with variable wind direction and speed.Aug 10, 2025 · N502WF · Substantial damageNTSB CEN25LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Lowell, MIThe pilot’s failure to extend the landing gear before landing.Aug 9, 2025 · N861T · Substantial damageNTSB WPR25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Ronan, MTThe student pilot's inadequate landing flare and recovery from a bounced landing.Aug 8, 2025 · N734SW · Substantial damageNTSB ERA25LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pottstown, PAThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the engine mounts.Aug 8, 2025 · N69200 · Substantial damageNTSB ERA25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rangeley, METhe pilot’s failure to maintain control of the airplane during landing, which resulted in a runway excursion and subsequent nose over.Aug 8, 2025 · N89351 · Substantial damageNTSB ERA25LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Memphis, TNFailure of the left main landing gear due to the loss of the protective paint coating and a change in the local surface finish from impermissible grinding, which resulted in fatigue cracking.Aug 8, 2025 · N1950C · Substantial damageNTSB CEN25FA307Accident · 2 fatalClass 3 · FieldFinal reportHughes 369D · West Alton, MOThe pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.Aug 7, 2025 · N173AL · DestroyedNTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.Aug 6, 2025 · N500HT · Substantial damageNTSB CEN25LA311Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Monee, ILThe student pilot’s failure to maintain airspeed and altitude resulting in a collision with the ground during the base to final turn.Aug 6, 2025 · N65818 · Substantial damageNTSB ANC25LA106Accident · No injuriesClass 4 · LimitedFinal reportBrian Turner Northern Explorer · Delta Junction, AKThe pilot’s failure to maintain obstacle clearance during landing, which resulted in an impact with trees.Aug 6, 2025 · N907BT · Substantial damageNTSB WPR25LA239Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ponderosa Pines, MTThe pilot’s improper pedal application during an approach to a hover.Aug 3, 2025 · N750GT · Substantial damageNTSB CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.Aug 3, 2025 · N3157B · Substantial damageNTSB CEN25LA302Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Taylor, TXThe flight instructor’s inadequate supervision and delayed remedial action which resulted in a skid contacting the terrain. Contributing to the accident was the flight instructor’s improper judgement to allow the student pilot to manipulate the flight…Aug 3, 2025 · N4684S · Substantial damageNTSB ANC25LA083Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Chisana, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.Aug 2, 2025 · N900HY · Substantial damageNTSB ANC25LA082Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Yakutat, AKThe pilot’s failure to maintain clearance during approach in gusting wind conditions to a remote airstrip, resulting in a collision with brush.Aug 2, 2025 · N206GR · Substantial damageNTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.Aug 1, 2025 · N52175 · Substantial damageNTSB ANC25LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Anchorage, AKThe pilot’s decision to continue an unstabilized approach, which resulted in a landing touchdown with insufficient runway remaining and a subsequent runway overrun and a collision with a fence.Aug 1, 2025 · N645AT · Substantial damageNTSB WPR25LA242Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moriarty, NMThe pilot’s improper landing flare, which resulted in a hard landing.Jul 31, 2025 · N50778 · Substantial damageNTSB WPR25LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Thermal, CAThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.Jul 31, 2025 · N2658C · Substantial damageNTSB WPR25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Cashmere, WAThe pilot’s failure to maintain clearance from obstacles during an aborted landing, while flying in tailwind conditions. Contributing to the accident was the high density altitude weather condition.Jul 31, 2025 · N759NB · Substantial damageNTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.Jul 31, 2025 · N1244G · Substantial damageNTSB WPR25LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Inhama, ORThe pilot’s failure to maintain clearance from trees while taxiing, which resulted in a wing strike.Jul 28, 2025 · N71879 · Substantial damageNTSB WPR25LA229Accident · No injuriesClass 4 · LimitedFinal reportLake Tahoe Properties CA 8 · Davenport, WAThe pilot's failure to maintain directional control during the landing roll.Jul 28, 2025 · N66LT · Substantial damageNTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.Jul 27, 2025 · N42725 · DestroyedNTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.Jul 26, 2025 · N594BA · Substantial damageNTSB CEN25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31T3 · Appleton, WIThe pilot’s failure to maintain control of the airplane on the ground, which resulted in a collision with a parked airplane.Jul 26, 2025 · N401VA · Substantial damageNTSB CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.Jul 25, 2025 · N756XY · Substantial damageNTSB ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 25, 2025 · N29110 · Substantial damageNTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.Jul 24, 2025 · N5204C · Substantial damageNTSB CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…Jul 23, 2025 · N35025 · Substantial damageNTSB CEN25LA284Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Hudson, MIThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action during landing that resulted in a loss of control and impact with terrain.Jul 23, 2025 · N1812J · Substantial damageNTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.Jul 22, 2025 · N422K · Substantial damageNTSB CEN25LA290Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Lansing, ILThe pilot's failure to extend the landing gear before landing due to his distraction of other traffic and failure to follow his landing procedures.Jul 22, 2025 · N737HN · Substantial damageNTSB CEN25LA279Accident · No injuriesClass 4 · LimitedFinal reportDyke Delta JD-2 · Oshkosh, WIThe pilot’s failure to maintain control of the airplane while landing with a tailwind.Jul 22, 2025 · N71AW · Substantial damageNTSB CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.Jul 22, 2025 · N502KB · Substantial damageNTSB ERA25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Juan, PRThe student pilot’s excessing pitch attitude during takeoff, which resulted in a loss of aircraft control and aerodynamic stall.Jul 21, 2025 · N4187U · Substantial damageNTSB ERA25LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna TP206C · Versailles, KYThe pilot’s mismanagement of the airplane’s available fuel supply, which resulted in fuel starvation and a subsequent total loss of engine power.Jul 21, 2025 · N8670Z · Substantial damageNTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.Jul 20, 2025 · N3443C · Substantial damageNTSB CEN25LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Baraboo, WIThe pilot’s failure to maintain directional control during landing.Jul 20, 2025 · N9623Q · Substantial damage