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 ERA18LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech B 55 · Statesville, NCA total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA051Accident · No injuriesData collectionFinal reportCessna 182H · Tucson, AZThe pilot’s failure to use taxiways shown on the airport diagrams and his subsequent failure to avoid a ditch.NTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.NTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB ERA18FA016Accident · 2 fatalField investigationFinal reportPiper PA 32 · Morrison, TNThe pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.NTSB GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.NTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.NTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.NTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.NTSB CEN18LA025Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Larchwood, IAThe pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.NTSB CEN18FA024Accident · 4 fatalField investigationFinal reportCessna 172N · Hatch, NMThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…NTSB WPR18LA023Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B95 · Las Vegas, NVThe flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing.NTSB WPR18FA026Accident · 1 fatalClass 2 · FieldFinal reportPiper PA 18-150 · Murphy, IDFailure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.NTSB ERA18LA019Accident · Serious injuriesLimited investigationFinal reportMaurer Elmo A V Star SA900 · Erwinna, PAThe pilot's failure to maintain airplane control during landing.NTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.NTSB ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…NTSB WPR18LA021Accident · No injuriesLimited investigationFinal reportMetcalfe Robert B Vans RV 6 · Selma, CAThe pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power.NTSB ANC18LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · Dawsonville, GAThe failure of the pilot, who was not a certified mechanic, to tighten the B-nut on a remotely mounted oil filter line, which resulted in oil exhaustion, a total loss of oil pressure, and a subsequent total loss of engine power.NTSB GAA18CA033Accident · No injuriesData collectionFinal reportEvolution Revo · Berlin, NHThe pilot’s failure to center the ground steering before landing, which resulted in a loss of directional control.NTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.NTSB WPR18CA028Accident · No injuriesData collectionFinal reportStill Michael J Titan T-51 · Chandler, AZThe pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.NTSB GAA18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Skwentna, AKThe pilot’s decision to land on an unimproved snow-covered airstrip, which resulted in the airplane coming to rest inverted.NTSB GAA18CA035Accident · No injuriesData collectionFinal reportSmith Aerostar 600A · Tallahassee, FLThe pilot's incorrect pitch control and premature landing gear retraction during the initial climb.NTSB GAA18CA029Accident · Serious injuriesData collectionFinal reportSix Chuter West Legend XL · Mabton, WAThe pilot’s failure to see and avoid transmission wires.NTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.NTSB GAA18CA026Accident · No injuriesData collectionFinal reportJohn A Brewer ELA Aviacion 10 Ecli · Bristol, TNThe pilot’s failure to maintain lateral control during the landing roll.NTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR18FA016Accident · 1 fatalField investigationFinal reportRobinson R22 · Arlington, WAThe pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.NTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.NTSB CEN18LA020Accident · No injuriesLimited investigationFinal reportBell 206B · Groom, TXThe total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to operate the helicopter with minimum fuel on board.NTSB CEN18LA019Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502B · Olton, TXThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA022Accident · No injuriesData collectionFinal reportAviat A1 · Williamsport, PAThe pilot’s failure to verify that the parking brake was disengaged before landing, which resulted in a runway excursion.NTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB WPR18LA014Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA 1A · Maricopa, AZThe pilot’s failure to see and avoid unmarked power lines during the approach to land.NTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…NTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…