NTSB investigations, 1989, MO
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 118 |
| 1965 | 136 |
| 1966 | 155 |
| 1967 | 173 |
| 1968 | 100 |
| 1969 | 83 |
| 1970 | 111 |
| 1971 | 112 |
| 1972 | 80 |
| 1973 | 80 |
| 1974 | 80 |
| 1975 | 98 |
| 1976 | 101 |
| 1977 | 96 |
| 1978 | 111 |
| 1979 | 100 |
| 1980 | 85 |
| 1981 | 95 |
| 1982 | 86 |
| 1983 | 84 |
| 1984 | 74 |
| 1985 | 72 |
| 1986 | 54 |
| 1987 | 59 |
| 1988 | 67 |
| 1989 | 47 |
| 1990 | 41 |
| 1991 | 37 |
| 1992 | 40 |
| 1993 | 58 |
| 1994 | 47 |
| 1995 | 39 |
| 1996 | 28 |
| 1997 | 33 |
| 1998 | 29 |
| 1999 | 43 |
| 2000 | 31 |
| 2001 | 33 |
| 2002 | 30 |
| 2003 | 30 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 27 |
| 2007 | 31 |
| 2008 | 31 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 32 |
| 2012 | 33 |
| 2013 | 21 |
| 2014 | 19 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 28 |
| 2018 | 22 |
| 2019 | 20 |
| 2020 | 24 |
| 2021 | 15 |
| 2022 | 19 |
| 2023 | 25 |
| 2024 | 22 |
| 2025 | 19 |
| 2026 | 21 |
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\") = 1989
AND c.\"eventStateOrRegion\" = 'MO' 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") = 1989 AND c."eventStateOrRegion" = 'MO' 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 MKC90LA039Accident · No injuriesLimited investigationFinal reportBeech 80 · Cape Girardeau, MOAn inoperative landing gear extension system due to failure of an electric motor and a misplaced emergency crank handle.NTSB MKC90LA037Accident · No injuriesLimited investigationFinal reportSaint Louis YPT-15 · Creve Coeur, MOThe pilot's failure to maintain directional control of the airplane. Contribuiting to the accident was the sun glare.NTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.NTSB MKC90LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOPoor planning by the pilot in not refueling enroute which resulted in fuel exhaustion.NTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MKC90LA004Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Gainesville, MOThe pilot's failure to compensate for wind conditions and to maintain runway alignment during the landing approach. Contributing to the accident was the turbulent conditions.NTSB MKC90LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Mountain View, MOLoss of engine power for undetermined reasons. Premature retraction of the landing gear by the pilot was a contributing factor.NTSB MKC89LA199Accident · No injuriesLimited investigationFinal reportCessna 150 · California, MOImproper use of the carburetor heat by the pilot resulting in the formation of carburetor ice and subsequent loss of power.NTSB DCA89IA071Incident · No injuriesClass 1 · IncidentFinal reportBoeing 737-200A · Kansas City, MOThe flightcrew's failure to adequately prepare for and execute a nonprecision approach and their subsequent premature descent below minimum descent altitude. Contributing to the cause of the incident was the inadequate and deficient services provided to the…NTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.NTSB MKC89FA194Accident · Serious injuriesField investigationFinal reportCessna 206A · Lees Summit, MOEngine partial power loss due to water in the aircraft fuel system, and an inadequate preflight.NTSB MKC89LA189Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Kansas City, MOInadequate control tower service provided by tower personnel, and inadequate remedial action by the vehicle driver. The pilot's lack of visual lookout was considered to be a contributing factor.NTSB MKC89LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · St. Clair, MOThe pilot's inability to establish a positive rate of climb due to the misjudged weight and balance calculations.NTSB MKC89LA178Accident · No injuriesLimited investigationFinal reportBell 206B · Marys Home, MOThe failure of the pilot to maintain control of the helicopter.NTSB MKC89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, MOControl interference by the dual student as the instructor tried to recover from the student's bounced landing, and failure to maintain proper runway alignment. Contributing factors were: improper flare by the student, the crosswind, the student's…NTSB MKC89LA169Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Harviell, MOThe pilot's inability to avoid unsuitable terrain during the landing roll after a forced landing. The forced landing was made necessary by a loss of engine power caused by a foreign object restricting the fuel system.NTSB MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.NTSB MKC89LA167Accident · No injuriesLimited investigationFinal reportCessna 320 · St. Clair, MOThe landing gear retraction/extention system failed for undetermined reason.NTSB MKC89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Camdenton, MOAircraft control was not maintained by the pilot in command.NTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.NTSB MKC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Excelsor Sprgs, MOThe catastrophic failure of the aircraft engine and the pilots failure to maintain directional control of the aircraft during the landing roll. Improper maintenance, the dark night conditions, and restricted visibility due to oil on the windscreen were…NTSB MKC89LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOAircraft control was not maintained by the pilot in command due to improper use of the flight controls in flaring the aircraft for landing and counteracting the effects of the cross-wind on the drifting aircraft.NTSB MKC89LA144Accident · No injuriesLimited investigationFinal reportCessna 210 · Kaiser, MOFailure of the pilot to extend the landing gear. A factor in the accident was the pilot's failure to use the checklist.NTSB MKC89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Grain Valley, MOFailure of the student pilot to maintain proper runway alignment, while aborting a bounced landing. Factors related to the accident were: the pilot's improper flare and lack of experience in the make and model of aircraft, the right crosswind, and the…NTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.NTSB MKC89DCA01Accident · 1 fatalFinal reportPiper PA-25-235 · Auxvasse, MOThe pilot-in-command's failure to maintain adequate airspeed, resulting in an inadvertant stall.NTSB MKC89LA128Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Creve Coeur, MOImproper use of the carburetor heat by the pilot and carburetor ice. Contributing factors were: carburetor icing conditions, high obstructions and terrain conditions (corn crop).NTSB MKC89LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bolivar, MOImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were the tall grass, inadequate runway maintenance, and trees.NTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.NTSB MKC89LA122Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbia, MOThe gear-up landing which was made by an unknown/unauthorized person.NTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.NTSB MKC89FA109Accident · Serious injuriesField investigationFinal reportBensen B-8KSB · Eldon, MOPilot's failure to maintain aircraft control which resulted in collision with the terrain during take off.NTSB MKC89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Moberly, MOThe failure of the pilot in command to maintain control of the aircraft while on takeoff ground run. Contributing to this lack of control were wind gusts from dust devils in the area, thermal activity, and the pilot's lack of experience.NTSB MKC89FA104Accident · 1 fatalField investigationFinal reportCallair A-9 · Hamilton, MOThe pilots failure to maintain control and prevent the airplane from descending while in a turn.NTSB MKC89DCG01Accident · Serious injuriesFinal reportGrigg/Bowers Flybaby · West Plains, MOImproper preflight planning by the pilot and his failure to attain adequate airspeed, which resulted in a stall as he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind, and the…NTSB MKC89LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wentzville, MOThe pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper…NTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.NTSB MKC89LA093Accident · No injuriesLimited investigationFinal reportHuff 1 · Liberty, MOPartial loss of engine power for an unknown reason. The soft terrain (plowed field) was a related factor.NTSB MKC89LA092Accident · No injuriesLimited investigationFinal reportVestal Quickie Q2 · St Joseph, MOThe pilot's improper flare and failure to maintain directional control of the aircraft. A factor related to the accident was: the pilot's lack of experience in this make and model of aircraft.NTSB MKC89FA090Accident · 2 fatalField investigationFinal reportPiper J-3 · Oak Grove, MOThe pilot's attempt to takeoff with the aircraft over its allowable takeoff weight and out of the center of gravity limits.NTSB MKC89LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Advance, MOThe pilot's inadequate visual lookout resulting in his failure to see power lines in time to avoid them. Contributing to the accident was the reduced visibility due to fog.NTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.NTSB MKC89LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Kansas City, MOImproper use of the carburetor heat control by pilot in command.NTSB MKC89LA057Accident · No injuriesLimited investigationFinal reportCessna 150 · Wayland, MOThe pilot becoming lost during the flight which resulted in fuel exhaustion.NTSB MKC89DCG02Accident · 1 fatalFinal reportWells Varieze · Macon, MOContinued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight…