NTSB investigations, 2015, OK
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
Latest 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\") = 2015
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") = 2015 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 CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.NTSB CEN15LA437Accident · Minor injuriesLimited investigationFinal reportCapella Aircraft Corporation ( FW2TDXLS · Bartlesville, OKThe pilot’s failure to maintain airplane control after takeoff.NTSB CEN15LA432Accident · 1 fatalLimited investigationFinal reportRans S18 · Shattuck, OKThe noncertificated pilot’s failure to maintain control of the unregistered airplane during initial climb and his subsequent exceedance of the airplane’s critical angle-of-attack, which resulted in a stall/spin.NTSB CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.NTSB CEN15FA316Accident · 2 fatalField investigationFinal reportBeech V35B · Colbert, OKThe pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…NTSB CEN15LA313Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Perry, OKThe pilot's incapacitation and subsequent loss of airplane control due to heat exhaustion.NTSB GAA15CA165Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Comanche, OKThe pilot's failure to maintain proper pitch control during touchdown, which resulted in a nose over and impact with terrain.NTSB CEN15LA258Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Haskell, OKThe loss of engine power for reasons that could not be determined because a postaccident engine examination and test run did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN15LA238Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Omega, OKImproper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.NTSB CEN15LA205Accident · Minor injuriesLimited investigationFinal reportPitts Model 12 · Burneyville, OKThe partial loss of engine power due to contamination of the fuel system.NTSB CEN15LA204Accident · Minor injuriesLimited investigationFinal reportGrumman G 164A · Maysville, OKThe loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA180Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Verdigris, OKThe fuel pump gear manufacturer’s allowance of set-up gears made from a nonconforming material to be put in the production inventory system, the installation of a nonconforming gear in the accident airplane’s production fuel pump, and the gear’s failure,…NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB CEN15CA166Accident · No injuriesData collectionFinal reportFunk B85C · Leonard, OKThe improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.NTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…NTSB CEN15CA121Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper landing technique which resulted in a hard landing and subsequent nose landing gear collapse.