NTSB investigations

11,934 cases where NTSB found Performance/control parameters.

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\", '010620'))
  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 CEN25LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Baraboo, WIThe pilot’s failure to maintain directional control during landing.Jul 20, 2025 · N9623Q · Substantial damageNTSB CEN25LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lansing, MIThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing in a crosswind condition.Jul 19, 2025 · N888DK · Substantial damageNTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.Jul 18, 2025 · N288EE · Substantial damageNTSB CEN25LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Oshkosh, WIThe pilot’s aggressive brake application which resulted in a loss of directional control and a ground loop.Jul 18, 2025 · N7369K · Substantial damageNTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.Jul 17, 2025 · N237FC · Substantial damageNTSB CEN25LA257Accident · Minor injuriesClass 4 · LimitedFinal reportVan's RV-6 · New Richmond, WIThe pilot’s failure to maintain proper airspeed and altitude during the approach which resulted in a runway overshoot and subsequent landing in a lake. Contributing to the accident was the pilot’s delayed remedial action to abort the landing.Jul 17, 2025 · N69NB · Substantial damageNTSB CEN25LA256Accident · Minor injuriesClass 4 · LimitedFinal reportFarrington Twinstar · Greencastle, INThe pilot’s failure to maintain pitch control during takeoff. Contributing to the accident was the pilot’s inexperience in the accident gyroplane.Jul 16, 2025 · N45CL · Substantial damageNTSB WPR25LA215Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · North Las Vegas, NVThe failure of the pilot to set the flaps to the proper configuration for takeoff.Jul 15, 2025 · N945B · Substantial damageNTSB CEN25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Wyoming, ILThe pilot’s failure to attain a positive climb rate due to airplane’s improper takeoff configuration.Jul 15, 2025 · N647RA · Substantial damageNTSB CEN25LA254Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Russellville, INThe pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.Jul 15, 2025 · N7501A · Substantial damageNTSB WPR25LA222Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Rotorsport UK Cavalon · Hurricane, UTThe pilot’s failure to maintain pitch control during takeoff, which resulted in an unintended liftoff from the runway and a subsequent loss of control.Jul 14, 2025 · N630JM · Substantial damageNTSB ANC25LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Egegik, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.Jul 14, 2025 · N2638M · Substantial damageNTSB CEN25LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35 · Cedarcreek, MOThe student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…Jul 13, 2025 · N3181V · Substantial damageNTSB CEN25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportScott Vincin Just Acft Highlander · Mancos, COThe airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.Jul 13, 2025 · N970SV · Substantial damageNTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.Jul 13, 2025 · N88220 · Substantial damageNTSB ANC25LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dillingham, AKThe pilot’s failure to maintain direction control during takeoff roll which resulted in a ground loop, and subsequent runway excursion.Jul 12, 2025 · N82109 · Substantial damageNTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.Jul 11, 2025 · N817GD · Substantial damageNTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.Jul 11, 2025 · N209ZM · Substantial damageNTSB ANC25LA075Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.Jul 11, 2025 · N8979D · Substantial damageNTSB ANC25LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s excessive braking during the landing roll, resulting in a nose over. Contributing to the accident was the pilot’s decision to continue the landing after determining the landing area was unsuitable.Jul 11, 2025 · N27293 · Substantial damageNTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.Jul 9, 2025 · N67RW · Substantial damageNTSB CEN25LA245Accident · No injuriesClass 4 · LimitedFinal reportFairchild 24R · Greeley, COThe pilot’s inability to maintain directional control during landing due to excessive wear in the tailwheel steering assembly.Jul 9, 2025 · N81210 · Substantial damageNTSB ANC25LA070Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Homer, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.Jul 9, 2025 · N2694D · Substantial damageNTSB CEN25LA244Accident · Minor injuriesClass 4 · LimitedFinal reportCessna LC41-550FG · Lambertville, MIThe pilot’s failure to land at the manufacturer’s recommended approach speed, which resulted in a runway excursion, and impact with trees.Jul 8, 2025 · N1229V · Substantial damageNTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.Jul 8, 2025 · N29342 · Substantial damageNTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.Jul 7, 2025 · N9019D · Substantial damageNTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.Jul 7, 2025 · N952SA · Substantial damageNTSB CEN25LA246Accident · No injuriesClass 4 · LimitedFinal reportThorp T18 · Lake Elmo, MNThe pilot’s failure to maintain obstacle clearance during the go-around, that resulted in the tailwheel impacting a taxiway sign, a subsequent loss of control due to the damaged tailwheel, and a runway excursion during the landing.Jul 6, 2025 · N18CH · Substantial damageNTSB ANC25LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Kokhanok, AKThe pilot’s failure to attain a proper touchdown point during landing which resulted in a hard landing.Jul 6, 2025 · N67251 · Substantial damageNTSB CEN25LA238Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Joliet, ILThe pilot’s failure to maintain directional control during the crosswind landing.Jul 5, 2025 · N646MA · Substantial damageNTSB ERA25LA257Accident · No injuriesClass 4 · LimitedFinal reportYates Tom W Kitfox III · Greenville, KYThe pilot’s loss of control during takeoff.Jul 4, 2025 · N11TY · Substantial damageNTSB CEN25LA237Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pecos, TXThe pilot’s failure to maintain aircraft control during gusty wind conditions.Jul 4, 2025 · N992TP · Substantial damageNTSB WPR25LA202Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Henderson, NVThe pilot’s failure to maintain directional control during a go-around, resulting in a collision with a runway sign.Jul 3, 2025 · N66JG · Substantial damageNTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.Jul 3, 2025 · N508K · Substantial damageNTSB CEN25LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Meeker, COThe student pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.Jul 3, 2025 · N66898 · Substantial damageNTSB 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 damage