NTSB investigations
4,592 cases where the sequence of events included Loss of control on ground.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA15LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garrison, IAThe malfunction of the right brake for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB ERA15CA153Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe student pilot's failure to maintain aircraft control during landing, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB ANC15CA014Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Talkeetna, AKThe pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.NTSB ERA15CA150Accident · No injuriesData collectionFinal reportCessna 172S · Richmond, VAThe student pilot's inadequate landing flare which resulted in a hard landing and substantial damage to the airplane.NTSB ERA15CA146Accident · No injuriesData collectionFinal reportCub Crafter CC11-160 · Elizabethton, TNThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15FA163Accident · 1 fatalField investigationFinal reportAhrens Gerd H RV 6 · Pratt, KSA hard landing, which resulted in the pilot’s loss of directional control and the airplane’s subsequent nose-over.NTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB ERA15CA148Accident · No injuriesData collectionFinal reportPiper PA 18 · Murfreesboro, TNThe student pilot's failure to maintain directional control while landing and the flight instructor's delayed remedial action, which resulted in a ground-loop and the left wing dragging the runway.NTSB ANC15CA013Accident · No injuriesData collectionFinal reportStinson 108 · Cordova, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.NTSB CEN15CA159Accident · No injuriesData collectionFinal reportArnold Zodiac CH 650 · Greeley, COThe pilot was unable to maintain directional control during the landing due to the foreign object that lodged behind the rudder.NTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.NTSB WPR15CA102Accident · No injuriesData collectionFinal reportCessna 185 - E · Carson City, NVThe pilot's failure to maintain directional control during landing with a crosswind which resulted in a ground loop.NTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.NTSB ERA15LA124Accident · No injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Sebastian, FLThe pilot's failure to conduct all of the required items on the Before Starting Engines checklist, which resulted in her failure to detect an open hydraulic circuit breaker and led to insufficient hydraulic pressure to operate the airplane's brakes, her…NTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.NTSB ERA15CA121Accident · No injuriesData collectionFinal reportAutogyro Calidus · Crozet, VAThe pilot's improper control inputs which resulted in a loss of control and rollover during the takeoff roll.NTSB WPR15CA097Accident · No injuriesData collectionFinal reportSchneider Richard J Alaskan Bushmaster · Newburg, ORThe pilot's failure to maintain directional control during the takeoff roll into sunlight, which restricted his visibility.NTSB CEN15CA134Accident · No injuriesData collectionFinal reportMaule MX 7-180 · Georgetown, TXThe pilot did not maintain control of the airplane while landing in gusting crosswind conditions.NTSB ANC15LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.NTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.NTSB CEN15CA105Accident · No injuriesData collectionFinal reportCessna 172K · Holland, MIThe pilot's loss of control while landing in gusty wind conditions.NTSB ERA15CA106Accident · No injuriesData collectionFinal reportCessna 172L · New Castle, PAPilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.NTSB WPR15LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA15LA097Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe student pilot’s failure to maintain airplane control after engine start, which resulted in a ground collision with trees.NTSB ERA15CA095Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, METhe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.NTSB CEN15LA099Accident · No injuriesLimited investigationFinal reportCessna 195B · Llano, TXThe pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.NTSB CEN15CA097Accident · No injuriesData collectionFinal reportCessna 172M · Marquette, MIThe pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.NTSB WPR15CA078Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Sedona, AZThe pilot's loss of directional control during the landing roll.NTSB ERA15CA083Accident · No injuriesData collectionFinal reportCessna 182P · Nashville, TNThe pilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ERA15CA079Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Henniker, NHThe pilot's failure to maintain aircraft control while landing, which resulted in a collision with a snow bank. Contributing to the accident was ice that covered the landing surface.NTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.NTSB WPR15CA053Accident · No injuriesData collectionFinal reportStafford Wayne H Glastar · Monroe, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and encounter with terrain.NTSB CEN15CA061Accident · No injuriesData collectionFinal reportAmerican Champion 7EC · Colorado Springs, COThe loss of airplane control after encountering windshear.NTSB CEN15CA213Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Mesquite, TXThe pilot's loss of directional control while landing in gusting crosswind conditions, which exceeded the airplane's maximum demonstrated crosswind velocity.NTSB CEN15CA058Accident · Serious injuriesData collectionFinal reportMccrary Bobby C JR RV 4 · Los Lunas, NMThe pilot inadvertently applied the left brake during the landing roll which resulted in a loss of directional control and subsequent impact with terrain.NTSB ERA15CA057Accident · No injuriesData collectionFinal reportCessna T182T · St. Petersburg, FLThe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with a hangar.NTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB WPR15LA042Accident · No injuriesLimited investigationFinal reportCessna U206G · La Verne, CAThe pilot's loss of directional control during the landing roll for reasons that could not be determined, because postaccident examination of the nosewheel assembly revealed no anomalies that would have precluded normal operation.NTSB WPR15CA041Accident · No injuriesData collectionFinal reportChampion 7ECA · San Diego, CAThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB ERA15LA051Accident · No injuriesLimited investigationFinal reportBell Bill Kitfox 6 · Columbus, NCA loss of directional control during landing for reasons that could not be determined based on the available information.NTSB ERA15CA043Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Old Bridge, NJThe pilot's loss of control while landing the tailwheel-equipped airplane in gusting wind conditions, which resulted in a ground loop.NTSB CEN15CA037Accident · No injuriesData collectionFinal reportCessna 162 · Hinckley, ILThe student pilot's relaxing of elevator back pressure during the landing roll that induced a porpoise, loss of control, and collapsing of the nose wheel.NTSB ERA15LA039Accident · No injuriesLimited investigationFinal reportCurtiss Wright P 40B · New Smyrna Beach, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a ground loop and a subsequent runway excursion.NTSB ERA15CA037Accident · No injuriesData collectionFinal reportAviat S 2C · Rutland, VTThe pilot's failure to maintain directional control during landing rollout in gusty crosswind conditions, which resulted in a ground loop and subsequent substantial damage to the airplane.NTSB WPR15LA022Accident · No injuriesLimited investigationFinal reportCessna TU206G · Monument, ORThe loss of braking action during the landing roll on a gravel runway for reasons that could not be determined based on the available information.