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 NYC08LA021Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Pensacola, FLThe fatigue fracture of the tail wheel spring during takeoff.NTSB LAX08CA021Accident · No injuriesData collectionFinal reportBeech A36 · Camarillo, CAThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall.NTSB DEN08LA017Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Salida, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain.NTSB LAX08CA018Accident · No injuriesData collectionFinal reportBell 206L-1 · Ramona, CAThe pilot's failure to maintain control and correct a descent and a loss of tail rotor effectiveness while maneuvering at a low altitude and reduced airspeed.NTSB ANC08CA009Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Pilot Point, AKThe pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in a loss of control, and an in-flight collision with terrain. Factors associated with the accident were gusty, high winds.NTSB MIA08CA008Accident · No injuriesData collectionFinal reportGlobe GC-1B · Edenton, NCThe pilot's failure to maintain airspeed while on final approach resulting in an inadvertent stall.NTSB CHI08CA024Accident · No injuriesData collectionFinal reportCessna C-182 · Cedar Springs, MIThe pilot's decision to takeoff with strong, gusty winds and his inability to stop the airplane prior to it traveling off the end of the runway during the delayed aborted takeoff. Factors associated with the accident were the wet, grass airstrip and gusty…NTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.NTSB DFW08FA015Accident · 5 fatalField investigationFinal reportBeech A36 · Glenpool, OKThe pilot's failure to maintain control of the airplane after departure, which resulted in a collision with power lines. A factor was the high winds.NTSB DEN08LA013Accident · No injuriesLimited investigationFinal reportLearjet 35A · Goodland, KSThe pilot's failure to maintain aircraft control during the landing.NTSB CHI08CA019Accident · No injuriesData collectionFinal reportBell 47G-2A · Wautoma, WIThe pilot's failure to maintain control of the helicopter resulting from a distraction in the cockpit. A contributing factor was the distraction due to the dog in the cockpit.NTSB LAX08CA013Accident · No injuriesData collectionFinal reportPoser DM 582 Buckeye · Hurricane, UTThe pilot's inadequate compensation for the existing wind conditions and subsequent failure to maintain aircraft control.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB NYC08CA011Accident · No injuriesData collectionFinal reportSlagle Thorp T-18 · Franklin, KYThe pilot's failure to maintain control of the airplane during the landing.NTSB DFW08CA010Accident · No injuriesData collectionFinal reportEurocopter EC 130 · Bay St Louis, MSThe pilot's encounter with dynamic rollover as result of his inadequate preflight inspection.NTSB MIA08LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Hillsville, VAThe pilot's failure to maintain control of the airplane during a go-around.NTSB DFW08CA014Accident · No injuriesData collectionFinal reportAir Tractor 402B · Taft, TXThe pilot's failure to maintain control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.NTSB NYC08LA001Accident · 1 fatalLimited investigationFinal reportLambert John G Varieze · Chesapeake, VAA loss of control in flight for undetermined reasons.NTSB CHI07LA309Accident · No injuriesLimited investigationFinal reportRobinson R44 · Jackson Center, OHThe reported vibration in the helicopter during an approach for landing for undetermined reasons. Contributing to the accident was the mature cornfield.NTSB CHI07CA315Accident · Minor injuriesData collectionFinal reportAerotechnik Sportstar-Evektor · Maple Lake, MNThe student pilot's failure to relinquish the flight controls and the flight instructor's inadequate supervision which resulted in the certified flight instructor not being able to maintain directional control. Contributing factors included the student…NTSB DEN07LA167Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Silver City, NMThe student pilot's failure to maintain control of the helicopter resulting in his settling with power and subsequent impact with terrain. A factor contributing to the accident was the trees.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB DEN07FA165Accident · 1 fatalField investigationFinal reportCessna T210M · Moriarty, NMthe instructor pilot's failure to maintain aircraft control during aborted landing and attempted go-around which resulted in an inadvertent elevator trim stall. Contributing to the accident were the instructor pilot's inadequate supervision during the…NTSB SEA07LA270Accident · Serious injuriesLimited investigationFinal reportSocata TB20 · Beatty, NVThe pilot's failure to follow the manufacturer's procedures during a go-around and subsequent loss of airplane control. A contributing factor to the accident was the dark night.NTSB ATL07LA129Accident · 1 fatalLimited investigationFinal reportKolb MK II · Sweetwater, TNThe pilot's failure to maintain control of the airplane during climb.NTSB ANC07FA102Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe failure of the pilot's seat to engage, or remain engaged, and the pilot's inadvertent stall/mush during takeoff-initial climb. Contributing to the accident was the failure of maintenance personnel to comply with an FAA AD regarding the pilot's seat rails.NTSB SEA07CA269Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Bend, ORProper descent rate not obtained/maintained during a pinnacle approach.NTSB SEA07LA266Accident · Serious injuriesLimited investigationFinal reportSt. Claire Ragtop-01 · Perris, CAThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing factors to the accident were the fence and the undetermined brake malfunction.NTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.NTSB LAX07LA280Accident · Serious injuriesLimited investigationFinal reportRoot Sherpa · Scappoose, ORA loss of aircraft pitch control due to the fatigue failure of the fuselage tube structure at the flight control stick gimbal mechanism due to an incomplete weld penetration at the root of the weld.NTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.NTSB DEN07FA158Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik a.s. SportStar · Erie, COThe flight instructor's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/spin. Contributing to the accident was the flight instructor's inadequate preflight planning, his failure to calculate the airplane's weight and…NTSB LAX07LA278Accident · No injuriesLimited investigationFinal reportSkykits Savannah ADV · Lava Hot Spring, IDFailure of the pilot to maintain aircraft control during landing.NTSB LAX07CA273Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Oakland, CAThe student pilot's failure to adequately compensate for the crosswind conditions and to maintain directional control.NTSB SEA07FA263Accident · 1 fatalField investigationFinal reportAero Vodochody L-39C · Reno, NVThe pilot's encounter with wake turbulence while maneuvering over a race course. Contributing to the accident was the low altitude at which the encounter occurred.NTSB NYC07CA231Accident · No injuriesData collectionFinal reportMooney M20C · Allentown, PAThe pilot's improper recovery from a bounced landing.NTSB MIA07CA151Accident · No injuriesData collectionFinal reportSchleicher ASW-24E · Morganton, NCThe failure of the pilot to maintain airspeed while turning base to final resulting in the left wing contacting the ground.NTSB DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB NYC07CA218Accident · No injuriesData collectionFinal reportPiper PA-28-181 · N Myrtle Beach, SCThe pilot's failure to maintain aircraft control during a go-around, which resulted in a collision with water. A factor in this accident was the crosswind conditions.NTSB CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.NTSB NYC07LA212Accident · 2 fatalLimited investigationFinal reportSchrack Starduster Too · Verona, KYThe pilot's failure to maintain airspeed during initial climb. Contributing to the accident was the inadvertent stall.NTSB ANC07TA093Accident · No injuriesFinal reportPiper PA-18-150 · Valdez, AKThe pilot's selection of unsuitable terrain for takeoff. A factor contributing to the accident was an inadvertent stall/mush.NTSB NYC07LA210Accident · 1 fatalLimited investigationFinal reportCessna 150J · Hazleton, PAThe pilot’s failure to maintain airspeed while maneuvering at low altitude.NTSB MIA07CA139Accident · Minor injuriesData collectionFinal reportTrinidad TB-20 · White Plains, NYThe pilot's failure to obtain adequate airspeed for takeoff which resulted in a stall, runway overrun down an embankment, and collision with a fence. A factor in accident was the pilot not utilizing the full length of the runway for takeoff.NTSB DEN07LA152Accident · Serious injuriesLimited investigationFinal reportSlingsby Swallow Type T.45 · Hutchinson, KSThe pilot's failure to maintain aircraft control during a low altitude release resulting in an inadvertent stall/spin. Contributing factors were the pilot's decision to turn back to the airport at low altitude and the wind gust.NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB SEA07FA247Accident · 6 fatalField investigationFinal reportLancair LC41-550FG · Kernville, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. Contributing to the accident was the pilot's failure to maintain an adequate airspeed.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.