NTSB investigations, OK
11 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1994 | 2 |
| 1995 | 1 |
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\" = 'OK' 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" = 'OK' 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 FTW96LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Kingston, OKthe pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.NTSB FTW94LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Owasso, OKThe pilot's failure to attain the proper touchdown point.NTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.NTSB FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB FTW88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Ardmore, OKDuring landing, the aircraft touched down about 15 feet short of the runway causing the rt main gear to collapse. The acft slid approx 800 ft BEF0RE coming to rest on the rwy. Both gear penetrated the upper skin on the wings.NTSB FTW85LA305Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sand Springs, OKThe plt allowed the acft to get too low on the VFR final apch. He added pwr and stated a gust of wind tipped the acft tothe left. When he corrected for this the acft's nose dropped and the nose sheel contacted the ground and separated. The acft then nosed…NTSB FTW84LA196Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Guthrie, OKWhile on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat…NTSB FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.NTSB FTW83LA360Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Afton, OKThe acft landed 3 ft short of the rwy on an inclined concrete slope. The weather was VMC. At the approach to the rwy a concrete embankment slopes downward about 10 ft to a road. The acft hit on this embankment bounced and slid 75 ft down the rwy. Discussions…NTSB FTW83LA249Accident · No injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKThe Certified Flight Instructor's delayed remedial action which resulted in the dual student stalling the airplane.NTSB FTW83FPJ01Accident · Serious injuriesFinal reportPiper PA-28RT-201T · 3 Miles Ne Of E, OKThe aircraft struck power lines near the south end of the airport, at dusk, while on a final approach to runway 36. After striking the wires, the plane impacted the ground.