NTSB investigations, NM
17 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 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\" = 'NM' 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\" = 340)
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" = 'NM' 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" = 340) 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 FTW02LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Belen, NMthe pilot's delay in aborting the takeoff which resulted in a runway overrun and collision with a fence. Contributing factors were the tailwind, high density altitude, and the pilot's selection of a downwind runway for takeoff.NTSB DEN00LA117Accident · No injuriesLimited investigationFinal reportBeech M35 · Los Alamos, NMThe pilot's misjudgment of distance/speed resulting in an overrun and subsequent collision with a blast fence. Contributing factors were high density altitude, a tailwind, and the blast fence.NTSB FTW98LA184Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe pilot's failure to attain the proper touchdown point during landing, resulting in an overrun, and his exceeding the airplane's maximum crosswind component. A factor was the gusty crosswind.NTSB FTW95TA218Accident · No injuriesFinal reportCessna R172K · Albuquerque, NMThe pilot's improper compensation for crosswind conditions. Factors were the crosswind, the proper touchdown point not attained, and the pilot not aborting the landing.NTSB FTW93LA088Accident · No injuriesLimited investigationFinal reportCessna 340A · Clovis, NMThe pilot's failure to execute a go around. Factors were the tailwind, the icy runway conditions and the pilot's improper touchdown pointNTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.NTSB DEN86LA218Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMAccording to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a…NTSB DEN86FA101Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Albuquerque, NMThe acft crashed on the second aborted takeoff attempt. The plt said that the acft was not accelerating properly on the first attempt and that the eng lost power on the second attempt. Ground witnesses said that the air conditioner condenser door was open and…NTSB DEN86LA012Accident · No injuriesLimited investigationFinal reportBeech D50A · T/C, NMA person identifying himself as leon taylor, notified the FAA in albuquerque, n.m., that the twin-bonanza acft he was piloting, overran the improvised airstrip where he was attemptting to land & crashed. Mr taylor was never heard from again. The n.m. state…NTSB DEN85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ruidoso, NMAcft was 20 lbs over the max gross weight. Plt said he aborted the first takeoff due to a rough running eng. The plt performed a runup and attempted a second takeoff which was aborted again due to rough running eng. The acft ran off end of rwy and struck a…NTSB DEN84LA250Accident · No injuriesLimited investigationFinal reportCessna 414 · Albuquerque, NMPlt originally planned apch to rwy 17 but changed rwy when informed by another acft that rwy 35 was the active. Two witnesses reported winds at the time were from the east, one stating 5 to 7 mph the other stating light and variable. Plt stated apch speed of…NTSB DEN84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Los Alamos, NMThe attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was…NTSB DEN84LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Albuquerque, NMWhile en route, the acft's ELT suddenly activated. The plt made an unplanned landing at laguna, NM to correct the ELT problem, then he continued on to coronado arpt at Albuquerque, NM. He said this incident made him tense. After receiving radar vectors to the…NTSB DEN84FA184Accident · Serious injuriesField investigationFinal reportCessna 182L · Rosebud, NMThe acft ran off the gravel road used for a rwy during landing and collided with a ditch. A relative of the plt who was a witness said the acft floated 'a long time' and seemed to be flying 'too fast.' The plt also said it took longer to land than he expected…NTSB FTW83LA308Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ruidoso, NMThe acft overran the rwy and collided with a ditch during landing. The acft had touched down about 500 yards down the rwy according to the plt. The airspeed was also high at 100 KTS IAS. Braking did not stop the acft on the 5500 ft rwy and the acft continued…NTSB FTW82DA298Accident · No injuriesFinal reportCessna 182E · Albuquerque, NMThe pilot stated that after a normal approach, the aircraft touched down at about 90 mph on the first 1/4 to 1/3 of the runway. He raised the flaps and applied brakes. He noticed that there was insufficient braking action to stop on the wet runway, but by the…NTSB FTW82DA133Accident · No injuriesFinal reportCessna 205 · Albuquerque, NMThe pilot stated that the landing was normal and that he applied light braking for passenger comfort while keeping the aircraft on the runway centerline and looking for the runway end. Heavy braking was applied when the runway end lights were observed. The…