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 ANC06CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Tok, AKThe pilot's failure to compensate for the wind conditions during the takeoff roll, which resulted in a collision with a tree. A factor contributing to the accident was a crosswind.NTSB LAX06LA260Accident · No injuriesLimited investigationFinal reportSicheneder Pitts S1S · Tracy, CAThe failure of the pilot to maintain directional control during the landing rollout.NTSB NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.NTSB CHI06CA238Accident · No injuriesData collectionFinal reportBoeing B75N1 · Minerva, OHThe pilot's failure to maintain directional control during landing which resulted in the airplane striking a dirt mound and nosing over. The dirt mound was a factor.NTSB ANC06CA117Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKThe pilot's failure to compensate for wind conditions during the landing roll, which resulted in a loss of control and subsequent collision with a ditch. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.NTSB CHI06CA261Accident · No injuriesData collectionFinal reportBeech B19 · Eden Prarie, MNThe pilot not maintaining directional control of the airplane during the landing. A factor was the ditch.NTSB CHI06CA228Accident · No injuriesData collectionFinal reportPiper PA-18 · Waukesha, WIThe pilot's inadequate compensation for the crosswind and failure to maintain directional control which resulted in a groundloop. Factors included the closed runway and the crosswind condition.NTSB DFW06CA196Accident · No injuriesData collectionFinal reportPearson Superfly · Denton, TXThe loss of control as result of the pilot's selection of an unsuitable landing area. A contributing factor was the muddy terrain.NTSB DEN06CA110Accident · No injuriesData collectionFinal reportCessna 182E · Roset, WYan inadvertent pilot-induced porpoise and his improper remedial action. A contributing factor was the wind gust.NTSB SEA06CA155Accident · No injuriesData collectionFinal reportCessna 180H · Belgrade, MTThe pilot's failure to maintain directional control while landing.NTSB ATL06CA117Accident · No injuriesData collectionFinal reportCessna 172S · Thomson, GAThe student pilot's failure to maintain directional control during the landing roll resulting in an on-ground collision with an embankment.NTSB SEA06CA156Accident · No injuriesData collectionFinal reportCessna 180 · Elk City, IDThe pilot's failure to maintain directional control, which resulted in a ground loop during the landing roll.NTSB SEA06CA151Accident · No injuriesData collectionFinal reportCessna 180H · Hailey, IDThe pilot's failure to maintain directional control of the airplane during taxi, which resulted in a nose over. A factor was the wind gust condition.NTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.NTSB DEN06CA106Accident · No injuriesData collectionFinal reportCessna 140 · Cunningham, KSthe pilot's failure to maintain directional control during the aborted takeoff. A contributing factor was the mud.NTSB SEA06CA176Accident · No injuriesData collectionFinal reportCessna 185 · Cove, ORThe pilot’s failure to maintain directional control during the takeoff roll. Factors include wet grass and trees.NTSB CHI06CA199Accident · Minor injuriesData collectionFinal reportPorter Mustang II · Ainsworth, NEThe delay in initiating the aborted landing which resulted in inadequate altitude to clear high vegetation off the end of the runway. Factors associated with the accident were the gusty crosswind, inadequate compensation for the wind conditions, and the high…NTSB ANC06LA095Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's failure to maintain control of the airplane while step taxiing a float-equipped airplane, which resulted in a collision with an embankment. A factor contributing to the accident was an unfavorable wind.NTSB ANC06CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and colliding with a runway light and the ground. Factors contributing to the accident were an inadvertent ground loop, and the…NTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06CA241Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Greenfield, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane during landing.NTSB DEN06LA100Accident · No injuriesLimited investigationFinal reportMaule M 6 180C · Kemmerer, WYthe pilot's loss of directional control during takeoff due to the improper rigging of the airplane's flap system by unknown maintenance personnel. A contributing factor was the high density altitude.NTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…NTSB LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB DFW06CA185Accident · No injuriesData collectionFinal reportCessna 120 · Rockwall, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the prevailing crosswind.NTSB ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.NTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.NTSB CHI06CA189Accident · No injuriesData collectionFinal reportCessna 172R · Waterford, MIThe directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.NTSB DEN06CA093Accident · No injuriesData collectionFinal reportCessna 305A · Saratoga, WYthe pilot's failure to maintain direction control during the takeoff roll.NTSB SEA06CA132Accident · No injuriesData collectionFinal reportCessna 195 · Great Falls, MTThe pilot's loss of aircraft control during the takeoff roll, and the subsequent inadvertent ground loop.NTSB ANC06CA083Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in the left wing striking the ground and a runway edge light. Factors contributing to the accident were the pilot's inadvertent application of the…NTSB ANC06CA082Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · St. Augustine, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a nose over when the airplane departed the runway.NTSB ANC06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Orlando, FLThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a on-ground encounter with the runway, and subsequent nose over. A factor contributing to the accident was an inadvertent ground loop.NTSB LAX06CA219Accident · Minor injuriesData collectionFinal reportCessna 170B · Vacaville, CAthe pilot's failure to maintain directional control. A contributing factor was pilot fatigue.NTSB LAX06CA218Accident · No injuriesData collectionFinal reportCessna T206H · Santa Maria, CAthe pilot's failure to maintain directional control during landing.NTSB CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.NTSB LAX06CA215Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Carlsbad, CAthe pilot's failure to maintain runway alignment during the aborted landing, which resulted in a collision with a tree.NTSB LAX06CA212Accident · No injuriesData collectionFinal reportMaule M-7-235C · La Verne, CAthe pilot's failure to obtain/maintain directional control on the landing rollout.NTSB LAX06LA210Accident · No injuriesLimited investigationFinal reportBeech A36 · Schellville, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB SEA06CA120Accident · No injuriesData collectionFinal reportCessna 180 · Great Falls, MTThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.NTSB NYC06CA149Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Louisville, KYThe pilot's failure to maintain directional control during landing. A factor in the accident was the wet grassy runway.NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.NTSB NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB CHI06CA151Accident · No injuriesData collectionFinal reportCessna 172N · Athens, OHThe student pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, and the ditch.NTSB CHI06LA150Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Darmstadt, INThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control, and an on-ground collision with terrain.NTSB LAX06LA192Accident · No injuriesLimited investigationFinal reportCessna 180A · Marina, CAthe installation of the unapproved forward seat stop by unknown maintenance personnel, which did not allow for full depth engagement of the seat lock pin, resulting in the seat slipping aft during the takeoff roll and subsequent loss of directional control. A…NTSB CHI06LA146Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Faribault, MNDirectional control not obtained/maintained by the pilot during landing. A contributing factor was the ditch.NTSB SEA06CA117Accident · No injuriesData collectionFinal reportAyres S-2R · Grand View, IDThe pilot's inadvertent reduction of turbine engine power to the reverse position while landing on a desert road. A factor was the fence adjacent to the road.NTSB NYC06LA134Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hagerstown, MDThe pilot's failure to maintain directional control during takeoff.NTSB LAX06CA195Accident · No injuriesData collectionFinal reportWaco Classic YMF 5C · Holbrook, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane during landing, which resulted in a ground loop.