NTSB investigations
7,301 cases where NTSB found Action/decision.
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\", '0204')) 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.
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", '0204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA25LA098Accident · Minor injuriesClass 3 · LimitedFinal reportMontaer Ltda MC01 · Miramar, FLThe pilot’s delay in recognizing and acting upon the airplane’s reduced takeoff performance.NTSB CEN25LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Bentonville, ARThe pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA079Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Tyler, TXAn electrical system surge for a reason that could not be determined that resulted in an overvoltage event, internal damage to electronics equipment, smoke in the cockpit, and a gear up landing.NTSB ERA25LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Fairfield, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.NTSB ERA25LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Newburyport, MAThe flight instructor’s delayed decision to initiate a go-around, which resulted in the airplane colliding with an obstacle during approach.NTSB ANC25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot’s failure to recognize that an automated taxiway gate was closing, and the pilot’s failure stop for the closing gate.NTSB CEN25LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · McKinney, TXThe flight instructor’s inadequate supervision and delayed remedial action and the student pilot’s failure to maintain a proper landing flare, which resulted in a nose down impact with the runway.NTSB CEN25LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Spearfish, SDThe pilot’s failure to land on the centerline of the snow-covered runway at night, which resulted in the left wing impacting a snowbank, a subsequent loss of directional control, and runway excursion.NTSB WPR25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Los Alamos, NMThe pilot’s failure to maintain airplane control while landing in gusty crosswind conditions.NTSB WPR25LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Gallup, NMThe pilot’s improper fuel management, which resulted in a total loss of engine power.NTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…NTSB ERA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBeech BE-76 · Melbourne, FLThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing.NTSB ANC25LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s improper airspeed management which resulted in a bounced landing and insufficient airspeed to perform a go around procedure.NTSB ANC25LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 182B · Waimea, HIThe pilot’s inadequate monitoring of the fuel status while en route, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA070Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV-7A · Gila Bend, AZA disconnection of the mixture control linkage during flight, which resulted in fuel starvation and a total loss of engine power. Contributing was the inadequate inspection of the mixture control arm attachment hardware.NTSB WPR25LA069Accident · No injuriesClass 4 · LimitedFinal reportSling Sling LSA · Carson, CAThe pilot’s decision to conduct a prolonged slip against warnings specified in the Pilot’s Operating Handbook which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA068Accident · No injuriesClass 4 · LimitedFinal reportRemos Remos G-3/600 · Brawley, CAThe flight instructor’s lack of remedial action to the student pilot’s inadequate landing flare, which resulted in a hard landing and a loss of directional control.NTSB ERA25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Myakka City, FLThe non-certificated pilot’s improper decision to operate the powered parachute in close proximity to a fence, which resulted in a collision with the fence during takeoff. Also causal was the pilot’s decision to operate the powered parachute without having…NTSB ANC25LA011Accident · No injuriesClass 3 · LimitedFinal reportRaytheon C90A · Honolulu, HIA temporary reduction in the airplane’s braking effectiveness during engine start following an exterior wash, which resulted in its uncommanded forward movement and collision with a parked airplane. Contributing to the accident was the flight crew’s delayed…NTSB ERA25LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Southport, NCThe pilot’s loss of aircraft control due to spatial disorientation, and the flight instructor’s inadequate supervision, which resulted in the subsequent overstress of the airplane during recovery.NTSB ERA25LA083Accident · No injuriesClass 4 · LimitedFinal reportBeech B95A · Murray, KYThe pilot’s failure to lower the landing gear before touchdown, which resulted in a gear-up landing. Contributing was the designated pilot examiner’s inadequate monitoring and lack of remedial action.NTSB ERA25LA081Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Lakewood, NJThe pilot’s delay in performing a go-around, which resulted in a collision with trees at the end of the runway.NTSB ERA25LA079Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT504 · Big Cypress, FLThe pilot’s decision to depart with cargo outside of the designated baggage compartment, which resulted in the cargo interfering with the rudder control system.NTSB ERA25LA077Accident · No injuriesClass 4 · LimitedFinal reportWolstenholme Dennis Pietenpol AIR Camper · Tullahoma, TNThe pilot’s failure to adequately secure the airplane before hand-propping the engine. Contributing was the pilot’s lack of training in hand-propping procedures.NTSB CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB WPR25LA058Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Los Alamitos, CAThe student pilot’s failure to maintain directional control during a run-on landing and the flight instructor’s excessive correction which resulted in impact with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB WPR25LA049Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SF50 · Mesa, AZThe pilot’s improper landing gear selection during the takeoff roll and failure to maintain airplane control during a rejected takeoff, which resulted in abnormal contact with the runway and a collapse of the nose landing gear.NTSB CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA25LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Huntington, WVThe pilot’s failure to utilize carburetor heat while operating the engine at low power and in conditions conducive to the formation of carburetor ice, which resulted in a total loss of engine power due to carburetor icing.NTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.NTSB ERA25LA055Accident · No injuriesClass 4 · LimitedFinal reportBrunner-Winkle Bird A · Senoia, GAThe pilot’s improper flare, which resulted in a hard landing, and landing gear collapse.NTSB ERA25LA068Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Daytona Beach, FLThe maintenance technician’s failure to follow the manufacturer’s recommended procedures during a wheel and tire change to ensure proper clearance of the tire to the wheel well resulting in the right main wheel becoming stuck in the well and subsequent…NTSB CEN25LA036Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.NTSB WPR25LA034Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Durkee, ORThe pilot's inadequate performance planning, which resulted in insufficient engine power to transition into an out-of-ground-effect hover at a high gross weight.NTSB ERA25LA045Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G58 · Fairfield Township, NJThe pilot’s failure to properly configure the landing gear for landing.NTSB ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB ERA25LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · St. Agatha, MEA partial loss of engine power due to carburetor ice as a result of the pilot’s delayed use of carburetor heat while operating in environmental conditions conducive to serious carburetor icing.NTSB WPR25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Aberdeen, IDThe pilot’s failure to maintain back pressure on the control stick during a landing attempt on gravel, which resulted in a nose over.NTSB ANC25LA005Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Lanai City, HIA partial loss of engine power due to the formation of carburetor ice as a result of the pilot’s improper use of carburetor heat.NTSB DCA25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Houston, TXBrake application before all three landing gears were on the ground, which caused the failure of the right main landing gear tires and resulted in tire fragments impacting the fuselage.NTSB CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.NTSB CEN25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Willis, MIThe pilot’s failure to maintain a stabilized approach, that resulted in a runway excursion and subsequent collision with trees. Contributing to the accident, was the pilot’s decision to attempt to land to a closed runway.NTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB ERA25LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Newnan, GAThe pilot’s inadequate use of carburetor heat during the engine run-up, which resulted in a partial loss of power due to carburetor icing during takeoff.NTSB CEN25LA017Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Shreveport, LAThe pilot’s inadvertent failure to lower the landing gear before touching down.