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 CHI97LA018Accident · 1 fatalLimited investigationFinal reportFrost RAF 2000 GTX SE · Adrian, MIthe pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.NTSB LAX97LA030Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZimproper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.NTSB FTW97FA032Accident · 1 fatalField investigationFinal reportMooney M20J · San Leon, TXThe pilot's inadvertent stall and spin of the airplane. Factors were the pilot's lack of total experience in the make and model of airplane and the weather conditions.NTSB SEA97TA023Accident · 1 fatalFinal reportBell 47G-3B-1 · Fillmore, UTinadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…NTSB LAX97FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Indio Hills, CAthe pilot's spatial disorientation which led to a loss of aircraft control, and exceeding the aircraft's structural design limits after the aircraft had entered a descending spiral. The pilot's lack of instrument flight currency and the dark night were…NTSB MIA97FA013Accident · 3 fatalField investigationFinal reportCessna 172P · St. Croixthe pilot's failure to maintain airspeed.NTSB IAD97LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Sheffield, MAThe pilot's abrupt control of the airplane, which resulted in an inadvertent stall, uncontrolled descent, and subsequent in-flight collision with water.NTSB CHI97LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jenison, MIthe pilot's inadequate compensation for the wind conditions. A factor was the crosswind condition.NTSB IAD97FA011Accident · 2 fatalField investigationFinal reportRyan Navion · New Hartford, NYA loss of control for undetermined reasons.NTSB IAD97LA010Accident · Minor injuriesLimited investigationFinal reportBellanca BL28 · Ledbetter, KYthe pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.NTSB IAD97LA009Accident · 1 fatalLimited investigationFinal reportCessna 172A · Lebanon, OHimproper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.NTSB SEA97FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Halsey, ORThe pilot-in-command's failure to maintain main rotor RPM, resulting in loss of control of the helicopter and collision with terrain. Factors included the pilot's lack of experience in helicopters, and interpersonal relationship problems between the pilot and…NTSB ANC97LA004Accident · Serious injuriesLimited investigationFinal reportBurns Burn Experimental · Sitka, AKthe pilot's failure to follow the checklist and secure the cockpit door/canopy.NTSB SEA97LA013Accident · 2 fatalLimited investigationFinal reportKeith Vans RV-6A · Hurricane, UTthe pilot's impairment of judgment and performance due to drugs (diphenhydramine) which led to spatial disorientation and loss of aircraft control. Contributing to the accident were: dark night lighting conditions; inoperative airport runway lights; the…NTSB SEA97LA011Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 · Tillamook, ORfailure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.NTSB FTW97LA015Accident · No injuriesLimited investigationFinal reportBeech BE-55B · Bellville, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were the dark night conditions and the pilot's failure to lower the flaps.NTSB SEA97GA008Accident · 2 fatalFinal reportPiper PA-18-150 · Holden, UTThe first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…NTSB SEA97FA006Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cle Elum, WAThe pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…NTSB LAX97LA010Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Santa Rita, CAThe pilot's inadequate preflight inspection of the helicopter.NTSB LAX97LA006Accident · No injuriesLimited investigationFinal reportBell 47G-5A · King City, CAthe pilot's failure to maintain adequate rotor rpm during the takeoff initial climb.NTSB IAD97LA003Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Mahopac, NYthe pilot's failure to maintain directional control during takeoff, which resulted in a inflight collision with trees (sapplings). A factor related to the accident was: the quartering tailwind that was encountered during takeoff.NTSB NYC97LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Coudersport, PAthe pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.NTSB MIA97LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartsville, SCThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an inadvertent stall, and subsequent in-flight collision with terrain and nose over.NTSB FTW97LA009Accident · Serious injuriesLimited investigationFinal reportYoung Cozy MK IV · Pueblo, COthe pilot/builder's improper design change which resulted in a loss of control following an intentional stall. A factor was an erroneous weight-and-balance calculation.NTSB FTW97LA004Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-59 · Sterling, COLoss of control when the pilot exceeded the velocity of stall while in a turn.NTSB MIA97LA001Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Jackson, MSthe pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.NTSB ANC97FA002Accident · 1 fatalField investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's inadequate compensation for wind conditions and failure to maintain adequate airspeed, which resulted in an inadvertent stall. The unfavorable wind condition was a related factor.NTSB SEA96LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar City, UTthe pilot's failure to attain proper airspeed during takeoff, which resulted in a premature lift-off and an encounter with the terrain during the aborted landing. Excessive extension of the wing flaps was a related factor.NTSB FTW96LA404Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Santa Fe, NMThe pilot's failure to obtain/maintain airspeed resulting in an inadvertent stall/mush. Factors were the high density altitude and the lack of suitable terrain for the landing.NTSB MIA96LA232Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Slocomb, ALThe pilot's failure to maintain airspeed.NTSB ANC96TA163Accident · Serious injuriesFinal reportde Havilland U-6A · King Salmon, AKfailure of the pilot to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain (water). Turbulence was a related factor.NTSB LAX96LA342Accident · No injuriesLimited investigationFinal reportBell 206B · Van Nuys, CAthe pilot's improper in-flight planning/decision to turn right instead of left.NTSB LAX96FA340Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Caliente, CAimproper in-flight planning/decision by the flight instructor (CFI) by allowing the airplane to flying into a box canyon area, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with wooded terrain. The CFI's…NTSB ANC96FA161Accident · 1 fatalField investigationFinal reportPiper PA-18 · Minto, AKthe pilot's inadequate compensation for wind conditions, while maneuvering to land, which resulted in inadequate airspeed for conditions, an inadvertent stall, and collision with terrain (water).NTSB LAX96LA345Accident · No injuriesLimited investigationFinal reportCessna 172F · Ehrenberg, AZThe pilot's attempt to perform a low altitude evasive maneuver with inadequate airspeed resulting in a stall/mush.NTSB ANC96FA158Accident · 2 fatalField investigationFinal reportChampion 7EC · May Creek, AKfailure of the pilot to maintain adequate airspeed, while maneuvering and/or flying at low altitude, which resulted in a stall and collision with the terrain. A factor relating to the accident was: the pilot allowed the weight and balance (aft…NTSB CHI96LA336Accident · Serious injuriesLimited investigationFinal reportKenoyer Horizon ONE · Owosso, MIthe pilot's failure to maintain aircraft control and airspeed. A factor was the pilot's lack of experience in type of aircraft.NTSB CHI96FA332Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Bellaire, MIthe pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.NTSB ANC96FA149Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Glennallen, AKfailure of the pilot to maintain adequate airspeed, while maneuvering a low altitude, which resulted in an inadvertent stall and an uncontrolled collision with the terrain. A factor related to the accident was: the pilot's use of a medication with sedative…NTSB FTW96LA382Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Edgewood, NMThe pilot's failure to maintain aircraft control. A factor was a whirlwind.NTSB SEA96FA209Accident · 1 fatalField investigationFinal reportCessna 340A · Wise River, MTThe pilot's attempt to fly in adverse meteorological conditions which led a loss of aircraft control. Factors contributing to the accident include: the pilot's failure to obtain the most current information of the meteorological conditions prior to departure,…NTSB MIA96LA226Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · St Clair, ALfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to ground.NTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.NTSB SEA96TA207Accident · Minor injuriesFinal reportBell 206L-3 · Sheridan, WYthe pilot's improper in-flight planning/decision, concerning maneuvers to position the helicopter for aerial application; and inadvertent loss of tail rotor effectiveness, which resulted in loss of directional control and subsequent collision with the…NTSB CHI96FA330Accident · 1 fatalField investigationFinal reportGreen Castle Avid Flyer Aerobat · Oxford, IAfailure of the private pilot to maintain sufficient airspeed after takeoff, during the initial climb and turn to the crosswind leg; and a delay by the flight instructor (CFI) in taking remedial action to avoid a stall.NTSB ANC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.NTSB CHI96FA324Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Grosse Ile, MIthe pilot exceeding the critical angle of bank required to maintain altitude.NTSB IAD96LA142Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYthe pilot's failure to maintain adequate altitude and airspeed during the landing approach, resulting in a stall/spin and subsequent encounter with an embankment.NTSB CHI96LA325Accident · 1 fatalLimited investigationFinal reportKarr Titan Tornado · Union Pier, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the pilot not maintaining aircraft control and intentional aerobatics.NTSB ANC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKthe pilot's premature liftoff and subsequent inadvertent stall.