NTSB investigations
8,203 cases where the first occurrence was “Loss of control - in flight”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 FTW04TA075Accident · Minor injuriesFinal reportBell 206B · Decatur, TXThe pilot's failure to maintain control of the helicopter during liftoff after encountering dynamic rollover. A contributing factor was the rough and uneven terrain.NTSB ANC04LA024Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Daytona Beach, FLThe pilot's inadequate compensation for wind conditions while hover taxiing, which resulted in a loss of control and subsequent in-flight collision with terrain and a rollover of the helicopter. A factor associated with the accident was a gusty wind condition.NTSB LAX04LA125Accident · 2 fatalLimited investigationFinal reportKnapple/Wray Lancair IV-P · Apache Junction, AZthe pilot/builder's failure to maintain an adequate airspeed while maneuvering that resulted in an inadvertent stall/spin.NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…NTSB LAX04LA110Accident · 1 fatalLimited investigationFinal reportTailwind W-8 · San Pedro, CAThe pilot's incapacitation during descent, which resulted in a loss of control and an in-flight collision with water.NTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.NTSB ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.NTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.NTSB MIA04FA044Accident · 2 fatalField investigationFinal reportCessna 150M · Venice, FLThe spatial disorientation of the flightcrew during the dark night and their failure to maintain control of the airplane resulting in the uncontrolled descent and in-flight collision with trees and terrain.NTSB CHI04IA056Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Rapid City, SDThe copilot's failure to maintain control of the airplane during the landing and the captain's delay in initiating remedial action. Factors contributing to the accident were the low ceiling and low visibility due to fog, and the aircraft's deviation from…NTSB FTW04FA062Accident · 1 fatalField investigationFinal reportBeech B36TC · Willow Park, TXThe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the dark night and rain.NTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.NTSB FTW04FA055Accident · 1 fatalField investigationFinal reportMooney M20C · Amarillo, TXThe pilot's incapacitation due to chest pains, resulting in a loss of control.NTSB DEN04FA035Accident · 1 fatalField investigationFinal reportRockwell 690A · Cortez, COthe pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…NTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.NTSB MIA04FA037Accident · 1 fatalField investigationFinal reportCessna 441 · Greenacres City, FLThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into a canal. A factor was the pilot's impairment by the drug chlorpheniramine.NTSB NYC04LA052Accident · Serious injuriesLimited investigationFinal reportMorgan S-17 · Woodstock, CTThe uncertificated pilot's decision to perform a low altitude maneuver at an inadequate altitude, which resulted in an in-flight collision with trees.NTSB ATL04LA064Accident · 1 fatalLimited investigationFinal reportAtkinson SA 102.5 · Trenton, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent in-flight collision with terrain.NTSB LAX04FA075Accident · 2 fatalClass 1 · FieldFinal reportLearjet 24B · Helendale, CAA loss of airplane control for undetermined reasons.NTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB NYC04LA050Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's inadequate pre-flight inspection, which resulted in a decrease in airplane performance due to ice, and a subsequent hard landing.NTSB ATL04LA057Accident · 1 fatalLimited investigationFinal reportInterplane Skyboy-2 · Covington, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor was the unqualified person (pilot).NTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.NTSB ATL04FA056Accident · 1 fatalField investigationFinal reportCessna 206H · Sanford, NCThe pilot's loss of control of the airplane during takeoff initial climb due to spatial disorientation, which resulted in an inflight collision with trees and the ground. Factors were the dark night, fog, and low ceilings.NTSB LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.NTSB FTW04LA041Accident · Serious injuriesLimited investigationFinal reportBull SE5-A · Rio Hondo, TXThe pilot's failure to maintain control of the tailwheel equipped airplane during takeoff. Contributing factors were the pilot's selection of the wrong runway for takeoff and the prevailing tailwind.NTSB SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.NTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.NTSB LAX04FA064Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian Sky Arrow 650 TC · Placerville, CAthe pilot's failure to fully remove an accumulation of ice and frost on the wings, which led to an inadvertent stall/mush and collision with the ground. A factor in the accident was the pilot's failure to correctly configure the flaps for takeoff.NTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.NTSB LAX04FA057Accident · 2 fatalField investigationFinal reportWing D-1 · Rosamond, CAThe flying pilot's failure to obtain/maintain control of the airplane during practice stalls, which resulted in the inadvertent entry into a spin.NTSB NYC04LA043Accident · 1 fatalLimited investigationFinal reportBarness Pulsar I · Bardstown, KYThe pilot's loss of aircraft control, resulting in a subsequent impact with terrain. A factor related to the accident was the pilot's unfamiliarity with the airplane.NTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.NTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.NTSB NYC04LA039Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cranston, RIThe pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.NTSB LAX04CA048Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe student pilot's failure to maintain control of the helicopter while hovering. A factor to the accident was the student pilot's lack of experience.NTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.NTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.NTSB CHI04FA025Accident · 1 fatalField investigationFinal reportCommander 114TC · Hutchinson, KSThe pilot's diverted attention during the missed approach which resulted in aircraft control not being maintained. Factors to the accident included the pilot not being current for instrument operations and the low cloud ceiling at night.NTSB ATL04LA033Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · Waxhaw, NCThe pilot's failure to maintain airspeed while maneuvering on final approach resulting in an inadvertent stall and in-flight collision with trees and the ground.NTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.NTSB NYC04CA019Accident · Serious injuriesData collectionFinal reportBeech A23 · Salem, NJThe pilot's delay in aborting the takeoff after his failure to obtain a proper climb rate. Factors related to the accident were the tailwind conditions, and the wet turf runway.NTSB CHI04LA026Accident · 1 fatalLimited investigationFinal reportMaster Donald C BD5B · Traverse City, MIThe pilot in command not maintaining control of the aircraft during the final approach.NTSB MIA04LA015Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Ocala, FLThe failure of the dual student to maintain airspeed (VS) and the CFI's improper supervision while turning to reverse direction resulting in an inadvertent stall/spin and collision with trees and the ground during the resultant uncontrolled descent.NTSB ATL04LA030Accident · No injuriesLimited investigationFinal reportThocker Vans RV-4 · Liberty, NCThe pilot's failure to maintain airspeed on initial takeoff climb resulting in an in-flight loss of control, inadvertent stall, and collision with the runway.NTSB DEN04MA015Accident · 1 fatalMajor investigationFinal reportCessna 208B · Cody, WYthe pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.