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 CEN13FA351Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · La Pointe, WIThe pilot’s failure to maintain airplane control after deciding to go around after a gear-up landing, resulting in an aerodynamic stall.NTSB WPR13LA270Accident · No injuriesLimited investigationFinal reportAero Vodochody L39C · Reno, NVThe other pilot’s failure to see and avoid the airplane during an air race training session, which resulted in a midair collision.NTSB WPR13CA271Accident · No injuriesData collectionFinal reportCessna T210N · Salmon, IDThe pilot's decision to land on a wet grass airstrip, which resulted in a main landing gear collapse after a collision with rough terrain.NTSB ERA13LA285Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Oxford, NCThe failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation.NTSB ERA13CA286Accident · No injuriesData collectionFinal reportLuscombe 8A · Orangeburg, SCThe inadvertent slippage of the pilot's foot off the right rudder pedal, resulting in a loss of directional control on the ground, and the pilot's overly aggressive application of wheel brakes, resulting in a nose over.NTSB DCA13CA106Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Nashville, TNThe flight crews failure to maintain clearance from the light pole while taxiing.NTSB CEN13LA348Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.NTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.NTSB ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…NTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…NTSB ERA13CA283Accident · No injuriesData collectionFinal reportHughes TH-55A · Morgantown, WVThe pilot’s inadequate planning which resulted in an encounter with settling with power and descent into terrain during takeoff.NTSB WPR13CA268Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Truckee, CAThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions.NTSB CEN13LA339Accident · Serious injuriesLimited investigationFinal reportYoungs William D T211 · Festus, MOFuel exhaustion due to the pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power.NTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB CEN13FA338Accident · 1 fatalField investigationFinal reportPipistrel Alpha Trainer · Pampa, TXThe loss of engine power due to fuel exhaustion as a result of the manufacturer providing the incorrect Pilot’s Operating Handbook to the owner, which prevented the pilot from accurately calculating the fuel requirements before the flight. Contributing to the…NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN13CA343Accident · No injuriesData collectionFinal reportCessna 150G · Franklin, OHThe pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA276Accident · No injuriesLimited investigationFinal reportCessna 170 · Plainville, CTThe pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.NTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.NTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…NTSB ERA13CA284Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Ozark, ALThe student pilot’s failure to maintain control of the airplane during the aborted landing.NTSB CEN13FA331Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B3 · Grand Prairie, TXThe pilot receiving instruction's failure to maintain adequate airspeed during a simulated hydraulics failure training maneuver, which resulted in his loss of control of the helicopter and its subsequent impact with terrain, and the flight instructor's…NTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB WPR13LA267Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORThe pilot’s unstabilized approach and use of an excessive speed at touchdown, which resulted in a loss of directional control during the landing and a subsequent runway excursion.NTSB WPR13CA278Accident · No injuriesData collectionFinal reportCessna 180 · Nervino, CAThe pilot’s decision to takeoff from an area off the runway surface which resulted in a collision with an object.NTSB WPR13CA263Accident · Minor injuriesData collectionFinal reportGarland Avipro Bearhawk · Sheridan, WYThe pilot's failure to maintain airspeed, which resulted in a stall and a loss of aircraft control during the initial takeoff.NTSB ERA13FA273Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Manchester, KYThe pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.NTSB CEN13FA326Accident · 1 fatalField investigationFinal reportHawker Beechcraft B200GT · Baker, LAThe pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.NTSB CEN13FA324Accident · 1 fatalField investigationFinal reportWeatherly 620B · Ludlow, SDThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was task- and/or work-related fatigue.NTSB CEN13CA345Accident · Minor injuriesData collectionFinal reportCessna 140 · Minot, NDThe pilot's failure to maintain aircraft control during takeoff.NTSB WPR13FA264Accident · Minor injuriesField investigationFinal reportRobinson Helicopter R44 II · Los Angeles, CAThe pilot’s loss of helicopter control following a precautionary landing, which resulted in a dynamic rollover.NTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB CEN13LA321Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Abbeville, LAFailure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.NTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.NTSB ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA13CA271Accident · No injuriesData collectionFinal reportFlight Design Ctls · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.NTSB ANC13CA109Accident · No injuriesData collectionFinal reportPiper PA 16 · Glennallen, AKThe pilot's loss of control during the initial climb after takeoff, resulting in a collision with trees.NTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.NTSB ERA13LA269Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Elkton, KYThe pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.NTSB CEN13CA317Accident · No injuriesData collectionFinal reportStinson 108 · Lebanon, INThe pilot did not maintain control of the airplane during the landing roll.NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB ANC13FA054Accident · 1 fatalField investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Petersburg, AKThe pilot’s failure to maintain adequate altitude above the trees, and his subsequent failure to maintain adequate airspeed while maneuvering to avoid the trees, which resulted in an inadvertent aerodynamic stall/spin and an uncontrolled descent.NTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.NTSB ERA13CA278Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · West Palm Beach, FLThe pilot’s diversion of attention while taxiing the airplane, which resulted in his failure to maintain directional control and collision with a ditch.NTSB CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.NTSB CEN13CA312Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILImproper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.NTSB WPR13CA257Accident · Serious injuriesData collectionFinal reportCessna 182P · Bridgeport, CAThe pilot's distracted attention while on final approach which resulted in his failure to maintain adequate airspeed and subsequent loss of aircraft control.NTSB CEN13CA336Accident · Minor injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Corona, NMThe pilot's failure to maintain aircraft control while ridge-soaring in gusty wind conditions.