NTSB investigations: NONE, NM
16 cases on aircraft whose registry engine model is NONE, where the defining event 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
| 2009 | 2 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 2 |
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '092'))
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 WPR26LA052Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon landing in increased wind, and the pilot’s inability to maintain the proper descent rate, which resulted in a hard landing.NTSB WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB WPR24LA019Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Albuquerque, NMThe pilot’s inability to maintain control of the balloon during landing due to unforecasted windshear and turbulent air.NTSB WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR22LA010Accident · Serious injuriesClass 4 · LimitedFinal reportRichardson Andrew P RICHARDSON-75 · Alburquerque, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR21LA158Accident · 1 fatalClass 3 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and fatal passenger injury when the passenger fell out of the basket.NTSB WPR20CA272Accident · Serious injuriesClass 4 · Data collectionFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to a high-wind landing, which resulted in a hard landing and serious passenger injury.NTSB GAA20CA012Accident · Minor injuriesData collectionFinal reportAerostar International RX 7 · Rio Rancho, NMThe pilot's failure to maintain an adequate descent rate during landing, which resulted in a hard landing and a postaccident fire.NTSB CEN18LA006Accident · Serious injuriesLimited investigationFinal reportCameron N-105 · Albuquerque, NMThe steep approach and hard landing after the balloon encountered unexpected high wind conditions, which resulted in a serious injury to a passenger.NTSB GAA16CA014Accident · Serious injuriesData collectionFinal reportKubicek BB · Albuquerque, NMA hard landing which resulted in serious injury to a passenger.NTSB CEN15LA434Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL69A · Albuquerque, NMThe pilot’s failure to maintain a proper descent rate on approach, which resulted in a hard landing and the pilot sustaining a serious injury. Contributing to the accident was the pilot’s lack of recent experience flying a standard-shaped balloon.NTSB CEN14LA005Accident · Serious injuriesLimited investigationFinal reportCameron N105 - NO Series · Albuquerque, NMThe pilot's decision to land the balloon from a high approach altitude due to high winds, which resulted in a hard landing.NTSB CEN13CA018Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 90A · Albuquerque, NMThe passenger’s inadequate brace position for the balloon landing, which resulted in a serious injury.NTSB CEN10CA017Accident · Serious injuriesData collectionFinal reportCameron Z77 · Albuquerque, NMThe pilot’s failure to maintain control of the balloon during the approach and landing.NTSB CEN09LA318Accident · Serious injuriesLimited investigationFinal reportAerostar International S-60A · Albuquerque, NMThe pilot's excessive descent rate.