NTSB investigations, 2011
783 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\") = 2011
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") = 2011 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 ERA12FA130Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Jacksonville, FLThe pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.NTSB CEN12LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Elk Rapids, MIThe loss of engine power due to the failure of the exhaust valve.NTSB CEN12LA127Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Marion, TXA total loss of engine power due to fuel starvation as a result of a piece of metal in the fuel line, which blocked fuel flow to the engine.NTSB WPR12CA072Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Murrieta, CAThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB CEN12LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot’s inadvertent positioning of the fuel selector valve between the right tank and OFF position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate inspection of the fuel valve and…NTSB WPR12LA070Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Concord, CAThe pilot's inadequate preflight inspection of the airplane and the subsequent total loss of engine power as a result of debris and water contamination in the fuel system.NTSB ERA12FA123Accident · 1 fatalField investigationFinal reportAero Commander 560-F · Venice, FLThe pilot’s failure to maintain adequate airspeed during a single-engine approach, which resulted in an aerodynamic stall. Contributing to the accident was the total loss of power in the left engine due to a failed No. 2 connecting rod bearing.NTSB ERA12CA124Accident · No injuriesData collectionFinal reportChapel Robert B Aerial · Simsbury, CTThe pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.NTSB CEN12LA114Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachute Condor · Rogersville, MOThe pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB ERA12FA120Accident · 1 fatalField investigationFinal reportCessna 441 · Nashville, PAThe pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…NTSB CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.NTSB ANC12CA016Accident · Minor injuriesData collectionFinal reportCessna 207A · Kwigillingok, AKThe pilot’s decision to continue visual flight into instrument meteorological conditions with moderate icing, which resulted in structural icing and an aerodynamic stall.NTSB ERA12FA115Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Morristown, NJThe airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…NTSB CEN12CA119Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Loreauville, LAThe student pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB ERA12CA118Accident · No injuriesData collectionFinal reportCessna 120 · Montague, MAThe pilot's delay in performing a rejected takeoff after experiencing an intermittent loss of engine power, which resulted in a runway excursion.NTSB ERA12LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Merry Hill, NCOperation of the airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s failure to maintain airspeed while making a forced landing following a total loss of engine power at low altitude, which resulted in an…NTSB WPR12FA067Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot's failure to maintain adequate separation behind a corporate jet, which resulted in an encounter with wake turbulence and a subsequent loss of control.NTSB CEN12LA110Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Midland, TXThe pilot’s improper fuel management during the flight, which resulted in a total loss of engine power.NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…NTSB WPR12LA065Accident · Minor injuriesLimited investigationFinal reportBell 407 · Rock Springs, WYThe unauthorized operation of the helicopter by a non-certificated and unqualified individual who failed to maintain helicopter control.NTSB WPR12LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAA total loss of engine power during initial climb 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.NTSB ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.NTSB WPR12FA062Accident · 1 fatalField investigationFinal reportCrosley Vans RV-8 · Armistead, CAThe pilot’s failure to maintain clearance from terrain while performing low altitude aerobatic maneuvers.NTSB CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…NTSB ERA12LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLA loss of engine power during takeoff for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…NTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.NTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.NTSB ANC12CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Kaltag, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's self-reported fatigue.NTSB ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.NTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.NTSB CEN12LA095Accident · Serious injuriesLimited investigationFinal reportBeech F90 · Midland, TXThe pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…NTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.NTSB ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB ERA12IA090Incident · No injuriesIncident investigationFinal reportCessna 402B · Nantucket, MAThe failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…NTSB CEN12FA086Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Riverwoods, ILThe pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.NTSB ERA12WA105Accident · 2 fatalForeign investigationCirrus SR20 · Minas Gerias, BrazilOn November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.NTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.NTSB ERA12CA083Accident · Minor injuriesData collectionFinal reportCessna 162 · Lincoln Park, NJThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control, a runway excursion, and collision with trees.NTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.NTSB CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.NTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…