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 GAA17CA226Accident · Minor injuriesData collectionFinal reportCessna 210 · Santa Teresa, NMThe pilot’s improper landing flare, which resulted in a hard, porpoised landing and subsequent nose-over.NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB ERA17CA149Accident · Serious injuriesData collectionFinal reportNorth American T 6G · Culpepper, VAThe pilot's failure to maintain airplane and directional control during the landing roll and subsequent go-around in gusting wind conditions.NTSB WPR17FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-310P · Harrisburg, ORAn encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.NTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.NTSB ERA17LA151Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Atlanta, GAThe pilot's diverted attention during the landing approach, which resulted in his failure to configure the landing gear and a subsequent a gear-up landing.NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.NTSB CEN17FA147Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Oxford, IAThe failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB CEN17LA148Accident · No injuriesLimited investigationFinal reportCessna T210M · Detroit Lakes, MNThe malfunction of the right main landing gear actuator for reasons that could not be determined because postaccident examination revealed no mechanical anomalies that would have precluded normal operation. Contributing to the accident was the improper…NTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.NTSB ERA17FA145Accident · 1 fatalField investigationFinal reportPipistrel Virus SW · Micanopy, FLThe pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup.NTSB GAA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Twisp, WAThe pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.NTSB ERA17FA144Accident · 1 fatalField investigationFinal reportBuckeye Dream Machine · Knoxville, TNThe pilot's decision to maneuver the aircraft at low altitude, towards rising terrain, which resulted in an inflight collision with trees.NTSB GAA17CA214Accident · Minor injuriesData collectionFinal reportRonald J Bender Baking Duce · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll after encountering a dirt devil.NTSB GAA17CA213Accident · No injuriesData collectionFinal reportIcon A5 · Key Largo, FLThe pilot’s failure to maintain a proper descent rate during the approach, which resulted in a hard landing.NTSB ERA17FA143Accident · 2 fatalField investigationFinal reportCessna 170B · Edgewater, FLThe Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.NTSB WPR17LA082Accident · Minor injuriesLimited investigationFinal reportOTT 601XL-B · The Dalles, ORA partial loss of engine power due to the reverse bending fatigue failure of the propeller hub bolts, which resulted from the bolts not fitting tightly into the propeller hub holes. Also causal was the pilot's decision to use improper bolts for this type of…NTSB CEN17LA144Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Wayne, INThe pilot receiving instruction’s failure to maintain airplane control during a crosswind landing in high gusting winds, and the flight instructor’s failure to maintain a proper airspeed and angle of attack during the go-around, which resulted in an…NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB GAA17CA212Accident · No injuriesData collectionFinal reportThomas Craig E Wittman W-10 · Stevensville, MTThe pilot’s decision to take off with a known master brake cylinder leak and his subsequent failure to maintain directional control during landing.NTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA17FA140Accident · 2 fatalField investigationFinal reportBeech A36 · Dadeville, ALA loss of engine power for reasons that could not be determined due to postcrash thermal damage to the engine accessories and the airframe. Contributing to the accident was the pilot's failure to navigate to any of the available forced landing sites within…NTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.NTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.NTSB GAA17CA204Accident · Minor injuriesData collectionFinal reportCessna 170 · Death Valley, CAThe pilot’s improper compensation for crosswind conditions during the landing flare and his subsequent failure to maintain directional control during the landing.NTSB ERA17CA137Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Cleveland, TNThe flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.NTSB GAA17CA208Accident · No injuriesData collectionFinal reportDempsey Daniel M Zodiac CH601XLB · Louisa, VAThe pilot’s in-flight fuel mismanagement and subsequent failure to maintain adequate airspeed while attempting to land on the runway, which resulted in an aerodynamic stall and a hard landing.NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB GAA17CA202Accident · Minor injuriesData collectionFinal reportCessna 182 · Mackay, IDThe pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.NTSB ERA17FA136Accident · 4 fatalField investigationFinal reportCessna T210 · Hayden, ALThe pilot's decision to continue the flight into known adverse weather conditions, which resulted in spatial disorientation and a subsequent loss of airplane control and in-flight breakup.NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.NTSB ERA17FA135Accident · 1 fatalField investigationFinal reportCessna 500 · Marietta, GAThe pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…NTSB CEN17FA138Accident · 1 fatalField investigationFinal reportBeech V35 · Union City, OKThe pilot's improper recovery from a spin.NTSB GAA17CA206Accident · No injuriesData collectionFinal reportCessna 172 · Timberlake, NCThe student pilot’s failure to maintain pitch control during the landing flare with a tailwind, which resulted in a propeller strike.NTSB WPR17LA080Accident · No injuriesLimited investigationFinal reportMaxcy Christopher L Stol King · Bozeman, MTThe pilot's failure to maintain directional control during landing.NTSB GAA17CA201Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot’s use of excessive airspeed during the approach, which resulted in a bounced, hard landing and subsequent loss of directional control during an attempted go-around.NTSB GAA17CA200Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Ketchikan, AKThe floatplane pilot's failure to avoid a buoy during takeoff.NTSB ERA17LA134Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · Islip, NYThe pilot's failure to lower the landing gear before touchdown, which resulted in the gear-up landing.