NTSB investigations, 2024, KS
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
| 1963 | 2 |
|---|---|
| 1964 | 134 |
| 1965 | 112 |
| 1966 | 134 |
| 1967 | 136 |
| 1968 | 109 |
| 1969 | 106 |
| 1970 | 92 |
| 1971 | 91 |
| 1972 | 81 |
| 1973 | 65 |
| 1974 | 84 |
| 1975 | 84 |
| 1976 | 91 |
| 1977 | 85 |
| 1978 | 67 |
| 1979 | 83 |
| 1980 | 60 |
| 1981 | 71 |
| 1982 | 59 |
| 1983 | 63 |
| 1984 | 49 |
| 1985 | 55 |
| 1986 | 52 |
| 1987 | 35 |
| 1988 | 36 |
| 1989 | 16 |
| 1990 | 35 |
| 1991 | 28 |
| 1992 | 23 |
| 1993 | 25 |
| 1994 | 32 |
| 1995 | 33 |
| 1996 | 30 |
| 1997 | 30 |
| 1998 | 22 |
| 1999 | 32 |
| 2000 | 20 |
| 2001 | 14 |
| 2002 | 19 |
| 2003 | 20 |
| 2004 | 25 |
| 2005 | 18 |
| 2006 | 19 |
| 2007 | 24 |
| 2008 | 27 |
| 2009 | 19 |
| 2010 | 18 |
| 2011 | 15 |
| 2012 | 22 |
| 2013 | 24 |
| 2014 | 15 |
| 2015 | 24 |
| 2016 | 20 |
| 2017 | 18 |
| 2018 | 17 |
| 2019 | 19 |
| 2020 | 11 |
| 2021 | 15 |
| 2022 | 15 |
| 2023 | 21 |
| 2024 | 13 |
| 2025 | 9 |
| 2026 | 11 |
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\" = 'KS' 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" = 'KS' 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 CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB CEN25LA028Accident · 1 fatalClass 3 · LimitedPreliminary reportCessna 182Q · Rose Hill, KSOn October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title…NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB CEN24LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Lawrence, KSThe pilot’s failure to maintain directional control during takeoff.NTSB CEN24LA262Accident · No injuriesClass 4 · LimitedFinal reportSkystar Kitfox · Hackney, KSThe pilot’s failure to maintain directional control during the landing roll in a gusting wind condition.NTSB CEN24FA248Accident · 1 fatalClass 3 · FieldFinal reportRotorway Scorpion 133 · Andale, KSThe pilot’s abrupt control inputs, which resulted in a low-G condition, main rotor mast bumping, and subsequent severing of the tailboom by the main rotor blades.NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.NTSB CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.NTSB CEN24LA166Accident · No injuriesClass 4 · LimitedFinal reportRans S-6ES · Emporia, KSThe pilot’s failure to maintain control during the landing flare.NTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.