NTSB investigations, NM
6 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 2000 | 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\" = 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" = '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" = 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 DEN01LA010Accident · No injuriesLimited investigationFinal reportOtero-Pitts PT1 · Albuquerque, NMA hard landing, which exceeded the design stress limits of the aircraft. Factors were the pilot's lack of experience in aircraft make and model and improper recovery from a bounced landing.NTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.NTSB DEN85LA095Accident · No injuriesLimited investigationFinal reportCessna 310 · Angel Fire, NMThe acft touched down 1500 ft short of the rwy and the nose gear collapsed. The taxiways were rough and soft yellow chevrons were painted on the taxiways, at the apch end of the rwy. The plt stated that he was concentrating on the apch and did not see the…NTSB FTW83LA388Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Lindreth, NMThe plt said he was approaching the rwy at 90 mph with full flaps and at 300 ft AGL he hit a downdraft. He added power and raised the nose but could not stop the descent.NTSB FTW83LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portales, NMAcft collided with power lines short of the rwy. Winds were gusty 27K.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.