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 ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.Mar 6, 2025 · N744SM · Substantial damageNTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.Mar 5, 2025 · N3341V · Substantial damageNTSB CEN25LA109Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · San Antonio, TXThe pilot’s failure to maintain directional control during a gusty crosswind landing.Mar 4, 2025 · N524HJ · Substantial damageNTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.Mar 2, 2025 · N6999 · Substantial damageNTSB ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.Feb 28, 2025 · N3080N · Substantial damageNTSB WPR25LA106Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Heber City, UTThe pilot’s loss of directional control during landing, which resulted in a collision with a snowbank.Feb 27, 2025 · N345HU · Substantial damageNTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.Feb 26, 2025 · N849DB · Substantial damageNTSB CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.Feb 24, 2025 · N34284 · Substantial damageNTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.Feb 23, 2025 · N2480D · Substantial damageNTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.Feb 23, 2025 · N321TB · Substantial damageNTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.Feb 23, 2025 · N40DJ · Substantial damageNTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.Feb 22, 2025 · N4191T · Substantial damageNTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.Feb 20, 2025 · N726ER · Substantial damageNTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.Feb 20, 2025 · N7792A · Substantial damageNTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.Feb 20, 2025 · N118LG · Substantial damageNTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…Feb 20, 2025 · N1609Y · Substantial damageNTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.Feb 20, 2025 · N19867 · Substantial damageNTSB WPR25LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxnard, CAThe student pilot’s failure to maintain directional control during landing roll.Feb 18, 2025 · N3901L · Substantial damageNTSB CEN25LA098Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Cookville, MOThe pilot’s failure to maintain adequate clearance from a tree during the low altitude operation.Feb 16, 2025 · N6100N · Substantial damageNTSB ERA25LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Culpeper, VAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll, resulting in a runway excursion.Feb 15, 2025 · N373AM · Substantial damageNTSB ERA25LA115Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Hampton, NHThe pilot’s failure to maintain adequate airspeed while maneuvering to land, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.Feb 11, 2025 · N77989 · Substantial damageNTSB WPR25LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Auburn, CAThe pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.Feb 9, 2025 · N92467 · Substantial damageNTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.Feb 9, 2025 · N84048 · Substantial damageNTSB WPR25LA107Accident · No injuriesClass 4 · LimitedFinal reportCessna T207A · Tusayan, AZAn encounter with wind gusts, which resulted in a loss of control and a collapse of the nose landing gear.Feb 7, 2025 · N9317M · Substantial damageNTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.Feb 6, 2025 · N798SP · Substantial damageNTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.Feb 6, 2025 · N73081 · Substantial damageNTSB ANC25MA018Accident · 10 fatalClass 1 · MajorFinal reportTextron 208B · Nome, AKThe National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…Feb 6, 2025 · N321BA · DestroyedNTSB ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.Feb 5, 2025 · N811WJ · Substantial damageNTSB WPR25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportLockheed C-130A · Daggett, CAAn inflight upset due to an improperly secured load that resulted in serious injuries.Feb 1, 2025 · N466TM · No damageNTSB WPR25LA087Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Upland, CAThe pilot’s failure to maintain adequate separation during landing, which resulted in a runway collision with another airplane.Feb 1, 2025 · N79LC · 2 aircraft · Substantial damageNTSB ERA25LA108Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Ravenswood, WVThe pilot’s distraction during taxi, which resulted in a taxiway excursion.Jan 30, 2025 · N74608 · Substantial damageNTSB WPR25LA085Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Santa Barbara, CAAn undetermined flap system anomaly that resulted in an irreversible right bank and rendered the airplane uncontrollable.Jan 29, 2025 · N124LZ · DestroyedNTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.Jan 29, 2025 · N1159K · Substantial damageNTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.Jan 27, 2025 · N51387 · Substantial damageNTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.Jan 24, 2025 · N730CS · Substantial damageNTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.Jan 20, 2025 · N8997W · Substantial damageNTSB ERA25LA098Accident · Minor injuriesClass 3 · LimitedFinal reportMontaer Ltda MC01 · Miramar, FLThe pilot’s delay in recognizing and acting upon the airplane’s reduced takeoff performance.Jan 19, 2025 · N916VS · Substantial damageNTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.Jan 17, 2025 · N21254 · Substantial damageNTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.Jan 14, 2025 · N6255N · DestroyedNTSB ERA25LA099Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Wilmington, NCThe pilot’s improper landing flare, which resulted in a wing strike.Jan 14, 2025 · N417KG · Substantial damageNTSB CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.Jan 12, 2025 · N8569V · Substantial damageNTSB DCA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Atlanta, GASubstantial injury to a passenger sustained during evacuation.Jan 10, 2025 · N589NW · Minor damageNTSB ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.Jan 9, 2025 · N4942G · Substantial damageNTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.Jan 8, 2025 · N430JM · Substantial damageNTSB WPR25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Red Rock, MTThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with deep snow and vegetation.Jan 6, 2025 · N4644Y · Substantial damageNTSB CEN25LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · McKinney, TXThe flight instructor’s inadequate supervision and delayed remedial action and the student pilot’s failure to maintain a proper landing flare, which resulted in a nose down impact with the runway.Jan 4, 2025 · N3589L · Substantial damageNTSB ANC25LA015Accident · No injuriesClass 4 · LimitedFinal reportGippsaero PTY GA8 · Nightmute, AKThe pilot’s loss of directional control while taxiing in gusting wind conditions.Jan 4, 2025 · N916RK · Substantial damageNTSB CEN25LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lubbock, TXThe loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees.Jan 3, 2025 · N725DC · DestroyedNTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.Dec 31, 2024 · N441HQ · Substantial damageNTSB ANC25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Anchorage, AKThe student pilot’s failure to maintain directional control of the airplane during touch-and-go operations on an ice-covered runway during her first solo flight.Dec 31, 2024 · N3552E · Substantial damage