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 MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.NTSB DFW05LA016Accident · Serious injuriesLimited investigationFinal reportWilson Loenslo YMF-80 · Arcola, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff initial climb.NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.NTSB ATL05LA017Accident · Serious injuriesLimited investigationFinal reportDavid Nielson Ison Hi-Max 1700 · Hendersonville, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB NYC05LA010Accident · Serious injuriesLimited investigationFinal reportFairchild 24R-40 · Custar, OHThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.NTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.NTSB MIA05LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot-in-command's failure to maintain airspeed while on base to final leg, which resulted in an inadvertent stall/mush and subsequent impact with the runway.NTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.NTSB CHI05LA015Accident · 1 fatalLimited investigationFinal reportStrissel Pitts S1S · Liberal, KSThe pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.NTSB MIA05FA008Accident · 3 fatalField investigationFinal reportEurocopter Deutschland BO-105 CBS5 · Santa Rosa Bch, FLThe pilot's spatial disorientation and in-flight loss of control of the helicopter after encountering night instrument meteorological conditions resulting in collision with water during the resultant uncontrolled descent. A factor in the accident was the…NTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.NTSB NYC05FA006Accident · 1 fatalField investigationFinal reportBeech H50 · Hartwood, VAThe pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.NTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.NTSB MIA05CA006Accident · No injuriesData collectionFinal reportSchweizer 269C · Diamond Head, MSThe pilot's inadvertent loss of tail rotor effectiveness during takeoff to a hover and aborted landing in a grass area resulting in the grass catching fire from the engine exhaust and the helicopter being consumed by fire.NTSB LAX05LA009Accident · 1 fatalLimited investigationFinal reportBrackett And Peltz Kit Fox III · Aguila, AZthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.NTSB ANC05CA007Accident · No injuriesData collectionFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain adequate airspeed during the landing approach, which resulted in a stall and an uncontrolled descent to the runway. A factor contributing to the accident was an inadvertent stall.NTSB SEA05LA006Accident · 1 fatalLimited investigationFinal reportCaldwell Glasair II · Hermiston, ORThe pilot's failure to maintain an airspeed above stall speed while executing a wingover maneuver at the top of a vertical climb, leading to an inadvertent spin, and the pilot's inadequate remedial action in attempting to recover from the spin. Factors…NTSB SEA05LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Oak Harbor, WAThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain.NTSB IAD05LA003Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Pittsburgh, PAThe delayed remedial action by the flight instructor.NTSB NYC05CA008Accident · No injuriesData collectionFinal reportHughes 269C · Minerva, OHThe pilot's failure to maintain control of the helicopter during liftoff.NTSB ANC05CA004Accident · Serious injuriesData collectionFinal reportCessna 185F · King Salmon, AKThe pilot's failure to use a checklist, and to remove the flight control locks prior to flight, which resulted in an uncontrolled descent and in-flight collision with terrain/water.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.NTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB LAX04CA332Accident · No injuriesData collectionFinal reportBell 222U · Santa Rosa, CAthe pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.NTSB LAX04FA330Accident · Serious injuriesField investigationFinal reportBushmaster 2000 · Fullerton, CAthe inadequate preflight inspection by the pilot-in-command, where the pilot failed to remove the makeshift gust lock attached to the rudder and left elevator of the airplane. As a result, the airplane veered off the runway surface during the takeoff roll,…NTSB ANC04LA113Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A · Kodiak, AKThe pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.NTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB CHI04CA266Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Hurdland, MOThe pilot's failure to maintain proper airspeed and directional control during the takeoff and his failure to properly abort the takeoff after the encountered tailstrike. A factor to the accident was the stall/mush encountered during the attempted takeoff and…NTSB LAX04LA320Accident · Serious injuriesLimited investigationFinal reportHebb Avid Magnum · Bridgeport, CAthe pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.NTSB ANC04LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to compensate for wind conditions during landing, and his failure to maintain adequate airspeed, which resulted in a loss of control, and subsequent collision with trees during an uncontrolled descent. Factors contributing to the accident…NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB CHI04FA257Accident · 4 fatalField investigationFinal reportCessna 182T · Chesterfield, MOThe pilot not maintaining airspeed and the inadvertent stall he encountered during the go-around. A factor was the tree he impacted during his uncontrolled descent.NTSB CHI04CA258Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Detroit, MIThe student pilot's failure to maintain directional control of the airplane during the landing flare and subsequent go-around. A factor was the T-hangar.NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.NTSB FTW04LA236Accident · 1 fatalLimited investigationFinal reportLancair 360 · Orange, TXThe pilot's failure to maintain adequate airspeed during takeoff resulting in an inadvertent stall and loss of aircraft control.NTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.NTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.NTSB FTW04FA235Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rachel, TXThe total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB MIA04LA131Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · St. ThomasThe failure of the pilot-in-command to comply with performance data related to the recommended takeoff profile and his failure to perform remedial action following reduced tailrotor effectiveness, resulting in subsequent initiation of an autorotation and…NTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.NTSB ANC04FA102Accident · 2 fatalField investigationFinal reportPiper PA-12 · Koliganek, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall and an uncontrolled descent.