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 WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.Feb 23, 2024 · N2618W · Substantial damageNTSB CEN24LA069Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 100 · Texarkana, ARThe pilot’s improper decision to attempt a go-around with full flaps extended, which resulted in decreased climb performance and led to a collision with trees.Dec 18, 2023 · N4104X · Substantial damageNTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.Nov 21, 2023 · N158TR · Substantial damageNTSB CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…Oct 30, 2023 · N510KC · Substantial damageNTSB WPR24FA014Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Williams, AZThe pilot’s failure to maintain sufficient airspeed and exceedance of the airplane’s critical angle of attack during initial climb after takeoff, resulting in an aerodynamic stall. Contributing was the pilot’s inadequate preflight airplane performance…Oct 17, 2023 · N6192J · Substantial damageNTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.Sep 13, 2023 · N95250 · Substantial damageNTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…Sep 13, 2023 · N109T · Substantial damageNTSB ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.Sep 10, 2023 · N124UA · Substantial damageNTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…Sep 2, 2023 · N6834W · Substantial damageNTSB WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.Aug 30, 2023 · N33094 · Substantial damageNTSB CEN23LA386Accident · Serious injuriesClass 4 · LimitedFinal reportSilverlight AR-1 · Granbury, TXThe pilot’s improper takeoff procedure which resulted in a loss of control during takeoff.Aug 20, 2023 · N57AR · Substantial damageNTSB WPR23LA306Accident · No injuriesClass 3 · LimitedFinal reportBoeing CH-46E · Springerville, AZThe flight crew’s misidentification of a No. 2 torque sensing system signal conditioner malfunction when both engines were performing normally, which resulted in their attempt to execute a single-engine steep approach and landing without sufficient engine…Aug 5, 2023 · N461WY · DestroyedNTSB CEN23LA346Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Halstad, MNThe pilot’s attempt to rotate the airplane without sufficient airspeed which resulted in a lack of climb performance and impact with terrain. Contributing to the accident was the pilot’s decision to attempt the takeoff with a tailwind.Aug 2, 2023 · N45453 · Substantial damageNTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.Jul 30, 2023 · N918KG · Substantial damageNTSB CEN23LA326Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Charles City, IAThe pilot’s improper preflight of the helicopter to ensure that it was within the loading and performance limitations that resulted in settling and impact with terrain during initial climb.Jul 26, 2023 · N4174L · Substantial damageNTSB WPR23LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Elko, NVThe pilot’s failure to ensure adequate airplane performance before taking off from a significantly shorter runway than originally planned for.Jul 20, 2023 · N4149J · Substantial damageNTSB CEN23LA309Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Princeton, TXThe student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle.Jul 16, 2023 · N41317 · Substantial damageNTSB WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.Jul 8, 2023 · N4135M · Substantial damageNTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…Jul 2, 2023 · N5524F · DestroyedNTSB ANC23FA045Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Old Harbor, AKThe pilot’s failure to maintain clearance from rising terrain. Contributing to the accident was the pilot’s delayed decision to turn away from the terrain.Jul 2, 2023 · N1132Q · Substantial damageNTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.Jun 26, 2023 · N23161 · Substantial damageNTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2023 · N3289S · DestroyedNTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.Jun 5, 2023 · N6174W · Substantial damageNTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.May 25, 2023 · N6699Q · Substantial damageNTSB ANC23LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Hunter Creek, AKThe pilot’s loss of directional control during takeoff roll in gusting wind conditions.May 20, 2023 · N4231Z · Substantial damageNTSB ANC23LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Anchorage, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.May 17, 2023 · N7741D · Substantial damageNTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.May 11, 2023 · N1596E · Substantial damageNTSB ANC23LA030Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Soldotna, AKThe pilot’s selection of an unsuitable landing site, which resulted in the main landing gear wheels breaking through the snow and the airplane nosing over.Apr 22, 2023 · N454FU · Substantial damageNTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.Apr 10, 2023 · N476TA · Substantial damageNTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.Mar 23, 2023 · N280KC · DestroyedNTSB CEN23LA138Accident · Serious injuriesClass 4 · LimitedFinal reportSocata TB21 · Eden Prairie, MNThe pilot’s continued flight into icing conditions in an airplane that was not equipped for icing, which led to structural icing, subsequent loss of airplane control and impact with terrain.Mar 12, 2023 · N789TB · DestroyedNTSB ANC23LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Anchorage, AKThe pilot's selection of an unsuitable landing site, resulting in the main landing gear wheels breaking through the snow, and a subsequent nose over.Jan 16, 2023 · N3904M · Substantial damageNTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.Dec 15, 2022 · N991AB · Substantial damageNTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.Dec 8, 2022 · N3861P · Substantial damageNTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.Oct 13, 2022 · N3885X · Substantial damageNTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.Oct 12, 2022 · N704JT · Substantial damageNTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…Sep 17, 2022 · N709RD · Substantial damageNTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.Sep 7, 2022 · N48918 · Substantial damageNTSB CEN22LA422Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Galena, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.Sep 7, 2022 · N590DC · Substantial damageNTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.Sep 7, 2022 · N1949H · Substantial damageNTSB CEN22LA409Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Eden Prairie, MNThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing.Aug 31, 2022 · N6628J · Substantial damageNTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…Aug 28, 2022 · N505DB · Substantial damageNTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.Aug 24, 2022 · N2317G · Substantial damageNTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.Aug 24, 2022 · N1815J · Substantial damageNTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…Aug 15, 2022 · N26HV · Substantial damageNTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.Aug 11, 2022 · N3937M · Substantial damageNTSB CEN22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Cantwell, AKThe pilot's excessive brake application during the landing roll that resulted in a nose over.Aug 4, 2022 · N9211T · Substantial damageNTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.Jul 30, 2022 · N1358K · Substantial damageNTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.Jul 24, 2022 · N60ED · Substantial damageNTSB ERA22LA312Accident · Serious injuriesClass 3 · LimitedFinal reportFlightstar Flightstar II SC · Russell, PAThe pilot failed to maintain adequate airspeed and exceeded the airplane’s critical angle of attack while attempting to climb over trees, which resulted in an aerodynamic stall and loss of airplane control.Jul 14, 2022 · N6116U · Substantial damage