NTSB investigations
289 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
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\" = 160) 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" = 160) 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 ANC02LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-128 · Anchorage, AKThe flight crew's inadequate preflight planning, and failure to calculate the airplane weight and balance prior to departure.NTSB CHI02LA008Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Jeffersonville, INThe dual student pilot's failure to maintain control of the helicopter, his failure to maintain altitude/clearance from the terrain, and the inadequate supervision by the flight instructor. A factor was the gusty wind condition.NTSB MIA01LA208Accident · No injuriesLimited investigationFinal reportMorton S. Dismuke Spencer Amphib 1-12E · Pensacola, FLThe dragging of the right wing during water operations for undetermined reasons resulting in the airplane flipping inverted.NTSB SEA01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Friday Harbor, WAThe pilot's failure to maintain directional control during landing.NTSB ANC01LA081Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Lake Minchumina, AKThe flight crew's improper recovery from a bounced landing. Factors associated with the accident were the selection of an unsuitable landing area, and a rough/uneven landing surface.NTSB LAX01LA220Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Montague, CAA loss of control during landing flare. Contributing to the accident was the gusty wind condition.NTSB CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.NTSB ATL01IA064Incident · No injuriesIncident investigationFinal reportBoeing 757 · Atlanta, GAThe pilots improper landing flare that resulted in the tail section collision with the runway.NTSB SEA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · McMinnville, ORThe student pilot's failure to adequately compensate for wind conditions while doing a touch-and-go landing.NTSB SEA01LA069Accident · No injuriesLimited investigationFinal reportCessna 180H · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty crosswinds.NTSB SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.NTSB ANC01LA020Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B2 · Girdwood, AKThe pilot's failure to maintain adequate altitude/clearance from terrain. A factor in the accident was flat light conditions.NTSB ANC00MA125Accident · 5 fatalMajor investigationFinal reportPiper PA-31T3 · Nuiqsut, AKThe pilot's failure to extend the landing gear, his improper aborted landing procedure, and inadvertent stall/mush. Factors in the accident were an improper adjustment of the landing gear warning horn system by company maintenance personnel, and the failure…NTSB LAX00LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Payson, AZThe pilot's failure to maintain directional control during the takeoff roll due to over-rotation, inadequate airspeed, and improper remedial action under the high density altitude condition.NTSB ATL00LA086Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Pine Hill, ALThe pilot's failure to adequately preflight the helicopter, which resulted in his failure to remove the tie down.NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.NTSB CHI00LA230Accident · No injuriesLimited investigationFinal reportBell BH-222-U · St. Paul, MNthe pilot's inadequate preflight and improper vertical takeoff and not obtaining clearance from helicopter pad light. Factors included the tailwind takeoff and the helipad light.NTSB CHI00LA222Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Oshkosh, WIthe pilot failed to maintain control of the airplane during flare/touchdown.NTSB SEA00LA083Accident · No injuriesLimited investigationFinal reportde Havilland U-6A · Kenmore, WAThe pilot's failure to maintain control of the aircraft during the landing roll. Contributing factors were the power wave created by the nearby yacht, the rough water conditions, and the pilot's loss of visual contact with the wave during the rollout.NTSB LAX00LA145Accident · No injuriesLimited investigationFinal reportOwens/Richburg Vans RV6-A · Sacramento, CAFailure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.NTSB SEA00FA014Accident · 1 fatalField investigationFinal reportEnstrom F28C · Pendleton, ORFailure to maintain clearance from the runway surface while maneuvering at low altitude, and inadequate remedial action after the tail rotor struck the surface.NTSB LAX99LA321Accident · No injuriesLimited investigationFinal reportCessna 172N · Vacaville, CAThe pilot's inadequate compensation for the existing gusty crosswind condition and his subsequent failure to maintain directional control.NTSB CHI99LA339Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Ann Arbor, MIThe pilot's improper touchdown during a water landing.NTSB SEA99IA148Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-135 · Moses Lake, WAMinimum aircraft control exceeded during takeoff test flight, which resulted in dragging a wing on the runway surface.NTSB SEA99LA137Accident · No injuriesLimited investigationFinal reportCessna 180J · Council, IDThe pilot's inadequate recovery from a bounced landing. Gusting wind conditions and a dirt bank adjacent to the runway edge were factors.NTSB CHI99LA273Accident · No injuriesLimited investigationFinal reportMooney M20B · Hayward, WIthe pilot's failure to maintain clearance with the surface of the lake. Factors associated with the accident were the low level flight, dusk light conditions, and the glassy water.NTSB ANC99LA095Accident · No injuriesLimited investigationFinal reportHelio H-395 · Igiugig, AKThe pilot's inadequate compensation for wind conditions during the downwind to upwind taxi turn. Factors associated with this accident were the high crosswind, the pilot's improper use of flaps, and his self-induced pressure because he was behind schedule.NTSB FTW99TA183Accident · Minor injuriesFinal reportMcDonnell Douglas 500-E · Oklahoma City, OKDuring a practice autorotation, the pilot flared the helicopter too low, which resulted in the tailboom contacting the ground. A factor was the dark night light conditions.NTSB ANC99LA071Accident · No injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe failure of the pilot to maintain directional control during the water landing.NTSB SEA99LA014Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Portland, ORThe flight crew's entry of an incorrect weight figure in the Flight Management System (FMS) computer, resulting in the approach being flown at an improper (low) Vref speed and an excessively nose-high attitude through the landing flare.NTSB FTW98LA406Accident · 1 fatalLimited investigationFinal reportNicks PW-5 · Waller, TXThe pilot's failure to maintain terrain clearance.NTSB SEA98LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lincoln City, ORThe pilot's inadequate remedial action to correct for a crosswind gust. The crosswind gust was a factor.NTSB FTW98LA386Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hilltop Lakes, TXThe pilot's failure to maintain control of the aircraft during takeoff. Factors were the pilot's lack of experience in grass field operations, the unsuitable terrain for takeoff, and the pilot's failure to perform a soft field takeoff procedure more suitable…NTSB SEA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180J · Oroville, WAThe pilot-in-command's failure to establish and maintain proper alignment.NTSB IAD98LA099Accident · No injuriesLimited investigationFinal reportMooney M-20C · Kent Island, MDthe pilot's improper takeoff technique and his failure to abort the takeoff.NTSB ANC98LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-400 · Juneau, AKThe flight crew's inadequate recovery from a bounced landing.NTSB ATL98LA100Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-4-250 · Wise, NCThe pilot's improper turn during the takeoff that resulted in dragging the sponson. A factor was the rough water caused by the boat wake.NTSB CHI98LA207Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Peshtigo, WIthe pilot misjudged the flare and inadvertently dragged the right sponson in the water. A factor was the pilot's lack of experience in the make and model aircraft.NTSB CHI98LA206Accident · Minor injuriesLimited investigationFinal reportParker Rotorway 162-F · Manchester, INthe pilot misjudged the flare.NTSB CHI98LA152Accident · No injuriesLimited investigationFinal reportRead Rotorway Executive · Valparaiso, INthe pilot not maintaining adequate clearance with the ground during hover. Factors which contributed to this accident were the pilot's execution of a hovering turn at too low of an altitude, inadequate preflight preparation, and failing to remove the…NTSB FTW98LA168Accident · No injuriesLimited investigationFinal reportBoeing A75N (PT-17) · Grand Junction, COFailure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.NTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.NTSB LAX98LA102Accident · Minor injuriesLimited investigationFinal reportLawrence Kitfox · Cottonwood, AZThe pilot's failure to maintain directional control and attain the proper airspeed for takeoff. A factor in the accident was his lack of recent experience in the make and model of airplane.NTSB ATL98IA024Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Montego Bay, JamaicaThe pilot's improper recovery from a bounced landing, compounded by the automatic deployment of the ground spoilers on main wheel spin-up, resulting in a pitch angle beyond the tail strike pitch angle of the airplane, which led to the tail contacting the…NTSB CHI98LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, INthe pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.NTSB SEA98LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Boise, IDThe student pilot's failure to maintain directional control due to excessive taxispeed. Pressure perceived by the student pilot to expedite clearing the runway after landing in order to facilitate an aircraft departure was a contributing factor.NTSB FTW97LA349Accident · No injuriesLimited investigationFinal reportAS+ AC-4B · Sundance, WYimproper planning/decision by the pilot, which led to a snag and sudden slack in the tow rope, and necessitated an aborted launch (emergency landing) after initial liftoff. This in turn led to an inadvertent stall, a wing drop, and the left wing tip dragging…NTSB LAX97LA265Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DUO Discus · Minden, NVThe pilot's failure to ensure that the wings were maintained at a lateral level attitude during the initial landing rollout. A factor in the accident was the rough, uneven nature of the terrain chosen for the landing.NTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.NTSB FTW97LA200Accident · No injuriesLimited investigationFinal reportBeech BE-56TC · Spring, TXThe pilot's failure to perform an adequate preflight (did not remove pitot tube protective covering prior to flight) which resulted in an inaccurate cockpit airspeed indication during takeoff roll and subsequent emergency landing. Factors were, the pilot's…