NTSB investigations
76 cases where the defining event was Dragged wing/rotor/float/other.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '093') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '093') 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 ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.NTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.NTSB ANC13CA087Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Bethel, AKThe pilot's failure to maintain directional control and crosswind compensation during landing.NTSB CEN13CA407Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Weslaco, TXThe pilot receiving instruction failed to compensate for the crosswind condition during landing, and the flight instructor's delayed corrective action.NTSB WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.NTSB CEN12CA665Accident · Minor injuriesData collectionFinal reportCessna 182 · Tiskilwa, ILThe pilot’s loss of control while preforming a short field takeoff.NTSB CEN12CA643Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Slaton, TXThe pilot’s misalignment of the helicopter during landing, which resulted in the helicopter’s fall from a raised platform.NTSB CEN12CA430Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Williston, NDThe pilot's failure to ensure a suitable landing surface.NTSB WPR12CA273Accident · No injuriesData collectionFinal reportCessna 170B · Concord, CAThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.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.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.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.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.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.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.NTSB CEN10WA413Accident · Minor injuriesForeign investigationBell 206 · La Tuna, MexicoThe government of Mexico has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 03, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA10CA273Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmingdale, NYThe pilot's failure to maintain directional control during a go-around attempt.NTSB ERA10CA223Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Moore Haven, FLThe pilot's failure to maintain directional control during a water landing.NTSB DCA10IA015Incident · No injuriesIncident investigationFinal reportBoeing MD · Charlotte, NCThe Captain's failure to initiate a go-around from a Category III approach when satisfactory tracking performance was not maintained below the required altitude resulting in excessive bank angle maneuvers at low altitude. Factors contributing to the incident…NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.NTSB WPR09LA313Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider OHG LS3-A · Cedar Valley, UTThe pilot inadvertently applied the tow release handle.NTSB CEN09CA011Accident · No injuriesData collectionFinal reportCessna 170 · Santa Fe, NMThe flight instructor's delay in taking timely control of the airplane. Contributing to the accident was the crosswind.NTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.NTSB LAX08CA294Accident · No injuriesData collectionFinal reportAir Creation Clipper 912 · Glendale, AZThe airplane's encounter with a dust devil.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.