NTSB investigations, 1999, MO
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1999
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") = 1999 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 CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.NTSB CHI00FA042Accident · 2 fatalField investigationFinal reportCessna 210D · Saint Charles, MOthe aircraft control not maintained by the pilot and the pilot exceeded the design limits of the aircraft. The clouds and night conditions were contributing factors.NTSB CHI00LA036Accident · No injuriesLimited investigationFinal reportCessna 172M · Ava, MOthe improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.NTSB CHI00FA040Accident · 6 fatalField investigationFinal reportCessna 525 · Branson, MOthe pilot descended below the minimum altitude for the segment of the GPS approach. Factors relating to the accident were low ceilings, rain, and pilot fatigue.NTSB CHI00LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-34 · East Lynne, MOinadequate airspeed and a subsequent stall. Factors associated with the accident were the tailwind, the pilot's misjudgment of the wind condition, and poor inflight planning.NTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.NTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.NTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.NTSB CHI00LA005Accident · No injuriesLimited investigationFinal reportZenair CH 2000 · St. Louis, MOthe student pilot misjudged the landing flare which resulted in a hard landing. A factor associated with the accident was the student's lack of total experience.NTSB CHI99LA347Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Henrietta, MOThe engine failure due to mismanagement of the fuel system and aircraft control not maintained by the pilot.NTSB CHI99LA345Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Troy, MOthe failure of the pilot to maintain directional control during landing. Factors in the accident were the proper alignment not attained by the pilot and the trees.NTSB CHI99FA341Accident · 3 fatalField investigationFinal reportCessna 172H · Plattsburg, MOthe pilot's failure to maintain airspeed during the initial climb. A factor relating to this accident was the inadvertent stall/spin.NTSB CHI99LA352Accident · No injuriesLimited investigationFinal reportCessna 150M · Lebanon, MOA loss of engine power due to a fractured shaft supporting the number three cylinder rocker arm. A factor relating to this accident was the trees.NTSB CHI99LA314Accident · No injuriesLimited investigationFinal reportBeech 58 · Chesterfield, MOthe inadvertent retraction of the landing gear by the pilot.NTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.NTSB CHI99LA306Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salem, MOThe pilot in command misjudging the touchdown point.NTSB CHI99LA298Accident · No injuriesLimited investigationFinal reportBell 206L · Cape Girardeau, MOThe inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.NTSB CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.NTSB CHI99LA277Accident · No injuriesLimited investigationFinal reportCessna 150M · Sikeston, MOthe loss of engine power due to the stuck exhaust valve. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI99LA262Accident · No injuriesLimited investigationFinal reportBeech C-45H · Grain Valley, MOthe failure of the pilot to use the tailwheel lock on takeoff, creating a condition where it was not possible for the pilot to maintain directional control. Factors were the unlocked tailwheel and the ditch.NTSB CHI99LA253Accident · No injuriesLimited investigationFinal reportBeech B36TC · Brookfield, MOthe total mechanical failure of the engine crankshaft due to fatigue. A factor was the ditch encountered on landing.NTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.NTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.NTSB CHI99LA226Accident · No injuriesLimited investigationFinal reportCessna 177RG · Weldon Springs, MOthe loss of engine oil for undetermined reasons. A factor was the trees.NTSB CHI99LA191Accident · No injuriesLimited investigationFinal reportBeech B19 · Taylor, MOthe airplane pilot's and the helicopter pilot's failure to maintain visual clearance from each other while in the traffic pattern.NTSB CHI99LA181Accident · Minor injuriesLimited investigationFinal reportRobbins Verieze · Odessa, MOThe pilot's misjudgment of altitude during landing.NTSB CHI99LA178Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Salem, MOthe engine quit due to water contamination of the fuel and the pilot's inadequate preflight.NTSB CHI99FA163Accident · 4 fatalField investigationFinal reportCessna 421B · Jefferson City, MOthe pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.NTSB CHI99LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Poplar Bluff, MOthe pilot selecting the wrong runway direction on which to initiate the takeoff and his failure to maintain directional control. Factors associated with the accident were the quartering tailwind condition, the rough terrain encountered, and fatigue.NTSB CHI99GA155Accident · 2 fatalFinal reportBell OH-58A · Poplar Bluff, MOThe tail rotor's impact with the blue warm-up jacket and the subsequent overload of the tail rotor drive shaft. A contributing factor was the absence of the helicopter's entry doors.NTSB CHI99LA154Accident · No injuriesLimited investigationFinal reportCessna R182 · Chesterfield, MOthe pilot's failure to attain clearance over the fence. Factors associated with the accident were the pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control, the crosswind, and the fence posts.NTSB CHI99LA143Accident · No injuriesLimited investigationFinal reportNarzinski Avid Flyer Mark IV · West Alton, MOThe failure of the connecting rod bearing, and the rough/uneven terrain condition.NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB CHI99FA102Accident · No injuriesField investigationFinal reportDouglas DC-9-15F · Kansas City, MOingestion of birds into both engines, resulting in foreign object damage and the subsequent partial power loss to both engines. A factor relating to this accident was the dark night.NTSB CHI99FA101Accident · 1 fatalField investigationFinal reportMooney M20F · Cabool, MOThe pilot not maintaining an appropriate airspeed during the turn from base to final resulting in a stall.NTSB CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.NTSB CHI99LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Odessa, MOthe total loss of engine power for reasons undetermined. Factors were total loss of engine power, the instructor pilot's encounter with unsuitable terrain, and the rough terrain.NTSB CHI99FA079Accident · 1 fatalField investigationFinal reportCessna U-206G · Salem, MOthe spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.NTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.NTSB CHI99LA067Accident · Minor injuriesLimited investigationFinal reportBaker Fisher Horizon · Bolivar, MOThe pilot's improper use of carburetor heat which resulted in carburetor icing and subsequent loss of engine power.NTSB CHI99LA063Accident · No injuriesLimited investigationFinal reportBeech BE-C-45H · St. Joseph, MOthe pilot not maintaining directional control during the landing rollout. A factor in this accident was the patchy snow on the runway.