NTSB investigations, 2002, 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\") = 2002
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") = 2002 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 CHI03LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Osage Beach, MOFuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees.NTSB CHI03IA033Incident · No injuriesIncident investigationFinal reportHughes OH-6 · Moberly, MOThe loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn.NTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB CHI03LA026Accident · Minor injuriesLimited investigationFinal reportA Pair of Jacks RV-6A · Belton, MOThe punctured nose landing gear tire.NTSB CHI02LA297Accident · No injuriesLimited investigationFinal reportJonas Nieuport · Creve Coeur, MOThe installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.NTSB CHI02FA284Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Westphalia, MOThe pilot's spatial disorientation while turning in a cruise climb in instrument meteorological conditions, which resulted in the pilot's loss of aircraft control, and his failure to recover from a resultant tight descending spiral.NTSB CHI02CA296Accident · No injuriesData collectionFinal reportRobinson R-22 · Maryland Height, MODynamic rollover due to the flight instructor's improper control inputs and the flight instructor's unsuccessful remedial actions. A contributing factor is the passenger's inadvertent movement of the cyclic control.NTSB CHI02LA282Accident · No injuriesLimited investigationFinal reportCessna A188B · Dexter, MOThe fatigue fracture of the connecting rod, the recommended engine overhaul not performed by the company, and the low altitude flight.NTSB CHI02TA239Accident · Serious injuriesFinal reportHughes 369A · Springfield, MOOverload failure of the tail rotor transmission housing (gearbox) for undetermined reasons, which resulted in an inability to adequately control the aircraft.NTSB CHI02FA237Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Festus, MOThe pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.NTSB CHI02FA215Accident · 1 fatalField investigationFinal reportPiper PA-30 · Marble Hill, MOThe solid fuel system contamination resulting in a loss of engine power. The inadequate emergency procedures, and the airspeed not maintained by the pilot were additional causes.NTSB CHI02LA210Accident · No injuriesLimited investigationFinal reportCessna 402B · St. Louis, MOThe landing gear collapsed for undetermined reasons.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…NTSB CHI02FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lee's Summit, MOThe inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…NTSB CHI02LA204Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Farmington, MOThe locked brake and the aircraft control not being possible due to the locked brake.NTSB CHI02LA186Accident · No injuriesLimited investigationFinal reportCessna 175 · Kaiser/Lake Oza, MOThe pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…NTSB CHI02LA170Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Kansas City, MOThe inadequate flare by the flying pilot and the remedial action not performed by the company check airman.NTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.NTSB CHI02LA168Accident · Minor injuriesLimited investigationFinal reportBumgarner CA65 Sky Fly · Warrensburg, MOThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the overload failure of the right main landing gear.NTSB CHI02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Joseph, MOThe pilot's failure to attain proper alignment with the runway.NTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB CHI02LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Viburnum, MOThe pilot's improper short field takeoff planning and procedure. The takeoff weight above the maximum gross weight and the hill were contributing factors.NTSB CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.NTSB CHI02LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Springfield, MOThe flightcrew's failure to follow weather avoidance prcedures and their delay in activating the seat belt sign. Factors were the turbulent thunderstorm weather conditions, and the failure of the National Weather Service to issue an applicable in-flight…NTSB CHI02LA108Accident · Minor injuriesLimited investigationFinal reportLong FEW TF-51 · Summersville, MOThe unsuitable terrain encountered during the power off landing. The loss of engine power for unknown reasons was a contributing factor.NTSB CHI02LA105Accident · 2 fatalLimited investigationFinal reportBozeman Pietenpol Aircamper · Rocky Comfort, MOThe pilot not maintaining aircraft control while maneuvering, and his failure to maintain airspeed resulting in a stall. Low altitude flight was a contributing factor.NTSB CHI02LA101Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kahoka, MOThe improper soft field takeoff/procedure by the pilot. Contributing factors were the night condition and the inadequate planning/decision by the pilot.NTSB CHI02LA096Accident · No injuriesLimited investigationFinal reportCessna 170A · Gainesville, MOThe pilot's misjudgment of distance/altitude and his failure to perform a go-around.NTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…NTSB CHI02IA085Incident · No injuriesIncident investigationFinal reportBeech BE-55 · Springfield, MOThe inadequate visual lookout by the flightcrew of the other airplane.