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 IAD02FA037Accident · 4 fatalField investigationFinal reportCessna 172P · Ocean City, MDThe pilot's spatial disorientation, which resulted in his subsequent loss of control of the airplane. A factor was the dark night, over water visual conditions.NTSB ATL02LA064Accident · 1 fatalLimited investigationFinal reportKopp Robert E GYRO-KOPP-TER · Citra, FLThe pilots failure to maintain flight control, followed by a subsequent collision with the terrain.NTSB LAX02LA109Accident · 1 fatalLimited investigationFinal reportTrenti RV-4 · Jacumba, CAin-flight loss of control for undetermined reasons.NTSB LAX02FA108Accident · Serious injuriesField investigationFinal reportBeech E90 · Reno, NVThe pilot's inadequate approach airspeed for the existing adverse meteorological conditions followed by his delayed remedial action to avert stalling and subsequent loss of airplane control. Contributing factors were the pilot's reduced visibility due to the…NTSB DEN02FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Glenwood Sprngs, COthe pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.NTSB LAX02FA101Accident · 3 fatalField investigationFinal reportCessna 425 · San Jose, CAthe pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…NTSB LAX02LA100Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Sonoma, CAthe pilot's excessive remedial control inputs in response to a passenger's control inputs, which led to a failure to maintain an adequate airspeed and an inadvertent stall/mush. The pilot's inadequate preflight decision to allow a student pilot to occupy the…NTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..NTSB FTW02LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Extension, LAThe pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.NTSB LAX02LA093Accident · No injuriesLimited investigationFinal reportSaumure Exec 162F · Ramona, CAThe pilot's failure to maintain adequate airspeed and main rotor rpm while performing a low altitude maneuver, which resulted in a loss of translational lift, a hard landing, and rollover on downhill terrain.NTSB LAX02FA088Accident · No injuriesField investigationFinal reportRobinson R22 Beta · Glendora, CAThe student's failure to maintain adequate main rotor rpm, and the flight instructor's inadequate supervision. Contributing factors were the high helicopter gross weight and density altitude, and the descending mountainous terrain.NTSB IAD02LA033Accident · No injuriesLimited investigationFinal reportHughes 269C · Lorain, OHThe pilot's failure to maintain directional control during takeoff.NTSB CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…NTSB NYC02FA060Accident · 1 fatalField investigationFinal reportRockwell 500S · Exeter, RIThe pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.NTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.NTSB IAD02LA030Accident · Minor injuriesLimited investigationFinal reportKorsch Classic IV · East Moriches, NYThe pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.NTSB LAX02LA085Accident · 2 fatalLimited investigationFinal reportEllenberger/Werner Glasair I TD · Minden, NVthe pilot's failure to maintain control of the airplane resulting in the airplane entering a flat spin from which the pilot did not recover.NTSB MIA02FA059Accident · 4 fatalField investigationFinal reportCessna TR182 · Cedar Key, FLthe failure of the pilot to maintain control of the airplane due to spatial disorientation resulting in the airplane descending and colliding with water. A factor in the accident was a dark night .NTSB SEA02LA039Accident · 1 fatalLimited investigationFinal reportBitton/Sport Flight Talon · Boring, ORLoss of control for undetermined reasons.NTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.NTSB SEA02FA036Accident · Serious injuriesField investigationFinal reportAero Commander 520 · Puyallup, WAThe pilot's failure to maintain aircraft control during takeoff. Trees were a factor.NTSB NYC02FA055Accident · 2 fatalField investigationFinal reportBeech V35B · Chester, CTThe pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.NTSB CHI02FA074Accident · 2 fatalField investigationFinal reportCessna 441 · Winfield, KSThe pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.NTSB LAX02LA071Accident · Minor injuriesLimited investigationFinal reportRichard S. Anderson Rotorway Exec 162F · Willcox, AZThe pilot's failure to compensate for a gust condition and to maintain lateral control while hovering due to restricted cyclic control movement, which resulted from an inadequate control location/design.NTSB MIA02LA054Accident · 1 fatalLimited investigationFinal reportQuitzau, Carl Vortex · Immokalee, FLThe failure of the pilot to maintain directional control of the gyroplane resulting in the in-flight loss of control and subsequent in-flight collision with terrain.NTSB NYC02FA051Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Chittenden, VTThe pilot's failure to maintain aircraft control while holding.NTSB CHI02FA067Accident · 1 fatalField investigationFinal reportCessna 402B · Bronson, MIThe maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…NTSB CHI02LA066Accident · No injuriesLimited investigationFinal reportCessna T210N · Chicago, ILthe pilot's failure to maintain aircraft control after takeoff. Factors relating to the accident were the pilot excessive rotation during takeoff and the crosswind.NTSB SEA02LA031Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glasgow, MTThe pilot's failure to maintain adequate flying airspeed resulting in a stall/mush condition and loss of control at low altitude. A contributing factor was the pilot's distraction from flying the aircraft while attempting to retract the landing gear.NTSB ATL02LA042Accident · Minor injuriesLimited investigationFinal reportLouis Edmondson 162F · St. Petersburg, FLThe pilot's decision to continue flight with demonstrated inadequate takeoff performance capability, which resulted in an in-flight loss of control and subsequent hard landing.NTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.NTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB LAX02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Tehachapi, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.NTSB DEN02LA019Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 902 · Aurora, COthe pilot's failure to maintain aircraft control due to inadvertent settling with power resulting in a hard landing. Contributing factors include the improperly planned approach, the high density altitude, and the encounter with vortex ring state.NTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.NTSB LAX02FA061Accident · 1 fatalField investigationFinal reportCessna T337H · Buena Park, CAthe pilot's failure to maintain control of the airplane during the landing approach. Factors included the pilot's distraction when informed that his landing gear was not down, and his impairment from the effects of prescription drugs.NTSB FTW02FA062Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Oak Grove, LAthe pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.NTSB NYC02FA044Accident · 1 fatalField investigationFinal reportRaytheon BE-23-B24R · Armonk, NYThe pilot's failure to maintain aircraft control.NTSB ATL02FA025Accident · 1 fatalField investigationFinal reportCessna C-210N · Lilburn, GAThe pilot's failure to maintain aircraft control.NTSB CHI02FA059Accident · 2 fatalField investigationFinal reportBorgman Smyth Sidewinder · Independence, KSThe pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.NTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.NTSB MIA02FA045Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Jacksonville, FLThe pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.NTSB MIA02FA044Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Raleigh, NCthe pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…NTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.NTSB ATL02FA017Accident · 3 fatalField investigationFinal reportBeech BE-55 · Montgomery, ALThe pilots failure to maintain airspeed while maneuvering in instrument flight conditions resulting in an inadvertence stall/spin (vertical descent) and subsequent in-flight collision with trees and terrain.NTSB FTW02FA048Accident · 2 fatalField investigationFinal reportGates Learjet 24D · Sierra Blanca, TXloss of control during descent for undetermined reasons.NTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.