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 MIA07CA126Accident · Minor injuriesData collectionFinal reportPhantom Sport XI · Anderson, ALThe failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.NTSB SEA07LA196Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Camarillo, CAThe pilot's failure to maintain aircraft control during a go-around. Contributing to the accident was the pilot's lack of experience in the make and model of airplane.NTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.NTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.NTSB LAX07FA219Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAthe pilot's inadequate in-flight decision to attempt low altitude flight operations into a box canyon in mountainous terrain, and his failure to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated stall and spin.NTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.NTSB SEA07CA194Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jordan, MTThe pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.NTSB LAX07GA217Accident · No injuriesFinal reportEurocopter France AS350 B3 · Paso Robles, CAa loss of control for undetermined reasons, which resulted in an uncommanded roll and subsequent collision with terrain. Contributing factors in the accident were the flying pilot's failure to request assistance from the second pilot in a timely manner and…NTSB CHI07CA212Accident · No injuriesData collectionFinal reportBell 47G-5 · Jesup, IAThe pilot's inability to maintain control of the helicopter when it unexpectedly encountered a whirlwind shortly after takeoff.NTSB DEN07CA115Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Albuquerque, NMThe pilot's failure to maintain aircraft control during an encounter with the loss of tail rotor effectiveness. Contributing factors were the high density altitude and the power lines.NTSB NYC07FA159Accident · 2 fatalField investigationFinal reportMooney M20F · Brooks, KYThe pilot's failure to maintain aircraft control during the aborted landing. Contributing to the accident was the exceedance of the airplane's maximum gross weight, and the pilot's inadequate preflight planning.NTSB DFW07LA152Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Delhi, LAthe pilot's failure to maintain control of the airplane while practicing aerial application turns over a field.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.NTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.NTSB NYC07LA155Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau Speed Astir II · Centre Hall, PAThe pilot's inability to maintain control of the glider for undetermined reasons.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.NTSB SEA07LA190Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Orangeburg, SCThe pilot's failure to maintain airspeed during go-around which resulted in a stall. The tailwind was a factor.NTSB SEA07CA191Accident · No injuriesData collectionFinal reportPiper PA 28R-180 · Henderson, NVThe pilot's failure to maintain control of the airplane during the attempted go-around, which resulted in a hard landing. A contributing factor was the crosswind.NTSB DFW07CA146Accident · No injuriesData collectionFinal reportSchweizer 269C · Slidell, LAThe pilot's encounter with settling with power condition while hovering out of ground effect. A contributing factor was the prevailing tailwind.NTSB MIA07CA112Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Greenville, SCThe pilot's inadvertent use of the wrong rudder during initial climb which resulted in a loss of control and collision with the ground.NTSB LAX07CA194Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Fresno, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB ANC07LA057Accident · No injuriesLimited investigationFinal reportCessna 182RG · Tok, AKThe pilot's failure to maintain control of the airplane during takeoff initial climb.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB SEA07CA179Accident · Serious injuriesData collectionFinal reportCessna 170A · Bozeman, MTThe pilot's inadequate visual lookout and failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain while manuevering to avoid the transmission lines. The sun glare was a factor.NTSB NYC07LA148Accident · 2 fatalLimited investigationFinal reportSyracuse Vans RV-4 · Wallkill, NYThe pilot's improper decision to attempt low altitude aerobatics, and his failure to maintain airspeed during the aerobatics, which resulted in an inadvertent stall while maneuvering.NTSB DEN07CA107Accident · Minor injuriesData collectionFinal reportTruitt Peter Zenair CH 701SP · Mountain View, WYThe pilot's failure to maintain aircraft control during cruise flight resulting in an impact with terrain. Contributing factors were the wind gust and high density altitude.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB ATL07CA095Accident · Minor injuriesData collectionFinal reportZaverton Elmer PJ260 SR Aero Sport · Lehighton, PAThe failure of the pilot to maintain sufficient airspeed while maneuvering to avoid a stall, which resulted in an inadvertent stall/spin, and collision with trees and terrain.NTSB NYC07LA147Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8GCBC · Sanford, FLThe pilot's failure to maintain airspeed and his excessive pitch attitude while maneuvering.NTSB DEN07CA103Accident · No injuriesData collectionFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.NTSB DEN07CA104Accident · No injuriesData collectionFinal reportBeech B36TC · Hudson, COThe pilot's improper in-flight decision, and his failure to maintain proper aircraft control during takeoff resulting in an inadvertent stall and the subsequent impact with the runway and terrain.NTSB SEA07LA163Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tonopah, NVThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall during the takeoff initial climb. The pilot's diverted attention to an open door, high density altitude, and wind gusts were contributing factors.NTSB NYC07LA143Accident · Serious injuriesLimited investigationFinal reportNorthwing Design Apache Quest · Springfield, VTThe non-certificated pilot's failure to maintain aircraft control, due to the installation of an alternate wing design.NTSB SEA07LA158Accident · 3 fatalLimited investigationFinal reportShepard Lancair Propjet · Portland, ORThe loss of airplane control during climb for an undetermined reason.NTSB ANC07CA050Accident · Minor injuriesData collectionFinal reportCessna 206 · Seldovia, AKThe pilot's inadequate compensation for wind conditions during the final landing approach, which resulted in an in-flight collision with trees. A factor associated with the accident was turbulence.NTSB ATL07CA090Accident · Minor injuriesData collectionFinal reportRosenbaum Super Petrel · Palm Harbor, FLThe pilot's failure to maintain directional control of the airplane during approach to land on a lake resulting in an inflight collision with water. A factor was the pilot's lack of qualification and total experience in the accident airplane make and model.NTSB SEA07LA154Accident · No injuriesLimited investigationFinal reportBell UH-1B · Biggs, CALoss of control during hover for undetermined reasons.NTSB NYC07CA132Accident · No injuriesData collectionFinal reportRobinson R-22B · Plant City, FLThe student pilot's failure to maintain directional control. Factors in the accident were variable wind conditions, and soft/uneven terrain.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB MIA07CA106Accident · Minor injuriesData collectionFinal reportCessna 150L · Greensboro, GAThe pilot's failure to retract the wing flaps during a go-around, which resulted in a stall, and uncontrolled descent, and an impact with terrain.NTSB NYC07FA130Accident · 1 fatalField investigationFinal reportMooney M20J · Canton, MAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.NTSB LAX07CA187Accident · Serious injuriesData collectionFinal reportAviat Husky A1-B · Winston, MTThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude in a canyon that led to a stall. The pilot's decision to fly along the canyon wall at a low altitude and low energy state was a factor.NTSB SEA07LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Rosamond, CAThe pilot's failure to abort the takeoff due to lack of airplane climb performance, which resulted in a collision with terrain.NTSB SEA07GA142Accident · 2 fatalFinal reportChristen Industries A-1 · Loa, UTThe pilot's failure to maintain an adequate airspeed during low altitude maneuvering flight that resulted in a stall. The pilot's decision to operate the airplane at a center of gravity beyond the rear limit, the low altitude of the flight, and the high…NTSB DEN07CA097Accident · Minor injuriesData collectionFinal reportStevenson RV-6 · Oakley, KSThe pilot's failure to maintain airspeed during final approach resulting in a inadvertent stall and impact with terrain.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.