NTSB investigations
321 cases where the sequence of events included 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 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 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 WPR24LA146Accident · Minor injuriesClass 3 · LimitedFinal reportRobert Sterling 4P · Lake Havasu City, AZA loss of engine power during initial climb due to fuel vapor lock. Contributing to the accident was the incorrect installation of the ancillary fuel supply system components.NTSB ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB ANC24LA024Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction’s failure to maintain control of the weight-shift control aircraft, during takeoff, which resulted in collision with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN24LA171Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7ECA · Lakeport, TXThe student pilot’s failure to maintain adequate airspeed during the final approach, which resulted in an inadvertent aerodynamic stall. Contributing to the accident the flight instructor’s delayed remedial action.NTSB WPR24LA116Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Coolidge, AZThe student pilot’s improper landing flare, which resulted in a hard landing in gusty wind conditions. Contributing, was the failure of the flight instructor to intervene in a timely manner.NTSB GAA24WA123Accident · No injuriesClass 5 · ForeignRobinson Helicopter R44 · Suben, AustriaNTSB GAA24WA102Accident · No injuriesClass 5 · ForeignMaule M7 · Staniel Cay, BahamasNTSB CEN24LA109Accident · Minor injuriesClass 4 · LimitedFinal reportJavron PA-12 Replica · Inver Grove Heights, MNThe pilot’s failure to properly configure the landing gear on his amphibious airplane before landing on water.NTSB CEN24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lampasas, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Denton, TXThe student pilot’s failure to maintain directional control while landing with a tailwind.NTSB CEN23LA386Accident · Serious injuriesClass 4 · LimitedFinal reportSilverlight AR-1 · Granbury, TXThe pilot’s improper takeoff procedure which resulted in a loss of control during takeoff.NTSB ANC23LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Tyonek, AKThe pilot’s encounter with windshear during the initial climb, which resulted in a loss of control.NTSB CEN23LA290Accident · No injuriesClass 4 · LimitedFinal reportGood James AIR CAM · Caswell Beach, NCThe pilot’s failure to properly evaluate the sea state during an open sea landing and subsequent takeoff attempt resulting in an inadvertent impact with the water.NTSB CEN23LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Holyoke, COThe pilot's failure to maintain directional control during the landing roll.NTSB CEN23LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Grand Forks, NDThe student pilot’s failure to attain a proper takeoff attitude while demonstrating a soft field takeoff and his improper control inputs resulting in a dragged wing. Contributing to the accident were the gusting wind conditions.NTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.NTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.NTSB ERA23LA116Accident · No injuriesClass 4 · LimitedFinal reportMesafox Kitfox · Orlando, FLAn inadvertent encounter with the jet blast of another airplane while taxiing, which resulted in substantial damage to the airplane’s left wing.NTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.NTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.NTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanNTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.NTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.NTSB CEN22LA440Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Merrill, WIThe student pilot's failure to maintain adequate roll control during takeoff with a quartering tailwind.NTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.NTSB ERA22LA293Accident · No injuriesClass 4 · LimitedFinal reportCrawford James R MU-582 Drifter · Seminole, FLThe pilot’s failure to maintain control of the airplane during landing flare.NTSB WPR22LA232Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Copperopolis, CAThe pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.NTSB ERA22LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Lancaster, NYThe student pilot’s excessive pitch during takeoff resulted in a loss of control and impact with terrain. Contributing was the student’s failure to relinquish the controls when ordered by the instructor.NTSB CEN22LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Port Bolivar, TXThe pilot’s failure to attain a proper soft field takeoff pitch attitude during takeoff that resulted in a runway excursion and subsequent impact with a canal.NTSB DCA22WA083AccidentClass 5 · ForeignDouglas DC9 · Diffa, NigerNTSB ERA22LA091Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Manhattan, NYThe pilots overapplication of flight controls during landing, which resulted in the rotor blades contacting the wire strike protection system and subsequent hard landing.NTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ANC21LA081Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Kodiak, AKThe pilot’s improper landing flare, which resulted in a hard landing and nose over.NTSB ERA21LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Martinsburg, WVThe flight instructor’s loss of directional control after an aerodynamic stall at takeoff.NTSB WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.NTSB ERA21LA259Accident · No injuriesClass 4 · LimitedFinal reportMaule M5 · Annapolis, MDThe pilot’s failure to maintain directional control during landing.NTSB ERA21FA237Accident · 1 fatalClass 3 · FieldFinal reportBeech A23 · Pinnacle, NCThe flight instructor’s mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB WPR21LA362Accident · No injuriesClass 3 · LimitedFinal reportMaule MX-7-235 · Ontario, ORA loss of hydraulic fluid and failure of the right brake for reasons that could not be determined due to a lack of available evidence.NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB ANC21LA010Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172R · Hope, AKThe pilot’s selection of unsuitable terrain for landing. A factor was the certified flight instructor’s selection of unsuitable terrain for landing.NTSB ANC20CA092Accident · No injuriesClass 4 · Data collectionFinal reportHelio H 295 · Fairbanks, AKThe pilot’s decision to initiate a right turn immediately after departure and his failure to maintain a proper crosswind correction, which resulted in a collision with terrain.NTSB WPR20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna Ector 305A · Amboy, CAThe pilot's failure to maintain directional control of the airplane during a precautionary landing which resulted in a ground loop.NTSB ERA20LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA25 · Miami, FLA total loss of engine power due to carburetor ice that was not detected by the pilot.NTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.NTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.