NTSB investigations
289 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 19 |
| 1985 | 16 |
| 1986 | 12 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 13 |
| 1990 | 7 |
| 1991 | 22 |
| 1992 | 9 |
| 1993 | 11 |
| 1994 | 15 |
| 1995 | 21 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 14 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 5 |
| 2007 | 7 |
Where
Open the mapLatest cases
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 NYC08CA063Accident · No injuriesData collectionFinal reportMaule M-7-235 · Key Largo, FLThe pilot's loss of control during the landing. Contributing was the wind gust.NTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.NTSB CHI07CA226Accident · No injuriesData collectionFinal reportHamilton Rotorway Exec 90 · Harvey, NDThe pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.NTSB ANC07LA067Accident · No injuriesLimited investigationFinal reportLockheed 382G-44K-30 · McGrath, AKThe pilot's excessive rotation of the airplane during takeoff, which resulted in dragging the tail on the runway and substantial damage.NTSB DFW07LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Castroville, TXThe flight instructor's inability to maintain directional control due to the drag created by the tall grass adjacent to the runway. A contributing factor was the tall grass.NTSB LAX07CA164Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Red Lodge, MTThe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment that resulted in dragging a wing and ground looping. Also causal was the pilot's delayed decision to abort the landing.NTSB LAX07CA092Accident · No injuriesData collectionFinal reportCessna 172S · Lake Wells, FLthe flight instructor's inadequate compensation for the gusty crosswind conditions.NTSB DCA06FA068Accident · No injuriesField investigationFinal reportBoeing B757-232 · San Juan, PRthe first officer's inadvertent application of full nose-up trim during a prolonged flare, resulting in an excessive pitch angle during landing and subsequent tailstrike. Contributing to the accident was the flight crew's failure to correct the airplane's…NTSB CHI06CA209Accident · No injuriesData collectionFinal reportCessna 180M · Chisholm, MNThe pilot's inadequate compensation for the wind condition. A factor associated with the accident was the gusty wind condition.NTSB CHI06LA212Accident · No injuriesLimited investigationFinal reportCessna R172K · Grand Rapids, MNThe pilot's failure to maintain control of the airplane during the landing. A factor associated with the accident was the gusty tailwind that prevailed.NTSB ANC06IA054Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKThe flightcrew's delayed go-around during an unstabilized approach to land, which resulted in dragging a wingtip on the runway during the go-around. A factor associated with the incident was the flightcrew's unstabilized approach.NTSB LAX06CA171Accident · No injuriesData collectionFinal reportCessna 320 · Long Beach, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.NTSB MIA06CA029Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Daytona Beach, FLThe flight instructor's inadequate supervision, and the student pilot's improper go-around procedures, which resulted in the airplane's left wing striking the runway.NTSB NYC06LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Laurel, DEThe pilot's improper decision to takeoff from an unimproved field, and his subsequent failure to abort the takeoff prior to collision with a sign and an embankment. Factors in the accident were his improper soft field technique, and the dark night conditions.NTSB DFW06CA017Accident · No injuriesData collectionFinal reportHawker Siddeley 125-700 · Houston, TXThe pilot-in-command's failure to attain proper runway alignment.NTSB LAX05CA302Accident · No injuriesData collectionFinal reportCessna 172S · Show Low, AZthe pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.NTSB DCA05MA099Accident · No injuriesMajor investigationFinal reportAirbus A321-231 · Fort Lauderdale, FLFollowing a bounced landing, the pilot in command activated his sidestick controller while the first officer was in control of the airplane, which subsequently resulted in the overcontrol of pitch and a tailstrike. Contributing to the circumstances of this…NTSB LAX05CA274Accident · No injuriesData collectionFinal reportBeech A36 · Healdsburg, CAthe pilot's failure to maintain lateral aircraft control during takeoff.NTSB DEN05LA108Accident · No injuriesLimited investigationFinal reportGrob G103 · Moriarty, NMthe glider pilot's intentional tow release at too low an altitude when he erroneously perceived the tow plane was about to crash. A contributing factor was the unsuitable terrain on which to make a landing.NTSB CHI05CA115Accident · No injuriesData collectionFinal reportCessna 172H · Plattsmouth, NEThe student pilot's inadequate compensation for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusting crosswind.NTSB IAD05TA058Accident · Minor injuriesFinal reportHughes 369FF · Quantico, VAThe flight crew's failure to maintain adequate altitude/clearance from a building, which resulted in contact with the building, dynamic rollover, and collision with terrain.NTSB CHI05CA085Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Atkinson, NEThe pilot's failure to compensate for the wind condition which resulted in a loss of aircraft control while landing. A factor associated with the accident was the gusty crosswind condition that existed at the time of the accident.NTSB NYC05FA054Accident · No injuriesField investigationFinal reportBoeing 777-200 · Newark, NJThe captain's failure to follow company procedures, which resulted in a tail strike. Contributing were the gusty crosswind and tailwind conditions, and the manufacturer's failure to provide adequate performance planning data to account for gusty crosswinds…NTSB ANC05IA002Incident · No injuriesIncident investigationFinal reportBoeing MD-11F · Anchorage, AKThe operator's failure to provide sufficient weight and balance information to the flight crew, which resulted in a center of gravity aft of the limit, and a tail strike during the takeoff roll. Factors associated with the incident are the operator's improper…NTSB CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB FTW04LA225Accident · No injuriesLimited investigationFinal reportBoeing 727-2M7 · El Paso, TXThe first officer's failure to maintain aircraft control. Contributing factors were the captain's delayed remedial action and the crosswind.NTSB LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.NTSB ATL04IA132Incident · No injuriesIncident investigationFinal reportPilatus PC-12-45 · LaGrange, GAThe pilot's failure to maintain aircraft control during the landing flare.NTSB FTW04LA117Accident · No injuriesLimited investigationFinal reportBell 407 · Hurst, TXThe student pilot's excessive flare prior to touchdown during the practice autorotation which resulted in the tailboom stinger striking the ground. A contributing factor was the flight instructor's delay to take remedial action.NTSB SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.NTSB CHI04LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Sturgis, MIThe pilot's inadvertent raising of flaps resulting in a loss of lift and his failure to maintain aircraft control resulting in a dragging of the wing.NTSB MIA04CA041Accident · No injuriesData collectionFinal reportMaule M-7-235B · Fort Lauderdale, FLThe pilot's failure to maintain aircraft control. A factor in this accident was the improper use of full flaps.NTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.NTSB ATL04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kinston, NCThe pilot's failure to maintain aircraft control which resulted in the dragging of the right wing tip and the on ground collision with a roadway.NTSB ANC03LA115Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to maintain control of the airplane during the takeoff run, which resulted in the airplane nosing over in the water. Factors contributing to the accident were wind gusts, and the pilot's inadequate evaluation of the wind conditions.NTSB MIA03FA120Accident · Minor injuriesField investigationFinal reportAerospatiale AS355F1 · Madison, FLThe pilot in command's diverted attention and loss of control while attempting to takeoff, which resulted in the main rotor blades being dragged, and the helicopter rolling over.NTSB DEN03LA097Accident · No injuriesLimited investigationFinal reportBell 206B III · Broomfield, COthe student pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB DEN03FA090Accident · 1 fatalField investigationFinal reportHughes 269C · Watkins, COfailure of both pilots to initiate a timely recovery from a practice autorotation. A contributing factor was the instructor's inadequate supervision of the pilot receiving instruction.NTSB MIA03CA107Accident · No injuriesData collectionFinal reportMichael Allen Brown RAF 2000 GTX · Punta Gorda, FLThe pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.NTSB CHI03LA098Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Wichita, KSThe premature lowering of the collective and the improper use of the cyclic during the run-on landing performed by the flight instructor, as well as the main rotor/tail boom contact. Contributing factors were the intentional run-on landing, the grass landing…NTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.NTSB IAD03LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Marietta, PAThe flight instructor 's misjudgment of the helicopter's height above the river.NTSB NYC02LA187Accident · No injuriesLimited investigationFinal reportBoeing 757-251 · Baltimore, MDThe captain's failure to follow existing company procedures for stabilized approach, and use of speed brakes.NTSB FTW02LA198Accident · No injuriesLimited investigationFinal reportAirbus Industrie A300-600F · El Paso, TXThe flight crew's failure to obtain the Vr speed prior to rotation which resulted in insufficient lift and the subsequent tail strike.NTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.NTSB CHI02LA124Accident · No injuriesLimited investigationFinal reportCessna 185F · Cumberland, WIthe failure of the pilot to maintain directional control after encountering high winds and gusty winds during taxi from landing.NTSB MIA02TA081Accident · No injuriesFinal reportBell OH-58C · Punta Gorda, FLDynamic rollover experienced by the pilot while attempting to lift off from a trailer after experiencing skid to trailer contact. A factor in the accident was the inadequate equipment (trailer) which had a 1.1875 inch high lip extending the length of the…NTSB ANC02LA015Accident · No injuriesLimited investigationFinal reportBoeing 727-100 · Kotzebue, AKThe pilot's decision to continue an unstabalized approach to landing. A factor associated with the accident is the pilot's failure to attain proper alignment with the runway.NTSB LAX02LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mammoth Lakes, CAThe onset of variable, gusty, crosswind conditions at the time of departure and the pilot's inadequate and improper compensation for the crosswind conditions.