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 CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.Dec 28, 2024 · N719LB · Substantial damageNTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…Dec 27, 2024 · N753MB · Substantial damageNTSB ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.Dec 25, 2024 · N6665K · Substantial damageNTSB ANC25LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s improper airspeed management which resulted in a bounced landing and insufficient airspeed to perform a go around procedure.Dec 25, 2024 · N3802Z · Substantial damageNTSB WPR25LA068Accident · No injuriesClass 4 · LimitedFinal reportRemos Remos G-3/600 · Brawley, CAThe flight instructor’s lack of remedial action to the student pilot’s inadequate landing flare, which resulted in a hard landing and a loss of directional control.Dec 22, 2024 · N191DY · Substantial damageNTSB CEN25LA063Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Springfield, MOThe student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.Dec 21, 2024 · N3104U · DestroyedNTSB WPR25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201T · Placerville, CAThe pilot’s failure to maintain an adequate descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.Dec 20, 2024 · N29247 · Substantial damageNTSB ERA25LA081Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Lakewood, NJThe pilot’s delay in performing a go-around, which resulted in a collision with trees at the end of the runway.Dec 19, 2024 · N12194 · Substantial damageNTSB CEN25LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCapella FW1C50 · Ozark, MOThe pilot’s failure to maintain aircraft control during high-speed taxi.Dec 15, 2024 · N556CF · Substantial damageNTSB ERA25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Englishtown, NJThe high wing airplane flight crew’s failure to maintain directional control while taxiing, which resulted in a collision with the stationary low wing airplane.Dec 14, 2024 · N9137H · 2 aircraft · Substantial damageNTSB WPR25LA061Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Gig Harbor, WAThe student pilot’s failure to maintain directional control during a touch-and-go.Dec 13, 2024 · N6750H · Substantial damageNTSB WPR25LA060Accident · Minor injuriesClass 3 · LimitedFinal reportZall Jihlavan Airplanes S R O JA-600 Skyleader · Reedley, CAThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Dec 12, 2024 · N789RC · Substantial damageNTSB WPR25LA057Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Glendale, AZThe pilot's failure to maintain directional control during the landing roll. .Dec 9, 2024 · N36249 · Substantial damageNTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.Dec 9, 2024 · N271BP · Substantial damageNTSB WPR25LA059Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · El Cajon, CAThe pilot’s inability to maintain directional control during landing with a flat tire.Dec 8, 2024 · N9199R · Substantial damageNTSB WPR25LA056Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Marysvale, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.Dec 5, 2024 · N1706B · Substantial damageNTSB WPR25LA051Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175 · Middlegate, NVThe pilot's failure to maintain directional control on a rough surface during takeoff.Nov 30, 2024 · N7501M · Substantial damageNTSB CEN25LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Pearland, TXThe flight instructor’s inadequate supervision of the student pilot that resulted in a loss of directional control during landing, and the excessive use of wheel brakes to regain directional control which resulted in the airplane nosing over.Nov 30, 2024 · N2933N · Substantial damageNTSB CEN25LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Mason, MIThe pilot’s failure to maintain aircraft control during landing rollout that resulted in a nose over and an impact with the runway.Nov 25, 2024 · N76061 · Substantial damageNTSB ERA25LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Lakeland, FLThe pilot’s failure to maintain yaw control during a tailwind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, and subsequent hard landing.Nov 21, 2024 · N422RH · Substantial damageNTSB WPR25LA044Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Show Low, AZThe pilot’s failure to maintain directional control during the takeoff.Nov 19, 2024 · N705AB · Substantial damageNTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…Nov 19, 2024 · N951JA · Substantial damageNTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.Nov 18, 2024 · N8152R · Substantial damageNTSB CEN25LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Crowley, LAThe pilot’s un-stabilized landing approach and high airspeed during the approach, that resulted in touchdown with insufficient runway remaining to stop the airplane.Nov 18, 2024 · N738PG · Substantial damageNTSB WPR25LA041Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Palm Springs, CAThe pilot’s failure to maintain clearance from a commercial airliner which resulted in an encounter with wake turbulence and subsequent loss of control resulting in impact with terrain.Nov 17, 2024 · N828PS · Substantial damageNTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.Nov 17, 2024 · N8390L · Substantial damageNTSB WPR25LA039Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Pomona, CAA total loss of engine power during final approach for reasons that could not be determined.Nov 17, 2024 · N617ET · Substantial damageNTSB ERA25LA055Accident · No injuriesClass 4 · LimitedFinal reportBrunner-Winkle Bird A · Senoia, GAThe pilot’s improper flare, which resulted in a hard landing, and landing gear collapse.Nov 17, 2024 · N15641 · Substantial damageNTSB WPR25LA038Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-6-300 · Boulder City, NVA loss of directional control during the landing roll in gusting crosswind conditions.Nov 15, 2024 · N241SA · Substantial damageNTSB CEN25LA046Accident · Serious injuriesClass 4 · LimitedFinal reportRotor Flight Dynamics Dominator · Gilbert, MNA total loss of engine power and subsequent autorotation to a swamp, that resulted in a rollover. Contributing to the pilot’s delayed egression from the gyroplane, was the lack of a restraint system cutting device.Nov 15, 2024 · UNREG · Substantial damageNTSB WPR25LA043Accident · No injuriesClass 4 · LimitedFinal reportCharlie Guinn CCK-1865 · Lewiston, MTThe pilot’s failure to maintain directional control in a gusting tailwind, which resulted in an impact with a tree.Nov 14, 2024 · N247CC · Substantial damageNTSB ERA25LA046Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Mariner · Parrottsville, TNThe pilot’s failure to maintain control of the helicopter during a precautionary, off-airport landing to sloping terrain.Nov 13, 2024 · N178EP · Substantial damageNTSB CEN25LA039Accident · No injuriesClass 4 · LimitedFinal reportAtkinson Jeffrey M RV-8 · Denton, TXThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Nov 13, 2024 · N228HM · Substantial damageNTSB CEN25LA084Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Lago Vista, TXThe flight instructor’s improper recovery from a practice autorotation which resulted in a hard landing.Nov 11, 2024 · N1243Y · Substantial damageNTSB CEN25LA036Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.Nov 9, 2024 · N49785 · DestroyedNTSB WPR25LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Lancaster, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Nov 8, 2024 · N1977C · Substantial damageNTSB WPR25LA034Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Durkee, ORThe pilot's inadequate performance planning, which resulted in insufficient engine power to transition into an out-of-ground-effect hover at a high gross weight.Nov 7, 2024 · N4361R · Substantial damageNTSB ERA25LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Ball Ground, GAThe pilot and the flight instructor’s failure to maintain control of the airplane during a simulated loss of engine power during takeoff, which resulted in a runway excursion, and collision with a taxiway sign.Nov 7, 2024 · N6444W · Substantial damageNTSB WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.Nov 6, 2024 · N9207X · Substantial damageNTSB ERA25LA038Accident · No injuriesClass 4 · LimitedFinal reportDeneal Daniel W Vans RV6A · Taylorsville, KYA nose landing gear collapse following a bounced landing.Nov 3, 2024 · N256GD · Substantial damageNTSB WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…Oct 31, 2024 · N154DC · Substantial damageNTSB ERA25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195A · Bethel, PAThe pilot’s failure to maintain directional control during landing.Oct 31, 2024 · N3083B · Substantial damageNTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…Oct 29, 2024 · N885CA · Substantial damageNTSB DCA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAirbus A300 F4-622R · Louisville, KYThe pilot’s incorrect pitch attitude during a bounced landing which resulted in a tailstrike.Oct 29, 2024 · N162UP · Substantial damageNTSB ERA25LA025Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairmont, WVThe student pilot’s improper flare, which resulted in a bounced landing and subsequent loss of directional control.Oct 27, 2024 · N926MK · Substantial damageNTSB ERA25LA023Accident · 2 fatalClass 3 · LimitedFinal reportBuckeye Dream Machine · Nicholasville, KYThe pilot’s loss of control in flight, which resulted in a collision with terrain.Oct 27, 2024 · N75331 · Substantial damageNTSB CEN25LA031Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Pearland, TXThe pilot’s failure to maintain control of the helicopter during lift off.Oct 27, 2024 · N7521Z · Substantial damageNTSB ANC25LA007Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Seward, AKThe pilot’s improper landing flare which resulted in a hard landing, loss of directional control, and nose-over.Oct 27, 2024 · N307AM · Substantial damageNTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.Oct 26, 2024 · N94981 · Substantial damageNTSB CEN25LA030Accident · No injuriesClass 4 · LimitedFinal reportStinson L-5 · Pleasanton, TXThe pilot’s failure to maintain control of the airplane during the landing.Oct 26, 2024 · N9HU · Substantial damage