NTSB investigations, MO
22 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 3 |
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\" = 390)
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" = 390) 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 CHI94LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Independence, MOThe pilot's misjudgment of distance, altitude, and speed on final approach to land, and failure to maintain obstacle clearance from the vehicle. The proximity of the vehicle to the approach path was a related factor.NTSB CHI93LA229Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Point Lookout, MOThe pilot in command's failure to maintain proper glide path, and her failure to attain the proper touch down Point.NTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.NTSB CHI92LA240Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Osage Beach, MOFailure to attain the proper touchdown point.NTSB MKC90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Dexter, MOThe pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.NTSB MKC90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hornersville, MOPoor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.NTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.NTSB MKC88DCA03Accident · Serious injuriesFinal reportLuscombe 8A · Painton, MOPilot did not maintian the proper decent rate on the final approach to the airport.NTSB MKC88FA041Accident · 1 fatalField investigationFinal reportPiper PA-31T-620 · Hazelwood, MOProper glide path not maintained by p.I.c., decision height not identified by the p.I.c., missed approach not performed by the p.I.c. turning on lights in overcast.NTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.NTSB MKC87LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Osage Beach, MOWhile performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI…NTSB MKC87LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Festus, MOThe CFI was giving inst to a pvt plt who was undergoing a biennial flt review. The pvt plt cmpltd the maneuvers and ret to the arpt. The lndg was aborted and a go-around was made. The CFI took control and executed another appch. The pvt plt was to monitor an…NTSB MKC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150J · Peculiar, MOThe plt reported that the acft encountered a downdraft as he made his apch to land at his pvt strip. The wind was from 250 degs at 7 KTS, a headwind for the landing acft. The plt reported no mechanical control difficulty during final apch. The plt reported…NTSB MKC86LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Liberty, MOThe instructor stated that the student had done well during this dual session, and he felt that traffic pattern airwork would be appropriate. Traffic pattern entry and letdown were normal, but the student got too low and slow on the full flap final approach.…NTSB MKC85LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Kansas City, MOPlt inadvertently entered clouds on VFR flight. Plt sighted an arpt through breaks in clouds and decided to land. The acft touched down short of a closed rwy, partially collapsing the left gear. It then bounced up onto the rwy and fully collapsed the left…NTSB MKC85LA009Accident · No injuriesLimited investigationFinal reportPiper PA32RT-300T · Columbia, MOThe plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be…NTSB MKC83LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrensburg, MOThe glider landed short of the rwy hitting a rough hump which was an old fence line. The glider bounced & landed hard on the rwy. The pax was hospitalized for 4 days for observation & treatment.NTSB MKC83LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Sullivan, MOAircraft landed short of runway and collapsed right main landing gear. As aircraft slid into some brush the nose gear collapsed.NTSB MKC82DA146Accident · No injuriesFinal reportMitsubishi MU-2B-20 · Camdenton, MOThe pilot landed hard damaging the landing gear on a paved area short of the displaced threshold. Flaps were set at 20 degrees instead of 40 degrees. After initial landing, the aircraft swerved right and went off the runway.NTSB MKC82DA111Accident · No injuriesFinal reportGrumman AA1C · St. Louis, MODuring a dual training flight the aircraft was allowed to descend into a corn crop short of the runway. The aircraft continued to the runway but landed hard and collapsed the landing gear.NTSB ATL82DA134Accident · No injuriesFinal reportCessna 150M · Hagerstown, MOOn final approach the student pilot felt the aircraft sink and realized she was not going to make the runway. Simultaneously power was applied and the nose of the aircraft was pulled up in an attempt to reach the runway. The aircraft stalled and nosed over…NTSB MKC82DA074Accident · No injuriesFinal reportBellanca 8KCAB · Hayitt, MOThe pilot stated that he came in slightly low on final to avoid crossing a road that ran through the center of the airstrip. The wheat field at the south end of the strip blended in with the colors and texture of the runway. The landing gear caught the tall…