NTSB investigations
11,934 cases where NTSB found Performance/control parameters.
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\", '010620')) 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", '010620')) 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 CEN25LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Baraboo, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN25LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lansing, MIThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing in a crosswind condition.NTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB CEN25LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Oshkosh, WIThe pilot’s aggressive brake application which resulted in a loss of directional control and a ground loop.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA257Accident · Minor injuriesClass 4 · LimitedFinal reportVan's RV-6 · New Richmond, WIThe pilot’s failure to maintain proper airspeed and altitude during the approach which resulted in a runway overshoot and subsequent landing in a lake. Contributing to the accident was the pilot’s delayed remedial action to abort the landing.NTSB CEN25LA256Accident · Minor injuriesClass 4 · LimitedFinal reportFarrington Twinstar · Greencastle, INThe pilot’s failure to maintain pitch control during takeoff. Contributing to the accident was the pilot’s inexperience in the accident gyroplane.NTSB WPR25LA215Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · North Las Vegas, NVThe failure of the pilot to set the flaps to the proper configuration for takeoff.NTSB CEN25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Wyoming, ILThe pilot’s failure to attain a positive climb rate due to airplane’s improper takeoff configuration.NTSB CEN25LA254Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Russellville, INThe pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.NTSB WPR25LA222Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Rotorsport UK Cavalon · Hurricane, UTThe pilot’s failure to maintain pitch control during takeoff, which resulted in an unintended liftoff from the runway and a subsequent loss of control.NTSB ANC25LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Egegik, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB CEN25LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35 · Cedarcreek, MOThe student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…NTSB CEN25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportScott Vincin Just Acft Highlander · Mancos, COThe airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.NTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.NTSB ANC25LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dillingham, AKThe pilot’s failure to maintain direction control during takeoff roll which resulted in a ground loop, and subsequent runway excursion.NTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.NTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.NTSB ANC25LA075Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ANC25LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s excessive braking during the landing roll, resulting in a nose over. Contributing to the accident was the pilot’s decision to continue the landing after determining the landing area was unsuitable.NTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.NTSB CEN25LA245Accident · No injuriesClass 4 · LimitedFinal reportFairchild 24R · Greeley, COThe pilot’s inability to maintain directional control during landing due to excessive wear in the tailwheel steering assembly.NTSB ANC25LA070Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Homer, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB CEN25LA244Accident · Minor injuriesClass 4 · LimitedFinal reportCessna LC41-550FG · Lambertville, MIThe pilot’s failure to land at the manufacturer’s recommended approach speed, which resulted in a runway excursion, and impact with trees.NTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.NTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.NTSB CEN25LA246Accident · No injuriesClass 4 · LimitedFinal reportThorp T18 · Lake Elmo, MNThe pilot’s failure to maintain obstacle clearance during the go-around, that resulted in the tailwheel impacting a taxiway sign, a subsequent loss of control due to the damaged tailwheel, and a runway excursion during the landing.NTSB ANC25LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Kokhanok, AKThe pilot’s failure to attain a proper touchdown point during landing which resulted in a hard landing.NTSB CEN25LA238Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Joliet, ILThe pilot’s failure to maintain directional control during the crosswind landing.NTSB ERA25LA257Accident · No injuriesClass 4 · LimitedFinal reportYates Tom W Kitfox III · Greenville, KYThe pilot’s loss of control during takeoff.NTSB CEN25LA237Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pecos, TXThe pilot’s failure to maintain aircraft control during gusty wind conditions.NTSB WPR25LA202Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Henderson, NVThe pilot’s failure to maintain directional control during a go-around, resulting in a collision with a runway sign.NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB CEN25LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Meeker, COThe student pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ANC25LA067Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 690B · Fairbanks, AKThe pilot’s failure to maintain control during takeoff resulting in a gear-up landing on the runway. Contributing to the accident was the pilot’s momentary distraction from within the airplane.NTSB ERA25LA255Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer 269C · Madisonville, KYThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.NTSB DCA25LA251Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Las Vegas, NVThe first officer’s failure to maintain proper pitch attitude during flare which resulted in a bounced landing and a tailstrike.NTSB CEN25LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Brush, COThe pilot’s failure to maintain directional control while performing a touch and go landing.NTSB ANC25LA062Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · Wasilla, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.NTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.NTSB WPR25LA199Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Tukwila, WAThe pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.NTSB WPR25LA194Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Helena, MTThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN25LA228Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Ben Bolt, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA25LA252Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Pelzer, SCThe pilot’s failure to maintain proper airspeed while landing on a short, down-sloping turf runway, which resulted in a noseover.NTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.NTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.