NTSB investigations: NONE
80 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, newest first
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.\"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."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 GAA15CA038Accident · Minor injuriesData collectionFinal reportUltramagic M90 - NO Series · Sherwood, ORThe pilot's failure to maintain the descent rate, resulting in a hard landing.NTSB GAA15LA015Accident · Serious injuriesLimited investigationFinal reportUltramagic N210 · Peoria, AZThe pilot's selection of unsuitable terrain for landing after noting a higher-than-anticipated wind speed and the balloon's high descent rate, which resulted in a hard landing.NTSB CEN15LA103Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons USA 120A · Peru, INThe hard landing due to a higher-than-forecast surface wind, which resulted in a serious neck injury to the pilot.NTSB ERA15CA035Accident · Serious injuriesData collectionFinal reportHead AX8 88B · Montevallo, ALThe pilot's decision to conduct a landing to a confined area in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.NTSB ERA14CA215Accident · Serious injuriesData collectionFinal reportSchleicher Alexander K 7 · Benton, TNThe pilot's distraction with traffic on the runway, and his subsequent failure to retract the air brakes prior to touchdown, which resulted in a hard landing.NTSB CEN14CA215Accident · Serious injuriesData collectionFinal reportFirefly 8B-15 · Security, COAn unexpected increase in wind velocity which resulted in a hard landing and the subsequent passenger injury.NTSB ERA14CA031Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1 26E · Eighty Four, PAThe pilot's failure to maintain proper airspeed and glide path, which resulted in an overshoot, a hard landing, and a subsequent collision with terrain. Contributing to the accident was the pilot's lack of total experience in make and model.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 CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.NTSB CEN13LA356Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Golden, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13IA350Incident · Minor injuriesIncident investigationFinal reportUltramagic M-105 · Louisville, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB ERA13LA212Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-225 · Chester Springs, PAThe pilot's failure to extinguish the burner pilot lights prior to a hard landing in windy conditions.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 CEN12CA393Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Pierce, NEThe balloon pilot’s encounter with increased wind during landing, which resulted in a hard landing and a passenger’s injury.NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.NTSB CEN11CA654Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 8 · Mingo, IAThe pilot’s failure to maintain control of the balloon’s descent during the landing, which resulted in the balloon having a hard landing in a ditch and causing a passenger to be seriously injured.NTSB CEN11CA517Accident · Serious injuriesData collectionFinal reportKubicek BB85 · Hartsel, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.NTSB WPR10LA169Accident · Serious injuriesLimited investigationFinal reportUltramagic S-160 · Rancho Santa Fe, CAA reduction of burner/heat production due to low fuel. Contributing to the accident was the pilot's continued flight with a low fuel status.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR10CA058Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-250 · Napa, CAThe pilot's encounter with variable winds which resulted in a hard landing and passenger 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 WPR09CA359Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Truckee, CAThe student pilot's failure to maintain adequate airspeed to avoid a stall during final approach to land. Contributing to the accident was the pilot’s lack of experience.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.NTSB CEN09LA318Accident · Serious injuriesLimited investigationFinal reportAerostar International S-60A · Albuquerque, NMThe pilot's excessive descent rate.NTSB MIA08CA193Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-150 · Sandown, NHThe pilot’s encounter with high winds during approach. Contributing to the severity of injuries was the passengers' improper landing preparation.NTSB NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…NTSB MIA08CA146Accident · Serious injuriesData collectionFinal reportFirefly 7-15 · Jamestown, RIThe pilot's excessive descent maneuver.NTSB LAX08CA112Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Buckeye, AZThe passenger's failure to hear and follow the pilot's instructions to get down in the bottom of the balloon basket before the high wind landing. A contributing factor was the high wind condition.