NTSB investigations
1,269 cases where NTSB found Performance/control parameters, general.
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\", '01062000')) 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", '01062000')) 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 CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.NTSB ERA18LA233Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · New Kent, VAThe student pilot’s loss of airplane control during a go-around.NTSB WPR18FA228Accident · 2 fatalClass 3 · FieldFinal reportPietenpol Aircamper · Camp Verde, AZLoss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.NTSB ERA18FA221Accident · 2 fatalField investigationFinal reportQuicksilver MXL II Sport · Westminster, MDThe in-flight fracture of a stainless steel bolt that was used to secure the upper and lower wing cables to the outer attach point at the leading edge spar of the right wing due to stress corrosion cracking, which caused the right wing to fail and precluded…NTSB CEN18LA344Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Addison, TXThe pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.NTSB CEN18FA339Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Bronson, MIThe pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.NTSB CEN18LA342Accident · No injuriesLimited investigationFinal reportCessna A188 · Whitewater, KSThe partial loss of engine power due to low cylinder compression, which led to the forced landing following a pull-up maneuver. Contributing to the accident was the airplane’s high gross weight.NTSB CEN18LA334Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Kindred, NDThe pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…NTSB GAA18CA494Accident · No injuriesData collectionFinal reportPiper PA18 · Gilliam Glacier, AKThe pilot's improper decision to take off in gusting crosswind conditions, which resulted in a loss of control and collision with terrain.NTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.NTSB WPR18LA214Accident · Minor injuriesLimited investigationFinal reportBell 206 · Basin City, WAThe pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.NTSB CEN18FA310Accident · 5 fatalClass 3 · FieldFinal reportExtra EA 400 · Ponca City, OKThe pilot's loss of control for reasons that could not be determined with the available evidence.NTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA18CA521Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Fairbanks, AKThe pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip.NTSB ANC18CA056Accident · Minor injuriesClass 4 · Data collectionFinal reportEurocopter AS 350 B3 · Kobuk, AKThe pilot's inadvertent dynamic rollover during takeoff.NTSB CEN18CA291Accident · No injuriesData collectionFinal reportQuad City Challenger · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Milford, IAThe pilot's loss of airplane control during takeoff for reasons that could not be determined because no anomalies consistent with a flight control system malfunction were observed.NTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.NTSB CEN18FA244Accident · 1 fatalField investigationFinal reportRobinson R22 · Sterling City, TXA loss of control during the landing approach for reasons that could not be determined based on the available information.NTSB CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.NTSB CEN18CA240Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Encino, TXThe gunner's failure to ensure that the net would not ensnare the helicopter's skids once deployed, which resulted in the pilot being unable to maintain helicopter control as the bull pulled on the net and subsequent impact with terrain.NTSB CEN18CA294Accident · No injuriesData collectionFinal reportRobinson R22 · Sterling City, TXThe pilot’s improper decision to exit the helicopter without shutting down the engine, which allowed the collective/throttle to increase and resulted in a loss of control of the unattended helicopter.NTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…NTSB ERA18FA167Accident · 2 fatalField investigationFinal reportRaytheon 58 · Springfield Township, NJA loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.NTSB CEN18LA219Accident · No injuriesLimited investigationFinal reportAston Kinsey Tercel · Cokeville, WYThe loss of gyrocopter control for reasons that could not be determined because postaccident examination of the gyrocopter revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB ERA18LA157Accident · 4 fatalLimited investigationFinal reportPiper PA 31 · Amagansett, NYThe pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.NTSB CEN18LA194Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Qulin, MOThe pilot’s improper weight-and-balance calculations and his decision to take off with the airplane at a high gross weight in high density altitude conditions, which resulted in an attempted takeoff that exceeded the airplane’s performance capability. Also…NTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…NTSB ERA18FA148Accident · 1 fatalField investigationFinal reportPiper PA34 · Bennington, VTThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.NTSB GAA18CA289Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Yakutat, AKThe helicopter’s movement during startup in gusting wind conditions, which resulted in the main rotor striking the tailboom.NTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.NTSB CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.NTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB CEN18FA149Accident · 3 fatalField investigationFinal reportEurocopter AS 350 B2 · Hazelhurst, WIThe pilot's loss of helicopter control as a result of fatigue during cruise flight at night.NTSB ERA18FA127Accident · 1 fatalField investigationFinal reportCessna 525 · Crozet, VAThe pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting…NTSB CEN18FA143Accident · 2 fatalField investigationFinal reportBeech G33 · Warsaw, OHThe pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing…NTSB CEN18FA139Accident · 1 fatalField investigationFinal reportWittman W10 · San Antonio, TXAn in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control.NTSB ERA18FA128Accident · 1 fatalField investigationFinal reportS.Z.D. SZD 48 Jantar STD 2 · LaBelle, FLThe pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence.NTSB ERA18LA124Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Lowville, NYThe pilot's diverted attention, which resulted in his inadequate monitoring of the airplane's attitude and a loss of control in flight.NTSB ERA18FA122Accident · 2 fatalField investigationFinal reportMD Helicopter 600 · Smethport, PAThe helicopter pilot's failure to maintain adequate clearance during power line construction work, which resulted in the helicopter's main rotor striking and becoming entangled with a wire and a subsequent dynamic rollover and collision with terrain.…NTSB CEN18LA137Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Maxwell, IAThe noncertificated pilot's unfamiliarity with the airplane, which resulted in a loss of airplane control when the pilot encounter a wind gust.NTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…NTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…NTSB ERA18FA092Accident · 2 fatalField investigationFinal reportQuest Kodiac 100 · Georgetown, FLThe pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.NTSB ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…NTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.