NTSB investigations, NC
19 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2006 | 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\" = 'NC' 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" = 'NC' 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 ATL06LA041Accident · No injuriesLimited investigationFinal reportCessna 500 · Burnsville, NCThe pilot's misjudged distance/altitude that led to an undershoot and the pilot's failure to attain the proper touchdown point.NTSB ATL06CA040Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Burlington, NCThe pilot's misjudgment of altitude/distance which resulted in an undershoot of the runway and subsequent impact with the runway collapsing the main landing gear.NTSB MIA99LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-601P · Statesville, NCthe pilot's failure to attain the proper touchdown point on the runway. Factors in this accident were excessive approach speed, rain, and a wet runway.NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB MIA97LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Burnsville, NCThe failure of the pilot to use the checklist to confirm that the main cabin door was closed and locked before takeoff. Also, failure of the pilot to attain the proper touchdown point during the precautionary landing. Contributing to the accident was the self…NTSB ATL94LA173Accident · No injuriesLimited investigationFinal reportBeech M35 · Winston-Salem, NCThe student pilot's failure to maintain airspeed and a proper glidepath on final approach, resulting in an inadvertent stall and undershoot. Factors were the night lighting conditions, and the flight instructor's inadequate supervision of the student pilot.NTSB ATL93LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe student pilot's failure to judge a proper touchdown point, and his failure to maintain directional control after landing. A factor was the pilot's lack of total experience.NTSB ATL93LA045Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe poor judgement of the flight instructor in allowing his student to return from a cross country at night, and the student pilot's failure to maintain a proper altitude on final approach. Factors were the dark night conditions, the trees below the final…NTSB ATL92LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA32-300 · Hickory, NCWhile on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…NTSB ATL92LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Ramseur, NCThe pilot's improper compensation for the wind conditions. The gusty crosswind was a factor in the accident.NTSB ATL88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and…NTSB ATL87LA199Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Mt. Airy, NCThe instructor stated this was the second flight of the day with the student. They had released from an air tow at 1,500 feet AGL. The instructor was demonstrating glide slope control for best final glide. When the sailplane was about 1,000 feet AGL and one…NTSB ATL86LA175Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fuquay-Varina, NCThe flt was a practical flt test for a commercial plt certificate. At aprx 3,000 ft the plt examiner initiated a simulated forced landing. The applicant spiraled to a modified downwind and base leg. The applicant said everything was fine until on final apch…NTSB ATL86LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Statesville, NCThe pilot allowed the aircraft to stall and touchdown short of the runway while competing in a power off spot landing competition. The pilot stated that the accident could have been prevented by simply adding power.NTSB ATL83LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Raeford, NCThe pilot stated that he wanted to practice night landings. He made on successful touch and go landing. On the second attempt he went low on final and struck the top of trees short of the runway. A VASI was in place on the landing runway. The pilot had flown…NTSB ATL82DA128Accident · No injuriesFinal reportCessna A150L · Greensboro, NCWhile landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a…NTSB ATL82DA108Accident · No injuriesFinal reportBeech C23-180 · Greensboro, NCThe pilot stated that he experienced a failure of the right brake system preventing him from maintaining directional control during ground roll after landing on runway 09. The mechanic who removed the aircraft from the accident scene reported that tire tracks…NTSB ATL82FLJ06Accident · 2 fatalFinal reportBede BD-4 · Knightdale, NCTwo witnesses observed the aircraft on a low final approach for runway 19. They reported that the aircraft then turned to an easterly heading. One witness reported that the left turn appeared to be coordinated. The other witness heard the pilot add power…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.