NTSB investigations: NONE, NM
18 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Hard landing”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1988 | 2 |
| 1989 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2001 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
Where
Latest 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN06CA108Accident · Serious injuriesData collectionFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMfuel exhaustion, resulting in the pilot's inability to relight one of two burners, and resulting in a hard landing.NTSB DEN04CA103Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 120A · Albuquerque, NMthe pilot's failure to maintain/obtain the proper descent rate.NTSB DEN03LA081Accident · Serious injuriesLimited investigationFinal reportAerostar International S66A-3060 · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high wind landing, which resulted in a hard landing. Contributing factors include the high wind and the berm.NTSB FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.NTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.NTSB FTW02LA011Accident · Serious injuriesLimited investigationFinal reportCameron 105 · Albuquerque, NMTher pilot's delay to compensate for changing weather conditions in-flight. Contributing factors were the high winds and an inaccurate weather forcast.NTSB DEN00LA015Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Artesia, NMThe pilot's inadequate compensation for the wind conditions.NTSB DEN99LA010Accident · Serious injuriesLimited investigationFinal reportAerostar RXS8 · Albuquerque, NMThe high wind condition and the pilot's subsequent intentional hard touchdown. A factor was the small landing area that was available to the pilot.NTSB DEN99LA006Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Alberquerque, NMThe passenger's failure to follow procedures/directives for a hard landing. A factor was the congested/confined landing area with power lines on both ends.NTSB DEN99LA023Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Albuquerque, NMThe passenger not following high wind landing procedures/directives which were given to her by the pilot. A factor was the unforecasted high wind condition.NTSB FTW98LA284Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Taos, NMThe pilot's improper flare. Contributing to the accident was the sudden wind shift which rendered the aircraft uncontrollable when the aircraft was on final approach to land.NTSB FTW97LA068Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Rio Rancho, NMThe passenger's failure to follow recommended procedures to properly brace for a high wind landing. A factor was the windshear.NTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.NTSB FTW95LA046Accident · Serious injuriesLimited investigationFinal reportRaven S100A · Las Vegas, NMThe pilot's improper in-flight planning/decision. A factor related to the accident was: the high wind condition.NTSB DEN89LA145Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Rio Rancho, NMA hard landing due to the pilots failure to accurately evaluate the weather conditions along with a delay in making a precautionary landing. Factors contributing to the accident were high winds and wind shear along with rough/uneven terrain.NTSB DEN89LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally II · Rio Rancho, NMThe commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was…NTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMNTSB FTW82FQA21Accident · Serious injuriesFinal reportBarnes AX-7 · Albuquerque, NMThe pilot stated she made a practice landing near a large hill and had no problems landing. She continued flight for approximately 20 minutes and prepared to land on a road. The balloon impacted a road embankment at touchdown and the pilot broke her leg. She…