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.
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
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 WPR25LA085Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Santa Barbara, CAAn undetermined flap system anomaly that resulted in an irreversible right bank and rendered the airplane uncontrollable.NTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB CEN25LA089Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Brush, COThe failure of the left main landing gear forward strut.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB CEN25LA087Accident · No injuriesClass 4 · LimitedFinal reportEpic E1000 · Arcola, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.NTSB ENG25WA015IncidentClass 5 · ForeignBombardier BD100 1A10 · Nassau, BahamasNTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.NTSB CEN25LA083Accident · No injuriesClass 4 · LimitedFinal reportRaytheon Hawker 800XP · Minneapolis, MNThe failure of the nose landing gear to extend for undetermined reasons.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 ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.NTSB CEN25LA082Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Plainview, TXFuel starvation due to fuel migration during the pilot induced slipping maneuver.NTSB CEN25LA086Incident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe failure of the lower hinge barrel due to fatigue cracking. Contributing to the failure of the lower hinge barrel was increased stress from end face contact likely associated with worn bushings or displaced needle bearings.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 CEN25LA080Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Omaha, NEThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.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 CEN25LA078Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH750 · Byron, ILThe pilot inadvertently moved the ignition key to the off position and broke the key, which resulted in a loss of engine power and subsequent forced landing.NTSB CEN25LA077Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Addison, TXA partial loss of engine power during takeoff due to the partial blockage of the fuel diaphragm metering stem and the No. 1 cylinder fuel injector nozzle. Contributing to the accident was maintenance that allowed the introduction of debris that resulted in…NTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB ERA25LA099Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Wilmington, NCThe pilot’s improper landing flare, which resulted in a wing strike.NTSB ERA25LA097Accident · No injuriesClass 4 · LimitedFinal reportJonathan C Eggers Challenger II · Conway, SCThe pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.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 CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.NTSB ERA25LA096Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Pompano Beach, FLThe separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.NTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.NTSB DCA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Atlanta, GASubstantial injury to a passenger sustained during evacuation.NTSB ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.NTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.NTSB WPR25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Red Rock, MTThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with deep snow and vegetation.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB ERA25LA091Accident · No injuriesClass 3 · LimitedFinal reportHelio HT-295 · Marion, OHThe failure of the right main landing gear spring due to intergranular stress-corrosion cracking that progressed into fatigue. Contributing to the accident was the improper rework of the spring at an undetermined time.NTSB ERA25LA090Accident · No injuriesClass 4 · LimitedFinal reportHinson Melvin J Velocity · Norfolk, VAA landing gear collapse during landing in gusty crosswind conditions.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 ANC25LA015Accident · No injuriesClass 4 · LimitedFinal reportGippsaero PTY GA8 · Nightmute, AKThe pilot’s loss of directional control while taxiing in gusting wind conditions.NTSB CEN25LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lubbock, TXThe loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees.NTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.NTSB ANC25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Anchorage, AKThe student pilot’s failure to maintain directional control of the airplane during touch-and-go operations on an ice-covered runway during her first solo flight.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 CEN25LA065Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28 · New Braunfels, TXThe pilot’s improper in-flight fuel planning which resulted in a total loss of engine power due to fuel starvation and a subsequent off-field landing on rough terrain.NTSB CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB ERA25LA094Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Florence, SCThe pilot’s failure to follow the emergency procedures and extend the landing gear manually after the landing gear did not initially extend normally.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 ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.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 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 CEN25LA063Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Springfield, MOThe student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.