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 ATL99LA105Accident · Minor injuriesLimited investigationFinal reportBell 47 · Trenton, GAThe loss of main rotor rpm due to improper use of the flight controls by the pilot. Factors were the tailwind and trees.NTSB NYC99FA163Accident · 1 fatalField investigationFinal reportPiper PA-31T · Deerfield, VALoss of control of the airplane due to pilot incapacitation following a heart attack.NTSB DEN99FA109Accident · 1 fatalField investigationFinal reportBoeing Stearman A75 · Carpenter, WYPilot incapacitation for unknown reasons.NTSB IAD99FA051Accident · No injuriesField investigationFinal reportCessna 172P · Gaithersburg, MDwas the pilot's failure to obtain the proper rotation speed and his subsequent loss of directional control. A factor in the accident was the improper setting of the elevator trim.NTSB NYC99FA161Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Dawson, MDThe pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, downdraft, and the pilot's decision to operate at a weight in excess of the maximum allowable gross weight.NTSB NYC99FA160Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dawson, MDwas the pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, and unfavorable winds.NTSB CHI99LA200Accident · Serious injuriesLimited investigationFinal reportGillmore Benson B&M · Greencastle, INthe failure of the cyclic control rod. Factors were aircraft control not possible for the pilot.NTSB CHI99LA197Accident · Minor injuriesLimited investigationFinal reportPorter Searey · Morenci, MIthe pilots inadequate preflight planning and his failure to maintain airspeed. Factors to the accident were the high trees at the departure end of the runway, and the stall encountered.NTSB CHI99FA202Accident · 1 fatalField investigationFinal reportRans S-10 Sakota · La Crosse, KSdirectional control not maintained by the pilot.NTSB MIA99LA189Accident · Minor injuriesLimited investigationFinal reportBoeing HU-369-OH6A · Murrells Inlet, SCAn inflight loss of control due to loss of tail rotor effectiveness as a result of the pilot's inadequate compensation for the winds and improper weather evaluation.NTSB CHI99LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Veblen, SDwas the pilot not maintaining clearance from terrain. A factor was the pilot not performing a load jettison.NTSB ANC99LA081Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Anchorage, AKThe pilot's failure to maintain an adequate airspeed, and subsequent inadvertent stall.NTSB NYC99LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot's failure to maintain directional control during the aborted landing. A factor in this accident was the crosswind condition.NTSB FTW99LA173Accident · Serious injuriesLimited investigationFinal reportLibersat Kolb Mark 3 · Vidor, TXThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin.NTSB FTW99FA172Accident · 1 fatalField investigationFinal reportKeen Glasair I · Albany, TXThe pilot's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines. Factors were the night light condition and the pilot's decision to fly at low altitude.NTSB DEN99LA105Accident · Serious injuriesLimited investigationFinal reportBell BH-206B · Telluride, COSettling with power and a loss of tail rotor effectiveness. Factors were an improperly planned approach by the pilot in command, high density altitude, and inadequate supervision by the safety pilot.NTSB LAX99FA220Accident · 4 fatalField investigationFinal reportCessna 182A · Paso Robles, CAthe pilot's failure to set the trim as prescribed by the published check list. This led to a steep climb angle which caused the airspeed to decay, resulting in a stall at an altitude too low to allow recovery.NTSB ATL99LA101Accident · No injuriesLimited investigationFinal reportCessna A188B · Glen Allan, MSThe improper installation of a nut and bolt assembly by a maintenance personnel that resulted in the in-flight loss of control of the left ailiron.NTSB NYC99LA144Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Corinna, METhe pilot-in-command's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA99LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WACompensation for wind conditions was inadequate. Gusting wind conditions was a factor.NTSB NYC99FA140Accident · 4 fatalField investigationFinal reportSikorsky S-76A · Jackson, KYthe failure of the PIC to adequately supervise the SIC, and maintain a positive climb. Factors were the fog and dark night.NTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.NTSB CHI99LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vincennes, INthe pilot's failure to maintain directional control of the airplane during the soft field takeoff. Factors associated with the accident were inadequate airspeed and the cable fence which was contacted.NTSB CHI99GA185Accident · 2 fatalFinal reportPiper PA-18-150 · Baudette, MNthe pilot inadvertently stalled the airplane. A factor was the low altitude.NTSB LAX99LA210Accident · No injuriesLimited investigationFinal reportBellanca BL-14-13 · Taft, CAThe pilot's inability to maintain control of the aircraft due to the aileron control cables being crossed and reversed. The pilot's lack of a thorough pre-flight inspection and the pilot not referencing a manual during the repairs on the aircraft is also…NTSB LAX99LA209Accident · 1 fatalLimited investigationFinal reportBlanco SEA Hawker · Yucca Valley, CAA loss of control in flight for undetermined reasons that resulted in an in flight collision with terrain. A factor was turbulent weather conditions in mountainous/hilly terrain.NTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.NTSB MIA99LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chapel Hill, NCThe failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.NTSB LAX99LA211Accident · 1 fatalLimited investigationFinal reportCessna 150G · Rimrock, AZThe pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…NTSB SEA99FA080Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ephrata, WAThe glider pilot's failure to maintain control of his aircraft during spoiler retraction, which led to the Piper pilot's inability to recover safe flying airspeed within the altitude constraints at the time of the event. Contributing factors were the failure…NTSB DEN99LA095Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXInadequate remedial action by the pilot in command (CFI) after the student failed to maintain control of the aircraft during the final stages of a visual approach to land. Factors were gusting crosswinds and the flight instructor's lack of total instructional…NTSB CHI99LA172Accident · Minor injuriesLimited investigationFinal reportde Havilland Tiger Moth DH82A · Maize, KSthe pilot's inability to maintain a climb after takeoff as a result of wind shear. Factors associated with the accident were the variable, gusty wind conditions, and the tree which was contacted.NTSB ANC99LA068Accident · No injuriesLimited investigationFinal reportRobinson R22 · Glennallen, AKThe pilot's failure to maintain rotor RPM during takeoff. Factors associated with the accident were a downdraft, and uneven terrain.NTSB NYC99FA126Accident · 2 fatalField investigationFinal reportBeech D50C · Montgomery, NYThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin.NTSB IAD99LA046Accident · 1 fatalLimited investigationFinal reportPoskus Revelation · Latrobe, PAWas the pilot's failure to maintain directional control.NTSB NYC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Alliance, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were the crosswind conditions and wind gusts.NTSB NYC99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Hillsborough, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of experience in the accident airplane's make and model.NTSB DEN99LA089Accident · Minor injuriesLimited investigationFinal reportDehaan Challenger II · Douglas, WYThe pilot's failure to maintain directional control of the aircraft by not adequately correcting for torque/p-factor during initial climb following takeoff.NTSB CHI99FA167Accident · 1 fatalField investigationFinal reportChampion 7ECA · Comstock, WIThe pilot's failure to maintain aircraft control. A factor contributing to this accident was the airplane's low altitude.NTSB SEA99FA176Accident · 2 fatalField investigationFinal reportCessna 152 · Coeur d'Alene, IDThe flight crew's failure to maintain adequate airspeed, resulting in a stall and uncontrolled collision with terrain. A factor was mountainous/hilly terrain.NTSB LAX99FA200Accident · 3 fatalField investigationFinal reportMBB BO 105LS A-3 · Huntington Bch, CAThe pilot's in-flight loss of control due to spatial disorientation while maneuvering to reverse direction after an inadvertent encounter with instrument meteorological conditions.NTSB LAX99LA198Accident · No injuriesLimited investigationFinal reportCessna 150L · Paso Robles, CAthe pilot's failure to maintain aircraft control and the resulting intentional off-airport landing. Inadequate recurrent training and recent flight experience were factors in this accident.NTSB NYC99LA119Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Covington, KYThe pilot's failure to maintain directional control during the takeoff/initial climb. A factor in the accident was the crosswind condition.NTSB DEN99LA085Accident · No injuriesLimited investigationFinal reportCessna 172L · Gunnison, COThe pilot's inadvertent stall/mush immediately after takeoff. Factors were the high density altitude weather condition, and the pilot's total lack of experience in type of operation.NTSB NYC99LA116Accident · 1 fatalLimited investigationFinal reportNations Acro Sport II · Pence Springs, WVThe student pilot's improper decision to perform aerobatics, and his failure to maintain aircraft control, which resulted in an inadvertent spin. A factor in the accident was the pilot's lack of aerobatic experience.NTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.NTSB FTW99FA143Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Rose Bud, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW99LA147Accident · No injuriesLimited investigationFinal reportCessna TU206C · West, TXThe pilot's improper recovery from a bounced landing.NTSB CHI99LA157Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe pilot's improper approach to landing A factor associated with the accident was the pilot's inadvertent settling with power.NTSB ATL99LA095Accident · No injuriesLimited investigationFinal reportAircraft Parts & Dev. A-9B · Hartsell, ALThe pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.