NTSB investigations
654 cases where NTSB found Aircraft structures.
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 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 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 ERA10CA461Accident · No injuriesData collectionFinal reportYeager Lancair · McMinnville, TNThe pilot’s failure to properly latch the cockpit canopy prior to takeoff, resulting in his diverted attention and failure to maintain aircraft control.NTSB ERA10CA477Accident · Minor injuriesData collectionFinal reportBeam-Walter RS-15 · Windsor, VAThe pilot's inadequate installation and preflight inspection of the right rudervator assembly, which resulted in a loss control during takeoff.NTSB ANC10CA078Accident · No injuriesData collectionFinal reportCessna U206F · Aleknagik, AKA bird strike which penetrated the airplane's windscreen.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.NTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.NTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.NTSB ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…NTSB WPR10CA475Accident · No injuriesData collectionFinal reportCessna 172S · Santa Maria, CAThe pilot's inadequate flare which resulted in a bounce and hard landing.NTSB CEN10LA420Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Toulin, ILA partial loss of engine power as a result of a cracked cylinder and the reduced visibility due to the oil-covered windshield.NTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.NTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.NTSB CEN10IA372Incident · No injuriesIncident investigationFinal reportEurocopter AS365N3 · Dayton, OHThe unintentional movement of the jettison handle in-flight due to the pilot’s dropping of a manual that impacted the handle and released the door window, which then impacted the horizontal stabilizer. Contributing to the accident was the jettison handle…NTSB WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB CEN10LA339Accident · 1 fatalLimited investigationFinal reportAirborne Windsport Edge · Ft. Lupton, COThe pilot intentionally performed prohibited aerobatic maneuvers that damaged the carriage wing attachment hang point and collapsed the wing.NTSB WPR10LA306Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Merced, CAThe pilot’s inability to maintain airplane control during cruise flight due to the failure of the elevator trim tab as a result of missing hardware for the elevator control cable bellcrank to elevator torque tube attachment bracket.NTSB WPR10LA293Accident · 2 fatalLimited investigationFinal reportRans Coyote II S6 · Lincoln, CAThe pilot’s failure to maintain adequate airspeed while in a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the increased drag on the airplane with the doors removed.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB WPR10LA276Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · San Diego, CAThe inadvertent opening of the aircraft canopy during the takeoff climb, which distracted the pilot and resulted in his failure to maintain aircraft control. Contributing to the accident was a lack of guidance in the manufacturer's pilot operating handbook…NTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.NTSB CEN10FA278Accident · 1 fatalField investigationFinal reportEvektor Aerotechnik Sportstar Plus · Richmond, TXThe opening of the cockpit canopy in-flight due to improper latching, which resulted in a loss of control and impact with terrain.NTSB ERA10IA285Incident · No injuriesIncident investigationFinal reportCessna 560XL · White Plains, NYThe flight crew's failure to ensure that the cabin door was secured/locked prior to takeoff.NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…NTSB DCA10CA061Accident · No injuriesData collectionFinal reportBoeing 747 · Miami, FLimpact of the fore flap with the aft fuselage after fatigue failure of the right wing fore flap carriage assembly attachment fitting at position 6.NTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.NTSB ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).NTSB ERA10IA254Incident · No injuriesIncident investigationFinal reportPiper PA 46-350P · Owensboro, KYA failure of the pilot's side window due to undetected cracking around the lower aft portion of the storm window cutout.NTSB WPR10FA211Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Captain Cook, HIThe pilot’s intentional in-flight maneuvers that exceeded the structural limits of the aircraft, which resulted in structural failure of the wings.NTSB WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.NTSB ERA10LA221Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Millbrook, NYThe pilot's failure to maintain aircraft control after takeoff while he was distracted by trying to hold shut the unlocked cockpit canopy. Contributing to the accident was the pilot's failure to lock the canopy prior to takeoff, and the inadequate guidance in…NTSB ENG10IA026Incident · No injuriesIncident investigationFinal reportAirbus A320 · Newark, NJThe separation of both halves of the left engine fan cowl assembly due to improper latching and locking of the all the fan cowl latches. The cause of the improper latching and locking of the fan cowls was due to the failure of the mechanic to unstow and…NTSB CEN10IA169Incident · No injuriesIncident investigationFinal reportSikorsky S-92A · Galliano, LAAn unsecured access door, which departed the helicopter and damaged a main rotor blade and a tail rotor blade. Contributing to the incident was the helicopter's color scheme, which made visual inspection of the door difficult.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB ERA10IA170Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Farmingdale, NYProgressive cracking from an undetermined initiation source, which resulted in the failure of the No. 4 cabin window outer pane, and the subsequent foreign object ingestion to the right engine.NTSB ERA10LA166Accident · Minor injuriesLimited investigationFinal reportBelcher William B II Firestar · Wetumpka, ALThe student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.NTSB CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.NTSB ANC10LA019Accident · No injuriesLimited investigationFinal reportCessna 208B · Kwigillingok, AKThe pilot's decision to take off with ice-contaminated wings in freezing rain and mist, which resulted in an aerodynamic stall.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB CEN10FA162Accident · No injuriesField investigationFinal reportMaule M-6-235 · Bennett, COThe pilot’s failure to maintain clearance from a utility line while maneuvering.NTSB WPR10LA121Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Fallon, NVInterference between the front seat lap belt and the rear seat rudder/brake pedal assembly that prevented normal operation of the rudder/brake system, which resulted in the pilots’ inability to maintain directional control.NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC10LA012Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gulkana, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane during landing.NTSB WPR10LA104Accident · 2 fatalLimited investigationFinal reportAirborne Streak 2 · Lake Isabella, CAThe pilot’s performance of prohibited aerobatic flight maneuvers that exceeded the structural limits of the airplane, resulting in an in-flight breakup.NTSB CEN10IA084Incident · No injuriesIncident investigationFinal reportATR ATR72 · Dallas, TXA fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…NTSB WPR10LA060Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Heli 369E · Kahuku, HIThe fatigue failure of the landing gear strut and maintenance personnel’s failure to perform an adequate inspection of the landing gear.NTSB CEN10FA042Accident · 1 fatalField investigationFinal reportZenith Zodiac 601 XL · Agnos, ARThe in-flight separation of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and strength and the lack of aileron counterbalances.NTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.NTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.NTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.