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 ERA25LA342Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Dover, DEThe pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.Sep 9, 2025 · N8483K · Substantial damageNTSB CEN25LA372Accident · No injuriesClass 4 · LimitedFinal reportCessna 182T · Seymour, INThe flight instructor’s improper landing flare which resulted in a bounced landing and loss of control.Sep 9, 2025 · N357CP · Substantial damageNTSB ANC25LA104Accident · No injuriesClass 4 · LimitedFinal reportJeremy Price Smith Super CUB · Chisana, AKThe pilot’s failure to maintain directional control during the takeoff roll.Sep 8, 2025 · N9930D · Substantial damageNTSB CEN25LA401Accident · No injuriesClass 3 · LimitedFinal reportCubCrafters CCK-2000 · Thompsonville, MIA total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…Sep 7, 2025 · N40DT · Substantial damageNTSB CEN25LA369Accident · Minor injuriesClass 4 · LimitedFinal reportZodiac CH 650B · Sturgis, MIThe pilot’s failure to maintain control while landing.Sep 7, 2025 · N22LZ · Substantial damageNTSB ERA25LA336Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Ridgeland, SCThe pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.Sep 6, 2025 · N231LS · Substantial damageNTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.Sep 6, 2025 · N560RT · Substantial damageNTSB ANC25LA102Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Unalakleet, AKThe pilots encounter with an obstructed dip in the landing surface during the landing roll out on a remote airstrip, which resulted in a noseover.Sep 5, 2025 · N242BC · Substantial damageNTSB WPR25LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Reno, NVThe pilot's failure to maintain directional control while transitioning from the landing roll to taxi, which resulted in a ground loop.Sep 3, 2025 · N4603B · Substantial damageNTSB ERA25LA381Accident · No injuriesClass 4 · LimitedFinal reportPitts S-1T · Danbury, CTThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.Sep 2, 2025 · N742MA · Substantial damageNTSB ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.Sep 2, 2025 · N9884B · Substantial damageNTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.Sep 2, 2025 · N26RJ · Substantial damageNTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.Sep 1, 2025 · N3576D · Substantial damageNTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.Sep 1, 2025 · N36RP · Substantial damageNTSB ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.Aug 31, 2025 · N628FN · Substantial damageNTSB CEN25LA359Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Nashville, ARThe pilot’s inadequate fuel planning which resulted in a total loss of power due to fuel exhaustion. Contributing to the accident was the landing zone being unlit.Aug 31, 2025 · N442PR · Substantial damageNTSB ANC25LA115Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Kanab, UTThe pilot’s improper landing flare, which resulted in a hard landing.Aug 30, 2025 · N71331 · Substantial damageNTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.Aug 29, 2025 · N1607F · Substantial damageNTSB ANC25LA099Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Petersville, AKThe pilot’s exceedance of the helicopter’s available power while landing in a remote confined area, which resulted in rotor droop and a hard landing.Aug 29, 2025 · N74435 · Substantial damageNTSB DCA25LA306Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-212 · Chase City, VAThe abrupt maneuver required to comply with a traffic alert and collision avoidance system resolution advisory during descent.Aug 28, 2025 · N373NW · No damageNTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.Aug 28, 2025 · N5181A · Substantial damageNTSB WPR25LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Everett, WAThe pilot’s failure to maintain directional control during landing in crosswind conditions.Aug 27, 2025 · N1755D · Substantial damageNTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.Aug 27, 2025 · N88SP · Substantial damageNTSB CEN25LA381Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe manufacturer flight instructor’s failure to maintain proper airspeed and a proper descent rate during a demonstrated hover out of ground effect (HOGE) autorotation, which resulted in a hard landing. Contributing to the accident was the manufacturer flight…Aug 27, 2025 · N505GR · Substantial damageNTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.Aug 27, 2025 · N92356 · Substantial damageNTSB CEN25LA406Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Beaman, IAThe pilot’s failure to maintain a proper glidepath during landing which resulted in a landing short of the runway.Aug 26, 2025 · N393KW · Substantial damageNTSB CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.Aug 26, 2025 · N655D · Substantial damageNTSB CEN25LA345Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12IS · Hartford, WIThe student pilot’s failure to maintain airplane control while landing on a turf runway.Aug 26, 2025 · N18HS · Substantial damageNTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.Aug 25, 2025 · N4584C · Substantial damageNTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Aug 24, 2025 · N376CD · Substantial damageNTSB CEN25LA340Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.Aug 24, 2025 · N424BG · Substantial damageNTSB WPR25LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.Aug 23, 2025 · N185GG · Substantial damageNTSB ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.Aug 23, 2025 · N170JL · Substantial damageNTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.Aug 23, 2025 · N2589V · Substantial damageNTSB CEN25LA337Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Caseville, MIThe front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.Aug 23, 2025 · N707EE · Substantial damageNTSB ANC25LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot receiving instruction’s failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.Aug 23, 2025 · N7050K · Substantial damageNTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.Aug 22, 2025 · N2460A · Substantial damageNTSB CEN25LA338Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fargo, NDThe pilot’s failure to maintain directional control during landing with a gusting crosswind. Contributing to the accident was the closure of the wind aligned runway 27.Aug 22, 2025 · N561RT · Substantial damageNTSB CEN25LA334Accident · No injuriesClass 4 · LimitedFinal reportKaman Aerospace K-1200 · Eagle, COThe pilot’s failure to maintain helicopter control which resulted in an uncontrolled descent and impact with terrain.Aug 22, 2025 · N171PL · Substantial damageNTSB CEN25LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Air Force Academy, COThe student pilot’s failure to perform an adequate preflight inspection.Aug 21, 2025 · N1401E · Substantial damageNTSB ANC25LA095Accident · No injuriesClass 4 · LimitedFinal reportHelio H-395 · Pilot Point, AKThe pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.Aug 21, 2025 · N44344 · Substantial damageNTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.Aug 20, 2025 · N8313N · Substantial damageNTSB ERA25LA315Accident · Serious injuriesClass 4 · LimitedFinal reportPatriot CX1900A · Centreville, ALThe pilot’s failure to detect and remove water contamination from the airplane’s fuel system before the flight, which resulted in a total loss of engine power during initial climb.Aug 20, 2025 · N150SP · Substantial damageNTSB CEN25LA331Accident · Minor injuriesClass 4 · LimitedFinal reportElmwood Christavia · South Saint Paul, MNThe pilot’s failure to maintain airplane control during the landing roll. Contributing to the accident was the pilot’s decision to land the airplane on a non-approved landing surface.Aug 20, 2025 · N383JA · Substantial damageNTSB CEN25LA330Accident · Minor injuriesClass 4 · LimitedFinal reportEXP Supercub · Grove, OKThe pilot’s failure to maintain elevator control during the landing, which resulted in a nose over.Aug 20, 2025 · N633JC · Substantial damageNTSB WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.Aug 19, 2025 · N20490 · Substantial damageNTSB WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.Aug 19, 2025 · N14GC · Substantial damageNTSB ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.Aug 19, 2025 · N691DM · Substantial damageNTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.Aug 19, 2025 · N4721U · Substantial damageNTSB CEN25LA329Accident · No injuriesClass 4 · LimitedFinal reportJMB Aircraft S R O VL-3LSA-912 · Erie, COThe flight instructors inadequate supervision of the flight and delayed remedial action and the pilot’s improper landing flare during which resulted in a hard landing.Aug 18, 2025 · N593TT · Substantial damage