NTSB investigations: NONE
125 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, 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_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."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 LAX98LA005Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Rancho Bernardo, CAThe pilot's intentional flight in high wind conditions and his improper in-flight planning.NTSB FTW98LA014Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Caddo Mills, TXthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the gusty wind condition.NTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.NTSB LAX97LA258Accident · Serious injuriesLimited investigationFinal reportCentrair ASW20F · Minden, NVthe pilot's improper planning/decision and subsequent encounter with gusty winds and strong downdrafts, which precluded reaching the airport and induced an unrecoverable high sink rate during an off-airport landing.NTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.NTSB NYC97LA137Accident · Serious injuriesLimited investigationFinal reportAerostar-Raven S-60-A · Clyde, OHAn abrupt touchdown to avoid power lines which resulted in a hard landing. Contributing to the accident was the pilot's failure to properly brief the passengers for the landing.NTSB LAX97LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · San Diego, CAThe pilot's decision to increase sink rate to avoid flying into an obstacle with insufficient altitude remaining to reduce the sink rate prior to impact with the ground.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 LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…NTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.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 SEA95LA228Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAfailure of the pilot to properly flare the airplane during the landing. Factors relating to the accident were: the pilot's improper approach to land, exceeding the proper touchdown point for landing, failure to go-around, while there was sufficient runway…NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.NTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.NTSB LAX95LA172Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 180A · Tucson, AZthe inability of the pilot to compensate for the wind conditions which resulted in the basket tipping over following touchdown during a high-wind landing.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 NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.NTSB FTW94LA172Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Durango, COThe pilot did not attain a proper level off during landing. A downdraft which was encountered was a factor.NTSB CHI94LA165Accident · No injuriesLimited investigationFinal reportBurkhart Grob BG 103 · Ionia, MIa hard landing as a result of the early disconnect of the glider launch/tow equipment.NTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.NTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.NTSB LAX93LA296Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 160A · Chandler, AZThe pilot's failure to adequately evaluate the weather conditions and subsequent uncontrolled touchdown resulting in a hard landing. Gusty wind conditions were a factor in the accident.NTSB MIA93IA052Incident · Minor injuriesIncident investigationFinal reportBalloon Works Firefly 7-15 · Orlando, FLPoor in-flight planning/decision by the pilot, and excessive descent resulting in a hard landing.NTSB LAX93LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Peoria, AZThe balloon's encounter with a gusty wind shear condition during the final descent for landing at an altitude insufficient for the pilot to take corrective action to prevent a hard landing.NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.NTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.NTSB FTW92LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Boerne, TXThe pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.NTSB DEN92LA021Accident · Minor injuriesLimited investigationFinal reportCameron V-77 · Littleton, COThe pilot's improper landing procedure, including wrong compensation for wind conditions and improper use of the envelope dump control. A factor was: high wind.NTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB DEN91LA137Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Englewood, COA hard landing and inadvertent deployment of the balloon heater. A factor was: inadvertent entanglement of a load cable with the heater activation device.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.NTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.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 NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.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 FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.NTSB DEN87LA174Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Silverthorne, COThe commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose…NTSB DEN87LA054Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colo. Springs, COThe Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing.NTSB MIA87LA030Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Brandon, FLA high sink rate was not arrested prior to the hard ldg. The plt stated that he briefed the pax on ldg procedures which included a tight grip in the event of an emerg ldg. The pax statements differed from those of the Balloon crew concerning the content of…NTSB CHI87LA034Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · Baldwin, WIWhile landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and…