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 CEN13LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rochester, MNThe pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…NTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.NTSB ERA13LA076Accident · 1 fatalLimited investigationFinal reportCassutt Sport Racer · Collegedale, TNImpact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.NTSB ERA13LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Albemarle, NCThe student pilot's failure to remain clear of the airplane’s rotating propeller.NTSB ERA13CA077Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Middletown, NYThe pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.NTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.NTSB CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.NTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.NTSB ERA13LA072Accident · Serious injuriesLimited investigationFinal reportHansen David Daniel RV-4 · Carthage, NCA partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13CA073Accident · No injuriesData collectionFinal reportBeech B19 · Fort Lauderdale, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.NTSB CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.NTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.NTSB CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.NTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…NTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB WPR13CA057Accident · Minor injuriesData collectionFinal reportHughes 369D · Sheridan, ORThe pilot’s failure to prevent the helicopter from entering a vortex ring state (settling with power) condition during an external load operation, which resulted in the helicopter’s main rotor blades impacting the truck.NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…NTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.NTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.NTSB WPR13FA061Accident · 3 fatalField investigationFinal reportPiper PA28 · Aurora, UTThe pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…NTSB CEN13LA072Accident · Serious injuriesLimited investigationFinal reportBeech S35 · DeRidder, LAA total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…NTSB WPR13LA060Accident · No injuriesLimited investigationFinal reportPiper PA30 · Phoenix, AZThe pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…NTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.NTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.NTSB CEN13CA077Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2S · Grain Valley, MOThe pilot's improper landing flare, which led to a bounced landing and subsequent loss of control.NTSB WPR13TA051Accident · Minor injuriesFinal reportEurocopter AS350B3 2B1 · Newfield, AZThe pilot's distraction while retrieving an item behind him while the helicopter was on the ground with the engine running, which led to his aggressive overapplication of the flight controls after experiencing a ground resonance condition and subsequent loss…NTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.NTSB WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.NTSB ERA13CA067Accident · Serious injuriesData collectionFinal reportRadley Vincent Quicksilver Sport 2S · King George, VAThe pilot’s failure to maintain directional control during taxi.NTSB CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.NTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…NTSB CEN13FA066Accident · 1 fatalField investigationFinal reportBrian P North RAF SE5A Replica · Watkins, COThe pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.NTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.NTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.NTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB CEN13LA062Accident · 1 fatalLimited investigationFinal reportJabiru USA Sport J250-SP · Jacksonville, TXThe pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.NTSB CEN13FA060Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Burlington, WIThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.NTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.NTSB WPR13GA044Accident · Minor injuriesFinal reportBell OH-58 · Altadena, CAThe landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…NTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB ERA13FA059Accident · 3 fatalField investigationFinal reportCessna 172N · Owls Head, METhe vehicle driver's failure to verify that the runway was not occupied by an airplane before crossing the runway, which resulted in the vehicle being struck by a departing airplane, and the pilot's continued takeoff with flight control damage, which…NTSB WPR13IA059Incident · No injuriesIncident investigationFinal reportBell 407 · Riverton, WYThe pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.NTSB WPR13FA041Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Morgan, UTThe pilot's inadequate preflight inspection, which resulted in frost remaining on the airplane's surfaces and led to its inability to produce enough lift to clear rising terrain.