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 GAA16CA168Accident · No injuriesData collectionFinal reportHughes 369 · Jamestown, NDThe pilot's excessive descent rate while flaring during a practice autorotation with a power recovery, which resulted in an impact with terrain.NTSB GAA16CA165Accident · Minor injuriesData collectionFinal reportBell 206B · Hanford, CAThe pilot's decision to release the collective while flying at 10 feet above ground level, resulting in the rapid helicopter descent and impact with terrain.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB GAA16CA163Accident · No injuriesData collectionFinal reportEnstrom F280 · Sodus, NYThe pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…NTSB GAA16CA162Accident · No injuriesData collectionFinal reportPiper PA24 · Homestead, FLThe pilots decision to hand prop the airplane's engine without securing the airplane, resulting a runaway airplane and collision with a fence.NTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.NTSB ERA16FA140Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Enterprise, ALThe pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…NTSB CEN16LA137Accident · Serious injuriesLimited investigationFinal reportMatthews H Thomas Jodel F11 A · Marathon, TXThe pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.NTSB CEN16LA134Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Stephenville, TXThe loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB GAA16CA166Accident · Minor injuriesData collectionFinal reportPiper J5A · Lake Harbor, FLThe pilot's exceedance of the critical angle of attack while maneuvering at low altitude, which resulted in an accelerated aerodynamic stall, spin, and impact with terrain.NTSB CEN16LA135Accident · Serious injuriesLimited investigationFinal reportBrantly B 2B · Galena, MOThe pilot’s loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA169Accident · Minor injuriesData collectionFinal reportAmerican Legend AL3 · Monticello, GAThe pilot's decision to land with a quartering tail wind, and failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with a tree.NTSB ERA16LA139Accident · 1 fatalLimited investigationFinal reportHall, Wendall W Harmon Rocket II · Cheraw, SCThe pilot's decision to fly at low altitude, which resulted in a collision with power lines.NTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.NTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.NTSB GAA16CA159Accident · No injuriesData collectionFinal reportCessna 152 · Valparaiso, INThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA158Accident · No injuriesData collectionFinal reportCessna 172 · Frederick, MDThe student pilot's improper pitch control during the landing flare, which resulted in a hard bounced landing.NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB WPR16FA086Accident · 1 fatalField investigationFinal reportAirborne XT 912 · Hawthorne, CAThe weight shift control aircraft encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the accident pilot's failure to recognize the potential for a wake…NTSB GAA16CA156Accident · No injuriesData collectionFinal reportRolladen-Schneider LS8 · Pine Grove, PAThe pilot's inability to maintain the glider's descent rate and glide path after encountering a downdraft, resulting in a collision with trees during an off airport landing.NTSB GAA16CA157Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…NTSB GAA16CA161Accident · No injuriesData collectionFinal reportBeech 58 · Huntsville, ALThe pilot's failure to extend the landing gear prior to touchdown resulting in a landing with the landing gear retracted and consequent substantial damage.NTSB GAA16CA153Accident · Serious injuriesData collectionFinal reportBarnes Thomas A Vans · Bolingbrook, ILThe pilot's failure to maintain direction control during the takeoff roll, which resulted in runway excursion, collision with terrain, and nose over.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.NTSB ERA16CA134Accident · Minor injuriesData collectionFinal reportEichhorn Gary L Skyraider I · Erwin, NCThe pilot's inadequate compensation for the wind which resulted in a loss of directional control.NTSB CEN16CA126Accident · No injuriesData collectionFinal reportNakajima A6M2 Model 21 · Midland, TXThe Goodyear pilot did not see and avoid the Nakajima ahead on the taxiway.NTSB ERA16LA131Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Rome, GAThe pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.NTSB WPR16LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, UTThe pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.NTSB WPR16FA084Accident · 4 fatalField investigationFinal reportCessna 182A · Alpine, WYThe noninstrument-rated pilot's failure to maintain airspeed during the initial climb in dark night conditions with no visual reference, which resulted in a stall and collision with terrain.NTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.NTSB ERA16CA128Accident · Serious injuriesData collectionFinal reportCessna 180 · South Burlington, VTThe pilot's failure to maintain airplane control during takeoff roll, which resulted in a nose over.NTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.NTSB GAA16CA149Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · Brigham City, UTLoss of directional control during landing, due to nose landing gear damage sustained in the prior takeoff, resulting in a runway excursion and nose over.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…NTSB CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…NTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.NTSB CEN16FA122Accident · 2 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Española, NMThe pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.NTSB GAA16CA148Accident · No injuriesData collectionFinal reportRemos G 3/600 · Chesapeake, OHThe pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.NTSB ERA16LA126Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20 · Pottstown, PAThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.NTSB GAA16CA187Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe failure of the student pilot to maintain pitch control while landing, which resulted in a hard landing, loss of directional control, and runway excursion.NTSB ERA16CA125Accident · No injuriesData collectionFinal reportPiper PA 22-108 · Lincolnton, NCThe non-certificated pilot's loss of directional control while landing.NTSB WPR16LA080Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache · Queen Creek, AZA loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…NTSB GAA16CA145Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Canton, TXThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.