NTSB investigations, 2018
18 cases where the defining event was Part(s) separation from AC.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 20 |
| 2012 | 15 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 14 |
| 2016 | 22 |
| 2017 | 19 |
| 2018 | 18 |
| 2019 | 19 |
| 2020 | 12 |
| 2021 | 12 |
| 2022 | 13 |
| 2023 | 15 |
| 2024 | 19 |
| 2025 | 22 |
| 2026 | 8 |
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\") = 2018
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
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") = 2018 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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 ERA19LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Simsbury, CTMaintenance personnel's inadequate inspection of the wheel brake system during the airplane's most recent 100-hour inspection, which resulted in a loss of hydraulic fluid and the pilot's inability to control the airplane during the landing.NTSB WPR19LA028Accident · No injuriesClass 3 · LimitedFinal reportBell 430 · Kailua, HIThe separation of one of the tail rotors blades’ root enclosures due to improper repair.NTSB GAA18CA544Accident · No injuriesData collectionFinal reportHalladay Roy Lockheed · Denver, COThe pilot's failure to verify that the emergency canopy release was in the correct position when opening the canopy during landing, which resulted in the canopy separating from the airplane and subsequently impacting the empennage.NTSB WPR18TA239Accident · Minor injuriesClass 3Final reportEurocopter EC130 · Hilo, HIThe separation of the left sliding door in flight after it opened for reasons that could not be determined based on the available evidence, which resulted in damage to the main rotor blades.NTSB ANC18LA067Accident · No injuriesLimited investigationFinal reportCessna U206 · Pedro Bay, AKThe fatigue fracture of both main landing gear legs during the landing roll, which resulted in the collapse and separation of both main landing gear legs.NTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.NTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.NTSB ANC18WA060Accident · No injuriesForeign investigationBell 205 · Hudson Bay, CanadaOn June 27, 2018, at 1713 central standard time, a Canadian registered Bell 205A helicopter, C-FYHD, operated by Transwest Air Ltd Partnership, was substantially damaged during a precautionary landing due to severe airframe vibration at Buckmayer Lake,…NTSB ERA18WA156Incident · No injuriesForeign investigationCessna 152 · Tulua, ColombiaThe government of Colombia has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions of…NTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…NTSB WPR18LA158Accident · No injuriesClass 3 · LimitedFinal reportRhoads Autogyro MTO Sport · San Manuel, AZThe fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB DCA18WA155Incident · No injuriesForeign investigationBoeing 737 · MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA18WA132Accident · No injuriesForeign investigationBell 206 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB GAA18CA108Accident · No injuriesData collectionFinal reportPiper J3L · Astoria, ORThe control stick handgrip separation from the control stick resulting in the airplane pitching forward, which resulted in hard landing.NTSB CEN18CA072Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 407 · Norfolk, NEMaintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight.NTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…