NTSB investigations

636 cases where NTSB found Aircraft capability.

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\", '010610'))
  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 ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.Feb 23, 2020 · N60SH · Substantial damageNTSB CEN20TA088Accident · Minor injuriesClass 3Final reportCessna 170 · Valley Center, KSThe pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur.Feb 16, 2020 · N170RH · Substantial damageNTSB CEN20CA074Accident · No injuriesData collectionFinal reportPiper PA32 · Kingfisher, OKThe pilot's improper continuation of a landing in which he landed too far down the runway at too high a speed, which resulted in a loss of directional control and a runway excursion.Feb 3, 2020 · N711PF · Substantial damageNTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.Jan 29, 2020 · N425GZ · Substantial damageNTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.Jan 27, 2020 · N214K · DestroyedNTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.Jan 22, 2020 · N36TT · DestroyedNTSB ANC20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 200 · Unalaska, AKThe pilot’s improper decision to takeoff downwind and to load the airplane beyond its allowable gross weight and center of gravity limits, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the inadequacy of the…Jan 16, 2020 · N547LM · Substantial damageNTSB CEN20CA052Accident · No injuriesData collectionFinal reportPiper PA28R · Onaga, KSThe pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.Dec 31, 2019 · N3849T · Substantial damageNTSB CEN20TA031Accident · No injuriesClass 3Final reportBeech 36 · Spring Branch, TXThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…Dec 6, 2019 · N408P · Substantial damageNTSB CEN20FA022Accident · 9 fatalClass 3 · FieldFinal reportPilatus PC12 · Chamberlain, SDThe pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…Nov 30, 2019 · N56KJ · DestroyedNTSB WPR20LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 205 · Red Creek, AZThe pilot’s failure to properly configure the flaps for an aborted landing, which resulted in degraded climb performance and impact with vegetation at the end of the runway.Oct 24, 2019 · N8326Z · Substantial damageNTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.Oct 3, 2019 · N700AQ · Substantial damageNTSB ANC19LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Beluga, AKThe pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.Sep 23, 2019 · N7071B · Substantial damageNTSB CEN19LA314Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Colorado Springs, COThe pilot's improper taxi speed and his excessive use of brakes, which resulted in a brake fire and substantial thermal damage to the airplane.Sep 11, 2019 · N8384E · Substantial damageNTSB WPR19FA252Accident · 2 fatalClass 3 · FieldFinal reportBeech C24 · Las Vegas, NVThe pilot’s operation of the airplane over its maximum gross weight and outside of center of gravity limits at a high-density altitude, which resulted in the exceedance of the airplane's critical angle of attack while maneuvering and subsequent aerodynamic…Sep 8, 2019 · N24030 · DestroyedNTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.Sep 8, 2019 · N602SS · Substantial damageNTSB CEN19LA297Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Independence Charter Township, MIThe reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.Sep 2, 2019 · N98278 · Substantial damageNTSB WPR19LA223Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Ruidoso, NMThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate…Aug 17, 2019 · N5410D · Substantial damageNTSB GAA19CA456Accident · No injuriesData collectionFinal reportPiper PA46 · Sparta, TNThe pilot's failure to maintain the runway heading during an aborted takeoff, which resulted in a runway excursion and collision with a sign and terrain. Contributing to the need to abort the takeoff was the pilot's improper decision to take off with the…Jul 27, 2019 · N12KW · Substantial damageNTSB CEN19LA242Accident · Serious injuriesLimited investigationFinal reportIcon A5 · Lake, MIThe pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…Jul 27, 2019 · N663BA · Substantial damageNTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…Jun 22, 2019 · N256TA · DestroyedNTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.Jun 21, 2019 · N243XT · Substantial damageNTSB ERA19LA199Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 · Readington, NJThe pilot's failure to land on the mowed turf runway, which resulted in the airplane landing in tall grass and subsequently nosing over.Jun 17, 2019 · N43766 · Substantial damageNTSB GAA19CA339Accident · No injuriesData collectionFinal reportAir Tractor AT502 · San Benito, TXThe pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 13, 2019 · N103CK · Substantial damageNTSB CEN19LA176Accident · No injuriesClass 3 · LimitedFinal reportKolb Kolb Twinstar TSP 1 · Hector, MNThe pilot’s operation of the airplane outside of the center of gravity limits, which resulted in an adverse aerodynamic condition and subsequent hard landing. Contributing to the accident was the pilot’s incorrect calculations of the airplane’s CG limits.Jun 13, 2019 · N217JM · Substantial damageNTSB CEN19LA173Accident · Minor injuriesClass 3 · LimitedFinal reportJust Highlander · Quinlan, TXThe pilot's decision to depart with minimal runway available and his improper soft-field takeoff procedure, which resulted in impact with trees due to a slow airspeed and settling effect during climb out.Jun 13, 2019 · N324SB · Substantial damageNTSB GAA19CA343Accident · No injuriesData collectionFinal reportMaule MX7 · Soldatna, AKThe pilot’s attempt to land on water in an airplane that was not equipped with floats.Jun 11, 2019 · N61339 · Substantial damageNTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.Jun 1, 2019 · N1418 · Substantial damageNTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…May 4, 2019 · N732MA · Substantial damageNTSB GAA19CA281Accident · No injuriesData collectionFinal reportCessna 340 · Carvers, NVThe pilot’s failure to accurately assess the available runway for the takeoff, which resulted in impact with a gravel berm.May 3, 2019 · N5418M · Substantial damageNTSB GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.May 3, 2019 · N2280X · Substantial damageNTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…Apr 22, 2019 · N501CE · Substantial damageNTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…Mar 31, 2019 · N902RA · Substantial damageNTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.Feb 21, 2019 · N108TE · Substantial damageNTSB ERA19FA068Accident · 1 fatalClass 2 · FieldFinal reportSaberwing Saberwing · Adel, GAThe in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.Dec 18, 2018 · N203SW · Substantial damageNTSB GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.Nov 14, 2018 · N264PC · Substantial damageNTSB GAA18CA575Accident · Serious injuriesData collectionFinal reportPiper PA28 · Spokane, WAThe pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.Sep 29, 2018 · N40825 · Substantial damageNTSB WPR18LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Malad, IDThe pilot’s failure to identify that he was not utilizing the full runway for takeoff, and his delayed decision to abort the takeoff, which resulted in a runway overrun.Sep 26, 2018 · N24BA · Substantial damageNTSB WPR18LA262Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Johns, AZThe pilot's inadequate preflight planning before takeoff in the high density altitude conditions, which resulted in the airplane being unable to maintain sufficient airspeed to continue to climb.Sep 15, 2018 · N734FT · Substantial damageNTSB CEN18LA383Accident · No injuriesLimited investigationFinal reportPiper PA46 · Santa Teresa, NMThe pilot's decision to attempt to take off in an overweight airplane in high density altitude conditions, which resulted in the airplane’s inability to climb, an aborted takeoff, and a subsequent runway excursion.Aug 31, 2018 · N747DA · Substantial damageNTSB ERA18FA238Accident · 3 fatalField investigationFinal reportSchweizer SGS 2 32 · Morrisville, VTThe pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…Aug 29, 2018 · N17970 · Substantial damageNTSB WPR18FA237Accident · 2 fatalClass 3 · FieldFinal reportChampion 7KCAB · Descanso, CAThe pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…Aug 22, 2018 · N1682G · Substantial damageNTSB WPR18LA214Accident · Minor injuriesLimited investigationFinal reportBell 206 · Basin City, WAThe pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.Aug 7, 2018 · N607RA · DestroyedNTSB GAA18CA469Accident · Minor injuriesData collectionFinal reportRans S7 · Kenai, AKThe pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…Aug 4, 2018 · N8443B · Substantial damageNTSB WPR18LA205Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · San Diego/El Cajon, CAThe pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.Jul 28, 2018 · N3477T · Substantial damageNTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.Jul 28, 2018 · N624FL · Substantial damageNTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…Jul 19, 2018 · N9878R · DestroyedNTSB GAA18CA408Accident · No injuriesData collectionFinal reportRobinson R44 · Rulo, NEThe pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation.Jul 10, 2018 · N144DJ · Substantial damageNTSB GAA18CA430Accident · No injuriesData collectionFinal reportRobinson R44 · Okawville, ILThe pilot's improper preflight weight and balance calculation, which resulted in his operating the helicopter over its maximum gross takeoff weight and in its subsequent failure to climb.Jul 9, 2018 · N944DC · Substantial damageNTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.Jul 1, 2018 · N66568 · Substantial damage