NTSB investigations, 2017, 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\") = 2017
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") = 2017 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 CEN18LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Versailles, MOThe total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.NTSB DCA18CA049Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Saint Louis, MOthe abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.NTSB CEN18FA054Accident · 2 fatalField investigationFinal reportPiper PA28 · Reeds Spring, MOThe noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.NTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.NTSB GAA17CA532Accident · No injuriesData collectionFinal reportCessna 177 · Harrisonville, MOA collision with a deer on the runway during the takeoff roll.NTSB GAA17CA525Accident · No injuriesData collectionFinal reportCessna 182 · Lockwood, MOThe pilot’s unstabilized approach and failure to go around, which resulted in a runway overrun on a wet, grass runway.NTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.NTSB CEN17LA326Accident · No injuriesLimited investigationFinal reportCessna 182 · Booneville, MOThe pilot’s failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA17CA476Accident · No injuriesData collectionFinal reportCessna 172 · Drexel, MOThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…NTSB CEN17LA293Accident · Serious injuriesLimited investigationFinal reportChapman T-BIRD II · Potosi, MOThe pilot's loss of airplane control during a departure turn for reasons that could not be determined.NTSB CEN17FA288Accident · 2 fatalField investigationFinal reportZenith CH701SP · Laddonia, MOThe pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…NTSB CEN17LA280Accident · No injuriesLimited investigationFinal reportStinson 108 · Lee's Summit, MOThe pilot’s loss of directional control during landing due to the failure of the right brake seal.NTSB CEN17FA252Accident · Minor injuriesField investigationFinal reportAirbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MOFuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…NTSB CEN17LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fulton, MOThe partial loss of engine power due to water contamination in the fuel system.NTSB GAA17CA361Accident · No injuriesData collectionFinal reportCessna 182 · Doniphan, MOThe pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN17LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-235 · Harrisonville, MOThe pilot's failure to maintain a safe distance between the airplane and a person on the ground, which resulted in serious injuries to the person.NTSB CEN17LA206Accident · No injuriesLimited investigationFinal reportKenneth B Hines Nieuport 28 · Boonville, MOA partial loss of engine power due to a compromised induction system.NTSB GAA17CA272Accident · No injuriesData collectionFinal reportJohn Murphy JSX-2 · Chesterfield, MOThe pilot’s failure to ensure that the canopy was properly secured before takeoff, which resulted in an unstable landing flare and hard landing.NTSB GAA17CA246Accident · No injuriesData collectionFinal reportThomas B Mcgrath JA30 Superstol · Chesterfield, MOThe pilot’s failure to maintain directional control of the airplane during the landing roll in crosswind conditions.NTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.NTSB CEN17LA171Accident · Serious injuriesLimited investigationFinal reportJohn Goodman Air Camper · Oronogo, MOA detached throttle cable support block, which resulted in the pilot’s inability to control the throttle and the subsequent stall while maneuvering for an emergency landing.NTSB GAA17CA195Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Mosby, MOThe student pilot's failure to maintain directional control during an attempted go-around.NTSB CEN17LA110Accident · Serious injuriesLimited investigationFinal reportAerostar Acft Corp Of Texas M20E · Clever, MOThe failure of the engine No. 2 connecting rod bearing for reasons that could not be determined due to the extensive secondary engine damage.NTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.NTSB CEN17LA097Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Ozark, MOThe pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.