Skip to content

NTSB investigations, 2011

21 cases where the sequence of events included Dragged wing/rotor/float/other.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2011 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '093' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 year(c.\"eventDate\") = 2011
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '093' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 year(c."eventDate") = 2011
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '093' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.Nov 4, 2011 · N2099B · Substantial damage NTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…Oct 26, 2011 · N6018U · Substantial damage NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damage NTSB ERA12CA168Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Zelienople, PAThe pilot did not maintain directional control during landing.Oct 12, 2011 · N567HW · Substantial damage NTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Sep 3, 2011 · N30950 · Substantial damage NTSB CEN11LA618Accident · No injuriesLimited investigationFinal reportVicari Waiex · Marion, ILThe partial loss of engine power during initial climb for undetermined reasons.Sep 2, 2011 · N100VY · Substantial damage NTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.Aug 30, 2011 · N2868A · Substantial damage NTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.Aug 29, 2011 · N172LD · Substantial damage NTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.Aug 17, 2011 · N388BA · Substantial damage NTSB CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.Jul 28, 2011 · N195SM · Substantial damage NTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.Jul 14, 2011 · N7709Z · Substantial damage NTSB WPR11CA293Accident · No injuriesData collectionFinal reportAviat A-1B · Livermore, CAThe pilot's failure to maintain directional control during a go-around.Jun 25, 2011 · N101HY · Substantial damage NTSB WPR11CA298Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe flight instructor's delayed remedial action and failure to maintain lateral control.Jun 16, 2011 · N434K · Substantial damage NTSB ANC11CA034Accident · No injuriesData collectionFinal reportCessna 180J · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.May 18, 2011 · N9951N · Substantial damage NTSB CEN11CA291Accident · No injuriesData collectionFinal reportCessna A185F · Hot Springs, ARThe pilot’s improper recovery from a bounced landing.Apr 28, 2011 · N2530S · Substantial damage NTSB ANC11CA024Accident · No injuriesData collectionFinal reportCessna 180H · Palmer, AKThe pilot’s loss of directional control during the landing roll resulting in a ground-loop.Apr 9, 2011 · N2709X · Substantial damage NTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.Mar 28, 2011 · N410VE · Substantial damage NTSB CEN11CA213Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Glenwood Springs, COThe pilot’s improper takeoff procedure, which resulted in a dynamic rollover when the left skid contacted the ground.Mar 1, 2011 · N74816 · Substantial damage NTSB WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.Jan 31, 2011 · N530RL · Substantial damage NTSB CEN11LA162Accident · No injuriesLimited investigationFinal reportPiper PA24 · Huntsville, TXThe pilot’s inadequate preflight inspection to ensure the main tanks were full, which resulted in a total loss of engine power due to fuel starvation.Jan 28, 2011 · N8023P · Substantial damage NTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.Jan 19, 2011 · N6187S · Substantial damage