Fatal NTSB investigations, 2012
201 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 171 |
|---|---|
| 2009 | 186 |
| 2010 | 201 |
| 2011 | 219 |
| 2012 | 201 |
| 2013 | 165 |
| 2014 | 188 |
| 2015 | 155 |
| 2016 | 140 |
| 2017 | 153 |
| 2018 | 173 |
| 2019 | 144 |
| 2020 | 80 |
| 2021 | 113 |
| 2022 | 104 |
| 2023 | 105 |
| 2024 | 97 |
| 2025 | 60 |
| 2026 | 24 |
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\") = 2012
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2012 AND c."highestInjuryLevel" = 'Fatal' 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 ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…NTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB ERA13LA093Accident · 1 fatalLimited investigationFinal reportRussom Roy G Hummel H5 · Calhoun, GAThe pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.NTSB ERA13FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Parkton, NCThe failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of…NTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB CEN13FA089Accident · 1 fatalField investigationFinal reportBeech 58 · Manhattan, ILAn in-flight loss of control and impact with terrain for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.NTSB ERA13LA076Accident · 1 fatalLimited investigationFinal reportCassutt Sport Racer · Collegedale, TNImpact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.NTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.NTSB CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.NTSB ERA13FA070Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Apollo Beach, FLMast bumping for reasons that could not be determined because one main rotor blade was not recovered.NTSB CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.NTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…NTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR13FA061Accident · 3 fatalField investigationFinal reportPiper PA28 · Aurora, UTThe pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…NTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.NTSB WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.NTSB ERA13WA066Accident · 1 fatalForeign investigationAerospatiale AS-355F1 · Great Guana Cay, BahamasOn November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…NTSB CEN13LA063Accident · 1 fatalLimited investigationFinal reportRedd Tom Quicksilver GT 400 · Oak Grove, LAThe total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.NTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB CEN13LA062Accident · 1 fatalLimited investigationFinal reportJabiru USA Sport J250-SP · Jacksonville, TXThe pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.NTSB CEN13FA060Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Burlington, WIThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.NTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB ERA13FA059Accident · 3 fatalField investigationFinal reportCessna 172N · Owls Head, METhe vehicle driver's failure to verify that the runway was not occupied by an airplane before crossing the runway, which resulted in the vehicle being struck by a departing airplane, and the pilot's continued takeoff with flight control damage, which…NTSB WPR13FA041Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Morgan, UTThe pilot's inadequate preflight inspection, which resulted in frost remaining on the airplane's surfaces and led to its inability to produce enough lift to clear rising terrain.NTSB ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.NTSB ERA13FA055Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Jackson, MSThe pilot's inadequate preflight inspection, which resulted in his failure to note the water in the fuel tank due to condensation, which subsequently shut down the engine in flight. Contributing to the accident was the pilot's self-induced pressure to…NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB CEN13WA061Accident · 2 fatalForeign investigationReims-Cessna F150 · Birr, Ireland, IrelandOn November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…NTSB WPR13FA036Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Waterville, WAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.NTSB CEN13LA046Accident · 1 fatalLimited investigationFinal reportSorensen Sprint Mxii · Groesbeck, TXThe pilot’s failure to maintain control of the noncertificated airplane during a go-around. Contributing to the accident was the pilot’s physical and psychological impairment.NTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…NTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.NTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.NTSB WPR13FA022Accident · 2 fatalField investigationFinal reportBehne Glasair III · Byron, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.NTSB CEN13LA029Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Castroville, TXThe pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.NTSB CEN13WA020Accident · 2 fatalForeign investigationMooney M20E · Speichersdorf, GermanyOn October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.NTSB WPR13FA013Accident · 1 fatalField investigationFinal reportAeropro CZ A240 · Half Moon Bay, CAThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.