NTSB investigations, 2007, OK
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2007
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") = 2007 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 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 DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.NTSB DFW08FA038Accident · 2 fatalField investigationFinal reportCessna T210M · Tulsa, OKThe pilot's failure to maintain clearance from the power transmission line(s). Contributing to the accident were the loss of aircraft electrical power, diverted attention, and the night conditions.NTSB DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB DFW08CA028Accident · No injuriesData collectionFinal reportCessna 152 · Ardmore, OKThe pilot's improper landing flare which resulted in a hard landing.NTSB DFW08CA021Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's improper recovery from a bounced landing.NTSB DFW08FA015Accident · 5 fatalField investigationFinal reportBeech A36 · Glenpool, OKThe pilot's failure to maintain control of the airplane after departure, which resulted in a collision with power lines. A factor was the high winds.NTSB DFW07CA192Accident · No injuriesData collectionFinal reportBoeing 1942 · Edmond, OKThe pilot's failure to maintain directional control during takeoff resuting in a nose over. A contributing factor was the soft terrain.NTSB DFW07CA194Accident · Minor injuriesData collectionFinal reportNicely Kitfox Model 5 · Guthrie, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable landing terrain for the forced landing.NTSB DFW07CA196Accident · No injuriesData collectionFinal reportInterplane Skyboy · Atoka, OKThe pilot's improper landing flare, resulting in a hard landing.NTSB DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB DFW07LA167Accident · No injuriesLimited investigationFinal reportRotorway 162F · Stratford, OKThe loss of engine power due to a seized supercharger. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA162Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315 · Stuart, OKThe loss of engine power due to a clogged fuel tube. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA164Accident · Serious injuriesLimited investigationFinal reportBoeing B737-800 · McAlester, OKAn in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.NTSB DFW07CA143Accident · Minor injuriesData collectionFinal reportBell BH206B-3 · Sand Springs, OKThe pilot's failure to maintain clearance with ground obstacles, which resulted in a blade strike. A contributing factor was the low altitude selected by the pilot.NTSB DFW07CA131Accident · No injuriesData collectionFinal reportGrumman G-164A · Okarche, OKThe pilot's failure to maintain clearance from an unmarked light fixture.NTSB DFW07CA129Accident · No injuriesData collectionFinal reportGrumman G-164A · Sayre, OKThe partial loss of engine power on takeoff-initial climb for an undetermined reason. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB SEA07CA105Accident · No injuriesData collectionFinal reportCessna 150E · Shawnee, OKThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.NTSB DFW07CA092Accident · Minor injuriesData collectionFinal reportCessna 182E · Marietta, OKThe airplane noseover due to the pilot's failure to obtain current NOTAM information on the closed airport. A contributing factor was the unsuitable terrain.NTSB DFW07FA084Accident · 1 fatalField investigationFinal reportBeech 58P · Marietta, OKThe pilot's improper landing flare. A contributing factor was the premature touchdown in an area of rising terrain.NTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DFW07LA080Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Ponca City, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB DFW07CA058Accident · No injuriesData collectionFinal reportCessna 152 · McAlester, OKThe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose landing gear.NTSB DFW07LA052Accident · No injuriesLimited investigationFinal reportFairchild Merlin SA-226-T · Tulsa, OKThe loss of control as result of the malfunction of the nose wheel steering mechanism during landing for undetermined reasons.