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 IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.NTSB CHI01LA224Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Houghton Lake, MIThe pilot's failure to maintain directional control during the takeoff run. A factor relating to this accident was the trees.NTSB SEA01LA140Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Spokane, WAThe pilot landed with insufficient formation spacing behind the lead aircraft, resulting in an encounter with the lead aircraft's wake turbulence, and subsequently lost directional control during landing roll.NTSB SEA01LA139Accident · No injuriesLimited investigationFinal reportPilatus PC-6/B2-H4 · Great Falls, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB LAX01FA252Accident · Minor injuriesField investigationFinal reportSikorsky S-76A · Los Angeles, CAThe failure of the pilot to reduce the engine power control levers to ground idle prior to leaving the helicopter, resulting in the unmanned helicopter moving on the helipad and performing a dynamic rollover.NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.NTSB ANC01LA089Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKAn inadvertent ground loop during the landing roll.NTSB SEA01LA136Accident · No injuriesLimited investigationFinal reportCessna 180K · Quincy, WAThe pilot's failure to maintain directional control during the landing roll. Factors include an encounter with a dust devil/whirlwind.NTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.NTSB LAX01LA248Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Marble Canyon, AZThe pilot's failure to use all the available runway and his failure to follow the prescribed short field takeoff procedure resulting in a loss of control during the takeoff roll. Factors were the short, rough, and rising runway, and the soft dirt surrounding…NTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.NTSB NYC01LA170Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Simsbury, CT**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional details.** a loose tail wheel assembly and the failure of maintenance personnel to adequately follow annual inspection procedures. A factor in the accident…NTSB FTW01LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Kingston, OKthe pilot's failure to maintain directional control during the takeoff roll, which required his evasive maneuver and resulted in a stall.NTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.NTSB LAX01LA238Accident · No injuriesLimited investigationFinal reportSparks KR-2 · San Diego, CAFailure of the pilot to maintain directional control during landing.NTSB SEA01LA126Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Big Creek, IDThe pilot's failure to adequately compensate for the wind conditions during the landing roll. High and gusting winds were factors.NTSB IAD01LA077Accident · Minor injuriesLimited investigationFinal reportGarro Sonerai II · Cortland, OHthe pilot's failure to maintain directional control during an aborted take-off. A factor was the pilot's failure to obtain adequate take-off speed.NTSB FTW01LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, TXthe pilot's inadvertent ground loop during the landing roll. A contributing factor was his lack of total experience in tail wheel-equipped airplanes.NTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB NYC01LA160Accident · No injuriesLimited investigationFinal reportChek Avid Mark IV · Salisbury, MDThe pilot's failure to maintain airplane control. Factors were the quartering tailwind, and the improper rebuild of the left main landing gear with a reduced size brace.NTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.NTSB ATL01LA069Accident · No injuriesLimited investigationFinal reportCessna 177 · Milledgeville, GAThe student pilot's failure to maintain directional control and the subsequent collision with an object during an attempted landing. A factor was porpoise induced oscillation.NTSB LAX01LA225Accident · No injuriesLimited investigationFinal reportCessna U206D · Boulder City, NVthe pilot's inadequate compensation for the tailwind gust and subsequent failure to maintain directional control of the airplane while landing.NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB LAX01LA223Accident · No injuriesLimited investigationFinal reportRudolph Venture · Grass Valley, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX01LA218Accident · No injuriesLimited investigationFinal reportStolp Starduster SA-300 · El Cajon, CAThe pilot's failure to maintain directional control during landing rollout.NTSB SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.NTSB IAD01LA078Accident · 1 fatalLimited investigationFinal reportPatalivo Dominator · Laconia, NHThe non-certificated pilot's inability to maintain control of the gyrocopter after inadvertently allowing it to become airborne. A factor was the pilot's lack of flight experience.NTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.NTSB ANC01LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Homer, AKThe student pilot's inadvertent ground loop. A factor in the accident was the pilot's lack of total experience.NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.NTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.NTSB MIA01LA161Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennettsville, SCThe pilot's improper correction for wind conditions and his failure to maintain control of the airplane resulting in the airplane sliding off an embankment during taxi from landing.NTSB SEA01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Billings, MTThe pilot-in-command's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the gusty crosswind conditions.NTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.NTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.NTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.NTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.NTSB NYC01LA137Accident · No injuriesLimited investigationFinal reportGraham Acro Sport · Hampton, NHA soft area in the turf runway, which resulted in a loss of directional control during the landing rollout.NTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB ANC01LA066Accident · No injuriesLimited investigationFinal reportHelio H-391B · Anvik, AKThe pilot's continued operation of the accident airplane with known equipment deficiencies, and an improper installation of the float assembly by maintenance personnel. A factor in the accident was the pilot's delay in aborting the takeoff.NTSB SEA01LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Boise, IDThe pilot's failure to adequately compensate for wind conditions. Wind gusts were a factor.NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.NTSB SEA01LA104Accident · No injuriesLimited investigationFinal reportCurtis Lionheart · Bremerton, WAthe pilot's failure to ensure the aircraft's longitudinal axis was aligned with the runway prior to touchdown, and his failure to maintain directional control during the landing roll. Factors include landing with a tailwind, and the pilot's lack of recent…NTSB LAX01LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Cottonwood, AZthe student's inadequate compensation for the gusty crosswind conditions and the subsequent loss of aircraft control during landing roll. The flight instructor’s inadequate supervision and his inadequate remedial action is also causal. Contributing factors…NTSB FTW01LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Fort Worth, TXthe inadvertent ground loop during the landing roll. A contributing factor was the gusty crosswind.