NTSB investigations
5,010 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 LAX08LA290Accident · 1 fatalLimited investigationFinal reportAirborne XT-912 · Chelan, WAThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.NTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.NTSB SEA08GA194Accident · 3 fatalFinal reportLockheed P2V-7 · Reno, NVThe failure of the flight crew to maintain airspeed above in-flight minimum control speed (Vmca) after losing power in the left jet engine during initial climb after takeoff. Contributing to the accident was the crew's inadequate cockpit resource management…NTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.NTSB ANC08CA117Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe student pilot's inadequate recovery from a bounced landing.NTSB SEA08LA192Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Camarillo, CAThe pilot's failure to fly the correct approach profile that resulted in the inadvertent pickup of a banner tow line with the airplane's main landing gear.NTSB MIA08FA177Accident · 1 fatalField investigationFinal reportCessna T310R · Latrobe, PAThe pilot's impairment/incapacitation (cardiovascular) resulting in the pilot being unable to control the airplane.NTSB MIA08CA176Accident · Serious injuriesData collectionFinal reportCameron ZL-60 · Anderson, SCThe pilot's improper use of the balloon burners.NTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.NTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…NTSB NYC08CA300Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Barceloneta, PRThe student pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the high winds.NTSB LAX08LA288Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Gerlach, NVThe pilot's failure to maintain aircraft control during an uncommanded pitch-up during the takeoff.NTSB SEA08LA190Accident · 1 fatalLimited investigationFinal reportLien Zodiac 601 XL · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control after the engine experienced a loss of power. Contributing to the accident was the mixture control arm separating from the fuel metering valve shaft.NTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.NTSB DEN08CA148Accident · No injuriesData collectionFinal reportRobinson R-22 · Refugio, TXThe pilot failed to maintain adequate airspeed while maneuvering to land.NTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.NTSB NYC08LA289Accident · Minor injuriesLimited investigationFinal reportEuropro CZ Eurofox · Millbrook, NYThe pilot's failure to maintain directional control during takeoff.NTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.NTSB CHI08CA267Accident · No injuriesData collectionFinal reportHughes 269A · Bremen, OHThe pilot's failure to maintain sufficient main rotor speed during the quick-stop maneuver. Contributing to the accident was the drainage ditch.NTSB NYC08LA287Accident · Serious injuriesLimited investigationFinal reportBell 206A · Barnesville, PAThe pilot's failure to maintain control of the helicopter during the low-speed, low-altitude maneuver which resulted in a loss of tail rotor effectiveness.NTSB NYC08CA294Accident · No injuriesData collectionFinal reportSacrey W Michael Zenair CH · Fincastle, VAThe pilot's inadvertent premature rotation during takeoff.NTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.NTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.NTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.NTSB LAX08CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Lake Tahoe, CAThe pilot's inadequate compensation for the wind and density altitude conditions and failure to attain and maintain an adequate airspeed that resulted in a stall/mush.NTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.NTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.NTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.NTSB DEN08FA141Accident · 4 fatalField investigationFinal reportCessna 182T · Georgia Pass, COThe pilot's failure to maintain aircraft control after inadvertantly encountering instrument meteorological conditions. Contributing to the accident were the pilot's failure to obtain a weather brief and the severe weather conditions.NTSB CHI08CA252Accident · No injuriesData collectionFinal reportHiller UH-12E · Cokato, MNThe pilot did not visually identify and maintain clearance with the power lines, and the pilot's inability to maintain control of the helicopter once it contacted the power lines. Factors associated with the accident were the low altitude operations being…NTSB SEA08LA178Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Richland, WAThe pilot's failure to maintain an adequate airspeed above stall speed while executing a steeply banked turn in the traffic pattern.NTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…NTSB CHI08CA253Accident · No injuriesData collectionFinal reportCessna 172R · Cincinnati, OHThe student pilot's inadequate recovery from a bounced landing. Contributing to the accident were the improper flare and excessive airspeed.NTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.NTSB NYC08CA277Accident · Minor injuriesData collectionFinal reportMooney M20F · Ridgeland, SCThe pilot's inadequate compensation for a crosswind during landing. A factor contributing to the accident was the crosswind.NTSB DEN08LA139Accident · 1 fatalLimited investigationFinal reportDickey RV-6A · Muskogee, OKThe pilot's improper decision to continue flight under visual flight rules into an area of reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was…NTSB DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…NTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.NTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.NTSB CHI08CA241Accident · Minor injuriesData collectionFinal reportFalk Zodiac HDS-601 · Middleton, WIThe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB DEN08CA133Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe student pilot's failure to maintain control of the airplane. Contributing to the accident were the flight instructor's inadequate supervision, turbulence, airspeed was not maintained, and compensation for the wind conditions was inadequate.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB DEN08LA131Accident · Serious injuriesLimited investigationFinal reportFlynn Van Munk · Erie, COA loss of engine power due to carburetor icing. The reason for the loss of aircraft control was not determined.NTSB LAX08FA256Accident · 5 fatalField investigationFinal reportCessna 172K · Gearhart, ORThe pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.NTSB DFW08CA203Accident · Serious injuriesData collectionFinal reportCollard Dragonfly · Big Sping, TXLoss of aircraft control due to inadvertent penetration of a dust devil.NTSB CHI08CA232Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Wall, SDThe pilot not maintaining airplane control during the landing. Contributing to the accident was the reported wind shear.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.NTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.NTSB DFW08CA208Accident · No injuriesData collectionFinal reportGroom Sparrow Hawk · Tulsa, OKThe student pilot's failure to maintain control of the gyroplane. Contributing to the accident was the lack of recent flight instruction prior to the flight.