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 IAD02FA074Accident · 1 fatalField investigationFinal reportWehrlen Glassair II RG · Jackson, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with terrain.NTSB CHI02CA203Accident · Minor injuriesData collectionFinal reportBilgri Sonerai II Lts · Juneau, WIThe pilot's failure to maintain sufficient airspeed while maneuvering to return to the airport. A reduction in handling quality and the distraction due to the open canopy were contributing factors.NTSB FTW02FA211Accident · 1 fatalField investigationFinal reportNorth American AT-6A · Albany, TXThe pilot's failure to maintain aircraft control.NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).NTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.NTSB CHI02FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lee's Summit, MOThe inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…NTSB ANC02LA080Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cordova, AKThe pilot's selection of an unsuitable runway for takeoff, which precipitated an in-flight loss of control and subsequent collision with terrain.NTSB DEN02FA076Accident · 2 fatalField investigationFinal reportWheeler Doug 2000 · Ogden, UTthe pilot's failure to obtain and maintain adequate main rotor rpm, resulting in blade flapping and subsequent blade contact with the airframe, severing of the tailboom, and causing loss of aircraft control. Contributing factors were the high gusty winds, and…NTSB CHI02CA194Accident · No injuriesData collectionFinal reportGrumman G-164 · Browning, ILthe failure of the pilot-in-command to maintain sufficient airspeed while maneuvering. The initial stages of a stall/mush condition, and the low maneuvering altitude due to the agricultural application pass, were contributing factors.NTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.NTSB IAD02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Barre, VTThe pilot's failure to maintain airspeed during a go-around attempt, which resulted in an inadvertent stall and a subsequent impact with trees. A factor was the pilot's delayed initiation of the go-around.NTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.NTSB LAX02FA227Accident · 4 fatalField investigationFinal reportCessna 177 · Hana, HIThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall.NTSB LAX02LA224Accident · No injuriesLimited investigationFinal reportMcConnell Lancair 320 · Sedona, AZthe pilot's inadequate compensation for a right, quartering tailwind during landing resulting in a loss of aircraft control and dragging a wing during the landing flare.NTSB IAD02LA072Accident · No injuriesLimited investigationFinal reportDesimone Zodiac CH-601-H · Wadsworth, OHThe pilot's overrotation after take off, which resulted in an inadvertent stall/mush. A factor was the pilot's decision to take off with a tailwind.NTSB CHI02CA198Accident · No injuriesData collectionFinal reportBaughman KR-2 · Scribner, NEThe pilot's excessive rotation and his failure to attain climb which resulted in a stall/mush.NTSB ANC02LA074Accident · No injuriesLimited investigationFinal reportCessna U206F · Koliganek, AKThe pilot's premature lift-off which precipitated an in-flight loss of control, and subsequent collision with terrain.NTSB SEA02LA126Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Deer Park, WALoss of control for undetermined reasons.NTSB DEN02FA070Accident · No injuriesField investigationFinal reportBoone Rotorway 162-F · Englewood, COthe pilot encountering settling with power. A factor contributing to the accident was the tailwind.NTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…NTSB CHI02LA181Accident · No injuriesLimited investigationFinal reportBell 206B · Three Rivers, MIA loss of tail rotor effectiveness.NTSB ANC02FA070Accident · 2 fatalField investigationFinal reportZawada Super Cuby · Cantwell, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, and subsequent collision with terrain. A contributing factor was the pilot's impairment from the effects of prescription painkilling drugs.NTSB NYC02LA129Accident · 1 fatalLimited investigationFinal reportPank KitFox · Sprakers, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in category of aircraft.NTSB MIA02LA125Accident · No injuriesLimited investigationFinal reportMooney M20R · Mt. Pleasant, SCThe pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.NTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.NTSB DEN02LA063Accident · 1 fatalLimited investigationFinal reportRich RV-4 · Grand Junction, COthe pilot failing to maintain aircraft control during the pull up maneuver. A factor relating to the accident was the inadvertent stall spin.NTSB FTW02LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 · Houston, TXThe pilot's loss of control after encountering dynamic rollover during takeoff. A contributing factor was the pilot's inadequate preflight inspection.NTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.NTSB CHI02LA176Accident · 1 fatalLimited investigationFinal reportBar/Curtiss JN-4D · Owatonna, MNThe pilot's failure to maintain adequate airspeed during the takeoff climb resulting in an inadvertent stall. A factor associated with the accident was the low altitude at which the stall occurred.NTSB ATL02LA131Accident · No injuriesLimited investigationFinal reportBeech 18 · Venice, FLThe pilot's improper use of flight controls during takeoff, that resulted in the loss of control during takeoff.NTSB DEN02LA057Accident · No injuriesLimited investigationFinal reportBeech 58P · Broomfield, COthe pilot's failure to follow procedures for a balked landing which resulted in a stall/mush.NTSB FTW02LA186Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Grand Lake, LAthe pilot's inability to control the helicopter in a hover due to the restricted movement of the cyclic for undetermined reasons.NTSB NYC02LA124Accident · No injuriesLimited investigationFinal reportHunter A-28 Victor · Shelter Island, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a collision with trees.NTSB MIA02LA115Accident · 2 fatalLimited investigationFinal reportBailey Dragon Fly · Trenton, GAthe pilot-in-command's failure to maintain airspeed while maneuvering, which resulted in the airplane stalling, spinning, and impacting with the ground.NTSB MIA02LA114Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Carrollton, GAthe pilot's inadequate compensation for wind and his failure to maintain aircraft control.NTSB SEA02FA106Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics LA-4-200 · Puyallup, WAFailure to maintain aircraft control during a go-around. Trees were a factor in the accident.NTSB ANC02LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor associated with the accident is a ditch adjacent to the runway.NTSB LAX02LA202Accident · 1 fatalLimited investigationFinal reportYakovlev YAK 52 · Antioch, CAThe loss of control while performing acrobatic maneuvers due to a screwdriver restricting elevator travel. A contributing factor was the airplane's fuselage not being sterile of foreign objects.NTSB NYC02LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Seaman, OHThe pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.NTSB IAD02LA059Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK21 · Woodstock, VAThe pilot's failure to recognize the loss of orographic lift conditions. A factor was the loss of orographic lift.NTSB ATL02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · N Myrtle Beach, SCThe pilot's failure to maintain airspeed during a banner tow pickup resulting in an inadvertent stall and uncontrolled descent and collision with terrain.NTSB LAX02LA192Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Goldfield, NVThe pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.NTSB CHI02LA155Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Alexandria, INThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.NTSB LAX02LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Henderson, NVThe student pilot's inadequate recovery from a bounced landing and the instructor's inadequate supervision.NTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.NTSB ATL02LA115Accident · Serious injuriesLimited investigationFinal reportFrank Fitzgerald Team Z Max · Huntsville, ALThe pilot's failure to maintain airspeed during a take off climb resulting in a loss of control (inadvertent stall) and the subsequent in-flight collision with terrain. A factor was the lack of total experience in type of aircraft.NTSB DEN02LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Rock Springs, WYthe pilot's failure to maintain aircraft control during initial takeoff climb. A contributing factor was the gusty crosswind.NTSB LAX02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kingman, AZthe CFI's failure to obtain/maintain an adequate airspeed during an attempted go-around, which resulted in a stall/mush condition. The high density altitude, tailwind, inadequate supervision, and overgross weight condition were factors.NTSB MIA02LA099Accident · Minor injuriesLimited investigationFinal reportPiper J-3F-65 · Eton, GAThe pilot's failure to maintain directional control during initial climb after takeoff, resulting in collision with a power pole. A factor in the accident was the flight's encounter with a downdraft condition during initial climb.