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 CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…NTSB SEA98FA083Accident · 2 fatalField investigationFinal reportPapa 51 Thunder Mustang · Marsing, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.NTSB CHI98LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tocsin, INthe pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.NTSB MIA98LA171Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) on final approach resulting in an inadvertent stall.NTSB FTW98LA245Accident · No injuriesLimited investigationFinal reportCessna 320B · Rockport, TXThe pilot's failure to maintain airspeed during a go around which resulted in an inadvertent stall. Factors were the pilot's lack of experience in the make and model aircraft, his failure to follow the before landing checklist, and his improper use of the…NTSB NYC98FA117Accident · 1 fatalField investigationFinal reportMorelli Rans S9 · Taunton, MAThe pilot's operation of the aircraft in an unapproved configuration contrary to procedures resulting in diminished aircraft control, and his failure to maintain control of the aircraft resulting in a stall/spin event. Contributing factors were the…NTSB CHI98FA172Accident · 1 fatalField investigationFinal reportPiper J-3C · Morris, ILThe pilot's failure to maintain aircraft control during low altitude flight.NTSB NYC98GA113Accident · 2 fatalFinal reportCessna 182R · Middleborough, MAThe pilot-in-command's failure to maintain control of the airplane during a VFR go-around. A factor was the impairment due to drugs.NTSB SEA98LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sandpoint, IDLoss of consciousness by the pilot-in-command/flight instructor, resulting in loss of aircraft control and subsequent collision with terrain.NTSB IAD98LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Minden, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. A related factor was the rough/uneven runway.NTSB NYC98LA115Accident · No injuriesLimited investigationFinal reportCessna 177B · Brogue, PAfailure of the pilot to maintaining proper runway alignment during an aborted landing (go-around). Related factors were: the pilot's improper recovery from a bounced landing, inadvertent porpoise, and the small trees encroaching into the runaway environment.NTSB NYC98FA111Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lincoln, MAThe pilot's failure to maintain airspeed.NTSB LAX98LA172Accident · 4 fatalLimited investigationFinal reportPiper PA-28-161 · Half Moon Bay, CAThe non-instrument rated pilot's loss of aircraft control due to spatial disorientation in dark night conditions.NTSB FTW98LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Huntington, UTThe pilot's failure to maintain adequate airspeed.NTSB CHI98LA158Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffith, INThe aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.NTSB SEA98FA078Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Great Falls, MTThe flight crew's failure to maintain aircraft control.NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.NTSB CHI98LA161Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Manhattan, KSthe pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.NTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.NTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.NTSB CHI98FA153Accident · 4 fatalField investigationFinal reportCommander 114-B · Lagrange, WIthe pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.NTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB IAD98FA054Accident · 4 fatalField investigationFinal reportBeech A36 · Davis, WVThe pilot's spatial disorientation, his subsequent loss of control of the airplane, and his overload of the horizontal stabilizer during a recovery attempt. Factors include the pilot's continued flight into icing conditions, his lack of airspeed control, and…NTSB FTW98FA215Accident · 1 fatalField investigationFinal reportBeech 76 · Frisco, TXThe pilot's failure to maintain control resulting in an inadvertent stall while performing simulated single engine maneuvers during a practical test for a multiengine rating.NTSB CHI98TA145Accident · Minor injuriesFinal reportPiper PA-18-150 · Artesian, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW98LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Georgetown, TXinadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.NTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.NTSB CHI98LA142Accident · 1 fatalLimited investigationFinal reportBombardier Rans S-9 · Waukee, IAthe pilot's failure to maintain control of the airplane which resulted in a stall while performing intentional buzzing maneuvers.NTSB IAD98LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe pilot's failure to maintain adequate airspeed during an aborted landing which resulted in an inadvertent stall/spin.NTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.NTSB LAX98LA146Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Sacramento, CAthe CFI's failure to follow procedures and directives, and the use of an improper technique to transition from an autorotative descent to a hover, which exceeded the aircraft's performance capabilities and resulted in a unplanned hard landing. The soft…NTSB NYC98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · New Bedford, MAThe pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.NTSB FTW98FA192Accident · 3 fatalField investigationFinal reportBeech BE-58 · Kerrville, TXThe non-instrument rated pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the dark night conditions, overcast skies, and the pilot's inadequate preflight planning.NTSB ATL98LA067Accident · 1 fatalLimited investigationFinal reportUnknown Freebird Sport · Englewood, FLThe inadvertent aerodynamic stall, and subsequent loss of control in-flight by the non-certificated pilot. A factor was the use of over the counter drugs which are known to cause drowsiness.NTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.NTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.NTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.NTSB MIA98LA142Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe inadvertent stall of the airplane and inadequate supervision of the student by the CFI-PIC while performing a soft field takeoff.NTSB LAX98FA141Accident · 2 fatalField investigationFinal reportCessna 172 · Ramona, CAThe loss of control of the aircraft on final approach for undetermined reasons.NTSB FTW98LA195Accident · No injuriesLimited investigationFinal reportBell 206B · Jasper, TXthe pilot's encounter with a dynamic rollover after the toe of the left skid became caught on a trailer, while attempting to land the trailer. A related factor was: the pilot's perception of pressure, which was induced by a need to perform a scheduled…NTSB FTW98FA190Accident · 2 fatalField investigationFinal reportCessna 150H · Parowan, UTThe pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.NTSB SEA98LA066Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Colstrip, MTThe pilot's operation of the aircraft above maximum gross weight, resulting in her inability to attain a sustained climb rate after becoming airborne. A factor was high density altitude conditions.NTSB MIA98LA141Accident · 1 fatalLimited investigationFinal reportStar-Lite Engineering Warp 1A · Lakeland, FLthe pilot's failure to maintain airspeed, while maneuvering on crosswind in the traffic pattern, which resulted in an inadvertent stall, and an in-flight collision with a building and the terrain. Factors relating to the accident were: the pilot's decision to…NTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.NTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…NTSB CHI98FA130Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Kalamazoo, MIThe pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.NTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.NTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…