NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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\" = 260) 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" = 260) 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 FTW90DRD03Accident · No injuriesFinal reportGrumman G-164A · Glynn, LALoss of directional control on the ground, due to intermittent locking of the right brake during the landing roll.NTSB DEN90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nephi, UTFailure of the pilot to maintain direction control and correct the resultant ground swerve. The snow bank was a related factor.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB MKC90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ely, MNImproper planning/decision by the pilot. A factor related to the accident was: the strong/gusty crosswind condition.NTSB LAX90LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Truckee, CAThe pilot's loss of directional control after landing on a recently plowed runway. Contributing to the accident was the four foot high snow berm alongside the runway and the icy spots on the runway.NTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.NTSB DEN90LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve. Patches of packed snow on the runway may have contributed to the pilot's inability to regain control after the initial swerve began.NTSB LAX90LA090Accident · No injuriesLimited investigationFinal reportCessna 180 · Red Bluff, CAThe pilot's loss of directional control during an attempted go-around after he swerved off the runway after landing with a crosswind component.NTSB LAX90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Napa, CAThe student pilot's failure to maintain directional control after landing.NTSB CHI90LA082Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILPilot's inability to maintain directional during the landing phase of flight. The slippery, snow covered runway, and a twelve knot direct crosswind contributed to the accident.NTSB CHI90LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harbor Springs, MIThe student pilot's failure to maintian adequate directional control of the aircraft. The unfavorable wind was a related factor.NTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.NTSB MIA90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane after the right main gear contacted a tie down hole, which resulted in a collision with the hangar.NTSB FTW90LA068Accident · No injuriesLimited investigationFinal reportCessna 180J · Austin, TXThe pilot in command's failure to maintain directional control of the airplane during a downwind landing. Contributing to the accident was the pilot's lack of total experience in this type airplane.NTSB CHI90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INFailure of the student pilot to maintain directional control during the landing roll. The student's lack of aviation experience was a related factor.NTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.NTSB DEN90LA051Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Burlington, COThe failure of the dual student to correct a ground loop swerve during takeoff ground run. Inadequate supervision by the CFI was a factor in the accident.NTSB SEA90LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Winthrop, WAWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. Darkness and the obstructions in the emergency landing area were related factors.NTSB DEN90LA050Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts · Las Vegas, NVThe pilot-in-command's failure to maintain directional control after a partial failure of the normal brake system.NTSB NYC90LA059Accident · No injuriesLimited investigationFinal reportGlobe Swift Gcib · Pittstown, NJThe pilot failed to abort the takeoff after losing directional control during the takeoff ground run. Factors related to the accident were: crosswind, hidden obstruction in high vegetation, and low time in model.NTSB MKC90LA050Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Satanta, KSDirectonal control was not maintained by the pilot in command.NTSB LAX90LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe student pilot's failure to maintain directional control during a full stop landing in calm winds.NTSB CHI90LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Sullivan, INThe student pilot's inadequate compensation for the wind gust and lack of total experience.NTSB CHI90LA067Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Lafayette, INThe helicopter student's iproper use of the collective pitch lever during the landing phase of flight. The pilot's lack of total expereince, the relatively high wind, and inadvertent liftoff of the helicopter were factors related to the accident.NTSB NYC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Northampton, MAPilot's improper handling of the airplane, resulting in the loss of directional control. Contributing to the accident were gusty wind conditions and the pilot's lack of total experience.NTSB FTW90LA053Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXInadequate compensation for wind conditions by the pilot, and his failure to maintain directional control. The unfavorable wind was a related factor.NTSB DEN90LA040Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Ft Collins, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the aircraft.NTSB BFO90LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Staunton, VAThe pilot's failure to maintain directional control of the airplane during a crosswind landing.NTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).NTSB CHI90LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, INFailure of the student pilot to maintain directional control and/or properly compensate for the wind conditions. Factors related to the accident were: the unfavorable wind conditions and the ditch.NTSB ANC90FA025Accident · No injuriesField investigationFinal reportCessna 150 · Anchorage, AKFailure of the student pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB LAX90DUQ01Accident · Minor injuriesFinal reportDavidson Throp T-18 · Camarillo, CAPilots failure to maintain directional control while landing in a crosswind.NTSB CHI90LA059Accident · No injuriesLimited investigationFinal reportCessna 150F · Elkhart, INFailure of the pilot to maintain directional control of the aircraft, which resulted in his failure to maintain proper runway alignment. Factors related to the accident were the pilot's lack of experience in winter operations, the icy runway condition, and…NTSB DEN90LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB CHI90LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Chillicothe, OHImproper planning/decision by the student pilot, which resulted in a landing on a slick runway, and his failure to maintain directional control during the landing, which resulted in his inability to maintain runway alignment. Contributing factors were: the…NTSB CHI90LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INFailure of the student pilot to maintain directional control and his improper use of (normal) brakes. His decision to make a running takeoff, his lack of total experience, and the snowbank were contributing factors.NTSB DEN90LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Billings, MTThe failure of the pilot to maintain directional control during adverse wind conditions.NTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.NTSB FTW90IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Baton Rouge, LAThe captain's excessive speed during a turn off of the runway, and his failure to maintain directional control. The wet taxiway was a related factor.NTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.NTSB BFO90LA016Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot's excessive taxi speed. Ice on the ramp and the location of the fence were related factors.NTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.NTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.NTSB MKC90LA037Accident · No injuriesLimited investigationFinal reportSaint Louis YPT-15 · Creve Coeur, MOThe pilot's failure to maintain directional control of the airplane. Contribuiting to the accident was the sun glare.NTSB SEA90LA024Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Seattle, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB MIA90LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Cocoa, FLFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground swerve. Factors related to the accident were the crosswind condition and ditch.NTSB FTW90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cresson, TXThe failure of the student pilot to maintain directional control of the airplane and the cfi's inability to regain control. Contributing to the accident was the lack of brakes on the cfi's side of the airplane.NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.NTSB CHI90LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student's lack of total experience, his diversion of too much attention to…NTSB LAX90LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Santa Ynez, CAThe student pilot's loss of directional control during a go-around.