NTSB investigations, MO
138 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 14 |
| 1992 | 4 |
| 1993 | 8 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 9 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 8 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 4 |
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 c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 CHI08CA023Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Morrison, MOLoss of control on the ground due to aircraft control not being maintained by the pilot. Contributing factors were the gusting winds and the uneven ground.NTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.NTSB CHI07CA247Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Kansas City, MOThe pilot's failure to manitain directional control during landing which resulted in the airplane striking a taxiway sign during the aborted landing. The crosswind and the sign were factors.NTSB CHI07CA074Accident · No injuriesData collectionFinal reportCessna 172S · St. Louis, MOThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Factors were the gusting crosswind conditions and the snow covered ground.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 CHI06CA017Accident · No injuriesData collectionFinal reportBellanca 7ECA · Cuba, MOThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI05CA208Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Willard, MOThe airplane overran the runway and hit a utility pole due to the pilot's delayed decision making and his failure to execute a go-around. Contributing factors included the exessive airspeed during the final approach, the high density altitude, the…NTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.NTSB CHI04LA249Accident · Serious injuriesLimited investigationFinal reportJohnson-Moore Zenith CH 701 · Galena, MOA loss of directional control for undetermined reasons. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI04FA205Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Point Lookout, MOThe pilot's failure attain adequate flying speed and his delay in aborting the takeoff which resulted in premature liftoff and an overrun of the runway. Contributing factors were the descending embankment, trees and ravine.NTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…NTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.NTSB CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.NTSB CHI03LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Sikeston, MOThe pilot's inadvertent activation of the brake system during touchdown and his inadequate remedial action, which resulted in the airplane nosing over.NTSB CHI03LA292Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Macon, MOThe pilot's improper use of the rudder, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind gust.NTSB CHI03LA168Accident · No injuriesLimited investigationFinal reportCessna A188B · Hornersville, MOThe pilot's failure to maintain directional control of the airplane during takeoff. A contributing factor was the crosswind.NTSB CHI03LA128Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Lake Ozark, MOAn inability to maintain control of the helicopter during the wind gust and brief tail wind. The ravine, wind gust and tailwind were contributing factors to the accident.NTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.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 CHI02LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrisonville, MOdirectional control not maintained be the pilot during landing rollout. The ditch was a contributing factor.NTSB CHI01FA292Accident · Minor injuriesField investigationFinal reportBoeing 737-3G7 · Kansas City, MOThe second in command failed to maintain proper runway alignment, directional control, and landed long. The pilot in command failed to execute a go-around and failed to provide adequate supervision. Additional factors included the thunderstorm, the dark…NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.NTSB CHI01LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Jefferson City, MOthe student pilots failure to maintain directional control. Factors were the service road and the nose gear collapse.NTSB CHI00LA280Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bolivar, MOThe pilot failed to maintain directional control of the airplane on landing. A factor associated with the accident was the crosswind.NTSB CHI00FA237Accident · 1 fatalField investigationFinal reportPiper J-5A · Belton, MOThe student pilot not maintaining directional control during the takeoff roll resulting in the inadvertent ground loop.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.NTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.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 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 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 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 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 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 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 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.NTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).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 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 CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.NTSB CHI97LA191Accident · No injuriesLimited investigationFinal reportCessna 402B · Springfield, MOThe pilot-in-command's (CFI) inadequate supervision and failure to take remedial action. A factor was the dual student's failure to maintain directional control.NTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.NTSB CHI97LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Kirksville, MOthe pilot failed to adequately compensate for the wind conditions on the runway during landing roll. Factors included the crosswind and gusts.NTSB CHI97LA066Accident · No injuriesLimited investigationFinal reportCessna 414 · Springfield, MOthe pilot's continued flight into known icing conditions with an inadequate windscreen deicing system and the diminished visual lookout. Factors were the icing weather conditions and the windscreen ice.NTSB CHI96LA182Accident · No injuriesLimited investigationFinal reportMooney M20F · Festus, MOthe pilot's not maintaining proper alignment with the runway and his inadequate compensation for wind conditions. A factor was the crosswind condition.