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 ERA16LA286Accident · Minor injuriesLimited investigationFinal reportCessna 177 · McDonough, NYThe pilot’s improper recovery from a slow flight configuration at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot’s decision to operate at low…Aug 8, 2016 · N30923 · DestroyedNTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.Aug 8, 2016 · N634LA · Substantial damageNTSB ANC16CA056Accident · No injuriesData collectionFinal reportBrian Turner Northern Explorer · Chickaloon, AKA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat.Aug 8, 2016 · N907BT · Substantial damageNTSB ERA16LA282Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · St. CroixThe flight instructor's improper recovery from a bounced landing, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.Aug 7, 2016 · N828BB · DestroyedNTSB ERA16LA281Accident · Serious injuriesLimited investigationFinal reportVans RV4 · Shelbyville, KYThe partial loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to effectively use carburetor heat.Aug 7, 2016 · N924WZ · Substantial damageNTSB CEN16CA321Accident · Serious injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Sparland, ILThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.Aug 7, 2016 · N17H · Substantial damageNTSB GAA16CA471Accident · No injuriesData collectionFinal reportPiper PA24 · Hillsboro, OHThe pilot's descent below the intended glidepath during the approach, which resulted in an impact with a ditch prior to the runway.Aug 6, 2016 · N7292P · Substantial damageNTSB GAA16CA422Accident · No injuriesData collectionFinal reportCessna 195 · Hillsborough, ORThe pilot's failure to attain a proper touchdown point and loss of directional control and her subsequent excessive brake application, which resulted in a nose-over.Aug 6, 2016 · N4026A · Substantial damageNTSB ERA16LA284Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8 · Northwood, NHThe balloon pilot’s inadequate weather planning and improper decision to depart in reported increasing variable winds with nearby thunderstorms, which resulted in a subsequent hard landing and a serious passenger injury.Aug 6, 2016 · N317W · No damageNTSB ERA16LA280Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Northampton, MAThe failure of the alternate air valve plate hinge pin, which caused the alternate air valve plate to lodge in the fuel servo assembly, which resulted in a restriction of air to the fuel servo assembly, a loss of engine power, and an off-airport emergency…Aug 6, 2016 · N3783M · Substantial damageNTSB CEN16FA308Accident · 1 fatalField investigationFinal reportPzl-Bielsko SZD 55-1 · Channahon, ILThe glider pilot's failure to maintain adequate pitch control while being towed and his subsequent failure to maintain adequate airspeed control after releasing from the towline, which resulted in the glider exceeding its critical angle of attack and an…Aug 6, 2016 · N551DR · Substantial damageNTSB CEN16FA307Accident · 1 fatalField investigationFinal reportWilson BUGATTI-DEMONGE 100P · Burns Flat, OKThe pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…Aug 6, 2016 · N110PX · DestroyedNTSB GAA16CA424Accident · No injuriesData collectionFinal reportStinson 108 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in runway excursion and nose-over.Aug 5, 2016 · N9250K · Substantial damageNTSB DCA16CA207Accident · No injuriesData collectionFinal reportBoeing 737 3H4 · Baltimore, MDthe tug operators excessive speed during pushback.Aug 5, 2016 · N368SW · Substantial damageNTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.Aug 5, 2016 · N323DC · Substantial damageNTSB CEN16LA332Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Miller, MOThe mechanic's improper installation of the left aileron swage fitting, which resulted in an inflight loss of control.Aug 5, 2016 · N6542Z · Substantial damageNTSB CEN16LA314Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley City, NDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 5, 2016 · N5599X · Substantial damageNTSB CEN16LA310Accident · 2 fatalLimited investigationFinal reportPiper PA-11 · Indianola, IAThe pilot's inadequate preflight planning, which resulted in the airplane being operated above its maximum gross weight, degraded its climb performance, and led to an aerodynamic stall during the initial climb.Aug 5, 2016 · N4707M · DestroyedNTSB CEN16LA306Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Russellville, OHA partial loss of engine power due to a fatigue crack of the No. 2 cylinder cooling fin, which resulted in failure of the No. 2 cylinder.Aug 5, 2016 · N10770 · Substantial damageNTSB GAA16CA423Accident · No injuriesData collectionFinal reportBeech F33 · Bivalve, MDThe pilot's excessive airspeed during landing, which resulted in a runway overrun, and impact with a ditch.Aug 4, 2016 · N90HF · Substantial damageNTSB CEN16LA313Accident · No injuriesLimited investigationFinal reportLiming Louis L HPL 1 High Wing Para · Mt. Orab, OHA partial loss of engine power due to a missing throttle cable fastener.Aug 4, 2016 · N9095U · Substantial damageNTSB ANC16CA051Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Homer, AKAn in-flight collision with a bird resulting in damage to a tail rotor blade, which required replacement.Aug 4, 2016 · N719TF · Substantial damageNTSB GAA16CA416Accident · No injuriesData collectionFinal reportCessna 172 · Palm Springs, CAThe student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.Aug 3, 2016 · N5203H · Substantial damageNTSB GAA16CA413Accident · Minor injuriesData collectionFinal reportCessna 172 · Cross Keys, NJThe pilot's failure to maintain lateral bank control during final approach, which resulted with an impact with a tree and substantial damage to the left and right wings.Aug 3, 2016 · N84371 · Substantial damageNTSB GAA16CA412Accident · No injuriesData collectionFinal reportCessna 120 · Belen, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a ground loop.Aug 3, 2016 · N72580 · Substantial damageNTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.Aug 3, 2016 · N2735A · DestroyedNTSB CEN16LA300Accident · Serious injuriesLimited investigationFinal reportWings AN Things Avid Flyer · Bluffton, INThe loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.Aug 3, 2016 · N430WT · Substantial damageNTSB CEN16FA304Accident · 1 fatalField investigationFinal reportSchweizer 269C 1 · Jeanerette, LAThe pilot's loss of helicopter control for reasons that could not be determined based on available evidence.Aug 3, 2016 · N1549W · Substantial damageNTSB ANC16CA050Accident · No injuriesData collectionFinal reportHolley Carol L Antares · North Pole, AKThe pilot's failure to maintain directional control of the weight-shift control airplane during the landing in a crosswind condition, which resulted in a runway excursion, a tip over of the wing, and a collision with terrain.Aug 3, 2016 · N8512Q · Substantial damageNTSB WPR16LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Weiser, IDA partial loss of engine power due to an internal catastrophic failure of the master rod crankpin bearing.Aug 2, 2016 · N23923 · Substantial damageNTSB WPR16LA156Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Prescott, AZThe flight instructor’s delayed remedial action to address a low rotor rpm condition, which resulted in an excessive descent rate and a subsequent hard landing.Aug 2, 2016 · N22UH · Substantial damageNTSB WPR16FA157Accident · 1 fatalField investigationFinal reportArion Lightning LS-1 · Van Nuys, CAThe pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological…Aug 2, 2016 · N341AL · Substantial damageNTSB GAA16CA421Accident · No injuriesData collectionFinal reportCessna 172 · Oak Island, NCThe pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing and substantial damage to the firewall.Aug 2, 2016 · N24447 · Substantial damageNTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.Aug 2, 2016 · N734GM · Substantial damageNTSB GAA16CA414Accident · No injuriesData collectionFinal reportCessna 150 · New Albany, MSThe pilot's failure to maintain an appropriate pitch attitude during landing, which resulted in an initial nose wheel contact, followed by a nose gear collapse, and the airplane came to rest in a nose down position.Aug 2, 2016 · N50945 · Substantial damageNTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.Aug 2, 2016 · N46459 · Substantial damageNTSB WPR16FA154Accident · 1 fatalField investigationFinal reportSperling Richard G Lancair 360 · The Dalles, ORThe pilot's loss of control during an aborted landing. Contributing to the accident was the pilot's failure to extend the landing gear before touchdown.Aug 1, 2016 · N528HZ · DestroyedNTSB GAA16CA411Accident · No injuriesData collectionFinal reportBeech F33 · Blythe, CAThe pilot's failure to attain adequate airspeed to climb and her exceedance of the airplane's critical angle-of-attack during takeoff initial climb at night, which resulted in an aerodynamic stall at low altitude.Aug 1, 2016 · N6728X · Substantial damageNTSB GAA16CA407Accident · No injuriesData collectionFinal reportCessna 152 · Scappoose, ORThe student pilot's failure to maintain pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard landing/abnormal runway contact, a partial nose wheel collapse and substantial damage to the firewall.Aug 1, 2016 · N49276 · Substantial damageNTSB GAA16CA406Accident · No injuriesData collectionFinal reportCessna 177 · Kalispell, MTThe airplane's hard landing during an aborted takeoff, following an encounter with a downdraft during takeoff initial climb from a remote mountain airstrip, resulting in an uncontrolled descent, attempt to land on the runway remaining, and subsequent nose…Jul 31, 2016 · N30550 · Substantial damageNTSB ERA16CA278Accident · Minor injuriesData collectionFinal reportTrick Trikes Storm · Valkaria, FLThe pilot’s premature rotation during takeoff, which resulted in an aerodynamic stall and a hard landing.Jul 31, 2016 · N4367X · Substantial damageNTSB CEN16LA297Accident · No injuriesLimited investigationFinal reportCessna 172F · Newark, ILThe failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.Jul 31, 2016 · N211FC · Substantial damageNTSB ANC16CA053Accident · No injuriesData collectionFinal reportCessna U206G · Sleetmute, AKThe pilot's failure to maintain adequate airspeed during the initial climb after taking off from a wet runway and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 31, 2016 · N206JC · Substantial damageNTSB GAA16CA415Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe student pilot's failure to maintain directional control during takeoff.Jul 30, 2016 · N1688C · Substantial damageNTSB GAA16CA408Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206 · Modesto, CAThe pilot's failure to maintain pitch control during an autorotation, which resulted in abnormal ground contact and main rotor contact with the tail boom. Contributing to the accident was the low fuel level which resulted in fuel starvation and a loss of…Jul 30, 2016 · N206LW · Substantial damageNTSB GAA16CA401Accident · Minor injuriesData collectionFinal reportS C Aerostar S .A. Festival R40S · Frankfort, MIThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion, a nose gear collapse, and impact with terrain.Jul 30, 2016 · N291AF · Substantial damageNTSB CEN16LA296Accident · Minor injuriesLimited investigationFinal reportRyan Navion B · Manitowoc, WIA leak in the gascolator due to degraded rubber gaskets, which allowed air to enter the fuel system and resulted in fuel starvation and a total loss of engine power during takeoff.Jul 30, 2016 · N5294K · Substantial damageNTSB CEN16LA294Accident · No injuriesLimited investigationFinal reportBell 47G 2 · Oshkosh, WIThe loosening and separation of the throttle linkage nut, which resulted in a loss of throttle control and subsequent hard landing after autorotation.Jul 30, 2016 · N975BH · Substantial damageNTSB WPR16FA153Accident · 4 fatalField investigationFinal reportPiper PA-31T · McKinleyville, CAAn inflight fire in the floor area near the main bus tie circuit breaker panel that resulted from chafing between an electrical wire and a hydraulic line and/or airplane structure.Jul 29, 2016 · N661TC · DestroyedNTSB GAA16CA405Accident · Minor injuriesData collectionFinal reportBell 206 · Outlook, WAThe pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.Jul 29, 2016 · N1087N · Destroyed