NTSB investigations
19,005 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 WPR26LA231Accident · No injuriesClass 4 · LimitedFinal reportRans S-7 Courier · Wessington Springs, SDThe pilot’s failure to maintain directional control during landing and subsequent go-around with a gusty right crosswind.NTSB ERA26LA240Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Westminster, MDThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA229Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G36 · Danbury, CTThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB WPR26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Salem, ORThe pilot’s failure to extend the landing gear prior to landing.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB WPR26LA208Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Pasco, WAThe pilot’s inadvertent excessive braking during the landing roll, which resulted in a nose over.NTSB WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…NTSB CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB CEN26LA215Accident · No injuriesClass 4 · LimitedFinal reportEaa Acro Sport II · Sheridan, ARThe pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB CEN26LA209Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Jonesboro, ARThe student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an…NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA206Accident · No injuriesClass 4 · LimitedFinal reportPitts Special S-1S · Bartlesville, OKThe pilot’s failure to maintain control during the landing rollout and subsequent aborted landing.NTSB WPR26LA206Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cascade, IDThe pilot’s improper approach, which resulted in a faster than normal touchdown and subsequent runway overrun.NTSB ERA26LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Chesapeake, VAThe pilot’s improper decision to continue with an unstabilized approach, which resulted in a hard landing, loss of directional control, and collision with a runway marker light and sign.NTSB CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB CEN26LA203Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Fort Worth, TXThe flight instructor’s delayed remedial action and the student pilot’s failure to maintain helicopter control during hover.NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.NTSB ERA26LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Fitchburg, MAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.NTSB CEN26LA201Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172H · Berryville, ARThe pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.NTSB CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA196Accident · No injuriesClass 4 · LimitedFinal reportGuenther Glen A Searey LSX · Briarcliff, TXThe pilot's failure to maintain sufficient altitude and aircraft control during the base to final turn, which resulted in the airplane impacting the water. Contributing to the accident was reported downdraft wind conditions.NTSB WPR26LA203Accident · No injuriesClass 4 · LimitedFinal reportPzl-Swidnik PW-5 · Soap Lake, WAThe pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight.NTSB WPR26LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206-L4 · Cedar City, UTThe flight instructor's failure to maintain helicopter control while manipulating the engine governor reference rpm adjustment during hover operations, which resulted in a loss of control and impact with the ground.NTSB ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA198Accident · No injuriesClass 4 · LimitedFinal reportCommander 114TC · Woodruff, WIThe pilot’s failure to maintain airplane control during the go-around.NTSB CEN26LA195Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Littlefield, TXThe pilot's excessive approach speed, which resulted in a hard, bounced landing and nose-over.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB ERA26LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGranito Joseph R RV-7A · Jaffrey, NHThe pilot’s failure to maintain directional control of the airplane during landing, which resulted in a touchdown off the paved runway surface and a collision with terrain during the subsequent aborted landing.NTSB CEN26LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Northport, MIThe pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.NTSB CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.NTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB ERA26LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Statesville, NCThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.NTSB CEN26LA189Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Morris, ILThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.NTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB CEN26LA205Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Conroe, TXThe pilot’s failure to properly latch the canopy before flight, which led to the canopy opening shortly after takeoff.NTSB CEN26LA188Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Corpus Christi, TXThe pilot's failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN26LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot’s improper decision to attempt an intersection takeoff and delay to abort the takeoff which resulted in a subsequent runway excursion.NTSB CEN26LA185Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Dallas, TXThe pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.NTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.NTSB CEN26LA183Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Bennett, COThe pilot’s improper flare during landing that resulted in a hard landing.NTSB WPR26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Marysvale, UTThe pilot's failure to maintain clearance from trees while maneuvering in mountainous terrain prior to encountering a downdraft.