NTSB investigations, AL
12 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 'AL' 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" = 'AL' 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 NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB ATL06LA008Accident · 1 fatalLimited investigationFinal reportElan/Glaser Dirks DG-300 · Brownsboro, ALThe pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.NTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.NTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.NTSB ATL90FA056Accident · Serious injuriesField investigationFinal reportCessna 150F · Weaver, ALThe pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…NTSB ATL87LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brownsboro, ALThe student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown.NTSB ATL86FKG05Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Birmingham, ALThe left main gear collapsed during a loss of control on landing. The plt reported the acft touched down prematurely during the flare and it contacted the lip of the rwy at the apch end. Directional control could not be maintained, according to the plt, and…NTSB ATL85LKG11Accident · Minor injuriesFinal reportLet L-13 · Huntsville, ALThe commercial plt was in training for a glider rating & was on a supervised solo flt to practice a landing. During the traffic pattern, he rolled out hi on final & extended the spoilers to adjust to the desired glide path, then retracted the spoilers to the…NTSB ATL83FKJ02Accident · Serious injuriesFinal reportLuscombe 8E · Elba, ALThe plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…NTSB ATL82DA239Accident · No injuriesFinal reportPiper PA-38 · Huntsville, ALThe student pilot was on a flight check to obtain a private pilot certificate. The flight examiner had instructed him to stay in the pattern and demonstrate a short field approach and landing. The flight examiner stated that on final approach, the aiming…NTSB ATL82DA156Accident · No injuriesFinal reportPiper PA-23-250 · Auburn, ALWhile on a downwind for a landing in multi-engine training, the nose gear would not extend. All efforts to extend the nose gear, including a bounced landing, were unsuccessful. The aircrew intended to land on the main gear and then hold the nose off until the…