NTSB investigations

19,222 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.

NTSB GAA17CA426Accident · No injuriesData collectionFinal reportCessna 170 · Friday Harbor, WAThe pilot’s loss of directional control during landing.Jul 11, 2017 · N2714D · Substantial damageNTSB GAA17CA404Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · King Vale, CAThe pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.Jul 11, 2017 · N357PJ · Substantial damageNTSB ERA17LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210L · Wilkes-Barre/Scranton, PAFailure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.Jul 11, 2017 · N732FJ · Substantial damageNTSB GAA17CA406Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wilkes-Barre, PAThe flight instructor's delayed remedial action to maintain helicopter altitude during hover flight instruction, which resulted in the helicopter skid contacting a crack in the runway and a dynamic rollover.Jul 10, 2017 · N2336J · Substantial damageNTSB WPR17LA147Accident · No injuriesLimited investigationFinal reportCessna 180 · Baker City, ORThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning.Jul 9, 2017 · N4683B · Substantial damageNTSB GAA17CA448Accident · No injuriesData collectionFinal reportCessna 172 · Manassas, VAThe student pilot’s improper landing flare, which resulted in a porpoised landing.Jul 9, 2017 · N80399 · Substantial damageNTSB CEN17LA265Accident · Minor injuriesLimited investigationFinal reportCubcrafters CC11-160 · Milesville, SDFuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…Jul 9, 2017 · N111JW · Substantial damageNTSB ANC17LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKA total loss of engine power due to fuel starvation for undetermined reasons.Jul 9, 2017 · N2429C · Substantial damageNTSB WPR17LA145Accident · Serious injuriesLimited investigationFinal reportPiper L 21B · Big Timber, MTThe pilot's decision to fly at low altitude in the vicinity of power lines, which resulted in a wire strike.Jul 8, 2017 · N99031 · Substantial damageNTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…Jul 8, 2017 · N2812NTSB GAA17CA474Accident · No injuriesData collectionFinal reportCessna 210 · Bettles, AKThe pilot's failure to maintain an appropriate glidepath during the approach to the runway over glassy water and in glaring sun conditions.Jul 8, 2017 · N9664X · DestroyedNTSB GAA17CA396Accident · No injuriesData collectionFinal reportChampion 7KCAB · Cottonwood, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 8, 2017 · N5195X · Substantial damageNTSB ERA17CA236Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Lake Ashby, FLThe pilot's incorrect configuration of the landing gear for a water landing in an amphibious airplane, which resulted in a nose-over.Jul 8, 2017 · N796SR · Substantial damageNTSB DCA17IA148Incident · No injuriesClass 1 · IncidentFinal reportAirbus A320-211 · San Francisco, CAThe flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…Jul 8, 2017 · C-FKCK · No damageNTSB CEN17LA286Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Walters, OKMaintenance personnel’s installation of an improper vacuum pump gasket, which resulted in oil starvation to the engine and a subsequent total loss of engine power.Jul 8, 2017 · N6257V · Substantial damageNTSB CEN17LA267Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ireland, INThe pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.Jul 8, 2017 · N7224U · DestroyedNTSB CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.Jul 8, 2017 · N793MA · DestroyedNTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.Jul 7, 2017 · N333GK · Substantial damageNTSB GAA17CA418Accident · No injuriesData collectionFinal reportPiper PA32 · San Antonio, TXThe pilot’s failure to extend the landing gear before touchdown.Jul 7, 2017 · XB-BNH · Substantial damageNTSB GAA17CA401Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Paoli, INThe pilot's decision to maneuver an overgross weight helicopter at a low altitude and airspeed with a gusting tailwind, which resulted in a high descent rate and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to…Jul 7, 2017 · N3203D · Substantial damageNTSB GAA17CA400Accident · No injuriesData collectionFinal reportRitter John I S D S C · Kemmerer, WYThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.Jul 7, 2017 · N599JR · Substantial damageNTSB GAA17CA399Accident · No injuriesData collectionFinal reportCessna 170B · Pine Bluff, ARThe pilot’s failure to maintain directional control during the landing roll.Jul 7, 2017 · N2811C · Substantial damageNTSB GAA17CA397Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Ahoskie, NCThe pilot's failure to maintain proper lateral/bank control during the landing in gusting wind conditions, which resulted in a nose-over into water.Jul 7, 2017 · N253BC · Substantial damageNTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.Jul 7, 2017 · N650HP · Substantial damageNTSB ERA17LA278Accident · No injuriesLimited investigationFinal reportPiper PA28 · Gainsville, GAThe separation of the mixture control cable from the mixture control lever at the carburetor, which resulted in the partial loss of engine power.Jul 7, 2017 · N6653J · Substantial damageNTSB ERA17LA235Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Greenwood, SCThe pilots' inadequate preflight inspection, during which they failed to adequately verify the quantity of fuel, which resulted in fuel exhaustion, a subsequent total loss of power to both engines, and a forced landing into trees. Contributing to the accident…Jul 7, 2017 · N337J · Substantial damageNTSB ERA17LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cape Coral, FLA total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.Jul 7, 2017 · N2492U · Substantial damageNTSB WPR17LA143Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ronan, MTThe pilot's failure to maintain adequate airspeed, which resulted in a loss of tail rotor effectiveness during a low-altitude orbiting maneuver and a subsequent hard landing.Jul 6, 2017 · N442DR · Substantial damageNTSB GAA17CA403Accident · No injuriesData collectionFinal reportLuscombe 8 · Grand Island, NEThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.Jul 6, 2017 · N45609 · Substantial damageNTSB ERA17FA232Accident · 1 fatalField investigationFinal reportMorrisey 2150A · Honesdale, PAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's use of two psychoactive substances, which led to his impaired decision to attempt to takeoff after engine issues became evident.Jul 6, 2017 · N917JL · Substantial damageNTSB CEN17LA264Accident · No injuriesLimited investigationFinal reportBell 47D1 · Big Lake, MNThe failure of the metal core assembly within a wooden main rotor blade due to undetected corrosion and fatigue, which caused the wooden blade to separate from the rotor mast.Jul 6, 2017 · N153B · Substantial damageNTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.Jul 5, 2017 · N4207J · Substantial damageNTSB GAA17CA392Accident · No injuriesData collectionFinal reportPiper PA22 · Berlin, NHThe pilot’s failure to maintain directional control during the landing roll.Jul 5, 2017 · N6936B · Substantial damageNTSB GAA17CA386Accident · Minor injuriesData collectionFinal reportAlexander Schleicher ASH 31 MI · Ely, NVThe pilot’s failure to maintain the proper airspeed and his exceedance of the glider’s critical angle of attack, which resulted in a stall/spin.Jul 5, 2017 · N31MX · DestroyedNTSB CEN17LA322Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hamilton, OHThe pilot's loss of directional control after landing for reasons that could not be determined because an examination of the airplane did not reveal any anomalies that would have precluded normal operation.Jul 5, 2017 · N17XK · Substantial damageNTSB CEN17LA271Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Rushville, INThe pilot’s inability to properly control engine power because of an improperly installed throttle control arm, which resulted in a partial loss of engine power and led to a forced landing.Jul 5, 2017 · N112DE · Substantial damageNTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 5, 2017 · N3225T · Substantial damageNTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.Jul 5, 2017 · CGBFY · Substantial damageNTSB WPR17LA141Accident · No injuriesLimited investigationFinal reportVickers Supermaine Ltd · Marana, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jul 4, 2017 · N5TF · Substantial damageNTSB GAA17CA384Accident · Minor injuriesData collectionFinal reportCessna P210 · Willits, CAThe pilot’s failure to maintain directional control while landing in gusting wind conditions. Contributing to the accident was the pilot’s failure to go around after the unstabilized approach.Jul 4, 2017 · N66NF · Substantial damageNTSB GAA17CA383Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Easton, PAThe pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.Jul 4, 2017 · N3025J · Substantial damageNTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.Jul 4, 2017 · N272WY · Substantial damageNTSB ERA17LA227Accident · No injuriesLimited investigationFinal reportPiper PA28 · San Juan, PRA partial loss of engine power during initial climb for reasons that could not be determined and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2017 · N9427J · Substantial damageNTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.Jul 4, 2017 · N45851 · Substantial damageNTSB ERA17CA245Accident · No injuriesData collectionFinal reportCessna 180 · Nashua, NHThe pilot's failure to maintain directional control during the landing roll.Jul 4, 2017 · N9961N · Substantial damageNTSB CEN17LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · El Paso, TXA partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.Jul 4, 2017 · N24LF · Substantial damageNTSB GAA17CA578Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Eagle Grove, IAThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.Jul 3, 2017 · N711NN · Substantial damageNTSB GAA17CA421Accident · No injuriesData collectionFinal reportAviat A 1 · Dixie, IDThe pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.Jul 3, 2017 · N368HY · Substantial damageNTSB GAA17CA389Accident · No injuriesData collectionFinal reportCessna 172 · Shreveport, LAThe student’s improper landing flare, which resulted in a hard landing.Jul 3, 2017 · N2173Z · Substantial damageNTSB GAA17CA379Accident · No injuriesData collectionFinal reportAmerican General Acft AG5 · Rio Vista, CAThe student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.Jul 3, 2017 · N321MW · Substantial damage