NTSB investigations
19,008 cases where NTSB found Personnel issues.
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\", '02')) 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", '02')) 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 ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.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 ERA25LA010Accident · No injuriesClass 4 · LimitedFinal reportDitsler Paul A Dakota Hawk · Nicklesville, GAThe pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.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 CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB WPR25LA010Accident · No injuriesClass 4 · LimitedFinal reportEnstrom Helicopter 280C · Vale, ORThe pilot’s failure to maintain engine and rotor rpm during takeoff, that resulted in a hard landing.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced 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 CEN25LA008Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Inguadona, MNThe pilot’s failure to properly configure the landing gear on the amphibious airplane before a water landing.NTSB ANC25LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Kasilof, AKThe right main landing gear’s inadvertent contact with uneven terrain, which resulted in a hard landing. Contributing was the pilot’s failure to adequately assess the landing environment prior to touchdown.NTSB WPR25LA004Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · El Monte, CAA total loss of engine power due to contaminated fuel.NTSB WPR25LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Venator, ORThe inadvertent application of brakes during landing that resulted in a ground loop.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 WPR25LA003Accident · 1 fatalClass 3 · LimitedFinal reportRaytheon C90A · Bakersfield, CAThe pilot’s incapacitation by an in-flight cardiac event that led to cardiac arrest.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 ERA25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Moore Haven, FLThe pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.NTSB ERA25LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa Bay, FLA total loss of engine power in flight due to fuel starvation. Contributing to the accident was the inadequate preflight fuel planning by the student pilot and flight instructor, and the improper inflight fuel management by the student pilot.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 WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.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 CEN24LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Caro, MIA total loss of engine power due to maintenance personnel’s failure to properly tighten the fuel supply line B-nut at the fuel servo.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 CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.NTSB OPS24LA045Incident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Brunswick, GAThe flight crew’s failure to properly identify the airport and runway of intended landing, and the lack of verification of their airplane’s position using all available navigation information.NTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.NTSB CEN24LA375Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14 19 · Cortez, COThe pilot’s failure to extend the landing gear before landing.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 CEN24LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta, COThe pilot’s loss of aircraft control during a bounced landing and go-around, during which the right main landing gear struck a large rock, which damaged it such that it collapsed during the following landing, which caused the airplane to impact the ground…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 WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…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 CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.NTSB DCA24LA318Incident · No injuriesClass 3 · LimitedFinal reportEmbraer ERJ 170-100 LR · Chicago, ILThe flight crew’s misidentification of the intended landing runway, which resulted in an approach to and landing on the wrong runway due to their planned continuation bias. Contributing to the incident was the flight crew’s decision to continue the approach…NTSB CEN24LA368Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Lexington, NEThe pilot’s failure to maintain proper clearance from powerlines.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 ANC24FA102Accident · 1 fatalClass 3 · FieldFinal reportCessna 206 · Chalkyitsik, AKA loss of engine power due to water-contaminated fuel as a result of the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to ensure replacement filters were available for use during refueling operations.NTSB ERA24LA393Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ravenel, SCThe pilot’s failure to maintain clearance from terrain, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.