NTSB investigations, 2010
676 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\") = 2010
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") = 2010 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 WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…NTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…NTSB CEN11CA140Accident · No injuriesData collectionFinal reportRockwell International 114A · North Lima, OHThe pilot’s failure to maintain directional control during the landing touchdown.NTSB CEN11CA135Accident · No injuriesData collectionFinal reportAllen Raymond H Lancair Legacy · Troy, MIThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadvertent stall. Contributing to the accident was the structural icing on the airframe.NTSB ERA11LA099Accident · No injuriesLimited investigationFinal reportBeech F35 · Syracuse, NYThe pilot’s failure to maintain adequate airspeed during landing with airframe structural icing, resulting in an aerodynamic stall and subsequent hard landing. Contributing to the accident was the pilot’s continued flight into known icing conditions.NTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.NTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.NTSB WPR11CA079Accident · No injuriesData collectionFinal reportMoyes Bailey Microlite · Newberg, ORThe pilot's improper recovery from a dive, which resulted in a loss of control.NTSB ANC11LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Saint Michael, AKThe loss of directional control during landing due to a flat nose wheel tire, resulting in a runway excursion and collision with trees.NTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…NTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.NTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB CEN11IA108Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Columbus, OHThe failure of water to properly drain through the fuselage drain holes, thus becoming trapped and freezing around the flight control cables, which resulted in the loss of control authority to the airplane's ailerons, elevator, and rudder.NTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.NTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.NTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB CEN11LA090Accident · 1 fatalLimited investigationFinal reportSoutherland Freebird Litesport U · Decatur, ILThe pilot's reported inability to control his amateur-built airplane for undetermined reasons after the airplane inadvertently became airborne while conducting a high-speed taxi.NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.NTSB WPR11CA060Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Warner Springs, CAThe certified flight instructor's inadequate compensation for the crosswind and delayed remedial action during landing, which resulted in a ground loop.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB ERA11CA059Accident · No injuriesData collectionFinal reportHiller-Rogerson Helicopter UH12E · Madison, FLThe pilot's encounter with a settling with power condition while he was performing slow, low-level, out-of- ground-effect flight maneuvers.NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.NTSB CEN11CA068Accident · No injuriesData collectionFinal reportSchweizer 300C · Broomfield, COThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's improper execution of an autorotation, which resulted in a hard landing.NTSB ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.NTSB WPR11FA045Accident · No injuriesField investigationFinal reportEurocopter AS350B2 · Pacoima, CAThe contamination of a spool bearing in the power turbine governor during manufacture, which led to the bearing’s failure in flight, a subsequent loss of engine power during departure, and the resultant hard landing.