NTSB investigations: NONE, AZ
122 cases on aircraft whose registry engine model is NONE. 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.\"eventStateOrRegion\" = 'AZ' 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'))
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" = 'AZ' 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'))
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 LAX99FA273Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 11 · Cave Creek, AZAn unforecast encounter with a low level microburst that resulted in a distortion of the balloon envelope, an excessive outflow of hot air (loss of lift), creating an excessive rate of descent that was beyond the performance capability of the balloon to…NTSB LAX99LA178Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Clarkdale, AZThe pilot's selection of unsuitable terrain during a high wind condition. Contributing factors were the high winds and the tree.NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB LAX98LA289Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Tucson, AZFailure of the pilot to properly connect the aileron controls during reassembly of the glider, and, his inadequate preflight inspection of the glider.NTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.NTSB LAX98LA084Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Prescott Valley, AZThe failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB LAX97LA028Accident · Serious injuriesLimited investigationFinal reportLeibert BD-5B · Phoenix, AZloss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.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 LAX95LA315Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe pilot's selection of a runway inappropriate for the tailwind condition and his resultant failure to achieve a touchdown point which would allow the aircraft to stop prior to over running the departure end. The rough condition of the dirt runway, the lack…NTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.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 LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.NTSB LAX95LA036Accident · Serious injuriesLimited investigationFinal reportThunder and Colt TC-180 · Peoria, AZthe flight's encounter with unforecasted high winds which resulted in a hard landing.NTSB LAX94LA162Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9-118 · Sedona, AZthe failure of the pilot lights and burners to relight in flight once extinguished due to the installation of an incorrect gas pressure regulator.NTSB LAX93LA324Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-35C · Wickenburg, AZthe pilot's failure to maintain an adequate airspeed margin while maneuvering to land, resulting in an inadvertent stall/spin.NTSB LAX93LA283Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Phoenix, AZThe pilot's inadequate planned approach to the landing area.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 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 LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.NTSB LAX90LA041Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Sun City, AZInadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.NTSB LAX88LA137Accident · Minor injuriesLimited investigationFinal reportAvian Magnum IX · Phoenix, AZDuring a local flight in a hot air balloon, while descending, the deflation line malfunctioned. It was found that the release pulley had no roller and the rope was knotted and jammed in the pulley. The vent could not be activated in this condition.NTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZNTSB LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…NTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…NTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…NTSB LAX86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Benson, AZA Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see…NTSB LAX86LA144Accident · No injuriesLimited investigationFinal reportCentrair Schleicher ASW-20 · Phoenix, AZThe plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5…NTSB LAX84LA492Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Marana, AZThe plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with…NTSB LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…NTSB LAX84LA297Accident · No injuriesLimited investigationFinal reportLet L-13 · El Mirage, AZThe glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a…NTSB LAX84LA257Accident · Serious injuriesLimited investigationFinal reportRaven S-55A-707 · Glendale, AZDuring a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry…NTSB LAX84LA246Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Prescott Valley, AZWhen the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers…NTSB LAX84LA216Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Marana, AZThe plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted…NTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…NTSB LAX84LA063Accident · Serious injuriesLimited investigationFinal reportRider AA-4 · Salome, AZThe plt of the balloon was making a precautionary landing due to his proximity to the mexican border. To avoid high tension wires, the plt 'ripped out' at a higher than normal altitude resulting in a hard landing. The plt received a fractured skull when he…NTSB LAX84LA037Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · New River, AZThe student plt was on his 9th solo landing when he landed on rwy 27 with a x-wing from 200 deg at 10 KTS. During the landing, the glider drifted to the north into some bushes, then swerved into a tree. The plt reported that upon landing, he lower the wrong…NTSB LAX83LA170Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Mesa, AZAccording to the plt, there was no wind when he began the sight-seeing flt; however, after takeoff, the wind steadily increased to aprx 12 KTS. By this time, the balloon was approaching a large green field, so he elected to land rather than take a chance of…NTSB LAX82DA090Accident · No injuriesFinal reportSchweizer SGS1-260 · Phoenix, AZDuring the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther.NTSB LAX82FUJ28Accident · No injuriesFinal reportBalloon Works Firefly · Phoenix, AZThe pilot was landing in a vacant lot when the light and variable wind shifted and started blowing the Balloon toward powerlines. Just prior to the wind shift, the Balloon was descending rapidly. Rather than make a hard landing, the pilot tried to "burn" his…NTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.NTSB LAX82FUJ07Accident · No injuriesClosedRaven AX-7 · Phoenix, AZNTSB LAX81DUK09Accident · No injuriesClosedSchweizer 1-26 · Sun City, AZNTSB LAX81DUJ99Accident · Serious injuriesClosedGlasflugel H301B · Maricopa, AZNTSB LAX81FA104Accident · No injuriesClosedSchweizer 2-33A · Maricopa, AZNTSB LAX81DUJ19Accident · Serious injuriesClosedRaven S-55A · Sedona, AZNTSB LAX80DUJ77Accident · Minor injuriesClosedMoneral S · Tucson, AZ