NTSB investigations
20 cases where NTSB found Flight surfaces (wing).
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
Where
Open the mapLatest cases
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01035750')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035750')) 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 WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB WPR24FA052Accident · Serious injuriesClass 3 · FieldFinal reportRemos Remos GX · Taylor, AZThe pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.NTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.NTSB ERA21LA051Accident · Serious injuriesClass 4 · LimitedFinal reportJ&J Ultralights Sea-Wing · Placida, FLThe pilot/owner’s improper preflight inspection of the weight-shift trike, which resulted in a loss of control at takeoff due to an improperly adjusted wingtip.NTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.NTSB CEN20CA184Accident · No injuriesClass 4 · Data collectionFinal reportRhoads, Larry E Sopwith Baby · Lee's Summit, MOThe airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.NTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.NTSB CEN17LA224Accident · No injuriesLimited investigationFinal reportMckenna SD-1A · Juneau, WIThe pilot’s difficulty controlling the airplane due to his incorrect reinstallation of the wings, which led to a bounced precautionary landing. Contributing to the accident was the failure of the pilot and the mechanic to verify the wings’ angle of incidence.NTSB ANC16LA034Accident · No injuriesLimited investigationFinal reportDe Havilland DHC3 · Homer, AKAn in-flight collision with a bald eagle, which resulted in substantial damage to the left wing.NTSB ERA16FA001Accident · 4 fatalField investigationFinal reportPiper PA32R · Westminster, SCThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB ERA15LA044Accident · Serious injuriesLimited investigationFinal reportItec Maverick · Dunnellon, FLA cell blowout in the fabric wing, which resulted in an asymmetrical loss of lift and a subsequent loss of aircraft control.NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…NTSB CEN12LA114Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachute Condor · Rogersville, MOThe pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.NTSB WPR11LA459Accident · No injuriesLimited investigationFinal reportMcarthur Steen Skybolt · Greenleaf, IDStructural failure of the upper left wing during aerobatic flight.NTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.NTSB ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).NTSB CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.