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 ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.NTSB DEN04CA076Accident · No injuriesData collectionFinal reportWilford J. Tolman Kitfox 6 · Montrose, COthe pilot's failure to maintain aircraft control during takeoff initial climb. A contributing factor was the gusting left tailwind weather condition.NTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.NTSB NYC04CA125Accident · No injuriesData collectionFinal reportCessna 150 · Sacramento, KYThe pilot's improper decision to land with a tailwind, and his inadequate compensation for the wind conditions. A factor was the tailwind.NTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…NTSB LAX04LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Carson City, NVthe pilot's failure to maintain directional control during an aborted touch-and-go landing.NTSB LAX04FA207Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Wittmann, AZThe flight instructor's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering the airplane with a dual student.NTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.NTSB FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.NTSB NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB ATL04FA107Accident · 2 fatalField investigationFinal reportMooney M20M · Cary, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with trees. Factors were low ceilings and fog.NTSB ANC04LA050Accident · No injuriesLimited investigationFinal reportCessna U206F · Nanwalek, AKA loss of directional control for an undetermined reason during takeoff-initial climb, which resulted in the left wing colliding with the ground.NTSB CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…NTSB SEA04CA076Accident · No injuriesData collectionFinal reportMooney M-20J · Redmond, ORThe pilot's failure to adequately compensate for wind conditions. Unfavorable wind was a factor.NTSB ATL04LA104Accident · 1 fatalLimited investigationFinal reportSukhoi SU-31 · Fort Lauderdale, FLThe pilot's failure to recover from an intentional spin during an attempted aerobatic maneuver.NTSB ATL04LA103Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Sale Creek, TNThe pilot's failure to maintain airspeed, and the pilot's alcohol impairment that resulted in an inadvertent stall and collision with the ground.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB CHI04CA109Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Flushing, MIThe pilot's failure to maintain airspeed while on final approach, resulting in an inadvertent stall at a low altitude.NTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.NTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.NTSB MIA04LA074Accident · Minor injuriesLimited investigationFinal reportTerry E. Morris Glasair III · Lakeland, FLThe pilot's failure to maintain airspeed and establish a climb during an attempted go-around which resulted in a stall/mush and collision with terrain. His failure to follow air traffic control instructions is a contributing factor.NTSB MIA04CA077Accident · No injuriesData collectionFinal reportCessna 172S · Key West, FLThe pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB NYC04LA106Accident · No injuriesLimited investigationFinal reportCessna 182S · Plainville, CTThe failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.NTSB CHI04LA103Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Marion, INThe pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.NTSB LAX04LA191Accident · No injuriesLimited investigationFinal reportNorth American Aviation Div. Navion · Page, AZthe pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush in high density altitude conditions.NTSB LAX04CA179Accident · No injuriesData collectionFinal reportBeech 95-A55 · Montague, CAthe pilot's failure to maintain an adequate airspeed during the takeoff climb, which led to a stall/mush. Factors to the accident were the uneven intersection of the two runways, and the pilot's failure to use all of the available runway, and the premature…NTSB LAX04LA178Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Elko, NVthe pilot's improper mixture leaning technique and failure to attain an adequate airspeed during takeoff, which resulted in a stall/mush.NTSB FTW04LA103Accident · Serious injuriesLimited investigationFinal reportPdps PZL-Bielsko SZD-50-3 · Cherry Valley, ARThe pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.NTSB LAX04CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · California City, CAthe certified flight instructor's failure to maintain an adequate airspeed, which resulted in a stall/mush condition and a collision with terrain. Factors in the accident were strong tailwind conditions and a sudden wind shift.NTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.NTSB ATL04CA083Accident · Minor injuriesData collectionFinal reportDantzer Lawrence L Rans S-12 · Lowndesboro, ALThe pilot's failure to maintain airspeed while manuevering which resulted in an inadvertent stall/spin. A factor was trees.NTSB SEA04LA058Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Chiloquin, ORThe pilot's failure to maintain airspeed during a downwind turn resulting in a stall-mush and collision with the ground. Wind gusts were a factor.NTSB NYC04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Louisville, KYThe student pilot's failure to maintain directional control while landing, and the CFI's delayed remedial action. A factor related to the accident was the gusting wind conditions.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB NYC04LA088Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Utica, NYThe copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.NTSB LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…NTSB LAX04FA162Accident · 2 fatalField investigationFinal reportMooney M20K · Los Angeles, CAThe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the low ceiling, reduced visibility (fog), and the pilot's lack of instrument flying currency. An additional factor was the failure of air traffic…NTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.NTSB LAX04FA165Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Napa, CAThe pilot's failure to maintain control of the airplane following a shutdown of the left engine during a night visual approach. A factor contributing to the accident was the dark night.NTSB MIA04LA068Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Labelle, FLThe pilot in command's abrupt pull up, which resulted in an overload of the right wing, right wing separation, an uncontrolled descent, and impact with terrain.NTSB NYC04LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Harrisonburg, VAThe pilot's improper decision to attempt a landing with an excessive tailwind, which resulted in an inadvertent stall while attempting to climb during a go-around. A factor related to the accident was the tailwind conditions and the rising terrain beyond the…NTSB ANC04LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Big Lake, AKAn in-flight loss of control for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB FTW04FA083Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Wrightsville, ARThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.NTSB FTW04LA080Accident · 1 fatalLimited investigationFinal reportGrumman G-164C · Hazen, ARThe pilot's loss of control while maneuvering during an aerial application flight for undetermined reasons.NTSB ATL04LA076Accident · No injuriesLimited investigationFinal reportBell 206 · Locust Grove, GAThe pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.