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 ATL02LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · St. Simons Island, GAThe pilot's failure to maintain airspeed during a simulated emergency landing, and his delayed remedial action that resulted in a stall, and an uncontrolled collision with trees. A factor was the check pilot's inadaquate supervision of the check ride.NTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.NTSB ANC02LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bethel, AKThe instructor pilot's inadequate preflight by his failure to remove all frost from the wings prior to takeoff, which resulted in an inadvertent stall and in-flight collision with terrain.NTSB LAX02FA285Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Tucson, AZthe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude, which resulted in a stall spin.NTSB CHI02FA284Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Westphalia, MOThe pilot's spatial disorientation while turning in a cruise climb in instrument meteorological conditions, which resulted in the pilot's loss of aircraft control, and his failure to recover from a resultant tight descending spiral.NTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.NTSB DEN02LA103Accident · 1 fatalLimited investigationFinal reportAdler SA-1 · Mead, COthe pilot's failure to maintain main rotor rpm, resulting in blade flapping, subsequent blade contact with the airframe, and loss of control.NTSB LAX02LA277Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus-B · Peoria, AZThe pilot's abrupt maneuver, which resulted in an inadvertent stall.NTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB LAX02LA273Accident · 1 fatalLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAThe pilot's loss of control for undetermined reasons. A contributing factor was low ceiling.NTSB FTW02FA243Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Decatur, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.NTSB ANC02FA108Accident · 2 fatalField investigationFinal reportRobinson R-44 · Ketchikan, AKThe pilot's failure to maintain control of the helicopter in-flight due to spatial disorientation, which resulted in an uncontrolled descent and impact with the surface of a lake. Factors contributing to the accident were the high terrain surrounding the…NTSB ANC02FA107Accident · 2 fatalField investigationFinal reportCessna A185F · Kodiak, AKThe pilot's failure to maintain adequate airspeed and his operation of the airplane in an over gross condition. A contributing factor was noncompliance with written company weight and balance procedures.NTSB DEN02TA100Accident · Serious injuriesFinal reportBell 206L-3 · Saguache, COthe pilot's inadequate in-flight planning and decision making, and the loss of tail rotor effectiveness. A contributing factor was the right quartering tailwind.NTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.NTSB NYC02FA166Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Deerfield, VAThe pilot's improper preflight decision to takeoff on an up-sloping runway with a tailwind, which resulted in an inadvertent stall and collision with a tree. Factors were the pilot's lack of familiarity with the geographic area, and a tailwind.NTSB MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…NTSB DEN02GA097Accident · 1 fatalFinal reportArctic S-1B2 · Meeteetse, WYthe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the intentional low pass/slow flight maneuver.NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.NTSB ANC02FA097Accident · 2 fatalField investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall, and subsequent collision with trees.NTSB NYC02LA163Accident · No injuriesLimited investigationFinal reportNiemann Champion II · Foxboro, MAThe pilot's failure to maintain aircraft control during the landing flare.NTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.NTSB SEA02LA150Accident · No injuriesLimited investigationFinal reportHughes 269A · Covington, WAAircraft control not maintained while hovering.NTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.NTSB FTW02LA236Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Paso, TXThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control. Contributing factors were the cross wind, and the pilot's lack of experience in the make and model of the accident airplane.NTSB ATL02FA156Accident · 3 fatalField investigationFinal reportCessna 182R · Lake City, TNThe pilot's failure to follow procedures pertaining to mountain flying, and the pilot's failure to maintain airspeed that resulted in an inadvertent stall and subsequent in-flight collision with trees and terrain. A factor was the certified flight instructor…NTSB MIA02LA146Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Fort Lauderdale, FLthe pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.NTSB CHI02FA237Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Festus, MOThe pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.NTSB FTW02LA231Accident · Minor injuriesLimited investigationFinal reportPage Rans S-7 · Welsh, LAthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.NTSB NYC02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's failure to maintain airspeed and the flight instructor's delayed remedial action, which resulted in an inadvertent stall during a simulated forced landing. A factor was the rising terrain.NTSB LAX02LA246Accident · No injuriesLimited investigationFinal reportAero Commander S2R-T34 · Los Banos, CAThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB ANC02LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKA jammed flight control system yoke/stick, which made directional control of the airplane not possible, and resulted in an in-flight collision with terrain.NTSB FTW02LA224Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Marietta, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI02LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, NEThe pilot not maintaining sufficient airspeed during the takeoff, and the inadvertent stall encountered by the pilot. The low altitude was a factor.NTSB SEA02LA142Accident · Minor injuriesLimited investigationFinal reportKaminski RAF 2000 · Newberg, ORThe pilot's inadequate compensation (excessive altitude) for crosswind conditions resulting in the gyroplane's rotors contacting the ground. Contributing factors were the gusty crosswind conditions.NTSB IAD02TA081Accident · 1 fatalFinal reportCrawford Widebody Long EZ · Martha's Vineyard, MAPilot incapacitation from a massive subarachnoid hemorrhage (stroke.)NTSB CHI02FA228Accident · 1 fatalField investigationFinal reportAeronca 7AC · Caro, MIThe passenger became incapacitated as a result of a stroke which lead to the inadvertent interference with the flight controls.NTSB ATL02FA150Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Spartanburg, SCThe pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.NTSB DEN02LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COthe student pilot's failure to maintain aircraft control and subsequent inadvertent stall/mush into terrain during a soft field take off. Contributing factors include the pilot's lack of experience and the high density altitude conditions.NTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.NTSB ATL02LA146Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A · Indianola, MSThe pilot's failure to maintain airspeed which resulted in a stall and the subsequent uncontrolled collision with the ground while maneuvering for an aerial application run.NTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.NTSB LAX02LA240Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · San Manuel, AZthe pilot's failure to maintain adequate airspeed while maneuvering in a box canyon, which resulted in a stall/mush. A factor in the accident was downdraft conditions that led to an uncontrolled decent.NTSB ANC02LA081Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Deadhorse, AKThe pilot's failure to correct a settling-with-power condition during a helicopter landing flare/touchdown, resulting in a hard landing and roll over.NTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.NTSB CHI02FA199Accident · 2 fatalField investigationFinal reportBeech E-90 · Bloomington, ILThe cause of the accident is undetermined.