NTSB investigations, 2019
19 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\") = 2019
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") = 2019 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 CEN20LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 525A · Scotts Bluff, NEThe installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.NTSB WPR20WA251Incident · No injuriesForeign investigationDe Havilland DHC8 · Eaton, AustraliaThe government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB DCA20WA016Incident · No injuriesForeign investigationBoeing 747 · Leipzig, GermanyThe government of Germany has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…NTSB WPR20WA011Incident · No injuriesClass 5 · ForeignDiamond DA42 · Singapore, SingaporeNTSB WPR19LA273Accident · No injuriesClass 3 · LimitedFinal reportSmyth Sidewinder · Tucumcari, NMThe in-flight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.NTSB WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.NTSB CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.NTSB WPR19LA242Accident · No injuriesClass 3 · LimitedFinal reportLockheed C130 · Santa Barbara, CAThe failure of the No. 3 bleed air duct due to corrosion, which resulted in numerous system failures and the pilot’s inability to maintain directional control during the landing roll.NTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…NTSB GAA19WA547Accident · No injuriesForeign investigationPiper PA28R · Sligo, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB CEN19LA251Accident · No injuriesClass 3 · LimitedFinal reportRyan Navion · Chicago, ILThe failure of the left main landing gear upper side brace assembly during landing due to reverse bending fatigue as a result of the incomplete penetration of the circumferential weld during initial production of the component.NTSB DCA19WA183Incident · No injuriesForeign investigationBoeing 747 · Harare, ZimbabweThe CAA of Zimbabwe has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAAZ's investigation under the provisions of ICAO Annex 13 as State…NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB CEN19LA166Accident · No injuriesClass 3 · LimitedFinal reportBeech E90 · Greenville, TXThe fatigue failure of the right main landing gear upper torque knee.NTSB ANC19LA024Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Nome Creek, AKThe failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…NTSB CEN19LA133Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Mineral Wells, TXThe in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.NTSB DCA19WA072Incident · No injuriesForeign investigationBoeing 787 · Casablanca, MoroccoThe BEA of Morocco has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on February 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of Morocco's investigation under the provisions of ICAO Annex…