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 CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.May 20, 2026 · N32F · Substantial damageNTSB CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.May 20, 2026 · N2307V · Substantial damageNTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.May 18, 2026 · N2479C · Substantial damageNTSB ERA26LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Statesville, NCThe pilot’s failure to extend the landing gear prior to landing.May 18, 2026 · N177BT · Substantial damageNTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.May 18, 2026 · N5114Z · Substantial damageNTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.May 16, 2026 · N252LM · Substantial damageNTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.May 14, 2026 · N9158L · Substantial damageNTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.May 14, 2026 · N952SF · Substantial damageNTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.May 13, 2026 · N40CT · Substantial damageNTSB CEN26LA188Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Corpus Christi, TXThe pilot's failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.May 13, 2026 · N6915Z · Substantial damageNTSB CEN26LA185Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Dallas, TXThe pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.May 13, 2026 · N652AE · Substantial damageNTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.May 12, 2026 · N5832L · Substantial damageNTSB CEN26LA183Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Bennett, COThe pilot’s improper flare during landing that resulted in a hard landing.May 11, 2026 · N1355S · Substantial damageNTSB 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.May 9, 2026 · N8092S · Substantial damageNTSB CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.May 9, 2026 · N55732 · Substantial damageNTSB 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.May 7, 2026 · N912Z · Substantial damageNTSB 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.May 7, 2026 · N926ES · Substantial damageNTSB 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.May 3, 2026 · N2904R · Substantial damageNTSB 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.May 2, 2026 · N145W · Substantial damageNTSB 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.May 1, 2026 · N400KB · Substantial damageNTSB WPR26LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Young, AZThe pilot’s failure to maintain clearance from a tree stump during landing in mountainous terrain.Apr 29, 2026 · N407BB · Substantial damageNTSB 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.Apr 26, 2026 · N8432Y · Substantial damageNTSB WPR26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Redding, CAThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the before landing checklist.Apr 25, 2026 · N6130F · Substantial damageNTSB ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.Apr 24, 2026 · N99467 · Substantial damageNTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.Apr 23, 2026 · N41S · Substantial damageNTSB ANC26LA031Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Lapeer, MIThe flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…Apr 23, 2026 · N44690 · Substantial damageNTSB WPR26LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Carlsbad, CAThe student pilot’s failure to maintain airplane control while landing in gusting crosswind conditions.Apr 22, 2026 · N733WT · Substantial damageNTSB ERA26LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Lanett, ALThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a runway excursion and collision with taxiway sign.Apr 22, 2026 · N5958W · Substantial damageNTSB ANC26LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.Apr 22, 2026 · N4136E · Substantial damageNTSB CEN26LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sherman, TXThe pilot's failure to maintain airplane control during recovery from a bounced landing.Apr 21, 2026 · N269JJ · Substantial damageNTSB ANC26LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Centennial, COThe student pilot’s failure to maintain adequate airspeed during the flare which resulted in the airplane exceeding its critical angle of attack and aerodynamic stall at a low altitude and loss of airplane control.Apr 19, 2026 · N53265 · Substantial damageNTSB WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.Apr 18, 2026 · N143AW · Substantial damageNTSB WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.Apr 17, 2026 · N7541B · Substantial damageNTSB ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.Apr 17, 2026 · N621CM · Substantial damageNTSB CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.Apr 17, 2026 · N9262Y · Substantial damageNTSB CEN26LA168Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mount Blanco, TXThe pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.Apr 17, 2026 · N445JS · Substantial damageNTSB CEN26LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Topeka, KSThe student pilot’s failure to maintain situational awareness while taxiing which resulted in a collision with fence poles on either side of a gate which was not intended for airplanes.Apr 17, 2026 · N84794 · Substantial damageNTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.Apr 14, 2026 · N495LP · Substantial damageNTSB WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.Apr 13, 2026 · N285AH · Substantial damageNTSB ERA26LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · The Rock, GAThe pilot’s improper landing flare, which resulted in a hard, porpoised landing.Apr 13, 2026 · N63405 · Substantial damageNTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.Apr 12, 2026 · N759AP · Substantial damageNTSB ERA26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Naples, FLThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Apr 12, 2026 · N6586S · Substantial damageNTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.Apr 11, 2026 · N314JP · Substantial damageNTSB WPR26LA156Accident · No injuriesClass 4 · LimitedFinal reportMarshall Daniel R L-21 · Cody, WYThe pilot's failure to maintain control of the airplane during the landing rollout, which resulted in a nose-over.Apr 10, 2026 · N453HC · Substantial damageNTSB ANC26LA025Accident · No injuriesClass 4 · LimitedFinal reportAvid Avid Flyer · Anchorage, AKThe pilot’s failure to maintain directional control while maneuvering onto the runway for takeoff. Contributing to the accident was the presence of heavy, wet snow adjacent to the runway.Apr 9, 2026 · N394BJ · Substantial damageNTSB CEN26LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tahlequah, OKThe student pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.Apr 6, 2026 · N1203F · Substantial damageNTSB WPR26LA146Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Chimney Rock, MTThe pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.Apr 4, 2026 · N5017G · Substantial damageNTSB CEN26LA163Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Wichita, KSThe flight crew’s failure to ensure that the rear cargo door was properly latched before flight.Apr 3, 2026 · N411CV · Substantial damageNTSB CEN26LA158Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Luverne, MNThe pilot’s failure to maintain directional control during a gusting crosswind landing, and the flight instructor’s delayed remedial action.Apr 3, 2026 · N430RP · Substantial damageNTSB CEN26LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.Apr 1, 2026 · N6569M · Substantial damage