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 CEN16LA217Accident · Minor injuriesLimited investigationFinal reportBellanca 17 30 · Westport, OKA total loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB ANC16CA031Accident · No injuriesData collectionFinal reportMaule M 6-235 · Fairbanks, AKThe pilot's decision to land on terrain unsuitable for a wheel equipped airplane.NTSB GAA16CA305Accident · Minor injuriesData collectionFinal reportCessna 172 · Pasco, WAThe flight instructor's failure to maintain pitch control during the simulated engine failure after takeoff, which resulted in a hard landing, landing gear(s) collapse, and wing damage.NTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.NTSB GAA16CA299Accident · Minor injuriesData collectionFinal reportBareiss David A Tango 2 · Sunrise Beach Village, TXThe nosewheel fairing becoming packed with debris during landing on the soft field due to a gap between the nosewheel tire and the fairing, which resulted in a loss of control and subsequent nose-over.NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…NTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.NTSB ERA16CA211Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Williamsburg, VAThe pilot's failure to maintain adequate airspeed during a go-around which led to the airplane exceeding its critical angle-of-attack and experiencing aerodynamic stall.NTSB CEN16LA228Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Deming, NMThe pilots’ failure to maintain adequate control of the airplane during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude. Contributing to the accident was the…NTSB CEN16FA214Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Marion, ILThe pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.NTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.NTSB GAA16CA300Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Moundsville, WVThe pilot's failure to maintain directional control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.NTSB CEN16LA213Accident · Minor injuriesLimited investigationFinal reportBell 47G 5 · Laureles, TXThe pilot's failure to apply additional engine power when he applied collective input, which led to a loss of rotor speed and the exceedance of the helicopter’s performance capability.NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB CEN16FA211Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Houston, TXThe pilot's improper go-around procedure that did not ensure that the airplane was at a safe airspeed before raising the flaps, which resulted in exceedance of the critical angle of attack and resulted in an accelerated aerodynamic stall and spin into…NTSB GAA16LA329Accident · Serious injuriesLimited investigationFinal reportMini Max 1200 · Batesville, INThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB GAA16CA315Accident · No injuriesData collectionFinal reportSeela Gerald L Glasair SH 2F · State College, PAThe pilot's hard landing in gusting wind conditions. Contributing to the accident were the pilot's unfamiliarity with the newly purchased airplane's throttle resulting in an unstable approach, and the pilot's ability to compensate for the wind.NTSB GAA16CA301Accident · No injuriesData collectionFinal reportCessna 172 · Urbana, OHThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, hard landing, and runway excursion.NTSB GAA16CA295Accident · No injuriesData collectionFinal reportCessna 172 · Thomson, GAThe student pilot's incorrect landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing, nose wheel collapse, and runway excursion.NTSB GAA16CA294Accident · No injuriesData collectionFinal reportBellanca 17 30 · Fredericksburg, VAThe pilot's failure to maintain directional control during the landing roll in gusting wind resulting in a runway excursion and substantial damage.NTSB GAA16CA293Accident · No injuriesData collectionFinal reportBell 47G · Hastings, MNThe pilot's failure to attain a positive rate of climb during takeoff from a service truck, which resulted in an impact with terrain and substantial damage to the tail boom and fuselage.NTSB GAA16CA292Accident · No injuriesData collectionFinal reportAeronca 7BCM · Rochester, WIThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, left main landing gear collapse, and a nose down. Contributing to the accident was the wind shift.NTSB GAA16CA297Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Chireno, TXThe student pilot's selection of unsuitable terrain for landing, which resulted in the helicopter rolling over during landing, and substantial damage to the tail boom.NTSB GAA16CA296Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Cahokia/St. Louis, ILThe flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.NTSB GAA16CA291Accident · Minor injuriesData collectionFinal reportBilly Amerson Stol CH 750 · Manning, SCThe pilot's failure to maintain directional control during landing, which resulted in an impact with a fence and trees.NTSB GAA16CA290Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Beaumont, TXThe non-pilot owner's decision to start the helicopter while awaiting the pilot's arrival, which resulted in a loss of yaw control and a rollover.NTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB WPR16FA120Accident · 1 fatalField investigationFinal reportRockwell S2R · De Smet, IDThe pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.NTSB ERA16LA204Accident · Serious injuriesLimited investigationFinal reportBobbi Boucher DUO Deuce · Stafford, VAThe pilot's failure to attain adequate airspeed during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.NTSB ANC16LA029Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802 · Fairbanks, AKThe pilot's inadequate preflight fuel planning, his reliance on the fuel flow indicator without verifying the initial fuel level input, and his improper decision to continue the flight with the low fuel light illuminated, which resulted in fuel exhaustion,…NTSB GAA16CA308Accident · No injuriesData collectionFinal reportCessna 208 · Fort Dodge, IAThe flight crew's failure to install the tail stand prior to passenger boarding, which resulted in a tail strike.NTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.NTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.NTSB GAA16CA285Accident · No injuriesData collectionFinal reportMaule M5 · Hamilton, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB ERA16CA203Accident · No injuriesData collectionFinal reportBeech F33A · Fairfield, NJThe pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power.NTSB GAA16CA281Accident · Minor injuriesData collectionFinal reportAmerican Champion 8KCAB · Black Diamond, WAThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, aerodynamic stall, impact with terrain, and nose over.NTSB GAA16CA277Accident · Minor injuriesData collectionFinal reportPiper PA 24 · Loda, ILThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…NTSB GAA16CA276Accident · No injuriesData collectionFinal reportMooney M20C · Williamstown, NJThe pilot's landing area overshoot and failure to maintain surface speed and braking capability, which resulted in a runway overrun and a collision with a fence.NTSB GAA16CA280Accident · No injuriesData collectionFinal reportStaudacher S 300 · Prospect Heights, ILThe pilot's incorrect pitch control during the landing, which resulted in a hard bounced landing, and subsequent left main landing gear collapse, a runway excursion, and a collision with a runway sign.NTSB ERA16LA202Accident · Minor injuriesLimited investigationFinal reportBell 407 · Mountain City, TNAn incorrect and unapproved repair of the engine compressor diffuser performed by a machinist at a repair facility, which resulted in failure of the compressor diffuser aft plate and a partial loss of engine power.NTSB CEN16LA207Accident · Minor injuriesLimited investigationFinal reportSmith Capella FW2R · Alamo, TXThe total loss of engine power due to fuel exhaustion, which resulted in a forced landing and a collision with a tree.NTSB WPR16LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Seattle, WAThe pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.NTSB GAA16CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Las Vegas, NVThe pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.NTSB CEN16LA203Accident · 1 fatalLimited investigationFinal reportCessna 150 · Penwell, TXThe pilot’s intentional flight into a silo.NTSB GAA16CA303Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Nicolaus, CAThe pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.NTSB GAA16CA271Accident · Minor injuriesData collectionFinal reportCessna 182 · Elk River, IDThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with terrain.