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 ATL01LA092Accident · Serious injuriesLimited investigationFinal reportKolb Twin Star Mark III · Edgewater, FLThe loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.NTSB ATL01FA093Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Anniston, ALThe inadvertent activation of the flight control gust locks by the pilot rated passenger that resulted in the loss of control inflight. Contributing was the pilot in commands failure to follow the airplane's pre-flight inspection check list.NTSB FTW01LA168Accident · 1 fatalLimited investigationFinal reportSchnitz FIIC-2 Goshawk · Marion, TXthe loss of control on takeoff for undetermined reasons.NTSB CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.NTSB CHI01LA227Accident · No injuriesLimited investigationFinal reportMcIlraith Searey Amphibian · La Crosse, WIThe pilot's inadequate compensation for wind conditions and turbulence which resulted in the encountered stall. Factors to the accident were turbulence and the high wind condition.NTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB LAX01LA256Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Mammoth Lakes, CAThe pilot's inadequate in-flight planning and his failure to maintain sufficient altitude above the terrain. Factors were the high terrain and the blind canyon.NTSB CHI01LA240Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe pilot not maintaining aircraft control while maneuvering on the aerial application flight. A factor to the accident was the encountered stall/mush at a low altitude.NTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.NTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.NTSB NYC01FA172Accident · 1 fatalField investigationFinal reportBeech A23-24 · Bridgeville, DEThe pilot's incapacitation, which resulted in a loss of aircraft control while maneuvering. A factor was the FAA Aeromedical Certification Division's inadequate certification/approval of the pilot's medical certificate. Findings were the pilot's inappropriate…NTSB ANC01FA084Accident · 4 fatalField investigationFinal reportMaule M-5-235C · Bettles, AKThe pilot's inadvertent stall of the airplane during an unknown phase of flight.NTSB CHI01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Langdon, NDthe pilot stalled the airplane while manuevering to avoid the power lines. A factor was the power lines.NTSB CHI01LA212Accident · 1 fatalLimited investigationFinal reportReitz Mohawk 1 · Camdenton, MOThe pilot not performing an aborted takeoff and the inadvertent stall he encountered on his inadvertent initial climb. Factors were his inadvertent lift-off, the reported inadequate rudder control, his inadvertent flight with known deficiencies, and the…NTSB ATL01FA082Accident · 2 fatalField investigationFinal reportLuscombe 8A · Resaca, GAThe certificated flight instructor's failure to maintain control of the airplane during a turning maneuver, which resulted in an inadvertent stall and subsequent collision with terrain. A factor was the loading of the airplane over maximum gross weight.NTSB MIA01LA181Accident · 1 fatalLimited investigationFinal reportFloback Lancair 4 · Kissimmee, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB FTW01LA176Accident · No injuriesLimited investigationFinal reportSikorsky SK-76A · New Iberia, LAthe loss of control while maneuvering for undetermined reasons.NTSB LAX01LA239Accident · 2 fatalLimited investigationFinal reportJohansen/Thiessen RV-6A · Jackpot, NVthe private pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and impact with terrain.NTSB ATL01LA077Accident · 1 fatalLimited investigationFinal reportKenneth West ARV 582 · Sebring, FLThe pilot's failure to maintain flying speed, followed by a subsequent inadvertent stall spin.NTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC01FA158Accident · 1 fatalField investigationFinal reportMoravan Zlin 526F · Queen Anne, MDThe pilot's failure to maintain airspeed during an aerobatic maneuver, which resulted in an inadvertent inverted spin.NTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.NTSB IAD01LA074Accident · No injuriesLimited investigationFinal reportCessna 182S · Montgomery, NYThe pilot's improper flare, and improper recovery from a bounced landing.NTSB SEA01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lewistown, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB LAX01LA229Accident · Serious injuriesLimited investigationFinal reportSmith FW-190 · Reedley, CAThe pilot's failure to maintain airspeed during takeoff, which resulted in an inadvertent stall.NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB FTW01LA155Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Paris, TXthe excessive pull up by the passenger along with the certified flight instructor's inadequate supervision leading to a loss of control during the takeoff initial climb.NTSB LAX01FA222Accident · 1 fatalField investigationFinal reportBeech 35-B33 · Lakeside, CALoss of control in flight due to cardiovascular incapacitation.NTSB FTW01FA151Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · McAlester, OKthe inadvertent stall by the pilot-in-command.NTSB CHI01LA190Accident · Serious injuriesLimited investigationFinal reportTerminella Glasair II RG · Bolivar, MOThe pilot not maintaining aircraft control during the initial climb after takeoff. A factor to the accident was the pilot's decision to operate the airplane over the kit manufacture's recommended maximum gross weight.NTSB MIA01LA170Accident · 2 fatalLimited investigationFinal reportUnknown DragonFly B · LaBelle, FLThe inadvertent stall/spin by the pilot resulting in an uncontrolled descent and impact with the ground.NTSB CHI01FA186Accident · No injuriesField investigationFinal reportBowman Renegade Spirit · Lynn Center, ILthe in-flight deformation of the left wing.NTSB CHI01LA181Accident · 2 fatalLimited investigationFinal reportMasko Mustang MII · Ann Arbor, MIThe pilot's failure to maintain control of the airplane resulting in the inadvertent stall/spin. A factor was the pilot's unfamiliarity with the airplane.NTSB MIA01LA166Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe failure of the pilot to maintain aircraft altitude control while on downwind leg of the landing pattern, resulting in an uncontrolled descent and in-flight collision with the terrain.NTSB FTW01LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newport, ARthe loss of control during takeoff initial climb as a result of encountering wake turbulence due to the pilot's failure to recognize the hazard and delay the takeoff.NTSB CHI01LA177Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Kenosha, WIthe inadvertent stall by the pilot. The low altitude was a contributing factor.NTSB NYC01FA147Accident · 1 fatalField investigationFinal reportCessna 172 · Newfane, VTThe pilot's failure to maintain aircraft control during takeoff. A factor was the pilot's impairment due to a narcotic painkiller and antihistamine.NTSB MIA01FA165Accident · 1 fatalField investigationFinal reportCessna 150L · Manteo, NCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner resulting in an inadvertent stall and subsequent in-flight collision with terrain.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.NTSB DEN01FA113Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-20 · Cerrillos, NMthe pilot's loss of aircraft control inflight for reasons undetermined. Contributing factors were the pilot's inadequate transition/upgrade training and his total lack of experience in aircraft make/model.NTSB CHI01LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Milltown, WIThe stall/mush encountered by the pilot during that takeoff. Factors were the pilot's excessive lowering of the flaps during the takeoff and the trees.NTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.NTSB LAX01TA204Accident · No injuriesFinal reportGates Learjet LR-24A · Victorville, CAThe copilot inadvertently induced a lateral oscillation resulting in an in-flight loss of control. The pilot-in-command failed to adequately surpervise the copilot.NTSB NYC01LA138Accident · Serious injuriesLimited investigationFinal reportInterplane Sky Boy · Sayre, PAThe pilot's failure to maintain an adequate climb airspeed.NTSB LAX01FA198Accident · 1 fatalField investigationFinal reportCessna 150L · Tulare, CAThe student's failure to maintain adequate airspeed during the crosswind climb that resulted in a stall/spin at low altitude and the airplane's subsequent ground impact. A factor was the student's failure to retract the wing flaps.NTSB CHI01LA153Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Cambridge, MNThe pilot's inadequate compensation for the wind conditions and the failure to maintain control of the airplane. A factor associated with the accident were the trees that the airplane contacted during the aborted landing.