Final NTSB investigations, 2012
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,511 |
| 1984 | 3,403 |
| 1985 | 3,051 |
| 1986 | 2,824 |
| 1987 | 2,757 |
| 1988 | 2,651 |
| 1989 | 2,478 |
| 1990 | 2,451 |
| 1991 | 2,391 |
| 1992 | 2,293 |
| 1993 | 2,244 |
| 1994 | 2,190 |
| 1995 | 2,216 |
| 1996 | 2,091 |
| 1997 | 2,038 |
| 1998 | 2,061 |
| 1999 | 2,069 |
| 2000 | 2,026 |
| 2001 | 1,876 |
| 2002 | 1,868 |
| 2003 | 1,928 |
| 2004 | 1,776 |
| 2005 | 1,826 |
| 2006 | 1,644 |
| 2007 | 1,809 |
| 2008 | 1,714 |
| 2009 | 1,613 |
| 2010 | 1,561 |
| 2011 | 1,612 |
| 2012 | 1,578 |
| 2013 | 1,317 |
| 2014 | 1,321 |
| 2015 | 1,317 |
| 2016 | 1,344 |
| 2017 | 1,334 |
| 2018 | 1,354 |
| 2019 | 1,309 |
| 2020 | 1,141 |
| 2021 | 1,216 |
| 2022 | 1,272 |
| 2023 | 1,216 |
| 2024 | 1,137 |
| 2025 | 778 |
| 2026 | 359 |
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed' 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 WPR13LA093Accident · No injuriesLimited investigationFinal reportKaufmann Vans RV-10 · Las Vegas, NVA missing elevator control assembly attachment bolt, which rendered the elevator control system ineffective and resulted in a loss of pitch control, and the pilot’s incorrect installation of the elevator control assembly.NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA13CA100Accident · No injuriesData collectionFinal reportRaytheon A36 · Rutland, VTThe pilot's failure to maintain control of the airplane while maneuvering on a snow-packed surface after landing, which resulted in a collision with a fuel truck.NTSB CEN13LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mc Allen, TXA loss of engine power due to carburetor icing.NTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.NTSB CEN13LA119Accident · No injuriesLimited investigationFinal reportBell 407 · Big Lake, TXThe loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.NTSB CEN13CA117Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Chicago, ILThe presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.NTSB WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…NTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.NTSB ERA13CA098Accident · Minor injuriesData collectionFinal reportMckay Gene RV-9A · Brunswick, GAThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB DCA13CA035Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD-11F · Memphis, TNthe operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.NTSB CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.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 CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB WPR13FA074Accident · 1 fatalField investigationFinal reportCharland Vortex · Wellton, AZThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB CEN13LA115Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Corcoran, MNThe pilot’s improper decision to land the helicopter in a position that placed the tail rotor near tarps, which resulted in the tarps being lifted into the tail rotor, subsequent tail rotor damage, a loss of tail rotor authority, and an uncommanded tail rotor…NTSB CEN13TA113Accident · Minor injuriesFinal reportCessna 550 · Oklahoma City, OKThe flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…NTSB CEN13LA110Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Las Cruces, NMThe pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.NTSB CEN13CA112Accident · No injuriesData collectionFinal reportCessna 172M · Eveleth, MNThe student pilot’s improper landing flare, which resulted in a hard nosewheel landing.NTSB ERA13LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Indian Trail, NCThe flight instructor’s failure to maintain adequate glidepath and airspeed control during short final approach and the airplane’s improper touchdown point, which resulted in a runway overrun.NTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.NTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…NTSB WPR13FA072Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Payson, AZThe airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…NTSB ERA13LA094Accident · No injuriesLimited investigationFinal reportWragg George Skybolt · Sarasota, FLThe pilot's inadequate preflight planning and failure to monitor the fuel quantity during flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.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 CEN13LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Grand Isle, NEThe student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.NTSB WPR13FA312Accident · 1 fatalField investigationFinal reportMooney M20F · Yosemite Valley, CAThe pilot’s decision to continue flight into instrument meteorological conditions, which resulted in his failure to maintain situational awareness and sufficient altitude to clear mountainous terrain.NTSB ANC13CA018Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Skwentna, AKThe pilot's loss of control while landing in gusting wind conditions.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 WPR13FA070Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Ely, NVThe pilot’s failure to regain airplane control following a sudden rapid descent during cruise flight, which resulted in an exceedance of the design stress limits of the aircraft and led to an in-flight structural failure.NTSB WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB ERA13CA091Accident · No injuriesData collectionFinal reportPiper PA28R · Newport News, VAThe pilot’s failure to properly monitor the flight controls (toe brake pedals) during engine start.NTSB CEN13FA105Accident · 2 fatalField investigationFinal reportBeech E-90 · Amarillo, TXThe pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.NTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.NTSB ANC13FA017Accident · Serious injuriesField investigationFinal reportEurocopter AS350 B3 · Beluga, AKThe pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…NTSB WPR13LA069Accident · Serious injuriesLimited investigationFinal reportPowerchute Airwolf 912ULS · Dell, MTThe pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.NTSB CEN13IA107Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Williston, NDThe snowplow driver’s failure to ensure that the runway was clear before driving onto it, which resulted in a runway incursion with a departing airplane.NTSB ERA13LA087Accident · Minor injuriesLimited investigationFinal reportRotorway DB-1 · Mayland, TNThe pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.NTSB ERA13CA086Accident · Serious injuriesData collectionFinal reportCessna 172P · Murfreesboro, TNThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB CEN13FA100Accident · 2 fatalField investigationFinal reportAerovodochody L-29 Delfin · Combine, TXThe airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.NTSB ANC13LA016Accident · No injuriesLimited investigationFinal reportCessna 150C · Juneau, AKThe collapse of the left main landing gear during the landing roll, as a result of fatigue cracking. Contributing to the accident was the improper maintenance of the landing gear.NTSB WPR13CA067Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Rawlins, WYThe pilot's failure to maintain main rotor rpm during takeoff, which resulted in a hard landing and subsequent rollover.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 ERA13CA092Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Lynchburg, VAThe student pilot’s improper flare, which resulted in a hard landing.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13FA096Accident · 3 fatalField investigationFinal reportMBB BK 117 A-3 · Compton, ILThe inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.