NTSB investigations
19,005 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 CEN26LA256Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Coralville, IAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.NTSB ERA26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Linneus, METhe pilot’s inadequate preflight and in-flight monitoring of the fuel quantity, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA261Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 STI · Greenwater, WAThe pilot’s failure to maintain directional control during the landing roll, in variable wind conditions.NTSB DCA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-211 · New York, NYThe first officer’s excessive aft sidestick input following a bounced landing, and the line check pilot’s delayed remedial action, which resulted in an increase in the airplane’s pitch attitude and a subsequent tailstrike.NTSB CEN26LA252Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Whiting, KSThe pilot's failure to maintain clearance from an antenna while maneuvering during a low-level aerial application flight.NTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot’s improper landing flare which resulted in a stall and a hard bounced landing.NTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB WPR26LA250Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Buffalo, WYThe pilot’s improper flare and subsequent failure to maintain directional control of the airplane during the aborted landing.NTSB CEN26LA246Accident · Minor injuriesClass 4 · LimitedFinal reportRotec Engineering Rally 3 · Hooker, OKThe total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.NTSB ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.NTSB WPR26LA252Accident · Serious injuriesClass 4 · LimitedFinal reportFairchild M-62A · Greenleaf, IDThe pilot’s failure to maintain proper airspeed during approach and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.NTSB WPR26LA243Accident · No injuriesClass 4 · LimitedFinal reportValerie Westedt Zenith Zodiac 650B · Colorado Springs, COThe pilot’s improper flare which resulted in a hard landing and their subsequent loss control of during a go-around. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA26LA263Accident · Serious injuriesClass 4 · LimitedFinal reportRyan Navion A · Newport, NHThe pilot’s failure to attain an appropriate touchdown point, which resulted in a runway overrun.NTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…NTSB WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB WPR26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportBell 47G · Springtown, TXThe pilot’s failure to maintain clearance from trees while in a low hover.NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.NTSB WPR26LA240Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Santa Paula, CAThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB WPR26LA239Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · El Cajon, CAThe pilot's failure to maintain directional control during landing with a right crosswind,.NTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.NTSB ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.NTSB ERA26LA260Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Highgate, VTThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Morganton, NCThe pilot and flight instructor’s failure to maintain directional control while maneuvering on the runway, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to complete a positive exchange of flight control following…NTSB CEN26LA240Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Traverse City, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA236Accident · No injuriesClass 4 · LimitedFinal reportBeech C24R · Baton Rouge, LAThe pilot’s failure to extend the landing gear before landing.NTSB WPR26LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A · Minden, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB WPR26LA229Accident · Minor injuriesClass 4 · LimitedFinal reportRyan Navion · Bismarck, MOThe pilot’s failure to remove the maintenance spacer before takeoff, which resulted in restricted flight control movement and a loss of control.NTSB ERA26LA248Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe student pilot’s failure to ensure clearance while taxiing, which resulted in contact with another airplane that was performing an engine run-up.NTSB CEN26LA232Accident · Minor injuriesClass 4 · LimitedFinal reportRocky Mountain Kitplanes S-6S · Marvel, ARA partial blockage of the pitot static system that precluded the airspeed indicator from displaying the correct airspeed which led to the faster landing speed and bounced landing.NTSB WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR26LA230Accident · No injuriesClass 4 · LimitedFinal reportStephen Aberle Chipper CH-2A · Alva, OKThe pilot's decision to taxi the tailwheel-equipped airplane over uneven terrain while operating with limited forward visibility, which resulted in the left main landing gear entering a hole.NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB CEN26LA229Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Carbondale, ILThe flight instructor’s delayed remedial action during the student pilot’s miscalculated landing flare which resulted in a hard landing and the nose landing gear collapsing.NTSB WPR26LA221Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glastar · Summer Lake, ORThe pilot's selection of an unsuitable landing area, which resulted in the airplane nosing over during the landing roll.NTSB CEN26LA225Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Meridian, MSThe total loss of power to both engines due to fuel exhaustion. Contributing to the accident was the pilot’s failure to verify the airplane’s fuel quantity before departure.NTSB ERA26LA278Accident · No injuriesClass 4 · LimitedFinal reportTextron 182T · Fredericksburg, VAThe pilot’s distraction during taxi, which resulted in a taxiway excursion.NTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.NTSB ERA26LA236Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC19-215 · Plymouth, NHThe pilot’s failure to maintain control of the airplane during an aborted landing attempt which resulted in an aerodynamic stall.NTSB ERA26LA237Accident · No injuriesClass 4 · LimitedFinal reportSinclair Pete Lancair ES · Youngstown, OHThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with an approach lighting system.NTSB ERA26LA234Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mayesville, SCThe pilot’s failure to remain clear of a power line during an aerial application flight.NTSB ERA26LA245Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft DCO-65 · Renovo, PAThe pilot’s failure to maintain control during an off-airport landing.