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 IAD97LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, NHThe pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.NTSB FTW97FA249Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-2B · Hobbs, NMThe pilot's failure to select an off-field landing site with sufficient time/altitude to perform the landing which led to his failure to maintain airspeed. A factor was the unfavorable wind.NTSB CHI97LA202Accident · Minor injuriesLimited investigationFinal reportNiquette Pietenpol GN-1 · Lake Village, INthe pilot's inability to maintain sufficient airspeed and climb.NTSB NYC97LA134Accident · Minor injuriesLimited investigationFinal reportMartin Velocity RG · Montauk, NYThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions.NTSB FTW97LA251Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Powderly, TXThe inadvertent stall due to the pilot's diverted attention to an open service door. A factor was the inadequate preflight inspection by the pilot.NTSB FTW97LA257Accident · Serious injuriesLimited investigationFinal reportReiffer RS-15 · Ward, ARThe pilot's inadvertent stall. Factors were the pilot's failure to attain the proper touchdown point, his failure to use the flaps to obtain the proper touchdown point, and the pilot's lack of recent experience in the type of aircraft.NTSB FTW97LA252Accident · Serious injuriesLimited investigationFinal reportBell 206B · New Iberia, LAthe pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.NTSB CHI97FA200Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · St. Paul, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. Related factors were the pilot's diverted attention and gusty wind conditions.NTSB MIA97LA202Accident · 1 fatalLimited investigationFinal reportDFL Holdings Tango · Keystone, FLan in-flight loss of control for undetermined reasons.NTSB FTW97LA238Accident · No injuriesLimited investigationFinal reportCessna 305A · Watkins, COThe pilot inadvertently stalling the airplane at an altitude insufficient for a safe recovery. A factor was the tailwind.NTSB FTW97LA237Accident · Serious injuriesLimited investigationFinal reportRans S-12 Airaile S-12 · Fort Collins, COAttempt by the pilot to fly the aircraft with the center of gravity out of limits. A factor was a disconnected lift strut support cable.NTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB MIA97LA192Accident · 1 fatalLimited investigationFinal reportUnknown Kolb Firestar II · Orlando, FLInadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.NTSB LAX97LA218Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The unapproved field modification of the cyclic trim switch, including the use of non-standard parts, which resulted in a hard-over lateral trim failure, and the pilot's subsequent failure to maintain control of the helicopter during a landing approach. A…NTSB ATL97LA087Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Labelle, FLfailure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.NTSB SEA97LA143Accident · No injuriesLimited investigationFinal reportCessna A188 · Richland, WAthe pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.NTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.NTSB LAX97LA214Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Jean, NVThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's failure to retract the flaps during the go-around.NTSB NYC97FA118Accident · 2 fatalField investigationFinal reportCessna 152 · Edgewater, MDThe pilot's excessive maneuver at a low altitude, and the flight instructor's inadequate supervision of the pilot, which resulted in an inadvertent stall/spin.NTSB FTW97FA221Accident · 2 fatalField investigationFinal reportCessna 172N · Greenbrier, ARThe pilot's failure to maintain aircraft control during a low altitude maneuver. Factors were the pilot's lack of total experience in the type of operation and inadequate training by the company management.NTSB FTW97LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Church Point, LAThe pilot's improperly performed short field takeoff procedures.NTSB SEA97FA133Accident · 3 fatalField investigationFinal reportCessna U206E · Red Lodge, MTThe pilot-in-command's flight into known adverse weather and the subsequent overload and separation of the right wing-strut fuselage-to-strut attach point. Factors contributing were clouds and obscuration.NTSB NYC97LA121Accident · 1 fatalLimited investigationFinal reportRobbins Kolb Firestar · Gilbertsville, PAThe noncertificated operator's improper decision to fly low over a congested area, which resulted in an abrupt maneuver to avoid a collision with a tethered blimp, and the subsequent uncontrolled descent and collision with terrain.NTSB NYC97LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 135 · Pepperell, MAThe pilot's failure to maintain airspeed during a turn, which resulted in an inadvertent stall and subsequent uncontrolled descent into water.NTSB IAD97LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Put-In-Bay, OHPilot in command failed to maintain control of the airplane. Factors to the accident where high wind conditions with a strong crosswind component and the pilot's inadvertent failure to raise the flaps during the go around.NTSB NYC97FA103Accident · 3 fatalField investigationFinal reportCessna 210M · Elliston, VAfailure of the PIC to maintain control of the airplane, due to spatial disorientation.NTSB LAX97GA198Accident · 2 fatalFinal reportBeech 95-B55 · San Carlos, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall/spin.NTSB MIA97FA175Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Avon Park, FLthe pilot's failure to maintain airspeed (Vso) during an approach in instrument flight conditions.NTSB IAD97FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Melville, NYThe pilot's failure to maintain control of the airplane. Factors to this accident were night instrument meteorological conditions with low ceiling and fog.NTSB FTW97LA209Accident · 1 fatalLimited investigationFinal reportGiertz Vmax Probe · Lake Jackson, TXThe pilot's failure to maintain aircraft control during an approach to landing. A related factor was the pilot's lack of experience in make and model of aircraft.NTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.NTSB LAX97LA207Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tracy, CAThe pilot's inadequate compensation for a crosswind gust, and his failure to maintain runway alignment after encountering the wind gust.NTSB NYC97FA099Accident · Serious injuriesField investigationFinal reportCessna 180 · Freedom, PAthe pilot's premature lift off, and his failure to maintain proper runway alignment, which resulted in an inadvertent stall, while attempting to avoid an obstruction (telephone pole). Factors relating to the accident were: the pilot allowed the airplane's…NTSB IAD97LA076Accident · 1 fatalLimited investigationFinal reportDresbach RV-4 · Bainbridge, OHfailure of the pilot to maintain control of the airplane during the initial climb after takeoff. The pilot's physiological conditions was a possible factor.NTSB MIA97FA173Accident · 6 fatalField investigationFinal reportCessna 205 · Homestead, FLThe pilot-in-command's failure to maintain airspeed as he slowed for a parachutist to jump from the aircraft, and his failure to apply spin recovery emergency procedures prior to ground impact. Contributing to the accident was the pilot-in-command's lack of…NTSB FTW97FA199Accident · 3 fatalField investigationFinal reportBeech V35 · Shawnee, OKThe pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.NTSB MIA97FA172Accident · Serious injuriesField investigationFinal reportBell 206B · Winter Park, FLThe pilots improper in-flight planning/decision to conduct an out of ground effect hover with a tailwind resulting in an in-flight loss of directional control due to loss of tailrotor effectiveness/unanticipated right yaw, and subsequent in-flight collision…NTSB FTW97FA193Accident · 1 fatalField investigationFinal reportPezetel M-18A · Wilmot, ARfailure of the pilot to remove the elevator control lock before the first flight of the day, which resulted in his inability to control the airplane, due to the locked elevator control. Related factors were: the prevailing high winds and the lack of a visible…NTSB SEA97LA109Accident · Minor injuriesLimited investigationFinal reportLearjet 35A · Great Falls, MTthe captain's inadequate preflight planning/preparation, and the subsequent improper response to a simulated loss of engine power, resulting in liftoff at an airspeed below that for which sustained flight was possible.NTSB SEA97LA112Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Snohomish, WAthe pilot's encounter with of a loss of tail rotor effectiveness (LTE) situation, and his subsequent inadequate remedial action. Related factors included: wind conditions that were conducive to an unanticipated right yaw event, and the pilot's limited…NTSB MIA97FA162Accident · 1 fatalField investigationFinal reportCessna R182 · N. Myrtle Beach, SCthe pilot's failure to maintain airspeed during a go-around resulting in an inadvertent stall.NTSB NYC97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Morristown, NJThe flight instructor's inadequate supervision which allowed the student to solo at night with less than one hour of night instruction with a known inoperative landing and taxi light. A Factor was the student pilot's spatial disorientation which resulted in…NTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.NTSB DCA97MA049Accident · Serious injuriesMajor investigationFinal reportAirbus Industrie A300B4-605R · West Palm Beach, FLThe flightcrew's failure to maintain adequate airspeed during leveloff which led to an inadvertent stall, and their subsequent failure to use proper stall recovery techniques. A factor contributing to the accident was the flightcrew's failure to properly use…NTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.NTSB SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.NTSB NYC97LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · New Castle, DEthe pilot's failure to maintain directional control of the airplane. A contributing factor was the gusty wind conditions.NTSB FTW97FA181Accident · 1 fatalField investigationFinal reportCessna 172RG · Intracoastal, LAthe pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.NTSB NYC97LA087Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Salem, OHthe pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.