NTSB investigations, 2015
674 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 759 |
|---|---|
| 2009 | 598 |
| 2010 | 655 |
| 2011 | 783 |
| 2012 | 766 |
| 2013 | 625 |
| 2014 | 671 |
| 2015 | 674 |
| 2016 | 697 |
| 2017 | 653 |
| 2018 | 669 |
| 2019 | 620 |
| 2020 | 324 |
| 2021 | 304 |
| 2022 | 315 |
| 2023 | 318 |
| 2024 | 324 |
| 2025 | 244 |
| 2026 | 153 |
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\") = 2015
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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") = 2015 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 CEN16LA079Accident · Serious injuriesLimited investigationFinal reportPiper 28-140 · Republic, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.NTSB GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.NTSB GAA16CA091Accident · No injuriesData collectionFinal reportCessna 177 · Grass Valley, CAThe pilot's loss of directional control during the touchdown and the subsequent attempted aborted landing which resulted in a runway excursion and impact with terrain.NTSB CEN16LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot’s improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to switch fuel tanks after the engine lost power, and his delayed decision to activate…NTSB GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB WPR16FA042Accident · 1 fatalField investigationFinal reportPiper PA32R · Castro Valley, CAThe pilot's loss of control due to spatial disorientation while maneuvering during an instrument approach in instrument meteorological conditions.NTSB ERA16LA077Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Myerstown, PAThe pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.NTSB GAA16CA102Accident · No injuriesData collectionFinal reportPiper PA 18A · Girdwood, AKFuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.NTSB GAA16CA099Accident · No injuriesData collectionFinal reportDavis Michael J MD Special · Wallace, NCThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB GAA16CA088Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Middle River, MDThe pilot's incorrect installation of the rudder horn and failure to properly inspect the installation, which led to a loss of directional control during takeoff.NTSB GAA16CA084Accident · No injuriesData collectionFinal reportPiper PA22 · New Castle, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB ERA16FA075Accident · 1 fatalField investigationFinal reportBeech C24R · Winder, GAA total loss of engine power for reasons that could not be determined because the examination of the wreckage did not reveal any mechanical anomalies that would have precluded normal operation.NTSB WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…NTSB GAA16CA090Accident · No injuriesData collectionFinal reportStinson 108 · Portales, NMThe pilot receiving instruction's improper brake application during the flight instructor's aborted landing, which resulted in a loss of directional control and a runway excursion. Contributing to the accident was the flight instructor's decision to perform…NTSB ERA16LA076Accident · No injuriesLimited investigationFinal reportPorrata Luis G Rans S 12XL · Guanica, PRThe pilot/owner's failure to maintain the engine in accordance with manufacturer guidance, which resulted in the undetected corrosion of the power takeoff bearing, subsequent bearing failure, and a total loss of engine power.NTSB ERA16FA074Accident · 2 fatalField investigationFinal reportHinton Paul M RV 4 · Greenville, FLThe pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…NTSB GAA16CA083Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Friendswood, TXThe student pilot's loss of directional control during an aborted landing, which resulted in a collision with a tree and impact with the ground.NTSB WPR16FA040Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350 · Superior, AZThe pilot's loss of helicopter control in mountainous terrain as the result of operating the helicopter outside the performance envelope of its hydraulic system and encountering the servo transparency phenomenon. Contributing to the accident was the pilot's…NTSB ERA16LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Brunswick, GAMaintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder.NTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…NTSB WPR16LA039Accident · No injuriesLimited investigationFinal reportMooney M20E · Corona, CAA partial loss of engine power during initial climb for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s decision to conduct the takeoff with observed engine deficiencies.NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.NTSB GAA16CA079Accident · No injuriesData collectionFinal reportMcmichael Elmer L Lancair 360 · Rimrock, AZThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and a left main landing gear collapse.NTSB ERA16LA067Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T Bird II · Lenoir, NCThe pilot’s failure to maintain airspeed and a coordinated turn in the traffic pattern, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to…NTSB ERA16LA068Accident · 1 fatalLimited investigationFinal reportMccorkle Robert B Rans S-12 Airaile · Benton, TNThe pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.NTSB ERA16LA065Accident · No injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Modena, NYA partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.NTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…NTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…NTSB CEN16LA061Accident · Minor injuriesLimited investigationFinal reportGlobe GC 1B · Lake Elmo, MNA loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.NTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB GAA16CA076Accident · Minor injuriesData collectionFinal reportCessna 172 · Abilene, TXThe student pilot's abrupt control inputs during the flare, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's lack of over sight and delayed reaction while landing.NTSB CEN16FA062Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Council Bluffs, IAThe pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.NTSB CEN16LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Angleton, TXA loss of control while hovering for reasons that could not be determined, because postaccident examination revealed no mechanical anomalies or failures that would have precluded normal operation.NTSB CEN16FA054Accident · 2 fatalField investigationFinal reportCessna 140 · Keytesville, MOThe non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…NTSB WPR16FA035Accident · 2 fatalField investigationFinal reportAero Vodochody L 39C · Apple Valley, CAA total loss of engine power on takeoff, which resulted from a sudden over-temperature condition due to an improperly adjusted fuel control unit and the deteriorated condition of the fuel nozzles.NTSB CEN16FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Pattonsburg, MOThe pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.NTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.NTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…NTSB ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…NTSB GAA16CA070Accident · Minor injuriesData collectionFinal reportStinson 108 · Sharon, KSThe pilot's decision to continue the unstabilized approach and landing and his delayed decision to go around with an insufficient climb rate, which resulted with collision with trees.NTSB GAA16CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5 · West Point, VAThe pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.NTSB ERA16LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Opa Locka, FLMaintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.NTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.NTSB GAA16CA072Accident · No injuriesData collectionFinal reportSkaggs Ronnie Lynn Rans S6S · Oldtown, MDThe pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain.NTSB ANC16CA009Accident · No injuriesData collectionFinal reportCessna 172 · Manley Hot Springs, AKThe pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.NTSB WPR16LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Wickenburg, AZA partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.