NTSB investigations, MO
47 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 7 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 2 |
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\" = 310)
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" = 310) 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 CHI08CA009Accident · No injuriesData collectionFinal reportCessna Turbo Centurion T210 · Festus, MOThe deer on the runway during the airplane landing rollout.NTSB CHI07CA270Accident · No injuriesData collectionFinal reportMooney M20J · Chesterfield, MOThe pilot failed to maintain directional control while taxiing after landing. A factor was the runway sign.NTSB CHI05CA031Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Sikeston, MOThe pilot not maintaining his visual lookout and not maintaining clearance from the pole during his taxi to park from a landing. A factor was the pole he impacted.NTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.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 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 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 CHI98LA056Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Nevada, MOa deer that ran onto the runway as the airplane was landing. The reduced light condition at dusk was a related factor.NTSB CHI97LA249Accident · No injuriesLimited investigationFinal reportBeech A36 · Chesterfield, MOthe pilot's failure to maintain proper alignment on the taxiway. Factors associated with the accident were the fence post, and the sunglare, which hindered the pilot's ability to see the fence post.NTSB CHI95LA017Accident · No injuriesLimited investigationFinal reportCessna 210L · Higginsville, MOA coyote (animal) that ran onto the runway as the airplane was landing.NTSB CHI94LA324Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrenton, MOthe pilot's failure to use the proper procedure for an aborted takeoff. Factors associated with the accident were the trees, the pilot's poor preflight/preparation, and the pilot's selection of unsuitable terrain for landing.NTSB CHI94LA107Accident · Minor injuriesLimited investigationFinal reportBeech 18S · Kansas City, MOthe failure of the driver of the ground vehicle to exercise proper visual lookout.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB CHI92LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Climax Springs, MODelay in aborting the landing by the pilot in command.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MKC89LA189Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Kansas City, MOInadequate control tower service provided by tower personnel, and inadequate remedial action by the vehicle driver. The pilot's lack of visual lookout was considered to be a contributing factor.NTSB MKC89LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Liberty, MOWhile flaring for a x-wind landing, the student plt saw a large brown animal running toward the rwy. He maneuvered to avoid the animal. He stated the left main gear struck the animal, then the acft went off the rwy, bounced & nosed over.NTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…NTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…NTSB MKC88LA123Accident · No injuriesLimited investigationFinal reportAeronca 7EC · St. Charles, MOThe plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision.NTSB MKC88LA093Accident · No injuriesLimited investigationFinal reportBeech 95 · Shell Knob, MOThe pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing.NTSB MKC88FA028Accident · No injuriesField investigationFinal reportAero Commander 680FL · Kansas City, MOAt 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent…NTSB MKC87LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOAfter lndg, the PIC was clrd to taxi to the g/a ramp. He was not aware of the new g/a ramp & proceeded toward the old ramp. He saw a large acft coming from the opposite drctn on the same twy, so he modified his route by selecting another way. Mistakenly, he…NTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…NTSB MKC87LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chillicothe, MOThe PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during…NTSB MKC86LA146Accident · No injuriesLimited investigationFinal reportCessna T303 · Lake Ozark, MOThe plt stated that the flt was uneventful until after landing when somebody instructed him, over the common traffic advisory frequency on his VHF radio, to park the acft at a new parking area, and he complied. This parking area was congested with extra acft…NTSB MKC86LA066Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Versailles, MOThe plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt…NTSB MKC86LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOThe pilot had been at this airport 31 times since 1979. During his taxi to takeoff for a night flight, he mistook a service road for a taxiway. He taxied past one sign without seeing it but struck the second one. This is the third documented accident at this…NTSB MKC85LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Kahoka, MOThe plt stated that as he turned final, the airspeed increased and he could not slow down so the acft touched down fast. When he attempted a last minute go-around, the acft hit a concrete filled metal pole, went off the end of the rwy, across a street and…NTSB MKC85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Cape Girardeau, MOWhile on a solo x-country flt, the student plt became lost/disoriended. When the acft's fuel level became low at dusk, the student elected to land on a gravel road. As the acft was on the landing roll-out, the left wing struck a brace wire for a power line…NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB MKC84LA239Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mount Vernon, MOThe acft rolled foward and collided with a metal hanger after the plt hand propped the acft to start it. The acft was tied at the tail and chocked with the plts oldest daughter on the foot brakes. In spite of these precautions the acft got away and hit the…NTSB MKC84LA187Accident · No injuriesLimited investigationFinal reportCessna 172N · Gainsville, MOThe pilot was taxiing the aircraft back to his hangar. Upon reaching the hangar he made a 180 degree turn to position the aircraft so he could push it backwards into the hangar. During the turn the left wing impacted a pole.NTSB MKC84IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Kansas City, MOWhile taxiing to rwy 01 for takeoff, the plt noticed a snow removal vehicle operating in reverse, approaching his acft. He tried to maneuver to the rt to avoid a collision but the snow removal vehicle struck the leading edge of the lt wing. The driver of the…NTSB MKC84LA055Accident · No injuriesLimited investigationFinal reportMooney M20C · Pittsburg, MOThe acft ran off of the snow covered rwy into trees after an attempted downwind takeoff. The plt had packed the 8 inch snow by driving his car on the rwy. During the aborted takeoff the plt was unable to stop the acft before tree contact.NTSB MKC84FA036Accident · No injuriesField investigationFinal reportBeech A36 · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…NTSB MKC83LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOWhile taxiing off temporary rwy 22 the plt prematurely taxied into the taxiway leading to the air cargo ramp. In an effort to reach the general aviation ramp he turned onto a vehicle access road & the left wing struck a vehicular traffic warning sign.NTSB MKC83LA185Accident · No injuriesLimited investigationFinal reportDe Havilland DHG-6-300 · Kansas City, MOAs the aircraft was being parked, the outer portion of the right wing contacted the awning on a building.NTSB MKC83IA159Incident · No injuriesIncident investigationFinal reportBoeing 727-231A · St. Louis, MODuring taxi, while being guided by a ground marshallers the tail of the acft hit the tail of another acft.NTSB MKC83IA115Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · St. Louis, MOWhile taxiing to the gate the number 1 engine struck a baggage cart in an area normally occupied by aircraft. The pilotsundivided attention was to the signalman.NTSB MKC83FA112Accident · No injuriesField investigationFinal reportBoeing 727-100 · St. Louis, MOThe acft was scheduled as Continental flt 415 & was departing from eastern airlines gate 14A. While departing from the gate, the aircrew turned left to avoid a DC-9 parked at gate 14, then turned right to a yellow taxi line. While maneuvering, the left wing…NTSB MKC83IA200Incident · No injuriesIncident investigationFinal reportDouglas DC-3 · Springfield, MOOn taxi for takeoff the acft left propeller struck a parked unoccupied acft.NTSB MKC83LA015Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOPilot taxiing to takeoff went on a roadway instead of a taxiway and collided with a sign post. The taxiway was marked by signs and yellow paint lines on surface where pilot became disoriented and left taxiway to follow road.NTSB MKC82DA177Accident · No injuriesFinal reportPiper PA32RT-300 · Excelsior Sprin, MOPilot did not attain enough airspeed and aborted takeoff too late to stop before going off end of runway into bushes, damaging landing gear.NTSB MKC82IA079Incident · No injuriesIncident investigationFinal reportCessna 402B · St. Louis, MOWhile taxiing in close to deplane his passengers, the commuter pilot pulled in behind a parked northwest orient 727. As he approached the rear of the 727, the pilot turned the Cessna 402B to the right so that the passenger door would be facing the gate. As…NTSB MKC82DA044Accident · No injuriesFinal reportHelio H-295 · Ozark, MOThe driver of the automobile parked on the east end of the east/west runway to watch aircraft taking off and landing on the north/south runway. After landing on the south end of the n/s runway, the pilot taxied to his right around a group of hangars and onto…NTSB MKC82DA037Accident · No injuriesFinal reportCessna 150 · Grain Valley, MOThe pilot was attempting to taxi his aircraft back to its tiedown space through 6 to 8 inches of snow. While maintaining clearance on an aircraft on his right the left wing tip struck the tail of a Cessna 140.