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 ANC25LA067Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 690B · Fairbanks, AKThe pilot’s failure to maintain control during takeoff resulting in a gear-up landing on the runway. Contributing to the accident was the pilot’s momentary distraction from within the airplane.Jul 3, 2025 · N690AX · Substantial damageNTSB ERA25LA255Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer 269C · Madisonville, KYThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.Jul 2, 2025 · N21385 · Substantial damageNTSB DCA25LA251Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Las Vegas, NVThe first officer’s failure to maintain proper pitch attitude during flare which resulted in a bounced landing and a tailstrike.Jul 2, 2025 · N66831 · Substantial damageNTSB CEN25LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Brush, COThe pilot’s failure to maintain directional control while performing a touch and go landing.Jul 2, 2025 · N7635H · Substantial damageNTSB ANC25LA062Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · Wasilla, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.Jul 2, 2025 · N5169X · Substantial damageNTSB CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.Jul 1, 2025 · N8834H · Substantial damageNTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.Jun 30, 2025 · N124GH · Substantial damageNTSB WPR25LA199Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Tukwila, WAThe pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.Jun 30, 2025 · N23UP · Substantial damageNTSB WPR25LA194Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Helena, MTThe pilot’s failure to maintain directional control of the airplane during landing.Jun 30, 2025 · N50476 · Substantial damageNTSB CEN25LA228Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Ben Bolt, TXThe pilot’s failure to maintain directional control while landing with a crosswind.Jun 30, 2025 · N5287S · Substantial damageNTSB ERA25LA252Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Pelzer, SCThe pilot’s failure to maintain proper airspeed while landing on a short, down-sloping turf runway, which resulted in a noseover.Jun 29, 2025 · N150TP · Substantial damageNTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.Jun 29, 2025 · N9420Y · Substantial damageNTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.Jun 28, 2025 · N6759K · Substantial damageNTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.Jun 28, 2025 · N1591V · Substantial damageNTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.Jun 28, 2025 · N55PT · Substantial damageNTSB ERA25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Mount Gilead, OHThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.Jun 26, 2025 · N3619J · Substantial damageNTSB ERA25LA241Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Burlington, VTThe pilot’s failure to maintain control of the airplane on landing.Jun 26, 2025 · N17N · Substantial damageNTSB CEN25LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Sweetwater, TXThe pilot’s failure to maintain directional control while landing with a crosswind.Jun 26, 2025 · N2300A · Substantial damageNTSB WPR25LA189Accident · No injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · San Luis, AZThe pilot receiving instruction’s failure to properly recover the helicopter during an autorotative landing and the instructor pilot’s failure to intervene, which resulted in a hard landing.Jun 25, 2025 · N3951A · Substantial damageNTSB CEN25LA223Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Unionville, MOThe pilot’s failure to maintain airplane control during a go-around.Jun 25, 2025 · N670P · DestroyedNTSB ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.Jun 25, 2025 · N97438 · Substantial damageNTSB WPR25LA196Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Pendleton, ORThe pilot’s failure to maintain directional control during landing, in gusting crosswind conditions.Jun 24, 2025 · N2051U · Substantial damageNTSB ERA25LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Calera, ALA loss of control during landing.Jun 24, 2025 · N34655 · Substantial damageNTSB CEN25LA221Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Pierre, SDThe pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.Jun 24, 2025 · N107ML · Substantial damageNTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.Jun 23, 2025 · N62XF · Substantial damageNTSB ERA25LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Milton, FLSeparation of the throttle cable sleeve during takeoff, which resulted an uncommanded engine power reduction and the pilot’s inability to control the engine throttle, and resulted in a forced landing.Jun 23, 2025 · N262AL · Substantial damageNTSB ANC25LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna P206C · Port Graham, AKThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a tail strike. Contributing to the accident was the pilot’s failure to initiate a go around after the abnormal runway contact.Jun 23, 2025 · N8630Z · Substantial damageNTSB CEN25LA213Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC130 · Clay Township, MIThe pilot’s failure to maintain control of the helicopter during landing.Jun 22, 2025 · C-GPVB · Substantial damageNTSB CEN25LA227Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob G-103A Twin II Acro · Midlothian, TXThe student pilot’s improper landing flare, which resulted in a hard landing.Jun 21, 2025 · N852BG · Substantial damageNTSB WPR25LA185Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8A · San Andreas, CAThe pilot’s loss of directional control during landing roll following an encounter with a dust devil.Jun 20, 2025 · N28545 · Substantial damageNTSB WPR25LA187Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Kayenta, AZThe pilots’ failure to maintain airplane control during takeoff in gusting crosswind conditions, which resulted in a runway excursion.Jun 19, 2025 · N454CT · Substantial damageNTSB ERA25FA230Accident · 2 fatalClass 3 · FieldFinal reportMooney M20F · Beverly, MAThe pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…Jun 19, 2025 · N9573M · Substantial damageNTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.Jun 19, 2025 · N6174A · Substantial damageNTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.Jun 19, 2025 · N7299Q · Substantial damageNTSB WPR25LA186Accident · No injuriesClass 4 · LimitedFinal reportKohut Mark A Murphy SR 2500 · Challis, IDThe pilot’s failure to maintain directional control during the landing roll.Jun 18, 2025 · N6161C · Substantial damageNTSB CEN25LA211Accident · No injuriesClass 4 · LimitedFinal reportCessna U206 · Falun, WIThe pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.Jun 18, 2025 · N932DB · Substantial damageNTSB WPR25LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Heber City, UTThe student pilot’s improper recovery from a bounced landing, which resulted in a nose over.Jun 17, 2025 · N6349S · Substantial damageNTSB CEN25LA209Accident · No injuriesClass 4 · LimitedFinal reportVans RV-14 · Sealy, TXThe pilot’s improper use of airplane’s wheel brakes during the landing roll-out.Jun 17, 2025 · N852BJ · Substantial damageNTSB CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…Jun 16, 2025 · N1UC · Substantial damageNTSB WPR25LA172Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Spokane Valley, WAThe pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.Jun 15, 2025 · N6848 · Substantial damageNTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.Jun 15, 2025 · N1996C · Substantial damageNTSB ANC25LA051Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s failure to maintain clearance from trees during a go-around with a tailwind.Jun 14, 2025 · N3846M · Substantial damageNTSB WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.Jun 13, 2025 · N9550K · Substantial damageNTSB ANC25LA053Accident · No injuriesClass 4 · LimitedFinal reportFrederick Joseph Shiple Kitfox SS7 · Yellow Pine, IDThe pilot's excessive application of the airplane’s wheel brakes during the landing roll, which resulted in a nose over.Jun 13, 2025 · N84FS · Substantial damageNTSB WPR25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen Schneider LS-7WL · Tonasket, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.Jun 11, 2025 · N78AW · Substantial damageNTSB ANC25LA047Accident · No injuriesClass 4 · LimitedFinal reportBrian Peck RV-14 · Camas, WAThe pilot’s failure to maintain directional control during landing roll which resulted in a runway excursion.Jun 10, 2025 · N991RS · Substantial damageNTSB ANC25LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Flagstaff, AZThe pilot’s failure to maintain directional control during takeoff in variable and gusty wind, which resulted in a ground loop.Jun 8, 2025 · N605NB · Substantial damageNTSB ANC25LA048Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Mojave, CAThe pilot’s failure to maintain directional control during landing roll.Jun 8, 2025 · N724SC · Substantial damageNTSB ERA25LA374Accident · No injuriesClass 4 · LimitedFinal reportFlying Cloud AL18 · Ridgeland, SCThe pilot’s failure to maintain directional control of the airplane during landing.Jun 7, 2025 · N859SS · Substantial damageNTSB CEN25LA204Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Pembine, WIThe pilot’s improper flare during landing which resulted in a bounced landing.Jun 6, 2025 · N499CT · Substantial damage