NTSB investigations, 2024, OK
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 14 |
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\") = 2024
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") = 2024 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 CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.NTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN24LA317Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Guthrie, OKA loss of engine power due to the separation and ingestion of an air filter retaining bracket into the engine cylinder.NTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…NTSB CEN24LA308Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Tulsa, OKThe mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.NTSB ENG24LA028Incident · No injuriesClass 3 · LimitedFinal reportBell 407 · Oktaha, OKThe loss of engine power due to high cycle fatigue failure of a power turbine stage 3 turbine wheel blade. The resulting engine imbalance caused a decoupling of the gas producer stage 1 and stage 2 turbine wheels leading to a stage 1 turbine overspeed and…NTSB CEN24LA258Accident · Minor injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · Stillwater, OKThe pilot’s failure to properly configure the landing gear before performing a water landing.NTSB CEN24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Ada, OKThe student pilot’s failure to maintain directional control during landing resulting in a runway excursion and impact with a sign.NTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.NTSB CEN24FA148Accident · 3 fatalClass 3 · FieldFinal reportDavis DA-3 · Antlers, OKImpact with terrain for reasons that could not be determined.NTSB CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB CEN24LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Cherokee, OKA partial loss of engine power for reasons that could not be determined. Contributing to the accident was the presence of ground fog, which hindered the landing approach and resulted in the pilot inadvertently landing long and impacting a fence during the…NTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.NTSB CEN24LA091Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24 · Hugo, OKThe binding of a main landing gear push-pull cable, which rendered the landing gear inoperative in a partially retracted position. Contributing to the accident was the pilot’s delay in executing a landing, which led to a total loss of engine power due to fuel…