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 SEA97LA102Accident · No injuriesLimited investigationFinal reportBoeing E75 · Spokane, WAThe pilot-in-command's inadequate application of crosswind controls during landing rollout. Factors were gusty crosswinds.NTSB SEA97LA055Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bandon, ORthe dual student's failure to maintain directional control of the airplane, and the flight instructor's improper remedial action. A factor relating to the accident was: the ravine located near the right side of the runway.NTSB FTW96LA377Accident · Serious injuriesLimited investigationFinal reportPzl-Mielec MIG-17 · Amarillo, TXThe pilot's excessive takeoff rotation which led to premature lift-off at a speed inadequate to maintain flight. A factor was the pilot's lack of experience in the MIG-17.NTSB NYC96FA174Accident · No injuriesField investigationFinal reportLockheed L-1011-100 · Jamaica, NYfailure of the flight crew to complete the published checklist and to adequately cross-check the actions of each other, which resulted in their failure to detect that the leading edge slats had not extended and led to the aircraft's tail contacting the runway…NTSB MIA96LA189Accident · No injuriesLimited investigationFinal reportPitts S-2B · Boca Raton, FLthe dual student's inadequate compensation for wind conditions, and inadequate supervision by the flight instructor. The gusty/crosswind condition was a related factor.NTSB ATL96LA106Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bartow, FLthe pilot's inadequate visual lookout, and his failure to maintain ground clearance, while maneuvering to avoid a collision with a utility line.NTSB LAX96LA240Accident · 1 fatalLimited investigationFinal reportExperimental Mini Mustang · Page, AZthe pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.NTSB LAX96LA238Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Page, AZthe pilot's inadequate compensation for wind conditions, and failure to maintain control of the aircraft. Factors relating to the accident were: the gusty and crosswind conditions.NTSB ANC96LA067Accident · No injuriesLimited investigationFinal reportCessna 170 · Dillingham, AKrotation (slippage) of the tire on the rim, and shearing of the valve stem, which allowed the rim to contact the ground and then separate.NTSB ANC96LA058Accident · No injuriesLimited investigationFinal reportCessna 180H · Palmer, AKThe pilot-in-command's inadvertent stall during the go around attempt. Factors in the accident were the pilot-in- command's lack of a high performance endorsement and the pilot/passenger's decision to allow the pilot-in-command to manipulate the controls…NTSB MIA96LA104Accident · No injuriesLimited investigationFinal reportCessna 150F · Ocala, FLthe student pilot's inadequate compensation for the wind during the landing flare.NTSB MIA96LA090Accident · No injuriesLimited investigationFinal reportHelio H-295 · Key West, FLThe pilot's inadequate compensation for wind conditions during lift-off, which resulted in the right wingtip contacting the runway. The gusty crosswind was a related factor.NTSB LAX96LA100Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Folsom Lake, CAthe flight instructor's inadequate supervision of the dual student and improper remedial action. A factor relating to the accident was: failure of the student pilot to maintain directional control.NTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB MIA96IA039Incident · No injuriesIncident investigationFinal reportBoeing 747-212B · Amsterdam, NetherlandsThe failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.NTSB SEA96IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Boise, IDthe pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.NTSB LAX96LA053Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Fresno, CAfailure of the pilot to maintain proper control of the helicopter, while in a hover.NTSB LAX96LA034Accident · No injuriesLimited investigationFinal reportCessna 310C · Boulder City, NVthe pilot's improper aircraft handling during touchdown which resulted in the right wing and horizontal stabilizer dragging on the runway. The poorly planned landing approach was a factor.NTSB CHI95LA276Accident · No injuriesLimited investigationFinal reportCessna A185E · Dickinson, NDthe pilot's inadequate compensation for the wind conditions, and his improper recovery from the bounced landing. The high wind was a factor.NTSB ANC95LA138Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Togiak, AKThe pilot's inadequate compensation for wind conditions and failure to maintain proper alignment with the intended point of landing. A factor relating to the accident was: the unfavorable wind condition.NTSB CHI95LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Motley, MNthe pilot's failure to maintain control of the airplane during a soft field takeoff.NTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.NTSB ANC95LA085Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta Junction, AKThe pilot's improper compensation for the wind conditions which resulted in dragging the right wing and shearing off the nose gear.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB ANC95LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Gulkana, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC95LA084Accident · No injuriesLimited investigationFinal reportLockheed L-382E · Mcgrath, AKFailure of the pilot-in-command to assure the airplane was adequately flared for landing.NTSB ANC95LA051Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's inadvertent water loop/swerve due to the use of improper landing procedures.NTSB MIA95LA125Accident · No injuriesLimited investigationFinal reportFabre Searay Bombadier · Orlando, FLThe abrupt use of the flight controls,by the pilot-in-command while taxiing on water that resulted in the airplane capsizing.NTSB BFO95LA049Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mount Sterling, KYthe pilot's failure to maintain aircraft control during landing. The gusty, crosswind condition and the pilot's inadequate compensation for the wind condition were factors.NTSB ANC95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Koliganek, AKThe student pilot's inadequate compensation for the wind conditions. A factor in the accident is a crosswind.NTSB FTW95LA144Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Edgewood, NMThe flight's encounter with a downdraft. The lack of a suitable landing area was a factor.NTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.NTSB FTW95LA172Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Elk City, OKThe pilot's failure to maintain proper altitude during a hovering turn. A factor was the low temperature.NTSB FTW95LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-24APF · Tulsa, OKThe pilot's failure to maintain vref during approach and his improper flare touchdown that resulted in an excessive pitch up attitude following touchdown.NTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.NTSB MIA94LA208Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Deland, FLThe pilot in command's failure to maintain ground clearance while maneuvering over the runway threshold resulting in the left wing contacting the ground.NTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.NTSB ANC94LA126Accident · No injuriesLimited investigationFinal reportCessna 208 · Cape Sabine, AKThe pilot's improper preflight planning, inadequate compensation for the wind conditions, not following procedures and directives, and overconfidence in his abilities, and the operators inadequate surveillance of the operation.NTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.NTSB LAX94FA292Accident · 1 fatalField investigationFinal reportCessna 414 · Taft, CAThe pilot's inadequate preflight planning/preparation and selection of the wrong runway for takeoff. Factors related to the accident were: the uphill slope of the runway, tailwind, high density altitude, and failure of the pilot to correctly configure the…NTSB NYC94LA127Accident · Minor injuriesLimited investigationFinal reportHawk RUL-1 · Lucasville, OHThe pilot's improper use of flight controls during the landing flare. A factor related to the accident was the pilot's lack of recent flight experience in this type airplane.NTSB ANC94LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for the wind condition. A factor in the accident was the gusty wind condition.NTSB CHI94LA217Accident · Minor injuriesLimited investigationFinal reportHunsberger Glasair · Lapeer, MIthe pilot's failure to maintain aircraft handling. A factor related to the accident was the gusty wind conditions.NTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.NTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.NTSB ANC94LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Kassan Bay, AKThe pilot's inadequate compensation for the wind. Factors were the rough water and the gusty wind condition.NTSB LAX94LA231Accident · 1 fatalLimited investigationFinal reportCessna 172N · Roosevelt, AZthe pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.NTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.NTSB ANC94LA016Accident · No injuriesLimited investigationFinal reportCessna A185F · Chefornak, AKThe failure of the pilot-in-command to adequately compensate for the gusty cross wind condition. A factor in the accident was the wind gust.NTSB FTW94LA020Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · San Antonio, TXThe pilot's failure to maintain a visual lookout. Factors were: inadequate altitude and distracted attention.