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 WPR25LA028Accident · No injuriesClass 4 · LimitedFinal reportDierenfield Devin RV-6A · Lancaster, CAThe pilot’s failure to maintain a stablized approach, which resulted in a hard landing.Oct 25, 2024 · N805RV · Substantial damageNTSB CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.Oct 24, 2024 · N62740 · Substantial damageNTSB ERA25LA024Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Williamsburg, VAThe pilot’s failure to maintain directional control on landing.Oct 21, 2024 · N300E · Substantial damageNTSB CEN25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Willis, MIThe pilot’s failure to maintain a stabilized approach, that resulted in a runway excursion and subsequent collision with trees. Contributing to the accident, was the pilot’s decision to attempt to land to a closed runway.Oct 21, 2024 · N51046 · Substantial damageNTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.Oct 21, 2024 · N881KE · DestroyedNTSB WPR25LA022Accident · No injuriesClass 4 · LimitedFinal reportSeifert Dale E Highlander · Elko, NVThe pilot’s failure to maintain direction control during a go-around, which resulted in a ground loop.Oct 20, 2024 · N716DW · Substantial damageNTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.Oct 20, 2024 · N512DW · DestroyedNTSB ERA25FA020Accident · 2 fatalClass 3 · FieldFinal reportGeisz Gilbert A Lancair 360 · Cross City, FLThe pilot’s exceedance of the critical angle of attack, which resulted in an aerodynamic stall at an altitude too low to recover. Contributing to the accident was the total electrical failure, which likely resulted in a loss of airspeed indication.Oct 20, 2024 · N510G · Substantial damageNTSB CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.Oct 20, 2024 · N583MB · Substantial damageNTSB ANC25LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Wasilla, AKThe pilot’s failure to maintain directional control during the landing roll, resulting in a ground loop.Oct 20, 2024 · N61795 · Substantial damageNTSB CEN25LA032Accident · No injuriesClass 4 · LimitedFinal reportRyan Navion A · Belleville, ILThe pilot’s failure to maintain airplane control during the takeoff.Oct 19, 2024 · N2341 · Substantial damageNTSB CEN25LA024Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2A · Stoughton, WIThe pilot’s failure to maintain directional control during landing.Oct 19, 2024 · N11JC · Substantial damageNTSB ERA25LA022Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Blountville, TNThe pilot’s failure to maintain directional control during takeoff and subsequent rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to verify rudder trim setting prior to takeoff.Oct 17, 2024 · N89S · Substantial damageNTSB ERA25LA021Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Sanford, METhe pilot’s failure to maintain directional control during the landing roll, resulting in a runway excursion and collision with terrain.Oct 17, 2024 · N109CT · Substantial damageNTSB CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…Oct 17, 2024 · N231MW · Substantial damageNTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.Oct 13, 2024 · N9493CNTSB WPR25LA019Accident · No injuriesClass 4 · LimitedFinal reportJared Baker Rans DSG INC S21 OUT · Springer, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with an obstacle.Oct 13, 2024 · N46ST · Substantial damageNTSB WPR25LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Creswell, ORThe pilot’s loss of aircraft control during the landing flare and subsequent aborted landing.Oct 13, 2024 · N35281 · Substantial damageNTSB WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.Oct 12, 2024 · N185WK · Substantial damageNTSB ERA25LA014Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · South Charleston, WVThe pilot’s decision to continue landing after encountering a strong tailwind, which resulted in a loss of control and subsequent runway excursion.Oct 12, 2024 · N1131M · Substantial damageNTSB ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.Oct 12, 2024 · N205MX · Substantial damageNTSB WPR25LA015Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Moriarty, NMThe pilot’s failure to maintain an adequate glidepath, which resulted in the glider landing on rough terrain short of the runway.Oct 11, 2024 · N41FL · Substantial damageNTSB ERA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing roll, resulting in the on-ground collision with trees.Oct 11, 2024 · N79HY · Substantial damageNTSB CEN25LA013Accident · Minor injuriesClass 3 · LimitedFinal reportRotorway Exec · Plymouth, INA loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.Oct 11, 2024 · N314AC · Substantial damageNTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.Oct 9, 2024 · N601KM · Substantial damageNTSB WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.Oct 8, 2024 · N631HC · Substantial damageNTSB ERA25LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisville, KYThe pilot’s improper landing flare and control inputs, which resulted in a hard landing. Contributing was the flight instructor’s delayed remedial action.Oct 8, 2024 · N640MG · Substantial damageNTSB CEN25LA009Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Garden Ridge, TXA loss of engine power that resulted from improper fuel system maintenance and the subsequent fuel starvation due to the leaking fuel pump outlet fuel line.Oct 8, 2024 · N2490H · Substantial damageNTSB CEN25LA007Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Richmond, TXThe partial separation of a portion of the propeller spinner and its mounting bulkhead along with the upper cowl fairing while in a full-power climb.Oct 8, 2024 · N9151V · Substantial damageNTSB CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.Oct 8, 2024 · N130GP · DestroyedNTSB WPR25LA005Accident · Serious injuriesClass 4 · LimitedFinal reportRotorsport Cavalon · Chico, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent descent and subsequent collision with trees.Oct 7, 2024 · N726CA · Substantial damageNTSB ERA25LA009Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher ASK-21 · Front Royal, VAThe pilot’s improper landing flare and subsequent improper recovery from a hard, bounced landing.Oct 6, 2024 · N341KS · Substantial damageNTSB CEN25LA011Accident · Serious injuriesClass 4 · LimitedFinal reportPowrachute SKY Rascal · Peculiar, MOThe failure of the pilot to use appropriate engine power during descent in turbulent air which resulted in a loss of control.Oct 6, 2024 · N2565Q · Minor damageNTSB CEN25LA004Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing E75 · Sanger, TXThe pilot’s failure to maintain airplane control.Oct 4, 2024 · N1612M · Substantial damageNTSB ANC25LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna U206B · Skwentna, AKThe pilot’s delayed go-around decision, which resulted in inadvertent contact with the landing surface, loss of directional control, and a nose over in gusting wind conditions.Oct 4, 2024 · N3495L · Substantial damageNTSB CEN25LA003Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Montrose, COA loss of engine power during a demonstrated autorotation due to an improperly adjusted air-fuel mixture or idle setting. Contributing to the accident was the pilot’s failure to perform the required idle check during previous flights in higher elevation areas.Oct 3, 2024 · N656RB · Substantial damageNTSB WPR25LA009Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Mesa, AZThe pilot receiving instruction’s failure to maintain airspeed during landing and the flight instructor’s delayed remedial action, which resulted in a hard landing.Oct 2, 2024 · N4199M · Substantial damageNTSB ANC25LA031Accident · No injuriesClass 4 · LimitedFinal reportLawrence M Zubel Loehle 5151 Mustang · Vernal, UTThe pilot’s improper landing flare, which resulted in a hard, bounced landing which result in the left landing gear collapsing.Oct 2, 2024 · N579LZ · Substantial damageNTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.Oct 1, 2024 · N45472 · Substantial damageNTSB CEN24LA377Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Manvel, TXThe pilot’s improper recovery from a practice autorotation which resulted in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.Sep 30, 2024 · N8372F · Substantial damageNTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.Sep 29, 2024 · N5625T · Substantial damageNTSB ERA24FA397Accident · 5 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Kill Devil Hills, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.Sep 28, 2024 · N1281F · DestroyedNTSB WPR24LA322Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Paris, IDThe pilot’s failure to properly configure the flaps, which resulted in a loss of directional control during takeoff.Sep 27, 2024 · N916PH · Substantial damageNTSB WPR24FA313Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Provo, UTThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.Sep 27, 2024 · N831AZ · Substantial damageNTSB CEN24LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 210-5(205) · Bryan, TXThe pilot’s failure to maintain aircraft control during the landing.Sep 27, 2024 · N205CT · Substantial damageNTSB CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.Sep 27, 2024 · N605KD · No damageNTSB WPR24LA315Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Kooskia, IDThe pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.Sep 26, 2024 · N54829 · Substantial damageNTSB CEN24LA367Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lakeway, TXThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and loss of control during a go-around.Sep 25, 2024 · N565CP · Substantial damageNTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.Sep 24, 2024 · N281EA · Substantial damageNTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.Sep 23, 2024 · N30YC · Substantial damage