NTSB investigations, NM
10 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 2005 | 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\" = 320)
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" = 320) 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 DEN05CA146Accident · No injuriesData collectionFinal reportSchleicher ASW-20B · Moriarty, NMthe pilot's failure to maintain control of the glider during the takeoff roll which resulted in a ground loop.NTSB DEN99LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Belen, NMThe pilot's failure to maintain aircraft control. Factors were his inadequate compensation for the gusty crosswind conditions, and the airplane manufacturer's failure to provide adequate performance data.NTSB FTW95LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Mimbres, NMInadequate preflight planning and the selection of unsuitable terrain for takeoff by the pilot-in-command.NTSB FTW95LA077Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Albuquerque, NMThe pilot did not align the aircraft with the runway. Factors were the dusk light conditions and the pilot's failure to activate the pilot controlled runway lights.NTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…NTSB DEN85LQA03Accident · No injuriesFinal reportPiper PA-18A · Tucumcari, NMOn July 4, 1985, at 1400 MDT, a Piper PA-18, N1754A, registered to ted w. stallings, departed the designated taxiway and collided with a culvert at Tucumcari municipal airport, Tucumcari, new Mexico. The aircraft was being taxied for thepurpose of a local…NTSB FTW83LA255Accident · No injuriesLimited investigationFinal reportGlasflugel H-301 · Los Lunas, NMThe glider ground looped off the rwy after the wingtip contacted tall grass. The acft had gone to the right early in thetow but the plt thought the tow would straighten him out even after the wing dropped to the ground. When the right wing contacted tall…NTSB FTW82FQA20Accident · No injuriesFinal reportCessna T210M · Belen, NMA person called abq fss at 2310Z on 6/7/82 & asked for a wx briefing in the area of deming/silver city, NM to abq. He said he was a pilot & the acft was N761YA. On 6/11/82, the burned out remains of the acft were found in open desert terrain. Tracks appearing…NTSB FTW82DA057Accident · No injuriesFinal reportCessna 172 · Navajo Dam, NMThe pilot landed at an unattended airport on what he thought to be approximately 2 inches of snow. It turned out to be 8 inches and the aircraft turned over on landing.NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…