NTSB investigations, 2004
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
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\") = 2004 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") = 2004 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 WAS05WA005Accident · Minor injuriesForeign investigationRobinson Helicopters R44 · Vlakfontein Far, South AfricaNTSB NYC05LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lawrenceburg, KYThe pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.NTSB LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.NTSB SEA05LA032Accident · No injuriesLimited investigationFinal reportAerostar 601 · Hamilton, MTA partial loss of engine power due to the lack of lubrication and subsequent failure of the left engine's right turbocharger for undetermined reasons, and subsequent forced landing after takeoff. A factor was the unsuitable terrain for the forced landing.NTSB NYC05LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Smoketown, PAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.NTSB NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.NTSB LAX05FA056Accident · 1 fatalField investigationFinal reportEurocopter France AS350BA · Panamint Spring, CAThe pilot's misjudged lateral distance from a mountainside and failure to maintain an adequate clearance from terrain and obstacles while performing a low altitude filming maneuver.NTSB IAD05CA027Accident · Minor injuriesData collectionFinal reportEnstrom 280C · Pedricktown, NJThe pilot's failure to maintain control of the helicopter during the takeoff and his failure to flare during the autorotation.NTSB NYC05CA037Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Johnstown, NYThe pilot's inadequate in-flight planning/decision which resulted in airframe ice with subsequent degradation of aircraft performance, and inadequate airspeed during the landing flare.NTSB DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.NTSB DFW05LA047Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Austin, TXThe failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.NTSB DFW05IA048Incident · No injuriesIncident investigationFinal reportBeech A36 · Natchitoches, LAThe loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.NTSB DFW05CA046Accident · No injuriesData collectionFinal reportCessna 172P · Houston, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the muddy condition of the terrain.NTSB DEN05FA045Accident · 1 fatalField investigationFinal reportPiper PA-31P · Gallup, NMthe pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.NTSB ATL05CA036Accident · No injuriesData collectionFinal reportChampion 7-GCAA · Talladega, ALThe binding right wheel brake that resulted in a loss of control during landing roll. A factor was the drainage ditch.NTSB ANC05IA020Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Anchorage, AKThe failure of a high-pressure fuel line fitting, which resulted in an engine fire during takeoff/initial climb.NTSB SEA05WA031Accident · 1 fatalForeign investigationRobinson R-44 II · Fairmont Hot Sp, CanadaNTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.NTSB CHI05FA049Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Ironwood, MIFatigue fracture of an engine cylinder resulting in a loss of power on the left engine. Additional causes were the pilot's failure to maintain minimum control airspeed (Vmc), the resulting loss of aircraft control, and an inadvertent stall/spin. Contributing…NTSB SEA05LA047Accident · No injuriesLimited investigationFinal reportCessna 182K · Olympia, WAThe pilot's improper flare. Factors include too high of an airspeed and an inadvertent porpoise.NTSB LAX05CA055Accident · No injuriesData collectionFinal reportTop Dog Trike · Torrey Pines, CAthe pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.NTSB IAD05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150C · East Moriches, NYSeveral mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.NTSB CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…NTSB SEA05CA030Accident · No injuriesData collectionFinal reportFairchild 24W-41A · Wenatchee, WAThe pilot's failure to maintain directional control during the landing roll. A frozen brake was a factor.NTSB NYC05WA032Accident · 3 fatalForeign investigationBeech 65-90 · Montpellier, FranceNTSB LAX05WA072Accident · 3 fatalForeign investigationRobinson R44 · Saga, JapanNTSB ANC05CA019Accident · No injuriesData collectionFinal reportCessna U206G · Illiamna, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted in a loss of control, and the airplane nosing over. A factor contributing to the accident was the gusty wind condition.NTSB LAX05LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Waialua, HIthe pilot misjudged distance and altitude and failed to attain the proper landing touchdown point.NTSB LAX05LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Phoenix, AZthe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control during landing.NTSB DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.NTSB SEA05CA029Accident · No injuriesData collectionFinal reportBeech 58TC · Everett, WAThe pilot's misjudgment of distance/speed on landing touchdown and rollout, and his subsequent excessive braking. A factor was the fence.NTSB NYC05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hartford, CTThe pilot's failure to maintain adequate clearance from trees during the approach to the runway. A factor related to the accident was the nighttime conditions.NTSB NYC05CA031Accident · No injuriesData collectionFinal reportFlight Design CT-2K · Waynesboro, VAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB DFW05LA045Accident · No injuriesLimited investigationFinal reportCessna 421C · Henderson, TXThe failure of the nose landing gear trunnion lug. A contributing factor was the non-compliance of the service bulletin by maintenance personnel.NTSB SEA05TA028Accident · Serious injuriesFinal reportChristen Industries A-1 · Terreton, IDThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.NTSB NYC05LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Providence, RIThe vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.NTSB CHI05LA047Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cedar Rapids, IAThe pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.NTSB LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.NTSB IAD05CA025Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Wheeling, WVThe pilot misjudged his distance/speed, and his intentional landing on an unsuitable taxiway at night. A factor in the accident was the night light conditions.NTSB DFW05LA041Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Texas City, TXThe pilot's failure to maintain clearance with terrain while performing aerobatics at a low altitude.NTSB DEN05LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 · Park City, UTthe student pilot's failure to maintain aircraft control, and the instructor's inadequate supervision by her failure to assure adequate rotor rpm was maintained.NTSB DEN05LA039Accident · No injuriesLimited investigationFinal reportRaytheon C90A · Salt Lake City, UTthe pilot's failure to obtain/maintain a proper climb rate and the pilot's premature initiation of the turn (low altitude flight maneuver). Contributing factors include the pilot's improper in-flight planning and decision making, the low altitude, the fog,…NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB SEA05CA027Accident · Minor injuriesData collectionFinal reportBreit Zodiac (CH-601-HDS) · Everett, WAThe pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.NTSB NYC05CA035Accident · Minor injuriesData collectionFinal reportRaytheon Corporate Jets 400A · Cleveland, OHThe loss of directional control by the operator of a ground service vehicle.NTSB DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.NTSB MIA05LA043Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakeland, FLThe faulure of the pilot to maintain directional control of the aircraft during the landing roll resulting in the on-ground collision with a taxiway sign and subsequent collapse of the nose landing gear.NTSB LAX05LA083Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH-2000 · Jean, NVan in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…NTSB DFW05LA043Accident · 1 fatalLimited investigationFinal reportAkers Douglas RA40 Defiant · Slaton, TXThe pilot's failure to maintain aircraft control. Contributing factors were the opening of the canopy in-flight and the pilot's diverted attention.