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 CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB ERA16FA176Accident · 3 fatalField investigationFinal reportBeech V35 · Syosset, NYThe pilot's loss of airplane control while operating in instrument meteorological conditions with only a partial instrument panel due to a failure of the airplane's vacuum pump. Contributing to the accident were the pilot's spatial disorientation and the…NTSB ERA16FA170Accident · Serious injuriesField investigationFinal reportBeech 76 · Pompano Beach, FLThe flight instructor's failure to maintain airplane control while demonstrating a simulated engine failure. Contributing to the accident was the pilot's improper response to the simulated engine failure.NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB CEN16FA146Accident · 2 fatalField investigationFinal reportRockwell 690B · Taylor, TXA loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.NTSB ERA16FA140Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Enterprise, ALThe pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…NTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB WPR16LA071Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Buckeye, AZThe pilot's improper decision to operate the high-performance aircraft despite warnings from a flight instructor that he did not have the experience to operate the aircraft that had different and more sensitive handling characteristics than the…NTSB WPR16LA070Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Petaluma, CAThe pilot's inadequate compensation for wind during the landing approach, which resulted in the balloon’s basket impacting a metal fence and a passenger sustaining serious injuries.NTSB WPR16LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G 3B 1 · Carson City, NVThe pilot's failure to maintain sufficient main rotor rpm, which resulted in a loss of helicopter control and a dynamic rollover.NTSB WPR16FA064Accident · 2 fatalField investigationFinal reportNorth American F51 · Maricopa, AZThe pilot’s failure to maintain airplane control while performing an acrobatic maneuver and his subsequent failure to recover from an inadvertent spin due to insufficient altitude.NTSB ERA16FA100Accident · 2 fatalField investigationFinal reportCessna 182 · Mobile, ALThe pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…NTSB WPR16FA059Accident · 2 fatalField investigationFinal reportPiper PA 24-260 · Santa Rosa, CAThe pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…NTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB WPR16FA042Accident · 1 fatalField investigationFinal reportPiper PA32R · Castro Valley, CAThe pilot's loss of control due to spatial disorientation while maneuvering during an instrument approach in instrument meteorological conditions.NTSB WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…NTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…NTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA16FA035Accident · 2 fatalField investigationFinal reportCessna 441 · Climax, GAThe pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.NTSB ERA16FA031Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Queens, NYThe noninstrument-rated pilot's spatial disorientation and subsequent loss of airplane control while maneuvering at low altitude, over water with no visible horizon, in dark night conditions, which resulted in a collision with the water.NTSB ERA16LA028Accident · 3 fatalLimited investigationFinal reportSchumacher Lancair Super ES · Pascagoula, MSThe pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather.NTSB CEN16LA022Accident · 1 fatalLimited investigationFinal reportDelwyn Schmidt No model · Bennington, KSThe unregistered airplane’s loss of engine power due to piston seizure. Contributing to the accident was the pilot’s loss of airplane control while maneuvering back to the runway.NTSB CEN16LA017Accident · Minor injuriesLimited investigationFinal reportComp Air CA8 · Ray, MIThe pilot's improper use of the trim, which created a cross-controlled situation and resulted in an aerodynamic stall during the attempted go-around.NTSB ERA16LA003Accident · Serious injuriesClass 2 · LimitedFinal reportBeech S35 · Knoxville, TNThe pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.NTSB CEN16LA006Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Parkston, SDThe pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.NTSB CEN16LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G · Huntsville, TXThe pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.NTSB CEN15LA437Accident · Minor injuriesLimited investigationFinal reportCapella Aircraft Corporation ( FW2TDXLS · Bartlesville, OKThe pilot’s failure to maintain airplane control after takeoff.NTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…NTSB ERA15LA367Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 19B · Saratoga Springs, NYThe pilot's failure to maintain glider control while attempting to land.NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.NTSB ERA15LA343Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 · Louisburg, NCThe propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.NTSB ERA15FA336Accident · 1 fatalField investigationFinal reportHenderson W A/Johnson W L RV 6A · Bon Aqua, TNThe pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.NTSB CEN15FA388Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Kewanee, ILThe pilot's loss of control due to spatial disorientation shortly after takeoff into low instrument meteorological conditions.NTSB ERA15FA331Accident · 1 fatalField investigationFinal reportCornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NYSeparation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…NTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.NTSB CEN15LA381Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Pontiac, MIThe pilot's failure to maintain airplane control while landing with a left quartering tailwind. Contributing to the accident was the pilot's inability to conduct a go-around because of a loss of engine power due to carburetor icing.NTSB GAA15CA254Accident · No injuriesData collectionFinal reportPiper PA 18-150 · LaBelle, FLThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over and impact with terrain.NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.NTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…NTSB CEN15FA325Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Truth or Consequences, NMThe student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.NTSB ERA15FA277Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Lake Wales, FLA partial loss of engine power due to oil starvation. Contributing was the flight instructor's failure to maintain control of the airplane during an aborted emergency landing, and his delayed decision to deploy the airplane's parachute system.NTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.NTSB ERA15LA271Accident · No injuriesLimited investigationFinal reportYoung John E Searey · Corbin, KYThe pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.NTSB CEN15LA306Accident · Serious injuriesLimited investigationFinal reportAir Creation Clipper 582 · Clark, SDThe pilot's inability to maintain control of the weight-shift control aircraft during initial climb due to his impairment from ethanol, methamphetamine, cocaine, and marijuana.NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.