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 LAX99LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Truckee, CAThe pilot's failure to obtain and maintain the proper climb airspeed during the initial takeoff climb, including his failure to anticipate the gust factor and density altitude effects in determining a safe airspeed.NTSB NYC99LA072Accident · Minor injuriesLimited investigationFinal reportMiner Rotorway Exec 162F · Mechanicsburg, PAThe pilot's inadvertent induced dynamic rollover. A factor in the accident was the pilot's lack of helicopter experience.NTSB LAX99LA119Accident · Minor injuriesLimited investigationFinal reportGallob Rans S4 · Mesa, AZThe pilot's failure to adequately compensate for the existing crosswind condition and to maintain lateral control of the aircraft.NTSB DEN99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Leadville, COThe pilot's inadequate compensation for the gusty crosswind conditions. A factor was the gusting crosswindNTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.NTSB LAX99TA115Accident · Minor injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAThe pilot's improper in-flight decision to maneuver in the area while observed inclement weather approached, which led to a loss of control. Contributing factors were the low ceilings, mountainous terrain and spatial disorientation.NTSB CHI99FA101Accident · 1 fatalField investigationFinal reportMooney M20F · Cabool, MOThe pilot not maintaining an appropriate airspeed during the turn from base to final resulting in a stall.NTSB MIA99FA095Accident · 2 fatalField investigationFinal reportBeech AT11/18 · Tampa, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to allow for recovery.NTSB LAX99LA112Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · San Jose, CAThe loss of aircraft control due to the pilot's sudden application of collective combined with excessive cyclic inputs.NTSB LAX99LA108Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Glenn, CAAn inflight loss of control for undetermined reasons.NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB FTW99LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE-76 · Mesquite, TXThe flight instructor's inadequate supervision of the multi-engine rated instrument student during a simulated single engine landing, resulting in loss of control of the airplane. Factors were the dark night light condition, the flight instructor's inadequate…NTSB FTW99LA083Accident · No injuriesLimited investigationFinal reportRobinson R22-B2 · Freer, TXThe passenger's inadvertent interference with the cyclic control which consequently restricted the control's movement.NTSB NYC99LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale 355 · Toledo, OHThe pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.NTSB LAX99LA089Accident · Minor injuriesLimited investigationFinal reportStern Rotorway Exec 162F · Tucson, AZThe sudden development of a wind gust which resulted in the pilot losing control, and the helicopter's dynamic rollover when a skid contacted the ground.NTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.NTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.NTSB LAX99LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Burson, CAThe pilot's failure to maintain adequate airspeed while maneuvering to avoid an obstacle immediately after takeoff. A factor in the accident was the pilot's inadequate examination of the off-airport takeoff area in order to identify potential hazards.NTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB NYC99FA047Accident · 1 fatalField investigationFinal reportCessna 310R · Kearny, NJa loss of elevator control for undetermined reasons.NTSB CHI99LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILthe pilot's failure to maintain proper runway alignment during the landing flare. A factor related to the accident was the snowbank which the airplane contacted.NTSB MIA99LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pahokee, FLThe pilot-in command's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command.NTSB FTW99LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe student pilot's failure to compensate for a crosswind resulting in a loss of control. Factors were the gusty high winds and the flight instructor's improper decision to allow the student to solo during high winds.NTSB FTW99FA060Accident · 1 fatalField investigationFinal reportPiper PA-32-300R · Smackover, ARThe pilot's spatial disorientation resulting in a loss of control of the airplane and the ensuing stall/spin. Factors were the low ceilings and the night condition.NTSB FTW99FA055Accident · 3 fatalField investigationFinal reportCessna 182P · Midland, TXThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.NTSB LAX99LA068Accident · 2 fatalLimited investigationFinal reportPiper PA-28 · Thermal, CAThe occurrence of an in-flight incapacitating heart rhythm to the pilot. A factor was the pilot's ingestion of over-the-counter medications that made him more susceptible to an abnormal heart rhythm.NTSB CHI99FA053Accident · 1 fatalField investigationFinal reportCessna C-172R · Angola, INThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB MIA99LA054Accident · No injuriesLimited investigationFinal reportDean Kolb Firestar 1 · Davenport, FLThe pilot's failure to perform weight and balance calculations, resulting in a loss of directional control on initial takeoff climb due to an aft center of gravity flight condition, in flight collision with trees and terrain. Contributing to the accident was…NTSB LAX99FA058Accident · 2 fatalField investigationFinal reportCessna 150L · Yucaipa, CAThe flight instructor's failure to maintain control of the airplane.NTSB MIA99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearwater, FLThe delay by the pilot-in-command (CFI) to take control of the airplane and inadvertent stall/mush resulting in the uncontrolled descent and impact with the runway.NTSB LAX99FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Santa Clarita, CAthe pilot's failure to maintain control of the aircraft. Factors were the night weather conditions and the lack of total and recent instrument flight time.NTSB LAX99LA056Accident · Serious injuriesLimited investigationFinal reportWeber CA-65 · Red Bluff, CAThe failure of the pilot to remove the right seat belt from around the right control stick, which resulted in a loss of aircraft control. An additional cause is the pilot's failure to use a checklist.NTSB FTW99LA047Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Lufkin, TXThe inadvertent stall due to the pilot's improper recovery from a bounced landing.NTSB LAX99LA047Accident · No injuriesLimited investigationFinal reportBell 47G2 · Helendale, CAThe pilot's failure to follow proper procedures to recover from main rotor blade aerodynamic retreating blade stall.NTSB ATL99LA033Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lantana, FLThe pilot's improper use of the flight controls during an attempted autorotation.NTSB NYC99FA033Accident · 1 fatalField investigationFinal reportGulfstream American AA-1 · Brooklyn, CTThe student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.NTSB NYC99FA032Accident · Minor injuriesField investigationFinal reportEurocopter EC-135-P1 · Newark, NJthe pilot's failure to maintain proper rotor rpm and his improper in flight decision to enter autorotation due to his lack of knowledge of the power plant controls. Factors in the accident were the night conditions and the pilot's improper decision to fly…NTSB FTW99FA041Accident · 1 fatalField investigationFinal reportCessna 501 · Umpire, ARThe pilot's in flight loss of control for undetermined reasons.NTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.NTSB FTW99LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Fayetteville, ARThe pilot's inadequate compensation for the wind conditions resulting in a loss of directional control. A factor was the shifting and gusty wind conditions.NTSB LAX99LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B · Camarillo, CAThe pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB LAX99LA033Accident · Serious injuriesLimited investigationFinal reportOld Hen Crow G1 · Tehachapi, CAThe failure of the pilot to maintain sufficient airspeed, which resulted in the aircraft entering a stall/mush flight condition that continued to impact. A factor in the accident was the pilot's lack of familiarity with the type of aircraft.NTSB IAD99LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJthe student's pilot's inadequate climb and his failure to maintain adequate altitude and clearance. A related factor was the wind gusts.NTSB NYC99LA025Accident · 2 fatalLimited investigationFinal reportHorner-Ryan Wichawk · Pine Island, NYThe pilot-in-command's failure to maintain control while maneuvering.NTSB CHI99LA028Accident · No injuriesLimited investigationFinal reportCessna 172I · Jacksonville, ILthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the student's lack of experience and the road which the airplane contacted.NTSB CHI99LA031Accident · Serious injuriesLimited investigationFinal reportCessna 337C · New Hudson, MIthe instructor pilot's not maintaining control of the airplane. A factor was the landing gear doors extended.NTSB FTW99FA022Accident · 2 fatalField investigationFinal reportChallenger II · San Antonio, TXThe pilot's inadvertent stall. A factor was the pilot's lack of experience in type of vehicle.NTSB CHI99LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Liberty, MOThe excessive rotation by the pilot-in-command. The climb not obtained by the pilot-in-command, the fence and the trees were contributing factors.