NTSB investigations, 1998, MO
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 | 20 |
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\") = 1998
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") = 1998 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 CHI99LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Liberty, MOThe excessive rotation by the pilot-in-command. The climb not obtained by the pilot-in-command, the fence and the trees were contributing factors.NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.NTSB CHI99LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Creve Coeur, MOthe pilot misjudged his altitude and airspeed during landing. A related factor was the dark night conditions.NTSB CHI99LA021Accident · Minor injuriesLimited investigationFinal reportJordan Acey Deucy P70 · Ava, MOthe pilot's attempted operation of the airplane with known deficiencies, and his not obtaining control of the airplane in flight. A factor was asymmetrical ailerons.NTSB CHI98LA366Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Point Lookout, MOThe pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.NTSB CHI98LA363Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Lamar, MOthe pilot improperly positioned the fuel selector to the closed position causing fuel starvation.NTSB CHI98LA358Accident · No injuriesLimited investigationFinal reportCessna 182K · Eldon, MOThe pilot's not correcting for a porpoise condition during landing roll.NTSB CHI98LA326Accident · No injuriesLimited investigationFinal reportCessna 150B · Lamar, MOinadequate lubrication of the torque plate holes and torque pins by the mechanic who performed the airplane's last annual inspection.NTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.NTSB CHI98IA275Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Saint Louis, MOthe failure of the flight crew to maintain clearance from the sweeper truck. A factor in the incident was the sweeper truck.NTSB CHI98LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springfield, MOthe pilot in command's inadequate preflight planning/preparation and inaccurate fuel consumption calculations that caused the aircraft's fuel supply to be exceeded. Factors to the accident were the dark light condition and the rough/uneven terrain condition.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).NTSB CHI98LA239Accident · Minor injuriesLimited investigationFinal reportRobinson R-44 · Cassville, MOThe pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.NTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.NTSB CHI98LA232Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Chillicothe, MOthe improper use of the engine starting procedure. Factors contributing to the accident were the pilot in command's lack of recent experience, the aircraft not being tied down, the utility pole and guy wire.NTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.NTSB CHI98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Risco, MOthe pilot's abrupt application of the brakes. Factors contributing to this accident were the pilot's inadequate preflight preparation, his delayed decision to abort the takeoff, and the soft field.NTSB CHI98LA191Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Excelsior Spr, MOthe inadequate preflight planning by the pilot in command and exceeding the maximum gross weight for the aircraft. A factor was the berm.NTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…NTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB CHI98LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hannibal, MOa loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.NTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.NTSB CHI98IA169Incident · No injuriesIncident investigationFinal reportDouglas DC-9-34 · St. Louis, MOthe yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB CHI98LA108Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Steele, MOthe pilot failed to maintain an adequate visual lookout. A factor was the pile of gravel in the taxiway.NTSB CHI98FA106Accident · 6 fatalField investigationFinal reportCessna U206G · Grain Valley, MOPilot's inadequate preflight, the partial loss of oil and the resulting rod failure. A factor was the pilot's failure to maintain flying speed.NTSB CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.