NTSB investigations, GA
16 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1992 | 2 |
| 1994 | 1 |
| 1999 | 1 |
| 2004 | 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\" = 'GA' 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" = 'GA' 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 ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB MIA99LA193Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Monroe, GAthe pilot-in command's improper handling and inflight decisions resulting in an undershoot of the intended landing runway. The pilot-in-command then failed to maintain airspeed, which resulted in a stall and the right wingtip impacting the ground.NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB ATL89LA043Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomaston, GAThe pilot and three passengers were on a night flight in an aircraft that was equipped to carry skydivers. During the approach to land, the landing light failed. While attempting to get the light to operate, the pilot allowed an undershoot to develop.…NTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…NTSB ATL88LA091Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…NTSB ATL87LA208Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Monroe, GAThe private plt was on his first flt of the day in a glider that he had not flown recently. He reported the takeoff, tow and traffic pattern as normal. He used the spoilers sparingly until he turned final. He was most surprised, he said, when one of the…NTSB ATL84FU004Accident · 1 fatalFinal reportUltraflight Lazair II · Blichton, GAThe ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No…NTSB ATL83LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Simons Isl., GADuring arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the…NTSB ATL83FKG05Accident · No injuriesFinal reportPiper PA-28-161 · Pine Moutain, GADue to local wx conditions, the acft was receiving radar vectors to columbus, GA. Enroute to columbus, the plt elected to land at the callay gardens-harris county arpt. During final approach, he encountered a downdraft & struck several trees. He then added…NTSB ATL82DA248Accident · Minor injuriesFinal reportCessna 172M · Perry, GAThe student pilot departed Perry, GA on a solo cross-country flight to augusta and jessup, GA. He was expected to return to Perry at about 1600 EDT. The flight progressed uneventfully to jessup where it was delayed by a thunderstorm. After departing jessup,…NTSB ATL82DA246Accident · No injuriesFinal reportCessna 182P · Batesville, GAThe pilot reported that during the landing, he flared normally at what he perceived to be the runway threshold. He was surprised when he touched down hard on an upslope, about 15 feet short of the marked threshold and several feet below the runway level. The…NTSB ATL82FKG11Accident · 2 fatalFinal reportCessna 210 · Lexington, GAIn the early morning hours on 4/23/82, the aircraft departed covington, GA and proceeded on an undetermined route. At about 2300 PST that night, residents near the accident site heard the sounds of a crash. The wreckage was found the next morning about 1000…NTSB ATL82DA082Accident · Minor injuriesFinal reportCessna 177 · Jefferson, GADuring arrival, the wind shifted favoring runway 27. The pilot reported that he started his final approach at 80 mph and then slowed to 60 mph as he approached the threshold. Just as the aircraft crossed over a treeline, the aircraft suddenly dropped and hit…