NTSB investigations, 2006, MO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2006
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") = 2006 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 CHI07CA047Accident · Minor injuriesData collectionFinal reportCessna T210L · North St. Louis, MOFuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.NTSB CHI07IA042Incident · No injuriesIncident investigationFinal reportBell 407 · Raytown, MOThe loss of engine power during cruise flight due to third stage turbine wheel blade fatigue and subsequent separation, which resulted in an emergency landing.NTSB CHI07LA039Accident · No injuriesLimited investigationFinal reportCessna 140 · Vienna, MOThe loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…NTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.NTSB CHI07CA031Accident · No injuriesData collectionFinal reportCessna 120 · Perryville, MOThe pilot's failure to maintain directional control during landing which resulted in an overload of the tailwheel attachment structure in the fuselage.NTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.NTSB CHI07TA015Accident · No injuriesFinal reportCessna 182R · Dexter, MOThe pilot's improper runway selection for landing and the pilot's inadequate flare. A factor was the tailwind.NTSB CHI07CA008Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Osage Beach, MOThe pilot's inadequate compensation for wind conditions which resulted in the hard landing. The gusting crosswind was a factor.NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.NTSB CHI06CA277Accident · No injuriesData collectionFinal reportRockwell 112TC · Bolivar, MOThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the go-around attempt. Contributing factors were the crosswind and the gusts.NTSB CHI06LA268Accident · 1 fatalLimited investigationFinal reportWindler Tri Q2 · Branson, MOFatigue failure, originating in an area of surface corrosion, of the right elevator mid span hinge pin and the subsequent failure of the elevator torque tube. Additional causes are the separation of the elevator from the airframe due to the hinge pin and…NTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…NTSB CHI06LA244Accident · Minor injuriesLimited investigationFinal reportFairchild SA227-AC · Grain Valley, MOthe pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.NTSB CHI06FA210Accident · 6 fatalClass 1 · FieldFinal reportde Havilland DHC-6-100 · Sullivan, MOthe pilot's failure to maintain airspeed following a loss of power in the right engine due to the fracturing of compressor turbine blades for undetermined reasons. Contributing to some parachutists' injuries was the lack of a more effective restraint system…NTSB CHI06CA180Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Jefferson City, MOThe dual student's excessive landing flare and his failure to maintain adequate airspeed, which resulted in the airplane stalling. A factor to the accident was the flight instructor's delayed remedial action and the runway edge light that the airplane struck.NTSB CHI06LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Bowling Green, MOThe loss of engine power due to fatigue fracture of the number two cylinder exhaust valve during initial climb after takeoff. A contributing factor was the unsuitable terrain (cornfield) encountered during the forced landing.NTSB CHI06LA164Accident · 1 fatalLimited investigationFinal reportMiller Zenair Cricket MC-12 · Lee's Summit, MOThe pilot's failure to maintain airspeed while operating in the traffic pattern after the loss of power in one engine, resulting in an inadvertent stall/spin. An additional cause was the loss of engine power in one of the two engines for undetermined reasons.NTSB CHI06FA154Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Parkville, MOThe pilot's improperly planned approach which resulted in the encounter with wake turbulence while the airplane's airspeed exceeded maneuvering speed. This encounter resulted in the subsequent loss of aircraft control and the in-flight separation of the left…NTSB CHI06CA131Accident · No injuriesData collectionFinal reportSchweizer 269C · Lees Summit, MOThe flight instructor's delay in taking remedial action which led to the hard landing during the practice autorotation. The misjudged glide path, the dual student restricting the throttle control, and the trees were factors in the accident.NTSB CHI06CA125Accident · No injuriesData collectionFinal reportBangham Barracuda · Monett, MORupture of the hydraulic hose and deformation of the hydraulic cylinder piston rods for undetermined reasons, which resulted in a failure of the landing gear extension system. Contributing factors were the pilot's premature shutdown of the engine on short…NTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.NTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…NTSB CHI06FA094Accident · 4 fatalField investigationFinal reportPiper PA34-200T · Branson, MOThe pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…NTSB CHI06LA089Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Sikeston, MOThe inadvertent landing gear retraction by the pilot during an after landing taxi.NTSB CHI06LA085Accident · Minor injuriesLimited investigationFinal reportWheeler Pitts Special · Fulton, MOThe altitude/clearance not obtained/maintained during landing by the pilot. Contributing factors were the trees, the embankment, the runway length, and the reduced visual lookout during the approach.NTSB CHI06LA069Accident · No injuriesLimited investigationFinal reportZilz Zenith CH801 · Moscow Mills, MOA loss of engine power due to inadequate design of the engine compartment which resulted in inadequate engine cooling and fuel starvation due to vapor lock. Factors associated with the accident were the utility pole and trees which were contacted during the…NTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.