NTSB investigations
820 cases where the first occurrence was “Undershoot”.
Cases, newest first
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.\"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."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 FTW82DA075Accident · 2 fatalFinal reportBell 206B · High Island BlkThe aircraft was low on the approach and during the flare, the vertical fin and tail boom contacted the safety netting extending beyond the boundaries of the platform landing area. The aircraft then settled back off the platform with one main rotor blade…NTSB LAX82DA087Accident · Minor injuriesFinal reportPiper J3-F65 · Yerington, NVDuring final approach for a hard dirt field the pilot reported that the bottom fell out and he hit short resulting in substantial damage to the aircraft.NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…NTSB LAX82DA082Accident · 1 fatalFinal reportCessna 172L · Gustine, CAThe pilot was familiar with the airport and the 35 ft power lines near the approach end of runway 36. During a night landing approach, the plane got low and the left wing struck a power line pole.NTSB CHI82DA061Accident · No injuriesFinal reportCessna 150 · Franklin, WIWhile practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short…NTSB DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…NTSB ATL82DLJ05Accident · Minor injuriesFinal reportCessna 150M · Fayetteville, NCWhile attempting a night landing to an airport runway marked only with reflectors, the aircraft contacted an embankment to the left of the runway.NTSB CHI82DA047Accident · No injuriesFinal reportBeech 35 · Ottawa, OHThe aircraft contacted a 4-foot snowberm located between the approach lights and the end of the pavement during the approach. The pilot was aware of the snow berm by the published NOTAM.NTSB NYC82DA034Accident · No injuriesFinal reportBellanca 17-30A · Factoryville, PADuring the previous flight, there was a landing gear malfunction. A mechanic checked the gear and a decision was made to fly the plane with the gear down to another airport for maintenance. During the subsequent flight, the "gear down" speed was not exceeded.…NTSB CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…NTSB MIA82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Deland, FLWhile practicing normal approaches and landings the student allowed the aircraft to get too low on final approach. The instructor took the controls but was unable to prevent a touchdown short of the runway threshold.NTSB ATL82FID05Accident · No injuriesFinal reportPiper PA-38-112 · Charlottesville, VAAfter performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a…NTSB FTW82DA049Accident · Minor injuriesFinal reportPiper PA-38-112 · Houston, TXThe pilot stated he encountered windshear while on short final for landing. The addition of full throttle by the pilot was insufficient to stop the descent before the aircraft impacted a small tree.NTSB NYC82DA022Accident · No injuriesFinal reportCessna 310 · Butler, PAThe pilot arrived at the destination at dusk. He circled the airport at pattern altitude to check the wind and runway condition. He noted that the runway was covered with snow. A long approach was made to runway 36 in a calm wind condition. Just prior to…NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB CHI82FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · New Philadelphi, OHWhile on final approach the aircraft contacted a tree about 70 feet high and 920 feet from the displaced threshold to runway 14. The pilot then elected to initiate a go-around and climbed straight ahead. After completing a 180 degree turn to downwind the…NTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…NTSB FTW82DA036Accident · Minor injuriesFinal reportCessna 182 · Fort Worth, TXA witness stated that the pilot had attempted to land on the north-south runway but was unable to stay on the runway. The pilot then attempted to land into the wind on an east-west asphalt taxiway but the aircraft touched down short.NTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…NTSB FTW82DA034Accident · No injuriesFinal reportPiper PA-28-161 · Hobbs, NMOn final approach to a gravel road the main landing gear collided with the upper strand of a powerline. The aircraft crashed in a pasture adjacent to the road. The student pilot was attempting to land at a family ranch.