NTSB investigations, 2008
54 cases where NTSB found Aircraft structures.
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 54 |
| 2009 | 55 |
| 2010 | 60 |
| 2011 | 51 |
| 2012 | 51 |
| 2013 | 36 |
| 2014 | 26 |
| 2015 | 35 |
| 2016 | 39 |
| 2017 | 25 |
| 2018 | 34 |
| 2019 | 32 |
| 2020 | 21 |
| 2021 | 31 |
| 2022 | 21 |
| 2023 | 28 |
| 2024 | 35 |
| 2025 | 12 |
| 2026 | 7 |
Where
Latest 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 year(c.\"eventDate\") = 2008
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0103'))
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") = 2008 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0103')) 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 ANC09LA017Accident · No injuriesLimited investigationFinal reportCessna 207A · Hoonah, AKThe pilot's failure to ensure that the aft cargo door was properly latched and locked prior to departure, which resulted in an in-flight opening of the aft cargo door and subsequent damage to the airplane.NTSB WPR09IA070Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Kamuela, HIThe separation of the endplate bolts for undetermined reasons, resulting in an in-flight separation of the right endplate. Contributing to the accident was the manufacturer's failure to provide sufficient guidance for endplate bolt installation.NTSB WPR09CA059Accident · No injuriesData collectionFinal reportCessna 210 · Sheridan, WYMaintenance personnel's failure to reinstall the left front pilot's seat correctly, which resulted in the pilot's loss of control and subsequent impact with a taxiway sign.NTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.NTSB CEN09FA094Incident · No injuriesField investigationFinal reportBombardier CL-600-2C10 · Chicago, ILThe failure of the left landing gear to extend due to improper maintenance when the landing gear door was replaced. Contributing to the incident was the manufacturer's inadequate maintenance manual instructions.NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB ERA09FA029Accident · 2 fatalField investigationFinal reportPiper PA-24 · Red Hill, VAThe pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…NTSB WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.NTSB CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.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 NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…NTSB SEA08FA196Accident · 1 fatalField investigationFinal reportDebus J / Mountain S / Bowes E DEBUS-CASST-SNOSHOO · Reno, NVThe movement of the airplane’s modified horizontal stabilizer trim system during an intentional high speed aerobatic maneuver that resulted in exceedence of the design stress limits of the airplane and an in-flight structural failure. Contrubuting to the…NTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.NTSB CHI08MA270Accident · 3 fatalMajor investigationFinal reportConvair CV-580 · Columbus, OHThe improper (reverse) rigging of the elevator trim cables by company maintenance personnel, and their subsequent failure to discover the misrigging during required post-maintenance checks. Contributing to the accident was the captain’s inadequate…NTSB CHI08CA287Accident · Minor injuriesData collectionFinal reportCessna 172M · Three Lakes, WIThe pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.NTSB MIA08CA176Accident · Serious injuriesData collectionFinal reportCameron ZL-60 · Anderson, SCThe pilot's improper use of the balloon burners.NTSB DFW08CA222Accident · No injuriesData collectionFinal reportFairchild SW3 · Carlsbad, NMFailure of the door to remain secure for undetermined reasons.NTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.NTSB CHI08CA298Accident · No injuriesData collectionFinal reportLake LA-4 · Algonac, MIThe amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.NTSB DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.NTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…NTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.NTSB LAX08LA242Accident · No injuriesLimited investigationFinal reportGlaser-Dirks Flugzeugbau DG-100G · Truckee, CAA malfunction of the tow release mechanism.NTSB CHI08FA196Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Sport Cruiser · Newark, ILThe pilot's failure to maintain control of the airplane in the landing pattern. Contributing to the severity of injuries was the failure of the pilot's shoulder harness.NTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…NTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB NYC08LA228Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toms River, NJThe failure of the pilot's seat to engage or remain engaged due to the improper inspection of the worn seat tracks.NTSB CHI08FA172Accident · No injuriesField investigationFinal reportEnstrom Helicopter 480B · Marinette, WIThe pilot inadvertently operating the helicopter at a gross weight greater than its maximum allowable operating weight, and flying the helicopter at an airspeed greater than the never-to-exceed speed for the helicopter’s gross weight condition, resulting in…NTSB CHI08CA168Accident · No injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INThe pilot/builder's failure to manufacture the airplane with an appropriate engine thrust angle. Contributing to the accident was the pilot/builder's adjustment of the horizontal stabilizer which rendered the airplane uncontrollable.NTSB CHI08LA158Accident · 1 fatalLimited investigationFinal reportMaggs Lancair 4P · Alhambra, ILThe pilot's decision to continue the flight into an area of known thunderstorm activity and the in-flight structural failure of the airplane.NTSB LAX08LA160Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger LSS · Moses Lake, WAThe pilot's inability to maintain control due to an in-flight separation of the vertical fin as a result of the failure of the airplane's builder to properly secure the vertical fin to the fuselage.NTSB CHI08FA133Accident · 2 fatalField investigationFinal reportBeech V35 · Bristol, OHThe loss of control during cruise flight in instrument conditions due to spatial disorientation.NTSB ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.NTSB DEN08CA089Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · De Witt, ARThe pilot's improper decision to attempt to close the canopy in flight, and his diverted attention resulting in the airplane impacting the terrain. Contributing to the accident was the excessively worn canopy latch.NTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.NTSB CHI08IA109Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Pontiac, MIThe inadvertent stalling of the rudder trim actuator motor during flight due to the pilot's unintentional exceedence of the motor's design limit for stalling while accelerating after completing a simulated engine-out maneuver.NTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.NTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.NTSB LAX08LA105Accident · No injuriesLimited investigationFinal reportRaytheon B300 · Tuscaloosa, ALThe pilot's encounter with severe turbulence during descent into the airport environment, which resulted in an exceedence of the aircraft's design stress limit and structural damage.NTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.NTSB SEA08LA101Accident · Minor injuriesLimited investigationFinal reportJihlavan KP 5 ASA · Marana, AZThe pilot's failure to maintain an airspeed above stalling speed (Vs) during an emergency landing after takeoff. Contributing to the accident was an inadequate preflight inspection, and the airplane's canopy coming partially open shortly after takeoff.NTSB CHI08CA095Accident · No injuriesData collectionFinal reportPiper PA-34-200T · North Canton, OHThe bird strike during approach for landing.NTSB CHI08CA097Accident · No injuriesData collectionFinal reportHughes 269A · Franklin Furnac, OHThe fuel exhaustion during cruise flight and the unsuitable terrain encountered by the pilot-in-command. A contributing factor was the trees.NTSB LAX08IA065Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Las Vegas, NVAn inadvertent encounter with severe turbulence during descent and the failure of two passenger seat belt attach fittings. Contributing to the incident was the failure of the operator to comply with the SAIB.NTSB CHI08CA087Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe left wing skin "fabric patch" separated from the wing ribs and spars for an undetermined reason.NTSB DEN08LA065Accident · No injuriesLimited investigationFinal reportPlocher SHA-Glasair · Telluride, COThe pilot's improper flare and his failure to maintain aircraft control, resulting in the design stress limits of the nose gear being exceeded. Contributing factors in this accident was the excessive airspeed, the pilot-induced porpoise of the airplane, and…NTSB NYC08CA102Accident · No injuriesData collectionFinal reportBeech C90-1 · Meridian, MSAn inadvertent encounter with in-cloud turbulence.