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 SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB ANC93LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC19 · Resurrect'N Bay, AKThe pilot-in-command's failure to maintain directional control upon landing.NTSB NYC93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wyantskill, NYInadequate supervision and delayed remedial action by the flight instructor. The student pilot's failure to maintain directional control and his inexperience is a contributing factor.NTSB NYC93LA114Accident · No injuriesLimited investigationFinal reportPitts S-2B · East Palestine, OHThe pilot's failure to maintain control of the aircraft. The pilot's improper compensation for the wind condition is a contributing factor.NTSB ANC93LA079Accident · No injuriesLimited investigationFinal reportCessna A185F · Kahiltna Glacie, AKThe pilot-in-command not maintaining directional control. A factor is the rough condition of the glacier airstrip.NTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.NTSB CHI93LA164Accident · No injuriesLimited investigationFinal reportGrumman TBM-3E · Spooner, WIThe pilot's failure to maintain directional control.NTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.NTSB MIA93LA027Accident · Minor injuriesLimited investigationFinal reportBell 47-G5A · Belle Glade, FLThe improper in flight decision of the pilot in command to attempt an agricultural turn with insufficient altitude to accomplish the maneuver. Contributing to the accident was the pilot's overconfidence in his abilities.NTSB ANC92LA183Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's preflight planning/preparation in accessing the available runway length and snow conditions. Factors relating to the accident were the snow bank and the pilot in command's lack of familiarity with skiplane operations.NTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.NTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.NTSB CHI92FA219Accident · 1 fatalField investigationFinal reportTeal TSC-1A2 · Oshkosh, WIThe pilot-in-command's not following procedures/directives.NTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.NTSB ANC92LA090Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-500D · Polk Inlet, AKThe pilot's failure to follow proper procedure and the company's inadequate procedures and directives. A factor was the uneven terrain.NTSB ANC92LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elephant Lake, AKThe dual student's inadequate compensation for wind conditions and the instructor's inadequate supervision. A factor was the tailwind.NTSB LAX92LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Coolidge, AZThe pilot's use of unsuitable terrain and inadequate compensation for the existing wind conditions.NTSB ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB NYC91LA243Accident · No injuriesLimited investigationFinal reportLake LA-4 · Wilton, METhe pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.NTSB DEN91LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Conchas Dam, NMLanding gear locking mechanism loose, landing gear wheel deployed inadvertently, and maintenance alignment not performed. Factors were: propeller governor underspeed, maintenance adjustment not corrected, and lowering of flaps not performed.NTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.NTSB ATL91LA163Accident · No injuriesLimited investigationFinal reportBell 47D1 · Winton, NCThe pilot's selection of unsuitable terrain for landing the helicopter.NTSB SEA91LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Genesee, IDThe pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.NTSB ANC91LA109Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane on landing.NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.NTSB NYC91LA225Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103B · Marion, OHThe pilot's improper decision to change landing runways with insufficient altitude and airspeed which resulted in a dragged wing and ground loop.NTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.NTSB CHI91LA180Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNBecause of inadequate compensation for the wind conditions, aircraft control was lost by the pilot. A factor related to the accident was a gusty crosswind landing environment.NTSB ANC91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Kenai, AKThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.NTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.NTSB MIA91LA145Accident · Serious injuriesLimited investigationFinal reportCorley Hubert KR-2 · Venice, FLThe pilot's improper use of flight controls.NTSB ATL91LA088Accident · 1 fatalLimited investigationFinal reportCessna 150J · Kure Beach, NCThe pilot's poor judgement, while impaired by alcohol, and his misjudgement of altitude/clearance above the water after initiating a low pass.NTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…NTSB ANC91IA052Incident · No injuriesIncident investigationFinal reportPiper PA-32-301 · Eek, AKThe failure of the center torque link bolt.NTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.NTSB ANC91IA028Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Unalaska, AKThe windshear encountered on short final. Contributing to the accident was the rising terrain within 150 feet of the runway, the variable nature of the wind due to the rising terrain, and the pilot's failure to maintain lateral control during the go around.NTSB LAX91LA013Accident · 2 fatalLimited investigationFinal reportBell 47G5 · AntarcticaThe pilot's failure to maintain on adequate altitude while maneuvering above the water.NTSB LAX90LA330Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Lakeport, CAThe pilot's failure to maintain control of the aircraft while high-speed water taxiing. The excessive taxi speed is considered a factor in the accident.NTSB ATL90LA162Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Savannah, TNThe pilot's failure to maintain aircraft control during the landing phase of the flight. Factors were: gusting wind conditions and turbulence.NTSB CHI90LA199Accident · No injuriesLimited investigationFinal reportFouga FOUGA-MAGISTER · Oshkosh, WIThe pilot-in-command's failure to maintain proper airspeed in turn from base to final.NTSB CHI90DEV05Accident · Minor injuriesFinal reportCessna 172P · Jerseyville, ILThe pilot's failure to go around when crosswinds upset aircraft alignment with the runway in the flare. Contributing to the accident was the pilot's attempt to land in crosswinds which exceeded the maximum for which the model has been demonstrated capable.NTSB ATL90LA059Accident · No injuriesLimited investigationFinal reportCessna 425 · Augusta, GAFailure of the pilot to maintain control of the aircraft during the go-around. A factor related to the accident was: the pilot's delay in initiating the go-around.NTSB MKC90LA041Accident · No injuriesLimited investigationFinal reportMancini Rotorway Exec · Mountain Iron, MNFailure of the non-certificated pilot to maintain adequate altitude, while maneuvering the helicopter. The pilot's lack of experience and proper certification (qualification) were related factors.NTSB CHI90DEE04Accident · No injuriesFinal reportCessna 172RG · Romeoville, ILDual student's inadequate compensation for wind conditions and remedial action not attained by the CFI. A factor related to the accident was: a snow bank adjacent the runway.NTSB CHI90LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · New Lenox, ILFailure of the pilot to attain wind information, which resulted in his selection of an unfavorable (wrong) runway. A factor related to the accident was: the crosswind condition.NTSB ATL89LA199Accident · No injuriesLimited investigationFinal reportHughes 269A · Saluda, SCStudent pilot's improper use of the flight controls during lift-off and inadequate supervision by the flight instructor.