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 CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.NTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…NTSB GAA19CA510Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Waco, TXThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover.NTSB ERA19LA260Accident · Serious injuriesClass 3 · LimitedFinal reportDG Flugzeugbau DG-500MB · Robertsdale, ALImpact with trees during the landing approach for reasons that could not be determined based on the available information.NTSB ERA19FA256Accident · 1 fatalClass 3 · FieldFinal reportMoriarty Marvin Aventura II · Minneola, FLThe pilot’s improper modifications to the airplane’s engine, which resulted in the partial loss of engine power. Contributing to the outcome was the pilot's exceedance of the airplane’s critical angle of attack during an attempted return to the airport…NTSB GAA19CA513Accident · Minor injuriesData collectionFinal reportCessna A185 · Rangeley Lake, METhe pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water.NTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.NTSB GAA19CA505Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Oxford, FLThe pilot’s continued use of battery power during a nonpowered flight in a powered-glider, which depleted the battery to a level that was insufficient to power the starter during the engine restart sequence and resulted in a forced landing to a soft field and…NTSB ERA19LA257Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Burnsville, NCThe pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…NTSB WPR19LA233Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Livermore, CAA partial loss of engine power due to fouled spark plugs in the No. 4 cylinder. Contributing to the accident was the pilot’s exceedance of the airplane’s critical angle of attack and a subsequent loss of control during the initial climb.NTSB WPR19FA230Accident · No injuriesClass 3 · FieldFinal reportCessna 560XL · Oroville, CAThe pilot’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane nose down pitching moment. Also causal was the flight crew’s delayed decision to abort the takeoff, which…NTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.NTSB ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.NTSB WPR19LA237Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Eugene, ORThe failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in…NTSB GAA19CA517Accident · Minor injuriesData collectionFinal reportCessna 180 · Arlington, WAThe pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA501Accident · No injuriesData collectionFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's overapplication of brakes during landing on unimproved terrain, which resulted in a nose-over.NTSB GAA19CA499Accident · Minor injuriesData collectionFinal reportVans RV7 · Ocracoke, NCThe pilot's failure to maintain lateral control during an attempted aborted landing, which resulted in impact with trees.NTSB GAA19CA496Accident · No injuriesData collectionFinal reportCessna TU206 · Regina, NMThe pilot's improper preflight performance planning for a high-density altitude takeoff from a short, dirt airstrip, which resulted in impact with terrain.NTSB ERA19FA251Accident · Serious injuriesField investigationFinal reportCirrus SR22 · Tappahannock, VAThe pilot's inability to land on the runway in dark night conditions with reported smoke in the cockpit, which necessitated the deployment of the airplane's parachute system.NTSB CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…NTSB GAA19CA498Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot entering the taxiway's failure to see and avoid the airplane established on the taxiwayNTSB ERA19FA250Accident · 2 fatalClass 3 · FieldFinal reportBeech 95B55 · Wilmington, DEThe pilots’ failure to place the left fuel selector into the proper position, which resulted in a total loss of the left engine’s power due to fuel starvation. Contributing was their failure to properly secure the left engine and their failure to maintain…NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB ANC19LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Lahaina, HIThe pilots’ failure to maintain a proper approach speed and their decision to continue the approach for landing, which resulted in the airplane landing long and a subsequent runway overrun.NTSB WPR19LA223Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Ruidoso, NMThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate…NTSB ERA19TA254Accident · Minor injuriesClass 3Final reportGIger Frank R Nieuport II · Talladega, ALA total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.NTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.NTSB GAA19CA495Accident · Minor injuriesData collectionFinal reportFlight Design CT2K · Hooper, WAThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.NTSB WPR19LA221Accident · Minor injuriesClass 3 · LimitedFinal reportAutoGyro Cavalon · Shelton, WAThe pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.NTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…NTSB GAA19CA497Accident · No injuriesData collectionFinal reportPiper PA 12 · McCarthy, AKThe pilot's overapplication of brakes during landing, which resulted in a nose-over.NTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…NTSB CEN19LA267Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC6 · San Marcos, TXThe pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.NTSB WPR19LA218Accident · No injuriesClass 3 · LimitedFinal reportExtra EA300 · Mesa, AZThe flight instructor’s operation of the airplane outside of the manufacturer’s limitations, which resulted in fuel starvation and a partial loss of engine power. Contributing to the accident was an inoperative electric fuel boost pump.NTSB GAA19CA494Accident · No injuriesData collectionFinal reportRockwell 690 · Stockton, CAThe pilot's delay in extending the landing gear and his improper movement of the landing gear lever, which led to a gear-up landing.NTSB ERA19LA246Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jay, FLThe pilot's improper decision to fly over a river at a very low altitude, which resulted in a collision with power lines.NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB ANC19TA044Accident · Minor injuriesClass 3Final reportCessna 180 · Anchorage, AKThe pilot’s failure to maintain takeoff heading due to sun glare, which resulted in his inability to see an island adjacent to the water lane and subequent impact with the island.NTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.NTSB ERA19LA245Accident · Serious injuriesClass 3 · LimitedFinal reportSchweizer 269C · Allentown, PAInadequate maintenance of the helicopter’s magnetos, which resulted in a partial loss of engine power during the initial climb due to a failure of the left magneto and malfunction of the right magneto.NTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA491Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Franklin, PAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing.NTSB GAA19CA489Accident · No injuriesData collectionFinal reportCessna 180 · Two Harbors, MNThe pilot's abrupt maneuver to try and avoid a deer during landing on a grass strip runway, which resulted in a ground loop.NTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.NTSB CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.