NTSB investigations
726 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '330') 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 CEN18LA164Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sioux Falls, SDFailure of the right main landing gear drag brace bolt for reasons that could not be determined based on the available information.NTSB DCA18FA144Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC 9 83(MD-83) · Alexandria, LAthe failure of the right main landing gear under normal loads due to fatigue cracking in an area subject to an FAA Airworthiness Directive that was not adequately inspected.NTSB CEN18LA115Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WIThe restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal…NTSB CEN18WA111Incident · No injuriesForeign investigationCirrus Design SF50 · Nuuk, GreenlandOn February 26, 2018, about 1804 coordinated universal time, a Cirrus Design Corporation SF50 Vision Jet, serial number 0034, United States registration N3AD, sustained minor damage during landing roll on runway 23 at Nuuk Airport (BGGH), Nuuk, Greenland. The…NTSB WPR18LA094Accident · Serious injuriesClass 3 · LimitedFinal reportSoko Galeb G 2 · Elko, NVAn improperly installed brake cylinder, which resulted in insufficient hydraulic pressure being provided to three of the brake cylinders and the left brake being inoperable during landing.NTSB WPR18LA089Accident · No injuriesLimited investigationFinal reportShanks V Roger Vari EZE · Santa Monica, CAAn undetected fluid leak in the right brake line, which resulted in a reduction of braking effectiveness at the right wheel and a loss of directional control during the landing roll.NTSB ERA18LA067Accident · No injuriesLimited investigationFinal reportCessna 172RG · Martinsburg, WVA hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.NTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB DCA18CA056Accident · No injuriesData collectionFinal reportMcdonnell Douglas DC 9 33F · Bethel, AKfailure of a cargo tie-down fastener, resulting in unsecured cargo striking the pressure bulkhead.NTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.NTSB GAA18CA013Accident · No injuriesData collectionFinal reportCessna 172RG · Auburn, WAThe failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.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 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 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 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 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 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 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 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 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 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 ERA16WA249Incident · No injuriesForeign investigationBeech B200 · Lima, PeruOn June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…NTSB DCA16WA185Accident · Serious injuriesForeign investigationEmbraer ERJ190 · Madrid, SpainThe Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) Spain has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on June 15, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB ERA16FA194Accident · 2 fatalField investigationFinal reportJihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VAThe pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…NTSB CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…