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 WPR13LA215Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Somerton, AZThe pilot's failure to maintain aircraft control while maneuvering at a low altitude in dark night conditions, which resulted in collision with terrain. Contributing to the accident was the pilot's fatigue due to his working at a time when he normally would…NTSB ERA13LA229Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAThe pilot’s loss of glider control due to improper rigging of the rudder control cables, the mechanic’s inadequate flight control checks following the glider’s most recent annual inspection, and the pilot’s failure to perform a thorough preflight inspection.NTSB ERA13FA227Accident · 2 fatalField investigationFinal reportNewgent, Barry S6S · Suffolk, VAThe pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…NTSB ERA13CA231Accident · No injuriesData collectionFinal reportCessna 182G · Arcadia, NYThe pilot's improper decision to continue a high approach with a tailwind, rather than perform a go-around, which resulted in an overrun on a wet, down-sloping, grassy runway.NTSB ANC13CA042Accident · Minor injuriesData collectionFinal reportCessna 207A · Newtok, AKThe pilot's continued flight into adverse weather and his failure to maintain clearance from terrain while on approach in flat light conditions. Contributing to the accident was the pilot's delayed decision to initiate a go-around.NTSB WPR13LA217Accident · No injuriesLimited investigationFinal reportRobinson R44 II · Pomeroy, WAThe pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…NTSB WPR13CA220Accident · No injuriesData collectionFinal reportAdolphson CCK-1865 · Bellingham, WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA13FA225Accident · 1 fatalField investigationFinal reportGrumman G-44 · Catskill, NYThe pilot’s misjudgment of the airplane’s altitude above the water and early flare for a landing on water with a glassy condition, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA13CA228Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Brogue, PAThe flight instructor's inadequate supervision of the student pilot during takeoff, which resulted in a collision with a power line.NTSB CEN13CA268Accident · Minor injuriesData collectionFinal reportHook Zodiac CH-650 · Gainesville, MOThe pilot misjudged the landing approach, which resulted in the airplane hitting a tree.NTSB WPR13CA253Accident · No injuriesData collectionFinal reportSchweizer 300C · Hamilton, MTThe student pilot’s failure to maintain helicopter control during a practice autorotation and the flight instructor's delayed remedial action.NTSB DCA13FA082Accident · No injuriesField investigationFinal reportEmbraer EMB-145LR · Newark, NJthe failure of flight 908's captain to ensure adequate clearance between the wingtip of his airplane and flight 4226's empennage when he attempted to pass behind the other airplane.NTSB CEN13LA254Accident · Serious injuriesLimited investigationFinal reportMason Robert Kolb Mark 3X · Lawrence, KSThe noncertificated pilot’s improper decision to depart with a tailwind.NTSB CEN13LA252Accident · No injuriesLimited investigationFinal reportCessna P210N · Saint Louis, MOThe pilot's failure to extend the landing gear or check that it was in the down position before landing.NTSB CEN13LA249Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Covington, LAThe pilot’s failure to maintain airspeed during a banner towing operation, which resulted in the airplane stalling and landing hard.NTSB CEN13CA251Accident · No injuriesData collectionFinal reportAlexander Duane A RV-8 · Cortland, OHThe pilot’s failure to maintain control of the airplane after encountering an unexpected soft spot in the runway during landing.NTSB CEN13CA250Accident · No injuriesData collectionFinal reportBeech A36 · Ingalls, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ANC13CA041Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Anaktuvuk Pass, AKThe pilot's failure to maintain lateral control while hovering over an area of snow-covered terrain, in flat light conditions, which resulted in a dynamic rollover.NTSB WPR13LA210Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Bryce, UTThe pilot's failure to establish the minimum liftoff speed during takeoff with the airplane over its maximum gross weight, which resulted in the airplane’s failure to climb and a subsequent loss of directional control and a runway excursion.NTSB WPR13FA211Accident · 2 fatalClass 3 · FieldFinal reportCessna 172RG · Calabasas, CAThe failure of the pilots in both aircraft to maintain an adequate visual lookout, which resulted in a midair collision.NTSB ERA13FA219Accident · 1 fatalField investigationFinal reportDaniels Dominator · Valkaria, FLThe pilot’s failure to maintain adequate power and airspeed, which resulted in a loss of control, abrupt descent, and impact with terrain. Contributing to the accident was the pilot’s failure to obtain adequate experience in the gyroplane before making the…NTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…NTSB WPR13LA209Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVThe pilot’s inadequate preflight planning, including operating in excess of the maximum certified gross weight and center of gravity limits at a high density altitude, which resulted in the airplane’s inability to maintain a positive rate of climb after…NTSB ERA13LA221Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Hoosick Falls, NYThe failure of the left wing attachment bracket weld due to inadequate welding by unknown maintenance personnel.NTSB ERA13CA216Accident · No injuriesData collectionFinal reportCessna 180 · Bethel, METhe pilot’s failure to maintain directional control during landing.NTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13FA241Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Norfolk, NEThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid power lines.NTSB CEN13CA246Accident · No injuriesData collectionFinal reportCessna 172N · New Orleans, LAThe pilot's failure to perform a steep climb before going around following a low pass for a banner tow pickup.NTSB ANC13CA039Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Seward, AKThe pilot’s decision to land on an unsuitable landing surface, which resulted in a nose over.NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB ERA13FA215Accident · 1 fatalField investigationFinal reportSchweizer SGS 2-32 · Shirley, NYThe pilot’s failure to maintain airspeed during final approach, which resulted in a stall. Contributing to the accident was the pilot’s likely impairment due to an over-the-counter sedating antihistamine.NTSB CEN13LA244Accident · 1 fatalLimited investigationFinal reportDean Leslie N Highlander · Bryan, OHThe pilot's failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN13CA247Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Owatonna, MNThe pilot’s loss of directional control during an aborted landing.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.NTSB ERA13CA218Accident · Serious injuriesData collectionFinal reportCessna 172P · Davis, WVThe pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.NTSB WPR13TA205Accident · No injuriesFinal reportBell BHT407 · Big Fork, MTThe pilot’s failure to maintain helicopter control while maneuvering over mountainous terrain in strong up/downdrafts and possible mountain wave activity, which resulted in a loss of tail rotor effectiveness.NTSB ERA13CA222Accident · No injuriesData collectionFinal reportCirrus Design SR22T · Milledgeville, GAThe student pilot’s failure to maintain a proper approach path for landing and the flight instructor’s delayed remedial action, which resulted in a runway undershoot and collision with a taxiway sign.NTSB CEN13IA270Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Clearwater, FLThe failure of the nose landing gear steering manifold during landing, which resulted in an uncommanded and uncontrollable right turn, and the overhaul facility’s improper overhaul of the nose landing gear steering manifold.NTSB CEN13CA238Accident · No injuriesData collectionFinal reportEnstrom F-28C · Lanesboro, IAThe pilot’s failure to maintain control of the helicopter while making an off-airport landing with a gusty tailwind.NTSB WPR13CA206Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe failure of the flight instructor and the pilot receiving instruction to recognize before entering the flare that the wind had shifted to a tailwind and terminate the practice autorotation.NTSB ERA13CA230Accident · No injuriesData collectionFinal reportCessna 152 · Americus, GAThe pilot’s delayed decision to terminate the practice approach during a simulated loss of engine power maneuver, which resulted in an inadvertent collision with utility wires.NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB ERA13LA212Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-225 · Chester Springs, PAThe pilot's failure to extinguish the burner pilot lights prior to a hard landing in windy conditions.NTSB CEN13CA236Accident · No injuriesData collectionFinal reportCessna T182T · Colorado Springs, COThe pilot’s improper recovery from a bounced landing.NTSB WPR13LA203Accident · 1 fatalLimited investigationFinal reportHoffman RV-4 · Bullhead City, AZThe pilot’s suicidal act.NTSB WPR13CA204Accident · No injuriesData collectionFinal reportBell 206B · Wells, NVThe pilot's failure to maintain clearance from an obstacle while maneuvering at a low altitude.NTSB ERA13CA210Accident · No injuriesData collectionFinal reportCessna 172N · Stow, MAThe pilot’s failure to maintain directional control while landing in gusty wind conditions.NTSB CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.NTSB WPR13CA202Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Mesa, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.