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 DEN99LA080Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Lamar, COThe pilot's failure to maintain directional control during initial climb following takeoff. A factor was the pilot's lack of experience in the type of aircraft, and the fence.NTSB LAX99LA186Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · San Luis Obispo, CAThe student's inadvertent and uncoordinated application of forward cyclic during an autorotation flare, which resulted in a loss of main rotor rpm; and the flight instructor's inadequate supervision.NTSB FTW99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe flight instructor's inadequate supervision resulting in an inadvertent stall/spin by the student pilot.NTSB FTW99LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Huffman, TXThe pilot's inadequate compensation for the wind conditions during landing. Factors were the wind gusts and the high vegetation beside the runway.NTSB ATL99LA083Accident · 1 fatalLimited investigationFinal reportMichael W. Campbell Lancair 320 · Tallessee, ALThe pilot's failure to maintain flying speed during the takeoff to initial climb that resulted in the a stall and the inflight collision with the trees.NTSB CHI99FA147Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Newton, IAthe failure of the pilot to maintain flying speed resulting in a stall and spin into the ground.NTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.NTSB LAX99LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Las Vegas, NVThe pilot's premature rotation during the aborted landing and his failure to attain and maintain sufficient airspeed, which resulted in a stall mush. Factors in the accident were the pilot's decision to attempt a landing in adverse wind conditions beyond the…NTSB FTW99LA134Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164-B · Garwood, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A related factor was the high density altitude.NTSB DEN99FA075Accident · 2 fatalField investigationFinal reportPiper PA-11 · Lander, WYThe pilot inadvertently stalling the airplane. Factors were his abrupt maneuvering of the airplane to avoid a powerline, and his attention being diverted.NTSB ATL99FA081Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Vicksburg, MSThe pilot's failure to obtain and maintain flying speed that resulted in an inadvertent stall, and the collision with trees. A factor is the dark night.NTSB LAX99LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Maxwell, CAFailure of the pilot to attain and maintain the proper reference climb airspeed during the rotation and initial climb, which resulted in a stall/mush condition.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB MIA99LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chattanooga, TNThe failure of the student pilot to maintain directional control during the flare/touchdown.NTSB FTW99LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Claremore, OKThe pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.NTSB CHI99FA140Accident · 3 fatalField investigationFinal reportPiper PA-28R-201 · Curran, MIthe inadvertent stall/mush. Factor which contributed to this accident were the pilot's inadequate preflight planning, the premature lift-off during the takeoff, the airplane's low airspeed following lift-off, and the trees.NTSB CHI99LA141Accident · Minor injuriesLimited investigationFinal reportBarrett Bensen B-8 · Mt. Pleasant, MIthe inadequate rotor rpm by the pilot.NTSB CHI99LA137Accident · 2 fatalLimited investigationFinal reportBerrick GP-4 · Plattsmouth, NEaircraft control and airspeed not maintained by the pilot-in-command. A factor to the accident was the inadvertent stall.NTSB FTW99LA125Accident · Serious injuriesLimited investigationFinal reportOakes J3 CUB · Greenbriar, ARThe student pilot's failure to compensate for the gusty wind condition while maneuvering, which resulted in the inadvertent stall. A factor was the gusty wind condition.NTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.NTSB ANC99LA050Accident · Serious injuriesLimited investigationFinal reportLuscombe L-8F · Kodiak, AKThe pilot's inadequate terrain clearance during the initial climb, and the inadvertent stall/spin during the turn to avoid terrain. A factor in this accident was the pilot exceeding the allowable maximum gross weight of the airplane.NTSB DEN99FA066Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar 601P · Ruidoso, NMThe pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.NTSB SEA99LA054Accident · 1 fatalLimited investigationFinal reportWells Baby Lakes · Monroe, WAThe pilot's failure to maintain aircraft control. A factor was attempting to fly the airplane outside of its weight and balance limits.NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB MIA99LA133Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Thomastown, MSAn in-flight loss of control caused by the main rotor severing the tail rotor drive shaft as a result of the pilot's cyclic pull-up into a tailwind for his second approach and landing. The loss of the tail rotor caused an uncontrollable descent and tree…NTSB CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.NTSB ATL99LA071Accident · Serious injuriesLimited investigationFinal reportHoskins Craig Lightning BUG · Crystal River, FLThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall.NTSB SEA99LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Puyallup, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB MIA99FA125Accident · 2 fatalField investigationFinal reportPiper PA-16 · Hardeeville, SCAn inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.NTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…NTSB LAX99LA143Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · North Las Vegas, NVThe pilot's failure to ensure that all loose items inside the cockpit were secure before attempting aerobatic maneuvers.NTSB CHI99LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mora, MNthe student pilot's improper soft field takeoff technique in that excessive back pressure was used which resulted in an inadvertent stall/mush. A factor associated with the accident was the student's lack of total experience.NTSB LAX99LA142Accident · Minor injuriesLimited investigationFinal reportWitzel Glassair II FT · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition.NTSB MIA99LA121Accident · No injuriesLimited investigationFinal reportFrederick Sweet Rotorway Exec · Fort Myers, FLThe pilot-in-command's failure to maintain aircraft control after the ground tie chain separated during engine run and hovering operations.NTSB CHI99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the gusty, high, wind conditions, and the pilot's continued flight into adverse weather.NTSB MIA99LA119Accident · No injuriesLimited investigationFinal reportDavid C. Bock Challenger II · Astatula, FLThe aircraft structure fluttering inflight resulting in fracture of fuselage longerons and the pilot being unable to maintain control.NTSB SEA99LA047Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Emmett, IDThe pilot's failure to maintain aircraft control during a low-altitude maneuver to view a coyote on the ground. A related factor was the pilot's low altitude.NTSB NYC99LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln Univ., PAThe student pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. Also causal was the certified flight instructor's inadequate supervision.NTSB NYC99FA085Accident · 2 fatalField investigationFinal reportCessna 310N · Cecilia, KYThe flight instructor's failure to maintain control of the airplane. A factor was the flight instructor's inexperience instructing in the accident airplane.NTSB ATL99FA066Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Tallahassee, FLThe pilot's failure to maintain flying speed during initial climb which resulted in a stall and uncontrolled collision with terrain.NTSB ANC99LA040Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe failure of the pilot to maintain rotor rpm during a downwind turn. A factor in the accident was the inadequate altitude to recover from the loss of rotor rpm.NTSB NYC99LA083Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Orient, NYThe pilot's inadequate compensation for crosswind conditions during takeoff.NTSB NYC99LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Westerville, OHThe failure of the pilot to maintain control of the helicopter.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.NTSB FTW99FA100Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain control of the helicopter while maneuvering. A factor was the pilot's impairment due to his use of a prescription narcotic.NTSB CHI99FA112Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Duluth, MNthe lack of sufficient aileron-to-wing gap clearance design. Contributing factors were the inadequate oversight of the Federal Aviation Administration of the design and manufacturing and flight test process of Cirrus Design Corporation, the location of the…NTSB CHI99LA116Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's misjudged flare and inadvertent stall during landing. A factor was the pilot's inadequate remedial action.NTSB CHI99LA113Accident · No injuriesLimited investigationFinal reportDelong Glastar GS-1 · Lapeer, MIThe failure of the pilot to maintain compensation for wind conditions. Factors to the accident were the crosswind condition and the presence of trees along the runway.NTSB LAX99LA124Accident · No injuriesLimited investigationFinal reportBeech D95A · Dillingham, HIThe student's failure to maintain aircraft control in the gusty crosswind conditions due to limited left yaw authority induced by the simulated single engine approach. The flight instructor's inadequate supervision of the flight and his failure to terminate…NTSB CHI99LA110Accident · Serious injuriesLimited investigationFinal reportSocata TB-9C · Cahokia, ILthe in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…