NTSB investigations, 1993, 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\") = 1993
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") = 1993 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 CHI94LA058Accident · Serious injuriesLimited investigationFinal reportMooney M-20E · Chesterfield, MOthe pilot's failure to assure an adequate fuel supply for the planned flight. Factors associated with the accident were the trees, unreliable fuel gauges and the pilot's decision to operate the airplane with the known unreliable fuel gauges.NTSB CHI94LA065Accident · No injuriesLimited investigationFinal reportCessna 210M · Festus, MOImproper planning/decision by the pilot. Factors related to the accident were: the icy runway, crosswind and snowbank.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB CHI94LA043Accident · Serious injuriesLimited investigationFinal reportCleveland Piel Emeraude CP-304 · Warrensburg, MOthe intentional entry of a stall/spin by the student pilot.NTSB CHI94GA038Accident · 1 fatalFinal reportHughes 369HS · Antonia, MOThe pilot's failure to maintain proper altitude. A factor was the dark night.NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.NTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.NTSB CHI94LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Independence, MOThe pilot's misjudgment of distance, altitude, and speed on final approach to land, and failure to maintain obstacle clearance from the vehicle. The proximity of the vehicle to the approach path was a related factor.NTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.NTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB CHI93LA360Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Marshfield, MOfuel exhaustion due to the failure of the fuel tank selector valve handle which prohibited the pilot from switching to a tank containing fuel.NTSB CHI93IA354Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · St. Louis, MOa failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.NTSB CHI93IA352Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · St. Louis, MOa fatigue failure of the power transfer unit caused by a material defect which resulted in a total hydraulic system failure.NTSB CHI93LA341Accident · No injuriesLimited investigationFinal reportCessna R182 · St Louis, MOthe pilot's delay in lowering the landing gear prior to touchdown.NTSB CHI93LA344Accident · No injuriesLimited investigationFinal reportBeech 19A · Troy, MOThe pilot's use of improper fuel in the airplane. Wet turf on the runway was a related factor.NTSB CHI93LA339Accident · No injuriesLimited investigationFinal reportCessna 172L · Curryville, MOImproper preflight planning and procedures by the pilot-in-command which resulted in fuel exhaustion.NTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.NTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.NTSB CHI93LA319Accident · No injuriesLimited investigationFinal reportPiper J-2 · Warrensburg, MOthe pilot's inadequate preflight planning and preparation. A factor in the accident was the downdraft near the end of the runway.NTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.NTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.NTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.NTSB CHI93LA278Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · West Plains, MOThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB CHI93LA273Accident · No injuriesLimited investigationFinal reportCessna 305B · Fulton, MOfailure to maintain directional control. A factor related to the accident was the pilot's fatigue.NTSB CHI93LA265Accident · No injuriesLimited investigationFinal reportBeech C24R · Chesterfield, MOthe pilot's improper recovery from a bounced landing.NTSB CHI93LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Branson, MOthe fractured nose gear retract arm which allowed the nose gear to collapse.NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.NTSB CHI93LA261Accident · No injuriesLimited investigationFinal reportBeech F33A · Kahoka, MOThe pilot's premature liftoff. The soft runway condition was a factor.NTSB CHI93FA249Accident · Serious injuriesField investigationFinal reportAmerican Eurocopter AS350BA · West Plains, MOUndetermined.NTSB CHI93LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · California, MOThe pilot in command's failure to maintain adequate airspeed.NTSB CHI93LA242Accident · No injuriesLimited investigationFinal reportStinson V77 · St. Charles, MOThe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the wind gusts present at the time of the accident.NTSB CHI93LA241Accident · No injuriesLimited investigationFinal reportCessna U206A · Kimberling City, MOA rock lodged in the left brake assembly.NTSB CHI93LA239Accident · Serious injuriesLimited investigationFinal reportAeronca AC7B · Kearney, MOThe pilot in command's failure to maintain adequate airspeed and the aircraft exceeding maximum allowable gross weight.NTSB CHI93LA229Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Point Lookout, MOThe pilot in command's failure to maintain proper glide path, and her failure to attain the proper touch down Point.NTSB CHI93FA218Accident · 1 fatalField investigationFinal reportCessna 172F · Miami, MOthe pilot's failure to maintain aircraft control.NTSB CHI93LA216Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Malden, MOA broken mixture control cable resulting in fuel starvation.NTSB CHI93LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Birch Tree, MOThe pilot's failure to maintain aircraft control.NTSB CHI93LA212Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Buckner, MOThe nut backing off the connecting rod bolt resulting in rod failure. A factor involved in this accident was the lack of suitable terrain for the pilot in command to make a run on landing.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB CHI93FA182Accident · 2 fatalField investigationFinal reportAerospatiale AS-350B · Cameron, MOThe loss of engine power due to failure of the second stage turbine labyrinth seal. Factors related to the accident were: the unfavorable wind and tall trees bordering the emergency landing area.NTSB CHI93LA178Accident · No injuriesLimited investigationFinal reportCessna 188A · Harrisonville, MOPilot in command's failure to attain a proper climb.NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.NTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.NTSB CHI93LA162Accident · 1 fatalLimited investigationFinal reportBeech A33-35 · Theodosia, MOPoor preflight planning/preparation by the pilot. Factors related to the accident were the tailwind, a heavy weight load, and unsuitable terrain in which to land the airplane.NTSB CHI93FA149Accident · 2 fatalField investigationFinal reportCessna 421B · Valley Park, MOImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and the pilot's failure to maintain control of the airplane during approach to an emergency landing. A related factor was: failure of the pilot to…NTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.NTSB CHI93IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-233 · Kansas City, MOA frozen aileron control bearing after it had become worn, corroded and exposed to water, and the manufacturer's inadequate maintenance/inspection requirment of the bearing(s).