NTSB investigations

12,339 cases where NTSB found Aircraft oper/perf/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\", '0106'))
  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 CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.Mar 4, 2024 · N1955W · Substantial damageNTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.Mar 3, 2024 · N729CJ · Substantial damageNTSB CEN24LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Paragould, ARThe pilot’s failure to maintain directional control during landing.Mar 2, 2024 · N5350C · Substantial damageNTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.Mar 2, 2024 · N2387B · DestroyedNTSB ERA24LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Key Largo, FLThe pilot’s improper go-around technique, which resulted in an aerodynamic stall at an altitude too low for recovery.Mar 1, 2024 · N1108T · Substantial damageNTSB WPR24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Albuquerque, NMThe pilot’s loss of control during landing due to a flat tire. Contributing to the accident was the pilot’s failure to replace the worn tire in a timely manner.Feb 28, 2024 · N26DR · Substantial damageNTSB CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.Feb 28, 2024 · N7770K · Substantial damageNTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.Feb 26, 2024 · N739UE · Substantial damageNTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.Feb 26, 2024 · N35719 · Substantial damageNTSB ERA24LA123Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Moultonborough, NHThe pilots’ failure to maintain directional control of the airplane during the landing.Feb 25, 2024 · N43892 · Substantial damageNTSB CEN24LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Watertown, SDThe stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing due to an undersized exhaust valve guide. Contributing to the accident were the improper manufacture of the engine cylinders, and the operation of…Feb 25, 2024 · N38696 · Substantial damageNTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.Feb 24, 2024 · N30169 · Substantial damageNTSB ERA24FA120Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Jackson, OHThe non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.Feb 24, 2024 · N8963N · DestroyedNTSB WPR24LA102Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Truth or Consequences, NMThe pilot’s failure to maintain airplane control during approach and landing that resulted in a runway excursion and subsequent impact with a berm.Feb 23, 2024 · N2669K · Substantial damageNTSB WPR24LA094Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · Valley Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude and inadvertently entering a box canyon where the airplane could not outclimb the rising terrain.Feb 23, 2024 · N1611E · Substantial damageNTSB 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 CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.Feb 23, 2024 · N3645W · Substantial damageNTSB CEN24LA119Accident · Serious injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Sextonville, WIA loss of engine power for reasons that could not be determined, followed by a loss of control and subsequent impact with terrain.Feb 23, 2024 · N750WW · Substantial damageNTSB CEN24LA118Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182P · Charleston, MSThe pilot’s failure to attain/maintain aircraft control during an approach for landing that resulted in an impact with terrain.Feb 20, 2024 · N14YY · DestroyedNTSB ANC24LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Trapper Creek, 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.Feb 17, 2024 · N1258V · Substantial damageNTSB ERA24LA119Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Polk City, FLThe glider pilot’s misjudged altitude, which resulted in an off-airport landing and collision with a fence.Feb 15, 2024 · N429SH · Substantial damageNTSB WPR24LA097Accident · No injuriesClass 4 · LimitedFinal reportMark G Ellingson Kitfox IV · Mesa, AZThe pilot’s failure to maintain directional control during landing.Feb 14, 2024 · N25EN · Substantial damageNTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.Feb 12, 2024 · N87965 · Substantial damageNTSB WPR24LA089Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Madera, CAThe pilot’s failure to maintain directional control during landing.Feb 11, 2024 · N737LU · Substantial damageNTSB WPR24LA085Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Santa Ana, CAA loss of airplane control due to wake turbulence resulting from the instructor pilot’s decision to continue the landing into a drifting wake vortex.Feb 11, 2024 · N377YG · Substantial damageNTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…Feb 10, 2024 · C-FLQQ · Substantial damageNTSB WPR24FA083Accident · 2 fatalClass 2 · FieldFinal reportHawker Beechcraft Hawker 900XP · Westwater, UTThe flight crew’s decision to conduct a post-maintenance stall test in an area of icing conditions, which resulted in wing contamination that significantly decreased the airplane’s critical angle of attack. Also causal was the airplane manufacturer’s lack of…Feb 7, 2024 · N900VA · DestroyedNTSB ERA24LA112Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30 · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind.Feb 7, 2024 · N39818 · Substantial damageNTSB ERA24LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301T · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll in a gusting crosswind.Feb 7, 2024 · N484AP · Substantial damageNTSB CEN24LA112Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Tupelo, MSThe pilot’s failure to maintain clearance from water during a dark night landing.Feb 7, 2024 · N4054Y · Substantial damageNTSB CEN24LA105Accident · No injuriesClass 4 · LimitedFinal reportBeech B23 · Blytheville, ARThe pilot’s improper descent path which resulted in a bounced landing and loss of control.Feb 2, 2024 · N6148N · Substantial damageNTSB ERA24LA107Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Elizabethtown, NCThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, right main landing gear collapse, and a collision with a ditch.Feb 1, 2024 · N6015U · Substantial damageNTSB ERA24FA103Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. GA-7 · Coatesville, PAThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…Feb 1, 2024 · N887CC · Substantial damageNTSB WPR24FA080Accident · 1 fatalClass 3 · FieldFinal reportSwanson R/Swanson S RV-6 · Concord, CAA total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.Jan 30, 2024 · N30AK · Substantial damageNTSB CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.Jan 29, 2024 · N315GW · Substantial damageNTSB ERA24LA100Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Orlando, FLThe failure of the pilot flying to maintain directional control after touchdown with wind gusts that exceeded the airplane’s crosswind limitation. Contributing to the accident were the flightcrew’s continued approach to the runway despite the consistent wind…Jan 28, 2024 · N103JT · Substantial damageNTSB ERA24FA096Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Weston, FLThe pilots’ spatial disorientation in dark night visual meteorological conditions, which resulted in their failure to maintain altitude and a subsequent descent and impact with a swamp.Jan 23, 2024 · N737VC · Substantial damageNTSB CEN24LA097Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kenosha, WIThe pilot’s failure to maintain control of the helicopter while landing.Jan 21, 2024 · N8350M · Substantial damageNTSB CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…Jan 21, 2024 · N255JP · DestroyedNTSB ERA24LA094Incident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Dulles, VAThe pilot-in-command’s approach to the critical angle of attack during initial climb, which resulted in a vibration the flight crew improperly identified as an engine issue and resulted in the subsequent off-airport landing. Contributing to the accident was…Jan 19, 2024 · N1983X · Minor damageNTSB ERA24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Lakeport, FLThe improper recovery from a bounced landing, which resulted in a hard landing and subsequent noseover.Jan 19, 2024 · N5799 · Substantial damageNTSB WPR24LA079Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Featherville, IDThe pilot's failure to maintain directional control during taxi, which resulted in a runway excursion and impact with terrain.Jan 18, 2024 · N2975A · Substantial damageNTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.Jan 18, 2024 · N7250Q · Substantial damageNTSB WPR24LA077Accident · Minor injuriesClass 4 · LimitedFinal reportDennis Smith Eclipse 10 · Yuma, AZThe pilot’s decision to takeoff with low rotor RPM and his subsequent loss of control.Jan 17, 2024 · N70WP · Substantial damageNTSB ERA24LA090Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Mooresville, NCThe pilot’s failure to maintain control of the airplane during a go-around in gusting crosswind conditions.Jan 14, 2024 · N512SP · Substantial damageNTSB ERA24FA088Accident · 3 fatalClass 3 · FieldFinal reportBeech 95-B55 (T42A) · Leyden, MAThe flight instructor’s failure to maintain airplane control during a stall, which resulted in an inadvertent spin from which the airplane was not recovered. Contributing to the accident were the overall effect of the flight instructor’s use of multiple…Jan 14, 2024 · N7345R · Substantial damageNTSB CEN24FA089Accident · 3 fatalClass 3 · FieldFinal reportCessna 310R · Poolville, TXPilot incapacitation for undetermined reasons which resulted into controlled descent into terrain.Jan 14, 2024 · N252DL · DestroyedNTSB CEN24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7-15 · Albany, TXThe pilot’s failure to maintain a proper descent rate during the landing approach in a high wind condition.Jan 13, 2024 · N2582U · Substantial damageNTSB WPR24LA075Accident · Serious injuriesClass 3 · LimitedFinal reportHarmon Rocket II · Mesquite, NVThe pilot’s loss of control on the landing roll, which led to the airplane coming to rest inverted.Jan 12, 2024 · N630L · Substantial damageNTSB WPR24LA071Accident · Minor injuriesClass 4 · LimitedFinal reportLearjet 55 · Livingston, MTThe flight crew’s decision to land on a snow-covered runway with a tailwind, resulting in a runway excursion and subsequent impact with terrain. Contributing to the accident, was the failure of the airport authority to plow the runway.Jan 11, 2024 · N558RA · Substantial damage