NTSB investigations, 2020
24 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 24 |
| 2010 | 26 |
| 2011 | 31 |
| 2012 | 30 |
| 2013 | 26 |
| 2014 | 30 |
| 2015 | 35 |
| 2016 | 38 |
| 2017 | 37 |
| 2018 | 63 |
| 2019 | 36 |
| 2020 | 24 |
| 2021 | 24 |
| 2022 | 22 |
| 2023 | 33 |
| 2024 | 33 |
| 2025 | 25 |
| 2026 | 13 |
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\") = 2020
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' 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 year(c."eventDate") = 2020 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' 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 CEN21LA041Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Xenia, OHThe airplane’s impact with a deer during takeoff.NTSB ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB ANC20LA089Accident · No injuriesClass 3 · LimitedFinal reportEurocopter AS 350 · Fort Greely, AKFailure of the door lock due to interference between the door and a cargo box.NTSB CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.NTSB CEN20LA327Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Alicia, ARInadequate maintenance of panel fasteners, which led to a side panel coming loose during takeoff and the pilot having to make a subsequent forced landing to a flooded rice field when the airplane became difficult to control.NTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.NTSB CEN20LA294Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Harlan, IAThe fatigue fracture of the upper rudder hinge that resulted in a partial separation of the rudder from the airplane during a spray pass.NTSB WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.NTSB ANC20LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Soldotna, AKThe delamination of the fabric material from the fuselage above the windscreen due to failed adhesive, which resulted in disrupted airflow and a subsequent hard landing.NTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…NTSB CEN20LA207Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Duluth, MNThe pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.NTSB DCA20LA107Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737 · Victorville, CAImproper installation of dorsal fin attach bolts which caused the dorsal fin to separate during flight, substantially damaging the left horizontal stabilizer.NTSB WPR20LA130Accident · 1 fatalClass 3 · LimitedFinal reportBell UH 1H · Mesa, AZAn in-flight separation of the tail rotor gearbox from the airframe due to fatigue failure of the gearbox attachment studs, resulting in a loss of directional control and subsequent ground impact. Contributing to the accident were 1) the improper application…NTSB ERA20CA153Accident · No injuriesData collectionFinal reportLancair Super ES · Merritt Island, FLThe pilot's failure to maintain a stabilized approach and improper landing flare, which resulted in a porpoised landing.NTSB ERA20CA135Accident · No injuriesData collectionFinal reportAugustaWestland AW119MKII · Philadelphia, PAThe in-flight failure of the lower left side of the engine cowling due to the mechanic’s improper installation of the fasteners, which resulted in the cowling impacting all four main rotor blades.NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB DCA20WA106Incident · No injuriesForeign investigationEmbraer ERJ190 · Rosario, ArgentinaThe Junta de Seguridad en el Transporte (JST) Republica Argentina Direccion Nacional de Investigaciones (JIAAC) has notified the NTSB of an incident involving a EMBRAER ERJ190 airplane that occurred on February 17, 2020. The NTSB has appointed a U.S.…NTSB WPR20CA102Accident · No injuriesData collectionFinal reportMooney M20K · Minden, NVThe pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.NTSB WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.NTSB ERA20FA074Accident · 2 fatalClass 3 · FieldFinal reportRobinson R66 · Mechanicsburg, PAA severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter.NTSB WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…