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 WPR22LA269Accident · Minor injuriesClass 4 · LimitedFinal reportMiller-Thorp T-18 Tiger · Angel Fire, NMThe pilot’s failure to maintain directional control during the landing roll in gusting wind.NTSB ERA22LA332Accident · Serious injuriesClass 4 · LimitedFinal reportWhitten Robinson Aventura II · Meritt Island, FLThe pilot’s failure to maintain control of the airplane during final approach to land, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and collision with a fence and terrain.NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB CEN22LA338Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic YMF-5C · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB CEN22LA335Accident · 1 fatalClass 3 · LimitedFinal reportAyres S2R-T34 · Parkin, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering.NTSB WPR22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lexington, ORThe pilot’s failure to maintain directional control during the landing roll with a gusting wind.NTSB WPR22LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Huntington Beach, CAA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel at an altitude too low for recovery. Contributing was the pilot’s delayed decision to switch fuel tanks.NTSB WPR22FA264Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-235 · Seguin, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…NTSB ERA22LA339Accident · No injuriesClass 4 · LimitedFinal reportVulcanair V1 · Salisbury, MDThe student pilot’s improper flare, which resulted in a hard landing.NTSB CEN22LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Neosho, MOThe pilot’s inadvertent application of the right brake and subsequent loss of airplane directional control, which resulted in a taxiway excursion and impact with trees.NTSB CEN22LA337Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.NTSB ERA22LA330Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Kenton, OHThe pilot’s inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB ERA22LA329Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Plant City, FLA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight fuel planning.NTSB CEN22LA371Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T65 · Wyman / Washington, IAThe pilot not maintaining sufficient altitude to clear an obstruction during the aerial application flight.NTSB CEN22LA343Accident · No injuriesClass 3 · LimitedFinal reportBeech E33A · Zena, OKThe pilot’s inadequate preflight inspection and fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.NTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.NTSB WPR22LA262Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Three Forks, MTA loss of engine power due to degraded and incorrectly maintained ignition system components. Contributing to the accident was the pilot’s delay in turning the airplane towards the runway when the engine began to lose power.NTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB ERA22LA347Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Franklin, PAThe pilot’s inadequate visual lookout while flying at a low level over a river, which resulted in a wire strike.NTSB CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.NTSB CEN22LA326Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Madison, ILLoss of tail rotor effectiveness resulting in an in-flight loss of control.NTSB WPR22LA261Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA342J · Escalante, UTThe pilot's failure to control the helicopter’s descent rate during landing, which resulted in collision with terrain.NTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.NTSB ERA22FA320Accident · 1 fatalClass 3 · FieldFinal reportKnight AA Nieuport 28 · Basehor, KSThe pilot’s incorrect installation of the left-wing strut, which resulted in a loss of airplane control during takeoff and a subsequent aerodynamic stall and spin from which the pilot could not recover.NTSB CEN22LA322Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 112 · Granbury, TXThe loss of engine power due to metal contamination within the cylinder following poor maintenance.NTSB CEN22LA321Accident · 2 fatalClass 3 · LimitedFinal reportJust Highlander · Bennington, OKThe pilot’s exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall and loss of control.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB WPR22LA258Accident · 2 fatalClass 3 · LimitedFinal reportEvolution Revolt · Walter Springs, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike and impact with terrain.NTSB WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.NTSB ERA22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · East Haddam, CTThe pilot's failure to maintain directional control during the landing.NTSB ERA22LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Orlando, FLThe flight instructor’s inadequate remedial actions following the student pilot’s improper control inputs, which resulted in dynamic rollover.NTSB ERA22LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Hanson, MAThe pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.NTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB WPR22FA255Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7BCM · Lake McMurray, WAThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain.NTSB WPR22FA254Accident · 1 fatalClass 3 · FieldFinal reportStucky Steven D RV-7 · Topeka, KSThe pilot’s failure to maintain aircraft control while performing an aerobatic maneuver on takeoff, which resulted in exceedance of the airplane’s critical angle of attack, a subsequent aerodynamic stall, and impact with terrain. Contributing to the accident…NTSB ERA22LA433Accident · No injuriesClass 4 · LimitedFinal reportEaster William C M-1 · Okeechobee, FLThe premature placement of an airport runway closure marker short of the runway, which resulted in the airplane’s collision with the marker during the landing approach. Contributing was the pilot’s inability to see the marker due the nose-high attitude of the…NTSB ERA22LA367Accident · Minor injuriesClass 4 · LimitedFinal reportVickers-Slingsby T65A · Butler, GAThe pilot’s retraction the landing gear just prior to touchdown on the runway.NTSB ERA22FA315Accident · 1 fatalClass 3 · FieldFinal reportPiper PA12 · Middle Township, NJThe pilot’s exceedance of the airplane’s critical angle of attack during a missed banner pickup, which resulted in an aerodynamic stall/spin and loss of control at an altitude too low to recover.NTSB CEN22LA341Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421B · Riverdale, NEA total loss of engine power as a result of fuel exhaustion.NTSB ERA22LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Tuscaloosa, ALThe student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…NTSB CEN22LA325Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305A · Mc Kinney, TXThe failure of the pilot to maintain adequate airspeed during landing resulting in an inadvertent aerodynamic stall.NTSB CEN22LA324Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Grain Valley, MOThe loss of engine power due to fuel exhaustion.NTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.NTSB ANC22LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot’s excessive use of brakes which resulted in a nose-over.NTSB ANC22LA057Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Lake Louise, AKThe pilot's failure to maintain a proper glide path, which resulted in a hard landing short of the airstrip.