NTSB investigations, 2006
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\") = 2006 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") = 2006 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 NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.NTSB NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB LAX07LA067Accident · 1 fatalLimited investigationFinal reportCessna 150J · San Diego, CAThe pilot's improper use of the throttle and failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB DFW07CA048Accident · No injuriesData collectionFinal reportCessna 172S · Spicewood, TXThe pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.NTSB DFW07CA047Accident · No injuriesData collectionFinal reportPiper PA 32R 301T · Crystal Beach, TXThe pilot's touchdown too far down the runway resulting in an overrun. Factors were the wet grass runway and the trailer.NTSB DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…NTSB DCA07WA021Incident · No injuriesForeign investigationBoeing B757-200 · Athens, GreeceNTSB CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.NTSB ANC07LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Albany, GAThe loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.NTSB WAS07WA006Accident · Minor injuriesForeign investigationde Havilland DHC-5 · Nairobi, KenyaNTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.NTSB ENG07WA010Incident · No injuriesForeign investigationBoeing 767-300ER(F) · Auckland, New ZealandNTSB DFW07WA054Accident · 2 fatalForeign investigationSabreliner NA-265T39 · Culiacan, MexicoNTSB DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.NTSB ANC07CA010Accident · Minor injuriesData collectionFinal reportBeech BE-23 · Asheville, NCThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in a forced landing and collision with trees. Factors associated with the accident were fog and low ceilings.NTSB SEA07LA039Accident · Serious injuriesLimited investigationFinal reportAveryt Vans RV-4 · Grants Pass, ORThe pilot's failure to maintain adequate airspeed during performance of a go-around, resulting in an inadvertent stall and subsequent in flight collision with the ground. A contributing factor was the in-flight loss of a portion of one propeller blade.NTSB DEN07WA041Accident · 1 fatalForeign investigationPiper PA-28-161 · Cantal Region, FranceNTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.NTSB DCA07WA018Incident · No injuriesForeign investigationBoeing 737-400 · Medan, IndonesiaNTSB CHI07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-260B · Belleville, ILThe failure of the torque link bolt which resulted in the right main landing gear strut scissors separating and becoming jammed in the wheel well. Contributing to the accident was the seized torque link bolt due to surface corrosion.NTSB LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.NTSB LAX07LA064Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · San Diego, CAFailure of the captain of the other taxiing airplane to maintain clearance from an occupied airplane stopped on the ramp.NTSB LAX07CA066Accident · Minor injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.NTSB DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.NTSB DFW07CA046Accident · No injuriesData collectionFinal reportCessna 172M · Houston, TXThe pilot's failure to compensate for the existing wind conditions during the landing roll resulting in a loss of control. A contributing factor was the crosswind.NTSB DFW07CA045Accident · No injuriesData collectionFinal reportErcoupe 415-C · Lakeshore, MSThe landing overrun for unknown reasons. A factor was the ditch.NTSB DFW07CA044Accident · No injuriesData collectionFinal reportCessna 150M · Eastland, TXThe partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.NTSB CHI07FA048Accident · 2 fatalField investigationFinal reportMooney M-20F · Mt. Gilead, OHBoth the pilot-in-command/aircraft owner and the flight instructor failed to recover from the stall and the flight instructor's inadequate supervision of the flight. Contributing to the accident was the failure to maintain stall speed which resulted in the…NTSB CHI07CA047Accident · Minor injuriesData collectionFinal reportCessna T210L · North St. Louis, MOFuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.NTSB NYC07FA051Accident · 2 fatalField investigationFinal reportCessna 414 · Johnstown, PAThe pilot's improper decision to abort the landing with a damaged airplane. Contributing to the accident were the damage from the airplane's impact with the runway, the pilot's failure to lower the landing gear prior to the landing attempt, and the in-flight…NTSB MIA07IA031Incident · No injuriesIncident investigationFinal reportBoeing 747-436 · Miami, FLThe flightcrew's misinterpretation of available lighting, signage, and airfield marking cues during taxi.NTSB CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…NTSB DEN07CA039Accident · No injuriesData collectionFinal reportCessna T210M · Broomfield, COthe failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB DEN07CA043Accident · No injuriesData collectionFinal reportCessna 172N · Cottonwood Fall, KSthe pilot's failure to maintain clearance from the fence. Contributing to the accident was the pilot's inability to properly identify the runway environment, and the improper in-flight decision to initiate a go-around.NTSB DCA07WA017Accident · No injuriesForeign investigationBoeing B737-400 · Makassar, IndonesiaNTSB ANC07LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-228F · Anchorage, AKThe failure of the deicing truck crew to maintain sufficient distance from the parked airplane during deicing, which resulted in a collision and substantial damage to the airplane.NTSB LAX07CA063Accident · No injuriesData collectionFinal reportBelcher Helicycle · Boulder City, NVa loss of engine power due to a fractured fuel line.NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB CHI07CA049Accident · No injuriesData collectionFinal reportBeech 99 · Mosinee, WIThe pilot encountering the unsuitable terrain during the landing. Factors were the dark night and the snowbank.NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB MIA07FA029Accident · 5 fatalField investigationFinal reportCessna 421B · Greenhead, FLThe pilot-in-command's improper planning/decision and continued flight into known adverse weather which resulted in an encounter with a level 5 thunderstorm.NTSB LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.NTSB ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB SEA07LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fresno, CAThe design stress limits of the airframe were exceeded by an unknown pilot.NTSB SEA07LA037Accident · Minor injuriesLimited investigationFinal reportCavalier F51D Mustang · Rexburg, IDThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB MIA07LA032Accident · Minor injuriesLimited investigationFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe airplane manufacturer's inadequate maintenance prior to final aircraft delivery, which resulted in fuel filter blockage and engine fuel starvation.