NTSB investigations
19,218 cases where NTSB found Aircraft.
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\", '01')) 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", '01')) 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 CEN26LA153Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Arlington, TXThe pilot’s failure to maintain clearance from terrain during the hover taxi.NTSB CEN26LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Beloit, KSThe pilot’s failure to maintain directional control during the landing with a quartering headwind. Contributing to the accident was the pilot’s runway selection based on the variable and gusting wind conditions.NTSB WPR26LA144Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Los Angeles, CAThe pilot’s failure to maintain adequate clearance from a jet blast fence during taxi.NTSB ERA26LA151Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Block Island, RIMaintenance personnel’s failure to ensure that the throttle cable was properly secured to the carburetor, which resulted an inflight separation of the throttle cable and the pilots’ inability to control the engine.NTSB CEN26LA145Accident · No injuriesClass 4 · LimitedFinal reportClassic Waco YMF · Galveston, TXThe biplane pilot’s failure to maintain an adequate visual lookout while taxiing, which included the failure to perform S-turns to compensate for limited forward visibility.NTSB WPR26LA148Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Chula Vista, CAThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent runway excursion.NTSB WPR26LA137Accident · No injuriesClass 4 · LimitedFinal reportSalt Lake Gyrocopters Calidus · Fairfield, UTThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was nose wheel misalignment at touchdown.NTSB WPR26LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Chehalis, WAThe pilot’s improper recovery from a bounced landing, which resulted in a tail strike.NTSB WPR26LA138Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Mesa, AZThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB ERA26LA154Accident · Minor injuriesClass 4 · LimitedFinal reportBeech V35 · Saluda, SCThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, collision with a fence, and a hard landing .NTSB CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB CEN26LA144Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20 · Northlake, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR26LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Cottonwood, AZThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA26LA150Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Athens, GAThe pilot’s failure to extend the landing gear before landing.NTSB WPR26LA124Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Upland, CAThe pilot’s improper approach, which resulted in a long landing, runway excursion, and a nose over.NTSB ERA26LA147Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA24-180 · Leonardtown, MDThe pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB CEN26LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Solon Springs, WIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA146Accident · No injuriesClass 4 · LimitedFinal reportSchroder David Lancair IV-P · Feather Sound, FLThe pilot's failure to extend the landing gear before landing.NTSB DCA26LA151Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AC · Denver, COThe overstress failure of the left main landing gear lower drag brace links during takeoff which resulted in a runway excursion during landing due to the left main landing gear collapsing.NTSB WPR26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182M · Flagstaff, AZMaintenance personnel’s decision to conduct an engine run at takeoff power in front of an active taxiway, and their failure to notify ATC, which resulted in the accident pilot’s loss of control during taxi due to an encounter with a jet blast.NTSB ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA138Accident · Minor injuriesClass 4 · LimitedFinal reportGlasflugel Kestrel · Little Switzerland, NCA loss of thermal lift during a glider flight, which resulted in a collision with trees during a landing approach to a diversionary airport.NTSB CEN26LA134Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Sonora, TXThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.NTSB ERA26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Thonotosassa, FLThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB WPR26LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Carefree, AZThe pilot reported that he landed the tailwheel equipped airplane at a backcountry airstrip, and while taxiing on rough terrain, the tailwheel spring failed and the tailwheel assembly separated from the airplane. The pilot shut down the airplane and exited to…NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.NTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.NTSB ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA128Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Larose, LAThe pilot’s improper fuel planning and his failure to adequately monitor the fuel level during flight, which resulted in fuel exhaustion, and a total loss of engine power. Contributing to the accident was the pilot’s lack of attention performing the task,…NTSB CEN26LA133Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Denver, COThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing which resulted in substantial damage to the airplane.NTSB CEN26LA131Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Van Burensburg, ILPropeller separation due to failure of the propeller attachment bolts.NTSB ERA26LA130Accident · No injuriesClass 4 · LimitedFinal reportTextron 680A · Miami, FLThe flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.NTSB DCA26LA142Accident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Houston, TXThe captain’s inadvertent activation of the takeoff/go around switch at touchdown that caused an increase in the airplane pitch attitude that was not corrected before the lower fuselage contacted the runway.NTSB WPR26LA113Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing.NTSB DCA26LA139Incident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · College Park, GAThe captain’s inadequate compensation for gusting crosswind wind conditions while attempting to land and a subsequent go-around.NTSB CEN26LA125Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12IS · Appleton, WIThe pilot’s failure to maintain proper airspeed during landing and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the runway. Contributing to the accident was the flight instructor’s delayed…NTSB ERA26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Monroe, NCThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB CEN26LA124Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Glencoe, MNThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision of the flight.NTSB ERA26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Gettysburg, PAThe flight instructor’s failure to identify the excess power required to lift off from soft and muddy ground, which resulted in a loss of control and subsequent collision with a hangar during takeoff.NTSB CEN26LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Golden, MOThe pilot’s failure to establish stabilized approach that would have allowed the airplane to touch down with adequate runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around.NTSB CEN26LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Pottsboro, TXThe pilot’s failure to maintain control during the landing roll with a crosswind.NTSB ERA26LA119Accident · No injuriesClass 4 · LimitedFinal reportTabor W Coates AR-1 · Kissimmee, FLThe pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control.NTSB ERA26LA117Accident · No injuriesClass 4 · LimitedFinal reportBeech V35 · Gulf Shores, ALThe pilot’s failure to establish a positive rate of climb before retracting the landing gear, which resulted in abnormal runway contact during the takeoff roll.NTSB WPR26LA104Accident · No injuriesClass 4 · LimitedFinal reportAerosport Ikarus C42E · Wendover, UTThe pilot’s mismanagement of engine power during a maximum performance, 180° climbing left turn at a low altitude that resulted in impact with terrain.NTSB CEN26LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Antigo, WIThe pilot receiving instruction’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed remedial action.