NTSB investigations, 2010
26 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 | 12 |
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\") = 2010
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") = 2010 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 CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB CEN11IA114Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 40 · Colorado Springs, COFatigue failure of the nose wheel fork, which resulted in separation of the nose wheel.NTSB CEN11LA077Accident · No injuriesLimited investigationFinal reportHalbrook Rans S-6S · St. Cloud, MNThe airplane kit manufacturer’s recommended use of an improper nut type for securing the door hinge.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB CEN11GA020Accident · 1 fatalFinal reportBell 206B · Clarkson Valley, MOThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…NTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB WPR10CA437Accident · No injuriesData collectionFinal reportHolt Herbert L Long EZ · Afton, WYThe pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.NTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.NTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.NTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.NTSB CEN10IA372Incident · No injuriesIncident investigationFinal reportEurocopter AS365N3 · Dayton, OHThe unintentional movement of the jettison handle in-flight due to the pilot’s dropping of a manual that impacted the handle and released the door window, which then impacted the horizontal stabilizer. Contributing to the accident was the jettison handle…NTSB WPR10LA317Accident · Serious injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZThe in-flight separation of the exhaust clamps for an undetermined reason, which resulted in the exhaust system striking the wooden propeller.NTSB CEN10CA358Accident · No injuriesData collectionFinal reportCessna 180K · Cahokia, ILThe fatigue failure of the axle's attaching bolts during landing.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB CEN10FA291Accident · 2 fatalField investigationFinal reportBell 222 · Midlothian, TXThe fracture of a swashplate drive pin as a result of hydrogen embrittlement due to an unknown source, which resulted in an in-flight breakup of the main rotor system during cruise flight.NTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.NTSB CEN10LA241Accident · Minor injuriesLimited investigationFinal reportHager Clinton Ray Vans RV-8 · Prague, OKThe in-flight separation of a propeller blade for undetermined reasons.NTSB ERA10IA254Incident · No injuriesIncident investigationFinal reportPiper PA 46-350P · Owensboro, KYA failure of the pilot's side window due to undetected cracking around the lower aft portion of the storm window cutout.NTSB ENG10IA026Incident · No injuriesIncident investigationFinal reportAirbus A320 · Newark, NJThe separation of both halves of the left engine fan cowl assembly due to improper latching and locking of the all the fan cowl latches. The cause of the improper latching and locking of the fan cowls was due to the failure of the mechanic to unstow and…NTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.NTSB ERA10IA170Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Farmingdale, NYProgressive cracking from an undetermined initiation source, which resulted in the failure of the No. 4 cabin window outer pane, and the subsequent foreign object ingestion to the right engine.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB WPR10FA133Accident · 5 fatalField investigationFinal reportEurocopter EC135 · Cave Creek, AZThe sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…NTSB ERA10WA149Incident · No injuriesForeign investigationPiper PA32 · Santiago, EcuadorOn February 6, 2010, about 1020 central standard time, a Piper PA-32-300, of Ecuadorian registration, HC-BOD, registered to and operated by Fundacion Amazonia Verde, separated the left main wheel during the landing roll at the Mashuim Airstrip, Santiago,…NTSB WPR10LA117Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe loss of a main rotor blade counterweight due to corrosion. Contributing to the accident was the failure of the operator to perform the initial and recurrent inspections required by a Service Bulletin to detect the corrosion in the counterweight.