NTSB investigations, 2023, 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\") = 2023
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") = 2023 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 CEN24LA060Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Anthony, KSA failure of the airplane’s alternator, which resulted in a loss of electrical power, and the pilot’s failure to use the emergency gear extension procedure during the initial landing approach, which led to a gear-up landing.NTSB CEN24LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Iola, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA031Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Manhattan, KSThe pilot’s improper modification of the engine cooling system that resulted in an engine overheat and total loss of power. Contributing to the accident was the pilot’s decision to continue the flight after the engine overheat light illuminated instead of…NTSB CEN24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Wichita, KSThe 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 CEN24LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Olathe, KSThe pilot’s mismanagement of the available fuel which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA425Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Herington, KSThe design of the spray valve control lever, which restricted the range of the left rear rudder and brake pedal and resulted in a loss of control during landing.NTSB CEN23LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210B · Wichita, KSLoss of engine power for reasons that could not be determined.NTSB CEN23LA366Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Derby, KSThe pilot’s loss of directional control during takeoff roll due the passenger’s interference with the rudder pedals, which resulted in a runway excursion.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.NTSB CEN23LA344Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Oberlin, KSThe blockage of the left fuel tank vent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident of the pilot’s failure to use his checklist to address the loss of engine power.NTSB CEN23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Gardner, KSA loss of engine power due to lead fouling of a spark plug.NTSB CEN23LA308Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Atchison, KSThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.NTSB CEN23LA279Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Chapman, KSThe pilot’s failure to maintain clearance from the power line during an agricultural application pass.NTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.NTSB CEN23LA237Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Pratt, KSFuel exhaustion due to the pilot’s inadequate preflight planning.NTSB CEN23LA222Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2S · Garden Plain, KSThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB CEN23LA198Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Wichita, KSThe pilot’s failure to maintain a safe taxi distance from a turbine-powered airplane, resulting in an encounter of the turbine-powered airplane’s jet blast while taxiing.NTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.