NTSB investigations, 2022, 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\") = 2022
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") = 2022 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 CEN23FA060Accident · 3 fatalClass 3 · FieldFinal reportBeech F33A · Yukon, OKThe pilot’s loss of airplane control for reasons that could not be determined.NTSB CEN23FA050Accident · 2 fatalClass 3 · FieldFinal reportCessna 170 · Gage, OKThe non-certificated pilots’ loss of airplane control, resulting in an impact with terrain during final approach. Contributing to the accident was the airplane owner’s impairment due to his use of ethanol and depressant medications, in combination with his…NTSB CEN23LA055Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Guthrie, OKThe airplane’s collision with a deer on the runway during landing.NTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.NTSB CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.NTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB CEN22LA343Accident · No injuriesClass 3 · LimitedFinal reportBeech E33A · Zena, OKThe pilot’s inadequate preflight inspection and fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA321Accident · 2 fatalClass 3 · LimitedFinal reportJust Highlander · Bennington, OKThe pilot’s exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall and loss of control.NTSB CEN22LA315Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 650B · Eufaula, OKThe loss of engine power due to a push rod that was incorrectly installed by the airplane owner.NTSB CEN22LA303Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-140 · Oklahoma City, OKThe pilot’s failure to maintain adequate airspeed for unknown reasons during the initial climb, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB CEN22LA311Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOSport 2017 · Mead, OKA partial loss of engine power for reasons that could not be determined.NTSB CEN22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150E · Harrah, OKThe flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB CEN22LA296Accident · No injuriesClass 4 · LimitedFinal reportBaker Eugene L RV6-A · Goldsby, OKThe pilot’s failure to maintain directional control during landing resulting in a runway excursion.NTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB DCA22LA126Incident · No injuriesClass 3 · LimitedFinal reportBoeing 757-236 · Tulsa, OKThe flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…NTSB CEN22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Marshall, OKThe pilot’s failure to manage fuel, which resulted in a loss of engine power to both engines due to fuel starvation.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.NTSB CEN22LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Heavner, OKA total loss of engine power due to oil exhaustion which resulted from improper engine maintenance.