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 CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.NTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.NTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.NTSB ERA21LA328Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Orlando, FLA total loss of engine power due to fuel starvation that resulted from improper maintenance of the fuel selector valve and fuel selector valve cover.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…NTSB ANC21LA073Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Fairbanks, AKThe pilot’s unexpected encounter with supercooled liquid droplets (SLD), which resulted in a loss of control due to ice accumulation. Contributing to the accident were: (1) the pilot’s failure to maintain the minimum airspeed for flight in icing conditions,…NTSB ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.NTSB ANC21LA071Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-14 · Tyonek, AKThe pilot’s failure to maintain directional control and adequate airspeed during takeoff which resulted in a collision with a river. Contributing to the accident was the pilot’s improper decision to load the airplane above its maximum allowable gross weight.NTSB WPR21LA320Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · West Jordan, UTThe pilot receiving instruction’s improper application of forward cyclic in a low rotor rpm condition and the instructor’s delayed remediation, which resulted in an impact with terrain.NTSB CEN21LA375Accident · No injuriesClass 3 · LimitedFinal reportHaley Highlander · Waller, TXA loss of engine power due to fuel exhaustion.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB CEN21LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Greenville, ILThe pilot’s failure to maintain directional control during taxi which resulted in a ground loop.NTSB ANC21LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Soldotna, AKThe flight instructor's inadequate supervision of the pilot receiving instruction, which resulted in a loss of control during the landing touchdown and a left main landing gear collapse.NTSB WPR21LA317Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Piper Sport · Santa Monica, CAThe student pilot’s improper landing flare.NTSB DCA21LA210Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD-11F · Phoenix, AZThe flight crew’s incorrect pitch attitude during go-around.NTSB ANC21LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rohn, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN21LA387Accident · Minor injuriesClass 4 · LimitedFinal reportSix Chuter Skye Ryder · Harrison, MIThe pilot’s loss of control while maneuvering at low altitude, which resulted in impact with terrain.NTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB ERA21LA325Accident · Minor injuriesClass 4 · LimitedFinal reportSilverlight Delta JET-II · Mulberry, FLThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent loss of directional control.NTSB CEN21FA368Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S2R · Strasburg, NDThe pilot’s intentional flight under power lines and his failure to maintain clearance from the lines during an aerial application flight.NTSB WPR21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Reno, NVThe pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.NTSB ERA21FA318Accident · 2 fatalClass 3 · FieldFinal reportPitts 12 · Ocklawaha, FLThe pilot’s failure to maintain airplane control while performing aerobatic maneuvers, which resulted in an inverted flat spin from which he was unable to recover.NTSB CEN21FA364Accident · 1 fatalClass 3 · FieldFinal reportCessna 210H · Melbourne, ARThe pilot’s failure to maintain control of the airplane with full flaps during the takeoff.NTSB CEN21LA366Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Navasota, TXThe pilot’s failure to extend the landing gear before landing.NTSB ERA21LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Oxford, CTThe inadvertent operation of the landing handle during the landing roll, which resulted in a nose gear retraction and subsequent collision with the runway.NTSB ERA21FA317Accident · 2 fatalClass 3 · FieldFinal reportRotorway Exec 162F · Argyle, NYThe pilot’s abrupt control inputs, which resulted in a low G condition, main rotor mast bumping, and the subsequent severing of the tail boom by a main rotor blade.NTSB CEN21LA370Accident · No injuriesClass 4 · LimitedFinal reportMarlowe Thooft Just Acft Highlander · Brainerd, MNThe pilot’s failure to maintain directional control during a crosswind landing that resulted in an impact with terrain.NTSB CEN21LA363Accident · No injuriesClass 3 · LimitedFinal reportRotary RAF2000 · Anahuac, TXThe pilot’s incorrect trim system installation, which resulted in a loss of gyroplane control and impact with terrain.NTSB CEN21FA360Accident · 3 fatalClass 3 · FieldFinal reportMooney M20M · Victoria, MNThe pilot’s loss of airplane control due to spatial disorientation during final approach, which led to a spiral dive that overstressed the airplane and resulted in an in-flight breakup.NTSB ERA21LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Miami, FLThe failure of the flight instructor to maintain the proper rate of descent during the aborted takeoff.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB ANC21LA070Accident · No injuriesClass 4 · LimitedFinal reportAlaskan Air Adventures SQ2 · Talkeetna, AKThe pilot’s inadvertent movement of the fuel selector valve to a position between the tanks, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ANC21FA069Accident · 6 fatalClass 2 · FieldFinal reportDehavilland DHC-2 MK.I · Ketchikan, AKThe pilot’s decision to continue visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in controlled flight into terrain. Contributing to the accident was the FAA’s reliance on voluntary compliance with the Ketchikan…NTSB CEN21LA357Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Mer Rouge, LAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot and ground personnel’s miscalculation of available fuel.NTSB CEN21LA356Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Corydon, INThe pilot’s failure to see and avoid power lines.NTSB CEN21LA354Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Wooster, OHThe pilot inadvertently collided with powerline wires during an agricultural spraying flight, resulting in a loss of aircraft control and subsequent impact with the ground.NTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.NTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.NTSB WPR21LA322Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Tucson, AZThe pilot's failure to maintain a safe taxi distance from a large turbine-powered airplane, resulting in an encounter of the turbine-powered airplane's jet blast while taxiing.NTSB CEN21LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Iron Mountain, MIThe mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.NTSB ERA21LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 210N · Somerville, NJThe pilot’s failure to extend the landing gear, which resulted in a gear up landing and substantial damage to the fuselage.NTSB ERA21LA313Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Waxhaw, NCThe pilot’s failure to abort the takeoff in sufficient time to stop the airplane on the runway remaining. Contributing to the accident was the lack of airplane takeoff performance due to the pilot’s failure to assure that the carburetor heat control was in…NTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.NTSB ANC21LA068Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-1 · Sterling, AKInsufficient available power as a result of low compression in three engine cylinders. Contributing to the accident was the pilot’s decision to takeoff with a slight quartering tailwind.NTSB ANC21LA066Accident · Minor injuriesClass 4 · LimitedFinal reportCessna U206F · Igiugig, AKThe pilot’s improper decision to continue a takeoff attempt when it became evident that the airplane would not become airborne before reaching the departure end shoreline.NTSB WPR21FA300Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Colusa, CAThe pilot’s abrupt flight control input that led to mast bumping and a subsequent in-flight breakup.