NTSB investigations, 1992, KS
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
| 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\") = 1992
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") = 1992 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 CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB CHI93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Ft. Riley, KSThe non-current student pilot's failure to maintain adequate clearance from terrain while operating at night, in instrument meteorological conditions.NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.NTSB CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.NTSB CHI92LA289Accident · No injuriesLimited investigationFinal reportLearjet LR-60 · Hutchinson, KSInadequate flight test methods by the manufacturer and the FAA which did not permit safe operating clearances.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB CHI92FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Ness City, KSThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB CHI92DCQ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Scott City, KSThe failure of the pilot in command to maintain sufficent airspeed for flight resulting in an inadvertent stall.NTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.NTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.NTSB CHI92DCQ04Accident · Minor injuriesFinal reportWSK PZL Mielec M18 · Norton, KSFailure of the pilot in command to level off while performing aerial application.NTSB CHI92DCQ03Accident · No injuriesFinal reportCessna A188B · Meade, KSThe pilot's improper preflight planning/preparation and his exceeding the aircraft's takeoff capability.NTSB CHI92LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Wichita, KSA loss of directional control and remedial action not performed by the pilot. Factors related to this accident were a swerve encountered by the pilot and the pilot's lack of overall experience.NTSB CHI92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Catherine, KSThe pilot's inadequate preflight planning. Factors associated with this accident were unsuitable terrain selected by the pilot and airplane clearance over the fence not attained by the pilot.NTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB CHI92LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSThe student pilot's improper recovery from a bounced landing, and the instructor's inadequate remedial action(s).NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.NTSB CHI92DCQ01Accident · No injuriesFinal reportGeorge Adrian Rands/ Coyote · Agusta, KSFailure of the pilot to maintain a proper descent rate, and an airspeed above stalling speed during a VFR final approach.NTSB CHI92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hanover, KSThe pilot's failure to abort the takeoff earlier in the takeoff roll, and the inadvertent stall/mush after lift-off. A factor was the soft terrain.NTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.