NTSB investigations, 2000, OK
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
| 1964 | 108 |
|---|---|
| 1965 | 105 |
| 1966 | 100 |
| 1967 | 134 |
| 1968 | 100 |
| 1969 | 99 |
| 1970 | 81 |
| 1971 | 102 |
| 1972 | 56 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 60 |
| 1976 | 66 |
| 1977 | 72 |
| 1978 | 63 |
| 1979 | 66 |
| 1980 | 64 |
| 1981 | 79 |
| 1982 | 63 |
| 1983 | 64 |
| 1984 | 65 |
| 1985 | 47 |
| 1986 | 42 |
| 1987 | 45 |
| 1988 | 38 |
| 1989 | 40 |
| 1990 | 29 |
| 1991 | 30 |
| 1992 | 36 |
| 1993 | 23 |
| 1994 | 32 |
| 1995 | 42 |
| 1996 | 35 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 36 |
| 2000 | 31 |
| 2001 | 24 |
| 2002 | 26 |
| 2003 | 22 |
| 2004 | 23 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 28 |
| 2008 | 25 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 19 |
| 2012 | 18 |
| 2013 | 23 |
| 2014 | 11 |
| 2015 | 17 |
| 2016 | 21 |
| 2017 | 20 |
| 2018 | 15 |
| 2019 | 15 |
| 2020 | 18 |
| 2021 | 17 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 19 |
| 2025 | 19 |
| 2026 | 13 |
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\") = 2000
AND c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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") = 2000 AND c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' 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 FTW01LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe certified flight instructor's (CFI) failure to maintain directional control of the airplane during landing. A contributing factor was the gusty wind condition.NTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…NTSB FTW01LA027Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Antlers, OKthe loss of engine power resulting from carburetor icing conditions.NTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…NTSB FTW01FA015Accident · 2 fatalField investigationFinal reportBeech BE-76 · Tulsa, OKthe instructor pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around, which resulted in his loss of control of the airplane. Contributory factors were the engine fire, the pilot's failure to follow the…NTSB FTW01FA013Accident · 1 fatalField investigationFinal reportCessna 210 · Oklahoma City, OKthe pilot's loss of control of the aircraft during initial/takeoff climb. Contributing factors were the night conditions, low ceilings, and the pilot's lack of flight experience in actual instrument meteorological conditions at night.NTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA255Accident · No injuriesLimited investigationFinal reportMooney M20 · Owasso, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA253Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Erick, OKthe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA251Accident · No injuriesLimited investigationFinal reportBeech BE58 · Bethany, OKthe fire, which ignited in the engine compartment for undetermined reasons while taxiing.NTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00FA236Accident · 1 fatalField investigationFinal reportCessna 150 · Collinsville, OKthe pilot's failure to maintain control of the aircraft while maneuvering after takeoff, which resulted in an inadvertent stall/spin and impact with terrain.NTSB FTW00LA224Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Tulsa, OKThe passenger's failure to comply with the briefing administered by the pilot. Factors were the passenger's physical impairment due to an injury sustained during the initial ground impact and the high wind condition.NTSB FTW00LA226Accident · No injuriesLimited investigationFinal reportCessna 182M · Shawnee, OKThe pilot's failure to maintain control of the airplane during the landing flare/touchdown. A factor was the gusty wind condition.NTSB FTW00LA222Accident · Serious injuriesLimited investigationFinal reportRomero SEA REY · Tulsa, OKThe loss of control by the pilot due to incapacitation for unknown reasons.NTSB FTW00LA221Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kingfisher, OKThe pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.NTSB FTW00LA197Accident · No injuriesLimited investigationFinal reportBushby Midget Mustang · Tulsa, OKThe in-flight separation of the propeller spinner. A factor was the lack of suitable terrain for the precautionary landing.NTSB FTW00LA194Accident · No injuriesLimited investigationFinal reportMooney M20R · Talihina, OKthe partial loss of engine power on takeoff, which resulted from incorrect adjustment of the fuel injector system by maintenance personnel.NTSB FTW00LA263Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKThe pilot's improper setting of the cockpit fuel selector, which resulted in a total loss of engine power and forced landing.NTSB FTW00LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA158Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sand Springs, OKThe pilot's failure to maintain directional control during the takeoff. A factor was the fence struck by the aircraft.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB FTW00LA134Accident · No injuriesLimited investigationFinal reportCessna 140 · Tulsa, OKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the runway sign struck by the aircraft.NTSB FTW00LA133Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Claremore, OKThe pilot's premature raising of the flaps.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB FTW00LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Maud, OKthe loss of engine power while maneuvering as a result of the separation of the exhaust rocker arm retaining stud due to fatigue, which resulted in a precautionary landing.NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.NTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.