NTSB investigations, 2017
25 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 61 |
| 2009 | 43 |
| 2010 | 38 |
| 2011 | 42 |
| 2012 | 41 |
| 2013 | 37 |
| 2014 | 19 |
| 2015 | 35 |
| 2016 | 27 |
| 2017 | 25 |
| 2018 | 28 |
| 2019 | 24 |
| 2020 | 30 |
| 2021 | 44 |
| 2022 | 53 |
| 2023 | 53 |
| 2024 | 52 |
| 2025 | 47 |
| 2026 | 26 |
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 year(c.\"eventDate\") = 2017
AND 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 year(c."eventDate") = 2017 AND 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 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.