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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB ERA25LA024Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Williamsburg, VAThe pilot’s failure to maintain directional control on landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.NTSB 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.NTSB CEN25LA032Accident · No injuriesClass 4 · LimitedFinal reportRyan Navion A · Belleville, ILThe pilot’s failure to maintain airplane control during the takeoff.NTSB CEN25LA024Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2A · Stoughton, WIThe pilot’s failure to maintain directional control during landing.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB WPR25LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Creswell, ORThe pilot’s loss of aircraft control during the landing flare and subsequent aborted landing.NTSB WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.NTSB 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.NTSB ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.NTSB 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.NTSB 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.NTSB 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.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN25LA004Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing E75 · Sanger, TXThe pilot’s failure to maintain airplane control.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB CEN24LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 210-5(205) · Bryan, TXThe pilot’s failure to maintain aircraft control during the landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.