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 CEN18LA290Accident · Minor injuriesLimited investigationFinal reportBell 206 · Todd Mission, TXThe passenger’s inadvertent interference with the tail rotor pedals, which resulted in a loss of helicopter control during takeoff and the subsequent impact with terrain.NTSB CEN18LA286Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Coldwater, KSThe pilot's loss of control while landing a tailwheel-equipped airplane in gusting wind conditions.NTSB CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.NTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…NTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.NTSB GAA18CA437Accident · No injuriesData collectionFinal reportCessna 180 · Bozeman, MTThe pilot's failure to maintain directional control during landing.NTSB GAA18CA432Accident · No injuriesData collectionFinal reportPiper PA28 · Oregon, WIThe pilot's improper decision to take off with a known brake malfunction, which resulted in a collision with a barn during landing on a wet runway.NTSB GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.NTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.NTSB GAA18CA428Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's improper landing flare, which resulted in a bounced landing.NTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.NTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.NTSB CEN18LA276Accident · No injuriesLimited investigationFinal reportBeech V35 · Katy, TXMaintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.NTSB GAA18CA424Accident · No injuriesData collectionFinal reportBell 206 · New Castle, INThe pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…NTSB GAA18CA422Accident · No injuriesData collectionFinal reportPiper PA18S · Palmer, AKThe pilot's failure to maintain pitch control during the landing roll.NTSB ANC18CA054Accident · Minor injuriesData collectionFinal reportCurtiss Wright C46 · Manley Hot Springs, AKThe pilot's failure to attain the proper touchdown speed and his decision to land with a tailwind without ensuring that there was adequate runway length for the touchdown.NTSB GAA18CA423Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Lowville, NYThe pilot’s failure to maintain a proper airspeed during the approach to land, which resulted in an aerodynamic stall.NTSB CEN18FA267Accident · 2 fatalField investigationFinal reportKolb Twinstar · La Porte, TXThe pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.NTSB WPR18LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCassutt Iiim · Rosamond, CAThe pilot's failure to maintain adequate airspeed during a low-altitude maneuver after a partial loss of engine power, which resulted in exceedance of the airplane’s critical angle of attack and a subsequent accelerated stall. Contributing to the accident was…NTSB WPR18CA213Accident · No injuriesData collectionFinal reportCessna E162 · Burlington, WAThe student pilot’s failure to maintain pitch control during an aborted takeoff.NTSB GAA18CA442Accident · No injuriesData collectionFinal reportChampion 7GC · Warren, ARThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA426Accident · No injuriesData collectionFinal reportPiper PA 20 · Dayton, OHThe pilot's inadequate compensation for variable crosswind conditions during landing, which resulted in a runway excursion.NTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA18LA192Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stewartstown, PAThe pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.NTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.NTSB GAA18CA425Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA18LA191Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Geneseo, NYThe pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow…NTSB WPR18LA197Accident · No injuriesClass 3 · LimitedFinal reportBeech 90 · Tolani Lake, AZAn autopilot deviation during climb for undetermined reasons, which resulted in an in-flight upset and loss of airplane control. Contributing to the accident was the pilot’s failure to adequately monitor flight systems due to a distraction.NTSB ERA18FA189Accident · 1 fatalField investigationFinal reportRutan Defiant · Plainville, CTThe pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.NTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…NTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…NTSB CEN18FA265Accident · 1 fatalField investigationFinal reportRose Parrakeet A-1 · Rhome, TXThe pilot's exceedance of the airplane's critical angle of attack after takeoff, which resulted in an aerodynamic stall.NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.NTSB GAA18CA418Accident · No injuriesData collectionFinal reportPiper PA28R · Houston, TXThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…NTSB GAA18CA415Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · De Land, ILThe pilot’s selection of unsuitable terrain for landing in crosswind conditions, which resulted in the airplane inadvertently becoming airborne and a subsequent hard landing and loss of directional control.NTSB GAA18CA408Accident · No injuriesData collectionFinal reportRobinson R44 · Rulo, NEThe pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation.NTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB ANC18FA053Accident · Serious injuriesField investigationFinal reportDe Havilland DHC 3 · Hydaburg, AKThe pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA18CA434Accident · No injuriesData collectionFinal reportClassic Waco · North Myrtle Beach, SCThe pilot's failure to maintain directional control during landing in a left quartering headwind.NTSB GAA18CA430Accident · No injuriesData collectionFinal reportRobinson R44 · Okawville, ILThe pilot's improper preflight weight and balance calculation, which resulted in his operating the helicopter over its maximum gross takeoff weight and in its subsequent failure to climb.NTSB GAA18CA413Accident · No injuriesData collectionFinal reportBeech T34 · Dallas, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…NTSB GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.NTSB ERA18LA188Accident · 1 fatalLimited investigationFinal reportNorthwing 17 · Section, ALThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during an aborted landing. Contributing to the accident was the pilot's lack of flight experience in the aircraft.NTSB GAA18CA498Accident · No injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot's improper landing flare, which resulted in a bounced landing.