NTSB investigations, MO
24 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 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\" = 320)
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" = 320) 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 CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.NTSB CHI05CA096Accident · No injuriesData collectionFinal reportChampion 7ECA · Mexico, MOThe pilot inadvertently using the wrong runway for takeoff, which resulted in a tailwind condition. Factors to the accident were the tailwind, the aborted takeoff, the wet grass runway, and the road embankment.NTSB CHI04CA200Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33 · Warrensburg, MOThe pilot's inadequate compaensation for the winds, and his inability to maintain directional control of the glider after encountering tall grass during the landing roll. The reported wind gust, tall grass, and the fence were contributing factors.NTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.NTSB CHI04LA054Accident · No injuriesLimited investigationFinal reportCessna 150E · Princeton, MOThe encounter with the unknown snow drifts during landing. The factors were the snow drifts, night, and the airport's failure to issue a NOTAM on the runway conditions.NTSB CHI03LA135Accident · No injuriesLimited investigationFinal reportCessna R172K · Kirksville, MOThe pilot's improper in-flight decision to land with a tailwind and failure to perform an aborted landing, resulting in the pilots decision to control the aircraft off of the right edge of the runway to avoid obstructions. Contributing factors were the…NTSB CHI02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Joseph, MOThe pilot's failure to attain proper alignment with the runway.NTSB CHI02LA040Accident · Minor injuriesLimited investigationFinal reportLyon Horizon 1 · Richland, MOThe pilot not attaining altitude/clearance from the tree line during the aborted landing. Factors to the accident were the pilot selecting to operate the airplane on the rough/uneven runway, the pilot's lack of total experience in the airplane, and the tree…NTSB CHI97LA022Accident · Serious injuriesLimited investigationFinal reportGalaxy AX8 · Columbia, MOthe pilot's selection of unsuitable terrain for landing. Factors relating to the accident were: the ditch, which was encountered during the landing; and high vegetation, which covered the ditch making it not visible to the pilot.NTSB CHI96LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Maryville, MOthe pilot's selection of an unsuitable area to taxi off the narrow runway in order to turn around. The proximity of the ditch was a related factor.NTSB CHI95LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Horseshoe Bend, MOthe pilot's failure to untie the main rotor tie-down strap prior to starting the helicopter.NTSB CHI95LA056Accident · No injuriesLimited investigationFinal reportCessna 206G · Butler, MOthe pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.NTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.NTSB MKC90LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lockwood, MOTouchdown point not attained and go-around not performed by the pilot in command. Contributing factors were a wet, grass runway.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB MKC87LA176Accident · Minor injuriesLimited investigationFinal reportEllsworth Varieze · Lebanon, MOThe PIC was back-taxiing down rwy 18 with a planned dept to the north. The PIC stated that he applied brakes in order to modify his direction during the taxi, but the brake failed to compensate. The PIC further stated that he applied more pwr in an attempt to…NTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.NTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…NTSB MKC86LA009Accident · No injuriesLimited investigationFinal reportCessna 140A · Pacific, MOThe airplane had rolled for 100 feet when the left wheel hit a mound of dirt left by a pocked gopher. The wheelpant bracket contacted the tire and acted as a brake. Airplane nosed forward to the inverted position.NTSB MKC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jefferson City, MOThe acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy.NTSB MKC82DA154Accident · No injuriesFinal reportPiper PA-25-235 · Fisk, MOThe pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the…NTSB MKC82DA061Accident · No injuriesFinal reportCessna 152 · Grain Valley, MODuring landing roll the aircraft went off the runway and ended up in a ditch.NTSB MKC82DA025Accident · No injuriesFinal reportCessna 172N · Lee'S Summit, MOPower was added to initiate taxiing. When the aircraft did not turn enough to the left additional power was applied and the aircraft struck a snowbank.NTSB MKC82DA021Accident · No injuriesFinal reportCessna 152 · Essex, MOThe student departed on a solo, cross-country flight. A comfort stop was made at an enroute airport during the first leg of the flight. The flight was then continued to the first pre-planned destination. After taking off on the second leg, the student became…