NTSB investigations, 2012, KS
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2012
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") = 2012 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 CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.NTSB CEN12CA624Accident · No injuriesData collectionFinal reportCessna 172R · Salina, KSThe flight instructor's improper flare in gusty wind conditions, which resulted in a hard landing.NTSB CEN12LA558Accident · No injuriesLimited investigationFinal reportBeech A36 · Ruleton, KSThe improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.NTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.NTSB CEN12LA551Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Holton, KSThe mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.NTSB CEN12FA521Accident · No injuriesField investigationFinal reportAyres S2R-T34 · Lakin, KSThe pilot's failure to maintain clearance from the corn during an aerial application flight.NTSB CEN12LA514Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Holcomb, KSThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power shortly after takeoff.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB CEN12LA549Accident · No injuriesLimited investigationFinal reportCessna 182D · Rose Hill, KSThe inadvertent deployment of a skydiver's parachute, which struck the right horizontal stabilizer.NTSB CEN12LA471Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Augusta, KSThe loss of brake effectiveness on landing roll for reasons that could not be determined because a postaccident brake system examination did not reveal any anomalies, which resulted in a runway excursion.NTSB CEN12LA373Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Gardner, KSThe pilot's delay in aborting the takeoff when the airplane was not accelerating as expected. Contributing to the accident was a wind shift during takeoff.NTSB CEN12CA342Accident · No injuriesData collectionFinal reportCessna 172S · Fort Scott, KSThe student pilot’s loss of directional control during the landing roll. Contributing to the accident was the student pilot’s diverted attention to retract the flaps.NTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.NTSB CEN12LA304Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · El Dorado, KSThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN12FA290Accident · 4 fatalField investigationFinal reportCessna 401 · Chanute, KSThe malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…NTSB CEN12LA288Accident · No injuriesLimited investigationFinal reportDonald K Stovall Pietenpol Aircamper · Rose Hill, KSThe loss of engine power due to carburetor icing.NTSB CEN12LA267Accident · Minor injuriesLimited investigationFinal reportBell 206B · Valley Falls, KSThe pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB CEN12CA219Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Emporia, KSThe pilot's loss of directional control while landing, which resulted in a ground loop and impact with a fence.NTSB ENG12IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hays, KSA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN12LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · El Dorado, KSThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.