NTSB investigations, 2010
79 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 62 |
|---|---|
| 2009 | 62 |
| 2010 | 79 |
| 2011 | 84 |
| 2012 | 102 |
| 2013 | 78 |
| 2014 | 82 |
| 2015 | 81 |
| 2016 | 120 |
| 2017 | 126 |
| 2018 | 175 |
| 2019 | 124 |
| 2020 | 83 |
| 2021 | 45 |
| 2022 | 55 |
| 2023 | 50 |
| 2024 | 51 |
| 2025 | 69 |
| 2026 | 30 |
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\" = '900' 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" = '900' 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 ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.NTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB ERA11FA042Accident · 1 fatalField investigationFinal reportMD Helicopters 369E · Thomas, WVThe pilot's failure to clear the helicopter and its external load from surrounding structures and his failure to execute a timely release of the external load, which resulted in an inadvertent entanglement and collision with wires and terrain. Contributing to…NTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.NTSB WPR11FA032Accident · 4 fatalField investigationFinal reportMooney M20J · Lander, WYThe pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB ANC11LA004Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sitka, AKA lightning strike which resulted in substantial damage to the elevator.NTSB CEN11CA015Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Richmond, INThe pilot's diverted attention to a landing gear indicator light that led to a loss of directional control and subsequent impact with terrain while taxiing.NTSB ERA11CA010Accident · Serious injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYThe passenger's loss of balance while deplaning.NTSB ERA11CA002Accident · No injuriesData collectionFinal reportFleet 16B · Lake City, SCThe pilot’s improper use of the brakes while taxiing.NTSB ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…NTSB ANC10CA103Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe student pilot's selection of unsuitable terrain for an off-airport landing, resulting in the airplane nosing over.NTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.NTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB ERA10CA461Accident · No injuriesData collectionFinal reportYeager Lancair · McMinnville, TNThe pilot’s failure to properly latch the cockpit canopy prior to takeoff, resulting in his diverted attention and failure to maintain aircraft control.NTSB ERA10IA459Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 407 · Marion, VAThe cardiac impairment of the pilot during a positioning flight.NTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.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 WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.NTSB WPR10IA430Incident · Minor injuriesIncident investigationFinal reportAirbus A320-232 · Sacramento, CAThe first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…NTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB CEN10LA494Accident · No injuriesLimited investigationFinal reportCessna 310F · LaGrange, INThe pilot did not maintain altitude due to his distracted attention to a vibration of unknown origin.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB CEN10CA466Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Pettus, TXThe pilot's decision to exit the helicopter with the engine running.NTSB WPR10FA383Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot‘s failure to maintain airspeed and airplane control during a turn from the base leg to final approach due to his diverted attention.NTSB ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…NTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.NTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.NTSB CEN10CA444Accident · No injuriesData collectionFinal reportBrewster Fleet 7-220 · Manzanola, COA collision with a hidden obstruction during the landing roll.NTSB CEN10IA438Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAThe loss of main rotor rpm during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies.NTSB ERA10LA377Accident · No injuriesLimited investigationFinal reportCessna 172N · Waynesboro, VAThe pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.NTSB ERA10CA367Accident · No injuriesData collectionFinal reportBell 206 · Roseville, PAThe pilot's failure to maintain clearance from a known wire hazard.NTSB ANC10CA063Accident · No injuriesData collectionFinal reportCessna 172P · New Stuyahok, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a collision with trees.NTSB DCA10WA078Incident · No injuriesForeign investigationBoeing 757 - 212 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-200 that occurred on July 16, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…NTSB CEN10FA382Accident · 3 fatalField investigationFinal reportCessna 421 · Tulsa, OKThe pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.NTSB WPR10LA336Accident · Minor injuriesLimited investigationFinal reportJohnson Helicycle · Arlington, WAAn undetermined airframe vibration which led to precautionary autorotation and hard landing.NTSB CEN10CA369Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Austin, TXThe pilot's failure to maintain directional control of the helicopter, resulting in impact with trees. Contributing to the accident was the pilot's failure to ensure the door was properly secured prior to flight.NTSB WPR10CA338Accident · No injuriesData collectionFinal reportAdams John R JR Piel Diamant · Montezuma, UTThe pilot's failure to maintain clearance from road signs during landing.NTSB CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.NTSB CEN10CA376Accident · No injuriesData collectionFinal reportWells Terry Hula Girl · Wellington, COA partial loss of engine power due to the inadequate design of the engine cowling.NTSB WPR10FA324Accident · 1 fatalField investigationFinal reportCessna 182P · Avalon, CAThe pilot's incapacitation due to a heart attack, which resulted in a loss of airplane control.NTSB ERA11WA157Incident · No injuriesForeign investigationBeech 300 · Jundiai, BrazilOn June 29, 2010, about 1910 UTC, a Beech 300, Brazilian registration PP-EPD, operated by The Government of the State of Amazonas, Brazil had a blown tire during the landing roll following a forced landing shortly after takeoff from Jundiai Airport (SBJD),…NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB WPR10LA300Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 120A · Grants Pass, ORThe balloon ground crew member's decision to not release his hold on the basket of an ascending hot air balloon basket as it lifted off of the ground.NTSB CEN10CA304Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Stanton, MNThe pilot’s inadvertent propeller blade pitch change and subsequent loss of forward thrust.