NTSB investigations, 2007
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\") = 2007 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") = 2007 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 SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.NTSB CHI08WA075Accident · No injuriesForeign investigationCessna T303 · Guernsey, United KingdomNTSB NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.NTSB LAX08FA043Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Paso Robles, CAThe pilot's encounter with isolated moderate (or greater) turbulence, updrafts, and downdrafts associated with localized mountain wave conditions at low altitude, and, his failure to maintain adequate airspeed during the encounter that resulted in an…NTSB CHI08CA057Accident · No injuriesData collectionFinal reportLerohl RV-8 · Alexandria, MNThe loss of engine power for undetermined reasons.NTSB LAX08WA045Accident · 1 fatalForeign investigationRobinson R-44 · Westgate Bridge, AustraliaNTSB DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…NTSB DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB CHI08CA058Accident · No injuriesData collectionFinal reportCessna 172F · Crystal Falls, MIThe rough, unsuitable terrain encountered during the landing which resulted in the total failure of the nose landing gear.NTSB CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.NTSB SEA08LA054Accident · Serious injuriesLimited investigationFinal reportHein Sonex · Murrieta, CAThe loss of engine power due to fuel exhaustion. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DFW08CA051Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot's failure to maintain aircraft control. A contributing factor was prevailing crosswind.NTSB OPS08IA004Incident · No injuriesIncident investigationFinal reportGulfstream American G5 · Teterboro, NJThe probable cause of this incident was the TEB tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll.NTSB CHI08FA055Accident · 1 fatalField investigationFinal reportCessna 310R · Traverse City, MIThe pilot's failure to maintain a proper glidepath during the instrument approach, which led to his loss of control and subsequent impact with trees and terrain.NTSB SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB NYC08LA070Accident · No injuriesLimited investigationFinal reportCessna 182R · Pittstown, NJA loss of engine power for undetermined reasons.NTSB MIA08WA058Accident · Minor injuriesClass 5 · ForeignCessna T210L · Ocumare del Tuy, VenezuelaOn December 26, 2007, about 1245 Atlantic standard time, a Cessna 210, N761YL, impacted with the ground during the approach to the Metropoltano Airport, Ocumare Del Tuy, Venezuela. Visual meteorological conditions prevailed and no flight plan information is…NTSB MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB MIA08CA045Accident · No injuriesData collectionFinal reportCessna 172P · Northampton, MAThe student pilot's failure to maintain directional control of the airplane during the takeoff roll and inadequate supervision by the CFI.NTSB DEN08IA044Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Aspen, COThe failure of the crankshaft due to fatigue. The fatigue crack initiation was not determined.NTSB ANC08LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Pole, AKA loss of engine power for an undetermined reason during an attempted go-around, resulting in a forced landing and a collision with snow-covered terrain. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB SEA08LA051Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A330-323 · Honolulu, HIThe failure of the two flight attendants in the aft galley to understand the lead flight attendant's instructions, which resulted in them not being seated when the flight encountered convectively induced severe turbulence. Contributing to the accident was the…NTSB SEA08LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-83 · Ontario, CAThe lack of turbulence forecasts available to the flight crew, which resulted in the flight attendants not being seated when the flight encountered severe terrain-induced turbulence. Contributing to the accident were the terrain-induced turbulence, the…NTSB NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB CHI08CA059Accident · Serious injuriesData collectionFinal reportInfinity Commander · Hot Springs Vlg, ARThe pilot not maintaining clearance/altitude from the trees during takeoff initial climb. Factors were the trees and reported turbulent winds.NTSB SEA08CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Truckee, CAThe loss of partial engine power during cruise for undetermined reasons. A contributing factor was the snow covered terrain.NTSB DFW08WA050Accident · 3 fatalForeign investigationCessna 172 · Boquete, PanamaNTSB DEN08CA043Accident · No injuriesData collectionFinal reportChampion 7GCAA · Gallup, NMThe pilot's premature landing flare and an inadvertent stall/mush. A contributing factor is pilot's lack of recent night experience.NTSB ANC08LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's selection of unsuitable terrain for taxi. Contributing to the accident were rough and uneven terrain, and an excessive taxispeed.NTSB SEA08CA055Accident · No injuriesData collectionFinal reportBrooks Exec 162F · Santa Maria, CAThe pilot's failure to maintain control of the helicopter during hover. Contributing to the accident was the pilot's lack of experience in rotorcraft.NTSB NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.NTSB NYC08CA067Accident · No injuriesData collectionFinal reportMooney M20F · Carrollton, GAThe pilot's descent below the glidepath during the approach, which resulted in a collision with terrain. Contributing factors included the pilot's diverted attention, pilot fatigue, and the night lighting conditions.NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB LAX08CA041Accident · Minor injuriesData collectionFinal reportFound Acft FBA-2C2 · Holbrook, AZThe pilot's failure to maintain directional control during landing rollout, which resulted in an inadvertent ground loop.NTSB DFW08CA049Accident · No injuriesData collectionFinal reportCessna 182 · Austin, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the gusting winds.NTSB DEN08RA050Accident · No injuriesClass 5 · ForeignPartenavia AP 68 TP · Pointe-A-Pitre, GuadeloupeOn December 22, 2007, at 1815 coordinated universal time, a Partenavia AP 68 TP, U.S. registered N901TP, owned by Air Coulibri Inc., and piloted by the accident pilot, was substantially damaged when it experienced an uncontained engine failure during the…NTSB LAX08CA040Accident · No injuriesData collectionFinal reportEldredge Aircamper SDE · Sahuarita, AZThe pilot's failure to maintain adequate airspeed. A contributing factor was the pilot's distraction due to the presence of an automobile, which appeared to encroach upon the runway environment.NTSB DFW08LA134Accident · 2 fatalLimited investigationFinal reportCessna 310 · Glenwood, NMA loss of control for undetermined reasons. Contributing to the accident was the marginal weather conditions in the area at the time of the accident.NTSB DFW08CA048Accident · Minor injuriesData collectionFinal reportPortman RV-7A · ELmendorf, TXThe failure of the nose landing gear. A contributing factor was the mound/uneven runway surface.NTSB DFW08CA047Accident · No injuriesData collectionFinal reportCessna 210 · Medford, OKThe pilot's decision to attempt a night landing without runway lighting. A contributing factor was inoperative runway lights.NTSB DEN08CA046Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Pueblo, COthe pilot's failure to maintain aircraft control resulting in a hard landing.NTSB CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.NTSB NYC08CA066Accident · No injuriesData collectionFinal reportPiper PA28-180 · Blue Bell, PAThe student pilot's failure to maintain directional control while landing.NTSB MIA08WA033Accident · No injuriesClass 5 · ForeignCessna 208B · Chub Cay, BahamasOn December 20, 2007, about 1630 Atlantic standard time, a Cessna 208B, N954PA, registered to and operated by Agape Flights, Inc., was ditched in the Atlantic Ocean approximately 30 nautical miles west-northwest of Chub Cay, Bahamas. The commercial-rated…NTSB DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB CHI08FA053Accident · 3 fatalField investigationFinal reportBeech V35B · Springfield, ILThe loss of control during an instrument approach due to spatial disorientation.NTSB ANC08TA028Accident · Minor injuriesFinal reportDouglas DC-3T · McMurdo Station, AYThe captain's decision to lift off before attaining a proper airspeed, resulting in a loss of control during takeoff.NTSB NYC08WA065Accident · 1 fatalForeign investigationCirrus SR22 · Gurupi, BrazilNTSB MIA08CA046Accident · No injuriesData collectionFinal reportCessna Citation 510 · Pittsburgh, PAThe flight crew's inadequate preflight, which failed to detect the blockage of the left wing's fuel vent port.