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.

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.Oct 11, 1997 · N2585Z · Minor damageNTSB 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.Oct 3, 1997 · N921G · Substantial damageNTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.Aug 10, 1997 · N90755 · No damageNTSB 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.Jul 25, 1997 · N120MJ · Substantial damageNTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.Jul 12, 1997 · N111XX · Substantial damageNTSB 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.Jul 6, 1997 · N3590H · No damageNTSB 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.Apr 14, 1997 · N380P · Substantial damageNTSB 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.Dec 21, 1996 · N4396K · No damageNTSB 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…Sep 27, 1996 · N434TC · Minor damageNTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.Jul 5, 1996 · N4014K · Substantial damageNTSB 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.Nov 26, 1995 · N2508E · No damageNTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.Nov 25, 1995 · N7019G · No damageNTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.Oct 10, 1995 · N9153X · No damageNTSB 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…Sep 28, 1995 · N5949E · Substantial damageNTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.Aug 8, 1995 · N9174Z · Substantial damageNTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.Jul 8, 1995 · N2232H · No damageNTSB 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.Apr 27, 1995 · N738TC · No damageNTSB 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.Nov 6, 1994 · N54693 · Substantial damageNTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.Oct 29, 1994 · N4070S · No damageNTSB 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.Sep 2, 1994 · N2597S · Substantial damageNTSB 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.Jul 22, 1994 · N50257 · No damageNTSB CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.Jun 25, 1994 · N21WR · No damageNTSB 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.May 21, 1994 · N1992B · No damageNTSB 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.May 20, 1994 · N140BG · Substantial damageNTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.Apr 16, 1994 · N6408F · No damageNTSB 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.Aug 1, 1993 · N2574M · No damageNTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.Jul 20, 1993 · N45124 · No damageNTSB 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.Jan 30, 1993 · N128TC · No damageNTSB 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.Jan 2, 1993 · N9056D · No damageNTSB 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.Dec 26, 1992 · N2815S · No damageNTSB 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.Sep 27, 1992 · N9539G · No damageNTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.Aug 16, 1992 · N75250 · No damageNTSB 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.Mar 1, 1992 · N94BG · Substantial damageNTSB 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.Dec 28, 1991 · N9517P · Substantial damageNTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.Oct 20, 1991 · N4057H · No damageNTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.Oct 19, 1991 · N6092K · No damageNTSB 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.Sep 21, 1991 · N4036Y · Substantial damageNTSB 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.Sep 7, 1991 · N4055T · No damageNTSB 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.Sep 9, 1990 · N9006Y · No damageNTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.Jun 23, 1990 · N99US · DestroyedNTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.Jun 17, 1990 · N1523C · No damageNTSB 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.Jun 21, 1989 · N4207U · No damageNTSB 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.Apr 27, 1989 · N4022Q · No damageNTSB 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…Oct 4, 1988 · N4098G · Substantial damageNTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMFeb 28, 1988 · N81DS · Substantial damageNTSB 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.Jan 18, 1988 · N9811N · No damageNTSB 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…Jul 3, 1987 · N41986 · No damageNTSB 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.Feb 11, 1987 · N40458 · No damageNTSB 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…Nov 4, 1986 · N37171 · No damageNTSB 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…Nov 2, 1986 · N4196N · No damage