NTSB investigations, 2001, 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\") = 2001
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") = 2001 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 CHI02LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-34 · Clinton, MOthe pilot's inadequate prefight, his failure to feather the propellers, and the fuel exhaustion.NTSB CHI02LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrisonville, MOdirectional control not maintained be the pilot during landing rollout. The ditch was a contributing factor.NTSB CHI02LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedalia, MOThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.NTSB CHI02LA040Accident · Minor injuriesLimited investigationFinal reportLyon Horizon 1 · Richland, MOThe pilot not attaining altitude/clearance from the tree line during the aborted landing. Factors to the accident were the pilot selecting to operate the airplane on the rough/uneven runway, the pilot's lack of total experience in the airplane, and the tree…NTSB CHI02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vandalia, MOThe student pilot's inadequate directional control on the previous landing resulting in the overload failure of the nose landing gear fork. Factors were the overload of the nose landing gear fork, and the student pilot's lack of total experience.NTSB CHI02FA033Accident · 2 fatalField investigationFinal reportZenair CH2000 · Wentzville, MOThe improper selection of the fuel selector which resulted in fuel starvation and subsequent engine failure. Factors were the unsuitable terrain for the forced landing encountered by the pilot and the night light condition.NTSB CHI02LA028Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Nevada, MOThe inadequate fuel consumtion calculations by the pilot resulting in fuel starvation during the aborted landing, and the overloaded steering link for undetermined reasons resulting in the lack of directional control during landing. Factors were the…NTSB CHI02LA012Accident · No injuriesLimited investigationFinal reportBeech 200 · Osage Beach, MOThe inadequate planning/decision and the exceeded crosswind component by the pilot. The gusts were a contributing factor.NTSB CHI02LA005Accident · No injuriesLimited investigationFinal reportCessna 182N · Graham, MOA loss of engine power due to the fatigue failure of the number 2 piston. Contributing to the accident was the unsuitable terrain.NTSB CHI01LA299Accident · No injuriesLimited investigationFinal reportBeech 58P · Theodosia, MODiminished braking action due to standing water on the runway. A factor associated with the accident was the ditch which the airplane contacted.NTSB CHI01FA292Accident · Minor injuriesField investigationFinal reportBoeing 737-3G7 · Kansas City, MOThe second in command failed to maintain proper runway alignment, directional control, and landed long. The pilot in command failed to execute a go-around and failed to provide adequate supervision. Additional factors included the thunderstorm, the dark…NTSB CHI01LA287Accident · No injuriesLimited investigationFinal reportCessna 305 · Vichy, MOThe pilot failed to maintain directional control of the airplane during landing. The crosswind was a factor.NTSB CHI01LA283Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sikeston, MOThe loss of engine power during the initial climb due to fuel contamination, water. A factor relating to the accident was the trees.NTSB CHI01LA278Accident · No injuriesLimited investigationFinal reportGremminger 532 Commander · Ste. Genevieve, MOThe inadequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the low altitude and the soft terrain on which the forced landing was made.NTSB CHI01FA231Accident · 2 fatalField investigationFinal reportWorld Helicopters 47D1 · Ballard, MOThe pilot's improper preflight planning which resulted in fuel exhaustion, and the pilot's subsequent improper autorotation.NTSB CHI01LA212Accident · 1 fatalLimited investigationFinal reportReitz Mohawk 1 · Camdenton, MOThe pilot not performing an aborted takeoff and the inadvertent stall he encountered on his inadvertent initial climb. Factors were his inadvertent lift-off, the reported inadequate rudder control, his inadvertent flight with known deficiencies, and the…NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB CHI01IA211Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Whiteman AFB, MOThe separation of a fan blade due to fatigue failure which led to case separation and loss of engine power in the left engine.NTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.NTSB CHI01LA194Accident · 1 fatalLimited investigationFinal reportHouston Challenger II · Sedalia, MOthe unsuitable terrain encountered during the forced landing. Additional factors were the pilot's lack of experience in the type of airplane, the loss of engine power for undetermined reasons, and the trees.NTSB CHI01LA190Accident · Serious injuriesLimited investigationFinal reportTerminella Glasair II RG · Bolivar, MOThe pilot not maintaining aircraft control during the initial climb after takeoff. A factor to the accident was the pilot's decision to operate the airplane over the kit manufacture's recommended maximum gross weight.NTSB CHI01LA183Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Catron, MOthe failure of the pilot to maintain clearance from the electrical wires.NTSB CHI01LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Columbia, MOThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.NTSB CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.NTSB CHI01LA158Accident · No injuriesLimited investigationFinal reportPackwood Packwood 1 · Pierce City, MOan engine failure during initial climbout and the fence struck during the runway overrun.NTSB CHI01FA146Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Osage Beach, MOAircraft control not being maintained by the pilot during the forced landing and inadequate preflight inspection performed by the pilot. Contributing factors to the accident were the fuel system contamination that resulted in the loss of engine power, the…NTSB CHI01LA147Accident · 1 fatalLimited investigationFinal reportCessna 150H · Protem, MOThe overload of the flap control cable for undetermined reasons resulting in aircraft control not being possible. The trees were a factor.NTSB CHI01FA136Accident · No injuriesField investigationFinal reportCessna 172S · Springfield, MOthe excessive touchdown airspeed by the pilot.NTSB CHI01FA128Accident · 2 fatalField investigationFinal reportCessna 210L · Farmington, MOThe fracture of the crankshaft due to fatigue, the propeller separating from the airplane while in-flight, which resulted in the propeller striking the empennage structure and flight controls, yielding the airplane uncontrollable. Contributing factors to the…NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.NTSB CHI01FA077Accident · 2 fatalField investigationFinal reportWatson Steen Skybolt · Camdenton, MOThe pilot not maintaining altitude/clearance from terrain during the low altitude maneuver. Factors were the wind gusts and the low altitude maneuver the pilot performed.NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.