NTSB investigations, 1990, MO
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 | 20 |
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\") = 1990
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") = 1990 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 CHI91LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Lee'S Summit, MOThe pilot's inability to maintain directional control of the airplane after landing. The icy runway and the pilot's lack to total experience were factors.NTSB CHI91LA045Accident · No injuriesLimited investigationFinal reportLaister LP-49 · Warrensburg, MOFailure to maintain directional control by the pilot. Factors related to the accident are lack of total experience in type aircraft, and type of operation.NTSB CHI91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Hannibal, MOThe pilot's improper recovery from a bounced landing. Factors were: excessive airspeed and the pilot's lack of total experience.NTSB CHI91LA013Accident · No injuriesLimited investigationFinal reportMooney M20/231 · Stockton, MOThe pilot's failure to maintain vso (minimum controllable airspeed) in a landing configuration. An associated factor is the pilot's inadequate remedial action.NTSB CHI91LA002Accident · No injuriesLimited investigationFinal reportGulfstream American 690B · Willow Springs, MOThe airplanes encounter with a static discharge, turbulence and a downdraft in the clouds which were associated with severe meteorological conditions.NTSB CHI91LA001Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE Jetstream 3201 · St. Louis, MOVisual outlook inadequate by the ground personnel. Contributing factors were lack of total experience in type of operation and a dusk light condition.NTSB CHI90GA273Incident · No injuriesFinal reportPiper PA-3O · Cape Girardeau, MOExcessive play in the landing gear extension linkage. A factor in the incident was unreliability of the gear indicating system.NTSB CHI90LA270Accident · Serious injuriesLimited investigationFinal reportBeech F-33A · Osage Beach, MOThe pilot's failure to establish a proper glide path, resulting in contact with trees short of the intended runway.NTSB CHI90LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Farmington, MOFuel exhaustion due to unknown reasons.NTSB CHI90LA246Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Reeds Spring, MOA delayed go-around.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB CHI90DCA02Accident · No injuriesFinal reportFisher Flying Products Classic BI Plane · Memphis, MOThe failure of the pilot to maintain directional control of the airplane during the landing roll. The pilot's lack of total aviation experience was a related factor.NTSB CHI90LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lees Summit, MOCheck list not followed, fuel system not understood, and fuel boost pump selector improperly used, by the PIC.NTSB CHI90LA216Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Salisbury, MOProper touchdown point not attained and go-around not performed by the PIC.NTSB CHI90LA223Accident · No injuriesLimited investigationFinal reportStearman E-75 · Mt. Grove, MOThe pilot's inadequate maintenance and servicing of the aircraft. A factor was water contamination in fuel tank.NTSB CHI90LA198Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ozark, MOTotal loss of engine power due to #2 turbine shaft bearing failure. A factor related to the accident was: none suitable terrain.NTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.NTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.NTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.NTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.NTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.NTSB MKC90LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Columbia, MOAircraft control not maintained resulting in a stall/mush by the PIC.NTSB MKC90LA131Accident · Minor injuriesLimited investigationFinal reportEugene M. Veras Polliwagon 150 · St. Charles, MOThe flight control system-stick was loose resulting in an stall.NTSB MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.NTSB MKC90LA125Accident · No injuriesLimited investigationFinal reportCessna 205 · Jonesburg, MOThe pilot in commands failure to attain a touchdown on the runway resulting in touchdown to the side of the runway and a nose over in soft terrain.NTSB MKC90MA115Accident · 2 fatalMajor investigationFinal reportPiper PA-46-310P · Naylor, MOThe pilot's failure to activate the pitot heat before flying in instrument meteorological conditions (IMC) above the freezing level, followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB MKC90LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Creve Coeur, MOFuel contamination and inadequate preflight.NTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.NTSB MKC90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · St. Louis, MOInadequate maintenance and proper touchdown point not attained by the pilot in command.NTSB MKC90LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lockwood, MOTouchdown point not attained and go-around not performed by the pilot in command. Contributing factors were a wet, grass runway.NTSB MKC90FA082Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bois D'Arc, MOInadvertent flight by the pilot into instrument meteorological conditions (IMC), and his spatial disorientation, which resulted in loss of aircraft control. Factors related to the accident were: the pilot's inadequate weather evaluation, darkness, low…NTSB MKC90LA084Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Branson, MOA disconnected throttle linkage that was inadequately inspected.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB MKC90LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Concordia, MOInadequate pre-flight planning and preparation, misjudged fuel consumption calculations and re-fueling not performed by the pilot in command.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB BFO90MA023Accident · 1 fatalMajor investigationFinal reportHawker Siddeley HS.125-35 · Columbia, MOInadequate preflight by the pilot(s), water contamination of the fuel, low level of deice fluid (methanol) in the deice tank, and subsequent ice blockage of the fuel filters. Darkness was a related factor.NTSB MKC90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Dexter, MOThe pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.NTSB MKC90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hornersville, MOPoor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.NTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).