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 WPR09CA344Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26A · Lake Riverside, CAA loss of lift which necessitated a forced landing in a field.NTSB WPR09LA313Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider OHG LS3-A · Cedar Valley, UTThe pilot inadvertently applied the tow release handle.NTSB WPR09CA310Accident · No injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot's failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB ANC09CA057Accident · No injuriesData collectionFinal reportCessna 180F · King Salmon, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.NTSB WPR09CA229Accident · No injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Novato, CAThe pilot's inadequate compensation for the gusting crosswinds. Contributing to the accident was the flight instructor's failure to take timely remedial action.NTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.NTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.NTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.NTSB WPR09CA063Accident · No injuriesData collectionFinal reportCessna 180C · Great Falls, MTThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.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 CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.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 DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.NTSB LAX08CA294Accident · No injuriesData collectionFinal reportAir Creation Clipper 912 · Glendale, AZThe airplane's encounter with a dust devil.NTSB MIA08CA100Accident · No injuriesData collectionFinal reportCessna 172A · Jamestown, PAThe pilot's failure to maintain control after takeoff resulting in contact with the ground. Contributing to the accident was the pilot's inadequate preflight planning resulting in a takeoff from a short, wet, soft, runway.NTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.