NTSB investigations, 2015
664 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 816 |
|---|---|
| 2009 | 839 |
| 2010 | 676 |
| 2011 | 755 |
| 2012 | 751 |
| 2013 | 642 |
| 2014 | 708 |
| 2015 | 664 |
| 2016 | 737 |
| 2017 | 719 |
| 2018 | 729 |
| 2019 | 691 |
| 2020 | 598 |
| 2021 | 590 |
| 2022 | 625 |
| 2023 | 591 |
| 2024 | 560 |
| 2025 | 432 |
| 2026 | 216 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106')) 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 CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.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 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 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 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 CEN16LA068Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Baytown, TXThe pilot's failure to maintain directional control during landing in gusting wind conditions.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 ERA16LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Charles Town, WVThe flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.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 GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.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 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 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 GAA16LA086Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 390 · Wheeling, ILThe pilots' decision to conduct an approach and landing in gusting wind conditions, and their failure to maintain control of the airplane during the first approach, which resulted in a wing strike.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 GAA16CA075Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe student pilot's failure to maintain directional control during the landing, which resulted in a horizontal rotation of the helicopter, and abnormal runway contact.NTSB GAA16CA068Accident · No injuriesData collectionFinal reportAviat A-1C · Hurtsboro, ALThe pilot's incorrect use of brake pressure during the landing roll, which resulted in a nose over.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 GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.NTSB GAA16CA081Accident · No injuriesData collectionFinal reportCessna 182 · Salisbury, NCThe pilot's failure to maintain pitch control during the landing flare, causing the airplane to balloon and land hard.NTSB GAA16CA064Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe student pilot's improper flare during landing, which resulted in a bounced landing, and a runway excursion.NTSB GAA16CA063Accident · No injuriesData collectionFinal reportCessna 182D · Hamlet, NEThe student pilot's incorrect brake application which resulted in a runway excursion and a nose over.NTSB GAA16CA061Accident · No injuriesData collectionFinal reportMelvin K Callen Backcountry Supercub · Fort Morgan, COThe pilot's excessive braking during the landing roll, which resulted in a nose over.NTSB ERA16CA056Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Danbury, CTThe pilot's failure to maintain adequate clearance from obstructions while on approach to landing.NTSB GAA16CA111Accident · No injuriesData collectionFinal reportCessna 172 · Covington, TNThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, ground loop, and impact with the ground.NTSB GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.NTSB ERA16FA043Accident · 2 fatalField investigationFinal reportBeech A36TC · Orlando, FLThe pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…NTSB CEN16CA070Accident · No injuriesData collectionFinal reportCessna 172 · Rush City, MNThe student pilot did not maintain directional control of the airplane and applied excessive right rudder during landing.NTSB WPR16FA029Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350B3E · Carlsbad, CAThe pilot's loss of control during landing on a dolly. Contributing to the accident were the pilot's decision to conduct the flight without an instructor despite multiple flight instructors' recommendations to the contrary, his failure to land on the ramp…NTSB GAA16CA054Accident · No injuriesData collectionFinal reportAeronca 7AC · Fowlerville, MIThe pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.NTSB GAA16CA059Accident · No injuriesData collectionFinal reportCessna 172R · Westminster, MDThe student pilot's failure to maintain pitch control during the landing, which resulted in a hard landing.NTSB GAA16CA057Accident · No injuriesData collectionFinal reportChampion 7ECA · Eufaula, ALThe student pilot's decision to land with a quartering tailwind, resulting in a loss off directional control, excessive brake application, and a nose over.NTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB GAA16CA058Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.NTSB GAA16CA062Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4 · Morganton, NCThe pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.