NTSB investigations, 2000, MO
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2000
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") = 2000 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 CHI01FA052Accident · 1 fatalField investigationFinal reportBeech BE-23 · Rolla, MOThe pilot's inadequate preflight during the pre-buy inspection, the pilot's incapacitation due to carbon monoxide, and the fractured muffler.NTSB CHI01LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Jefferson City, MOthe student pilots failure to maintain directional control. Factors were the service road and the nose gear collapse.NTSB CHI01LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Carrollton, MOthe misjudged touchdown point by the pilot. Factors were the runway lights not on, the dark night, and the plowed field.NTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB CHI00LA292Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Ellington, MOThe pilot's failure to maintain control of the aircraft during the aborted landing. Contributing to the accident was the rich mixture caused by an obstruction in the regulator section of the fuel servo.NTSB CHI00LA285Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Cape Girardeau, MOthe pilot's improper decision to continue the flight when the fuel sight gauge indicated empty and the exhausted fuel supply. A factor was the corn crop.NTSB CHI00LA280Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bolivar, MOThe pilot failed to maintain directional control of the airplane on landing. A factor associated with the accident was the crosswind.NTSB CHI00LA261Accident · No injuriesLimited investigationFinal reportCessna 152 · New London, MOthe fuel exhaustion and inadequate preflight planning/preparation by the pilot.NTSB CHI00LA252Accident · No injuriesLimited investigationFinal reportCessna 182Q · Warsaw, MOInadequate maintenance and the pilot's failure to maintain airspeed which resulted in failure of the carburetor and an inadvertent stall.NTSB CHI00LA240Accident · Minor injuriesLimited investigationFinal reportThompson Avid Mark IV · Springfield, MOthe pilot's inadequate preflight planning, his failure to abort the takeoff, and the inadequate airspeed. Factors included the tall runway grass, the quartering tailwind, and the trees.NTSB CHI00FA237Accident · 1 fatalField investigationFinal reportPiper J-5A · Belton, MOThe student pilot not maintaining directional control during the takeoff roll resulting in the inadvertent ground loop.NTSB CHI00LA238Accident · No injuriesLimited investigationFinal reportBeech BE-A35 · Poplar Bluff, MOthe pilot exceeded the VNE speed restriction of 144 MPH. Factors included the ruddervator flutter and the out of balance ruddervators.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB CHI00LA224Accident · Minor injuriesLimited investigationFinal reportBohner Pitts Model 12 · Neosho, MOThe unsuitable terrain the pilot selected during his emergency landing. Factors were the hay rolls and the loss of engine power for undetermined reasons.NTSB CHI00LA216Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOthe excessive brakes applied by the second pilot. A factor to the accident was the unavailability of brakes on the flight instructor's side of the aircraft.NTSB CHI00LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Warrensburg, MOinadequate airspeed on takeoff that resulted in a stall/mush condition. Factors associated with the accident were the wet, grass runway, and the trees near the departure end of the runway.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB CHI00LA153Accident · Minor injuriesLimited investigationFinal reportEaton Acro Sport I · Malden, MOthe water contamination of the fuel system and the inadequate preflight of the airplane by the pilot. The inoperative fuel system drain was a contributing factor. The wheat was a contributing factor.NTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…NTSB CHI00LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fulton, MOthe pilot's poor inflight planning which resulted in exceeded the proper touchdown point on the runway. A factor associated with the accident was the ditch that the airplane contacted.NTSB CHI00LA119Accident · No injuriesLimited investigationFinal reportBrice Rotorway Exec 162F · Kimberling, MOaircraft control not being maintained by the pilot. Factors to the accident were the encountered dynamic rollover and the uneven terrain.NTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.NTSB CHI00LA106Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Saint Joseph, MOthe pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.NTSB CHI00LA104Accident · Minor injuriesLimited investigationFinal reportWilson RAF 2000 GTX SE · Monroe City, MOthe pilot not obtaining clearance from the trees. Factors were the trees and the ravine terrain condition.NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB CHI00LA097Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Joplin, MOan inadequate rate of climb and the failure to attain clearance with the trees during the aborted landing. Factors associated with the accident were the pilot's failure to attain a proper touchdown point during the landing, the trees which were contacted, and…NTSB CHI00LA094Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hayti, MOthe failure of maintenance personnel to properly install and connect the aileron control rod. Factors were the inadequate annual inspection by maintenance personnel and the aileron control not possible by the pilot.NTSB CHI00LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Festus, MOthe pilot inadvertently retracted the landing gear instead of the flaps during the landing roll.NTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.