NTSB investigations
996 cases where the sequence of events included Sys/Comp malf/fail (non-power).
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\" = '330' 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" = '330' 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 DCA17WA215Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryThe Ministry of National Development Transport Safety Bureau of Hungary has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB GAA17CA546Accident · No injuriesData collectionFinal reportCessna 150 · Siler City, NCThe pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll.NTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.NTSB GAA17CA570Accident · No injuriesData collectionFinal reportPiper PA 31 · SaipanImpact with multiple birds while retracting the landing gear, which resulted in the subsequent failure of the right inboard main landing gear door actuator hose and prevented the pilot from being able to extend the landing gear.NTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.NTSB ERA17LA287Accident · No injuriesLimited investigationFinal reportCessna R182 · Clearwater, FLThe improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB DCA17WA225Incident · No injuriesForeign investigationBoeing 737 · Dubai, United Arab EmiratesThe GCAA of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO…NTSB DCA17WA168Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation…NTSB DCA17WA164Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…NTSB CEN17LA280Accident · No injuriesLimited investigationFinal reportStinson 108 · Lee's Summit, MOThe pilot’s loss of directional control during landing due to the failure of the right brake seal.NTSB ERA17LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210L · Wilkes-Barre/Scranton, PAFailure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.NTSB DCA17WA153Incident · No injuriesForeign investigationBoeing 737 · Ciudad Juárez, MexicoThe government of Mexico has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR17LA121Accident · No injuriesLimited investigationFinal reportBob Frederick Titan T-51 · Goodyear, AZFailure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.NTSB CEN17WA278Incident · No injuriesForeign investigationAmateur Construction Titan T-51 Mustang · Gloucestershire, United KingdomOn May 31, 2017, about 1433 hours universal coordinated time, a Titan T-51 Mustang, United Kingdom registration G-DHYS, had a landing gear collapse during landing at the Gloucestershire Airport, near Gloucestershire, United Kingdom. The pilot was not injured.…NTSB WPR17LA114Accident · No injuriesLimited investigationFinal reportTappen Chris Velocity SUV · Puyallup, WAThe airplane builder's failure to install safety wires on the brake disc attachment bolts, and the mechanic’s failure to identify the omission during the condition inspection. The subsequent brake disc separation resulted in a loss of directional control…NTSB WPR17LA113Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rockville, IDThe in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of engine power and a subsequent hard landing.NTSB CEN17FA196Accident · 1 fatalField investigationFinal reportPiper J3C · Chetek, WIThe pilot's failure to maintain control of the airplane while flying at a low altitude, which resulted in the airplane exceeding the critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17LA178Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Manistee, MIThe failure of the airplane owner and maintenance personnel to follow the propeller manufacturer's recommend overhaul schedule, which resulted in a fatigue fracture of the propeller blade actuating pin and a loss of thrust in flight.NTSB CEN17LA150Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Pontiac, MIMaintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…NTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…NTSB DCA17WA115Incident · No injuriesForeign investigationAirbus A321 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on February 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB CEN17LA104Accident · No injuriesLimited investigationFinal reportBeech D55 · Columbus, OHThe partial loss of left engine power during takeoff and initial climb, which led to a hard landing in gusting crosswind conditions. The reason for the loss of engine power could not be determined because postaccident examination of the left engine revealed…NTSB CEN17WA107Accident · No injuriesForeign investigationCessna 402C · Virgin Gorda, British Virgin IslandsOn February 11, 2017, at 2004 UTC, a Cessna 402C, N603AB, experienced brake failure during landing roll and impacted terrain at the Virgin Gorda Airport (TUPW), British Virgin Islands. The pilot and 8 passengers on board were not injured. The airplane…NTSB WPR17LA061Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 B55 (T42A) · Cameron Park, CAFailure of the landing gear to extend as a result of excessive wear within the landing gear gearbox and motor, which resulted in a gear-up landing.NTSB ERA17LA105Accident · No injuriesLimited investigationFinal reportS C Aerostar S A YAK 52 · St. Elmo, ALThe failure of the right main landing gear uplock actuator due to corrosion.NTSB WPR17LA056Accident · No injuriesLimited investigationFinal reportBeech 99 · Billings, MTThe fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.NTSB CEN17LA091Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Delta, COThe failure of the landing gear to extend during landing approach due to the interference between the landing gear motor's sector and worm gears.NTSB GAA17CA119Accident · No injuriesData collectionFinal reportCessna 175 · Lakeport, CAThe pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB CEN17LA057Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ionia, MIA failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.NTSB ERA17WA303Accident · 1 fatalForeign investigationSchempp Hirth VENTUS2C · San Carlos de Bolivar, ArgentinaOn December 3, 2016, about 1750 coordinated universal time, a Schempp Hirth Ventus-2C motorized glider, Argentine registration LV-EDB, operated by a private individual, was substantially damaged when it impacted terrain after the left wing detached from the…NTSB ERA17LA054Accident · No injuriesClass 3 · LimitedFinal reportLoofbourrow John W Rutan Defiant · Morristown, NJA collapse of the nose landing gear due to wear in the landing gear extension system.NTSB CEN17LA039Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Pleasanton, TXMaintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.NTSB ANC17LA005Accident · No injuriesLimited investigationFinal reportCessna A185 · Ninilchik, AKA loss of brake system fluid due to leaks in the o-rings, which resulted in asymmetrical braking and a subsequent loss of directional control during the landing roll.NTSB DCA17WA023Incident · No injuriesForeign investigationBoeing 737-476 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CCAA) has notified the NTSB of an incident involving a BOEING 737-476 airplane that occurred on November 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…NTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…NTSB DCA16CA226Accident · No injuriesData collectionFinal reportBombardier DHC 8 202 · Dulles, VAincorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.NTSB ANC16LA068Accident · Serious injuriesLimited investigationFinal reportJeffery D Tuttle BDK Carbon Concepts · Wasilla, AKThe structural failure of both wings’ leading-edge slats, which resulted in a loss of airplane control.NTSB CEN16LA374Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bowling Green, OHThe pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…NTSB CEN16LA336Accident · No injuriesLimited investigationFinal reportBeech E-55 · Wichita Falls, TXThe failure of the landing gear assembly snap ring, which prevented the pilot from being able to extend the landing gear and resulted in a gear-up landing. Also causal was the lack of the assembly's overhaul in accordance with the airplane maintenance manual.NTSB ERA16LA296Accident · No injuriesLimited investigationFinal reportMantell Allan T Kitfox 4 1200 · Canandaigua, NYThe failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…NTSB ANC16LA059Accident · No injuriesLimited investigationFinal reportWight Carbon CUB CCK-1865 · Wasilla, AKThe failure of the tailwheel suspension assembly during landing due to preexisting fatigue fractures in the suspension system, which resulted in a loss of directional control.NTSB ERA16LA266Accident · 1 fatalLimited investigationFinal reportRepublic RC 3 · Winter Haven, FLImproper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.NTSB ENG16RA030Incident · No injuriesForeign investigationAirbus A320 · Narita, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving an Airbus A320, which occurred on July 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Japan Transport Safety Board investigation under the…NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.