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 CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.NTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.NTSB LAX99FA266Accident · 1 fatalField investigationFinal reportCessna 177 · Boulder City, NVThe flight instructor's inadequate supervision of the flight and his failure to maintain an adequate airspeed and altitude margin while conducting low altitude maneuvers in an area of strong gusty winds and terrain-induced turbulence likely to contain wind…NTSB CHI99LA298Accident · No injuriesLimited investigationFinal reportBell 206L · Cape Girardeau, MOThe inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.NTSB CHI99LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Perry, IAthe student pilot's inadequate compensation for the wind conditions which resulted in her failure to maintain control of the airplane. A factor associated with the accident was the gusty crosswind condition.NTSB FTW99LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cypress, TXThe flight instructor's failure to maintain/obtain airspeed during takeoff climb, which resulted in an inadvertent stall/mush.NTSB FTW99FA212Accident · 1 fatalField investigationFinal reportStanton Pitts S-1S · Coushatta, LAThe pilot's poor in-flight decision to perform aerobatics at a low altitude and slow airspeed, resulting in the inadvertent stall/spin.NTSB ANC99FA110Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThe inadvertent stall/spin by the pilot. A factor was the box canyon into which he had flown.NTSB MIA99FA215Accident · 2 fatalField investigationFinal reportCessna 150F · Maple, NCthe pilot's failure to follow the aircraft's operating checklist and retract the wing flaps for takeoff as specified, as well as the pilot's failure to maintain airspeed (Vso) on initial takeoff climb, which resulted in an inadvertent stall, a spin, and…NTSB DEN99FA137Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMThe pilot's failure to maintain sufficient airspeed during final approach to landing, resulting in an inadvertent stall. A factor was the high density altitude.NTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.NTSB LAX99FA262Accident · 2 fatalField investigationFinal reportCessna 177B · Tusayan, AZwas the pilot's failure to have available and consult the FAA approved flight manual for performance data and, the high density altitude. Contributing to the accident were the dual magneto and spark plug system issues affecting optimum engine performance.NTSB IAD99GA056Accident · Minor injuriesFinal reportEurocopter AS-350 · Islip, NYThe pilot's loss of control during hydraulics-off hovering flight and the instructor's inadequate supervision of the maneuver. A factor was the tailwind.NTSB LAX99FA261Accident · 1 fatalField investigationFinal reportPorterfield CP-65 · Johnson Valley, CAThe failure of the pilot to maintain adequate airspeed while attempting to make a precautionary landing, which resulted in a stall/spin and collision with the terrain. A factor in his failure to maintain an adequate airspeed is the pilot's likely diverted…NTSB FTW99LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Bryan, TXThe flight instructor's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines.NTSB NYC99FA187Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · North Lima, OHThe pilot's loss of control of the airplane during a turn. Factors include the pilot's failure maintain sufficient airspeed, and his failure to maintain the airplane in proper trim.NTSB MIA99LA211Accident · No injuriesLimited investigationFinal reportMooney M-20R · Stoneville, NCthe pilot's failure to maintain airspeed, and adequately compensate for torque and P-factor, resulting in the loss of directional control, collision with hangars, and substantial damage to the aircraft during the attempted go around/recovery from a landing.NTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..NTSB CHI99MA269Accident · 10 fatalMajor investigationFinal reportBeech 65-A90 · Marine City, MIThe pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.NTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.NTSB LAX99LA258Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's premature retraction of the flaps during an aborted landing and his failure to obtain/maintain adequate flying airspeed, which resulted in a stall/mush condition and the airplane settling back onto the ground. The student pilot's failure…NTSB NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.NTSB LAX99LA257Accident · No injuriesLimited investigationFinal reportEwertz Starduster II · Winslow, AZthe pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.NTSB CHI99LA250Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Udall, KSthe failure of maintenance personnel to properly safety the aileron control cable during installation, the disconnected aileron control cable, and the unavailability of aileron control to the pilot.NTSB DEN99LA122Accident · Serious injuriesLimited investigationFinal reportRader Long EZ · Buena Vista, COThe pilot's failure to maintain control of the airplane. Factors were his unfamiliarity with the airplane, and the soft terrain that caused the airplane to nose over.NTSB SEA99LA120Accident · 2 fatalLimited investigationFinal reportAnderson Rans S-12 · Bowmont, IDAircraft control was not maintained while maneuvering at low altitude. An inadvertent stall was a factor.NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB LAX99LA254Accident · No injuriesLimited investigationFinal reportPiper PA32R-300 · Mammoth Lakes, CAThe pilot's failure to attain and maintain an adequate airspeed for the prevailing density altitude. The pilot's failure to abort the takeoff is also causal.NTSB CHI99LA235Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Maple Lake, MNThe pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.NTSB DEN99LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe flight instructor's failure maintain aircraft control. A factor was the inadequate supervision by the flight instructor.NTSB LAX99MA251Accident · 2 fatalClass 1 · MajorFinal reportSchempp-Hirth Nimbus 4DM · Minden, NVThe pilot's excessive use of the elevator control during recovery from an inadvertently entered spin and/or spiral dive during which the glider exceeded the maximum permissible speed, which resulted in the overload failure of the wings at loadings beyond the…NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB CHI99LA234Accident · Serious injuriesLimited investigationFinal reportGrimm SEA Hawker · Princeton, MNThe erratic aileron control response for undetermined reasons. A factor was the tree.NTSB CHI99LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Mcville, NDthe pilot not attaining a proper climb rate. Factors were the stall/mush and the ditch.NTSB SEA99LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Paul, IDThe pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…NTSB CHI99LA228Accident · Minor injuriesLimited investigationFinal reportMcmillan Zodiac CH 601 HD · Nauvoo, ILThe pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.NTSB DEN99LA117Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hobbs, NMThe pilot's inadequate in-flight planning. Factors were the loss of thermal lift, the subsequent stall/spin, and the fence post that he impacted.NTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.NTSB CHI99FA221Accident · 1 fatalField investigationFinal reportCessna 150 · Hubbard Lake, MIthe failure of the pilot to maintain aircraft control after executing the low pass and steep nose up climb.NTSB SEA99FA116Accident · 4 fatalField investigationFinal reportCessna 182D · Big Creek, IDThe pilot's failure to maintain control of the aircraft during approach. Factors included high density altitude conditions and high terrain, which obstructed view of the runway and limited maneuvering space in the traffic pattern.NTSB NYC99LA170Accident · No injuriesLimited investigationFinal reportPilatus B-4 · Erwinna, PAThe pilot-in-command's failure to maintain aircraft control.NTSB SEA99LA110Accident · Minor injuriesLimited investigationFinal reportParks RV-6 · Hunters, WAThe pilot's failure to maintain adequate airspeed during an attempted go-around.NTSB NYC99FA169Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Woodbridge, NJThe pilot's improper takeoff procedure, which resulted in a loss of tailrotor effectiveness.NTSB SEA99IA106Incident · No injuriesIncident investigationFinal reportJohn Hubbard Glasair II S · Florence, ORAircraft control was not maintained. Inadequate compensation for wind conditions and gusts were factors.NTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.NTSB DEN99LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Big Piney, WYThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A related factor was the gusty crosswind.NTSB DEN99FA119Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Coaldale, COThe pilot's failure to maintain control of the airplane for reasons for reasons undetermined.NTSB FTW99FA177Accident · 1 fatalField investigationFinal reportBeech V35 · Baton Rouge, LAThe pilot's performance of an abrupt maneuver immediately after takeoff, which resulted in an inadvertent stall.