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 ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB MIA05CA075Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Clermont, FLThe pilot's inadvertent deploying of the spoilers, while on final approach, resulting in the glider descending and impacting trees.NTSB DFW05FA086Accident · 3 fatalField investigationFinal reportBell 206B-3 · Shelbyville, TXThe pilot's failure to maintain altitude and clearance for undetermined reasons.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB DEN05LA059Accident · 1 fatalLimited investigationFinal reportBourgeois-Avid Flyer MK IV · Kaycee, WYthe pilot's failure to maintain airspeed which resulted in a stall.NTSB SEA05LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · The Dalles, ORThe student pilot's improper compensation for the wind condition and the improper rejected landing procedure, which resulted in the collision with terrain. A contributing factor to the accident was the crosswind condition.NTSB DFW05FA073Accident · 1 fatalField investigationFinal reportBell 206-L1 · Gentry, ARThe pilot’s improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness.NTSB MIA05LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Avon, MSThe pilot's failure to maintain airspeed while maneuvering at a low altitude, resulting in an inadvertent stall/mush, and impact with terrain.NTSB MIA05LA058Accident · Serious injuriesLimited investigationFinal reportInterplane Sro Skyboy · Zephyrhills, FLThe instructors in-flight loss of control due to the flight controls being jammed for undetermined reasons.NTSB DFW05CA070Accident · Minor injuriesData collectionFinal reportRobinson R22 · Owasso, OKThe flight instructor's failure to verify that the student had the flight controls and his delayed remedial action.NTSB DCA05MA037Accident · 8 fatalClass 1 · MajorFinal reportCessna 560 · Pueblo, COthe flight crew's failure to effectively monitor and maintain airspeed and comply with procedures for deice boot activation on the approach, which caused an aerodynamic stall from which they did not recover. Contributing to the accident was the Federal…NTSB IAD05LA038Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Penn Yan, NYThe flight instructor's inadequate planning/decision and his remedial action to conduct or recover from a simulated emergency procedure.NTSB ANC05LA033Accident · 2 fatalLimited investigationFinal reportTwente Pitts Model 12 · Marion, MSThe pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…NTSB IAD05LA039Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Woodbine, NJThe student's failure to maintain control of the airplane, and the flight instructor's inadequate remedial action, which resulted in an uncontrolled descent into terrain.NTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.NTSB DFW05FA065Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Alexandria, LAThe pilot's loss of control while maneuvering to land.NTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.NTSB DEN05LA053Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Pilar, NMthe pilot's failure to maintain control of the helicopter, and his improper use of night vision goggles (NVG). Contributing factors were the pilot's spatial disorientation, his self-induced pressure to return the helicopter to its home base, his lack of…NTSB DEN05CA052Accident · No injuriesData collectionFinal reportHughes 269C · Englewood, COthe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight. Contributing factors were low rotor rpm, low airspeed, and the instructor's delay in taking remedial action.NTSB LAX05CA078Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe certified flight instructor's inadequate use of the antitorque control pedals while adding throttle, which led to a loss of directional control.NTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.NTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…NTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.NTSB DFW05LA118Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Little Rock, ARThe pilot's failure to maintain control of the airplane during an instrument approach for undetermined reasons. Contributing factors were the mist and low cloud ceiling.NTSB DFW05LA053Accident · Serious injuriesLimited investigationFinal reportMyers Kit Fox Series VI · Cleveland, OKThe pilot's failure to maintain control and sufficient airspeed while performing an abrupt pull-up manuever after takeoff, which resulted in an inadvertent stall/spin.NTSB ATL05FA041Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Bradley, SCThe pilot's loss of control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with trees and the ground. A factor was the dark night conditions.NTSB LAX05FA061Accident · 2 fatalField investigationFinal reportVail Lancair 235 · Sacaton, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall/spin.NTSB LAX05LA060Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC135T1 · Casa Grande, AZthe separation of a main rotor control link due to improper maintenance installation.NTSB IAD05CA027Accident · Minor injuriesData collectionFinal reportEnstrom 280C · Pedricktown, NJThe pilot's failure to maintain control of the helicopter during the takeoff and his failure to flare during the autorotation.NTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.NTSB SEA05TA028Accident · Serious injuriesFinal reportChristen Industries A-1 · Terreton, IDThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DEN05LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 · Park City, UTthe student pilot's failure to maintain aircraft control, and the instructor's inadequate supervision by her failure to assure adequate rotor rpm was maintained.NTSB SEA05CA027Accident · Minor injuriesData collectionFinal reportBreit Zodiac (CH-601-HDS) · Everett, WAThe pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.NTSB LAX05FA053Accident · 1 fatalField investigationFinal reportEurocopter AS-350-B3 · Apache Junction, AZA loss of control during the final approach to land for undetermined reasons.NTSB DFW05LA037Accident · 2 fatalLimited investigationFinal reportCrosley Christen Eagle II · Morris, OKThe pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.NTSB DEN05LA035Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Monte Vista, COthe pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.NTSB DFW05LA034Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Bay View, TXThe pilot's failure to maintain directional control as result of his improper runway selection for takeoff. A contributing factor was the prevailing right quartering tailwind.NTSB SEA05FA025Accident · 2 fatalField investigationFinal reportCessna 208B · Bellevue, IDThe pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.NTSB LAX05LA039Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Rialto, CAthe pilot's failure to maintain adequate rotor rpm and altitude/clearance during the takeoff initial climb.NTSB NYC05LA020Accident · Serious injuriesLimited investigationFinal reportUnknown Sky Raider · Rappahannock Ac, VAThe uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.NTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB DFW05FA020Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.NTSB MIA05LA029Accident · Serious injuriesLimited investigationFinal reportJoseph R. Sirgo Aquilla · Eustis, FLThe passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.NTSB CHI05LA030Accident · 1 fatalLimited investigationFinal reportHedge Bede-4 · Omaha, NEThe pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.NTSB CHI05CA029Accident · Minor injuriesData collectionFinal reportGray Skybolt · St. Clair, MIThe pilot's improper spin recovery procedure, which resulted in a failure to maintain control of the aircraft during the intentional spin. An additional cause was the pilot's inability to maintain clearance to the trees and terrain during recovery.…NTSB LAX05LA020Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350-BA · Oxnard, CAThe inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…NTSB DFW05LA022Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Eagle Pass, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the unsuitable terrain for landing.NTSB NYC05CA018Accident · No injuriesData collectionFinal reportKinner Sportster · Millbrook, NYThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.